![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
Previous | Next | Contents | Index | Glossary | Library |
Print out the following files before you begin writing Accounting Entry type extensions. The files are located in the Cost Management admin/sql directory.
CSTACHKS.pls | Accounting Generation Type Extension Package Specification Template. If you create functions outside the predefined function within the CSTPACHK package, you must also modify this file to include those new functions. |
CSTACHKB.pls | Accounting Generation Type Extension Package Body Template. This file contains the function that you can modify to implement the Account Generation type extension. |
Suggestion: After you write the function, do not forget to compile it and store it in the database. See: Writing PL/SQL functions.
Parameter | Usage | Type | Description |
---|---|---|---|
i_org_id | IN | NUMBER | The organization that the actual cost worker is running in |
i_txn__id | IN | NUMBER | Transaction identifier |
i_debit_credit | IN | NUMBER | Transaction type; debit or credit |
i_acct_line_type | IN | NUMBER | Accounting line type |
i_cost_element_id | IN | NUMBER | Cost element Identifier |
i_resource_id | IN | NUMBER | Resource identifier |
i_subinv | IN | VARCHAR2 | Subinventory involved (optional) |
i_exp | IN | NUMBER | Expense or asset account identifier |
i_snd_rcv_org | IN | NUMBER | Sending or receiving organization identifier |
l_error_code | OUT | VARCHAR2 | Output error code. Can be any SQL code. |
l_error_nun | OUT | NUMBER | Output error number |
l_error_msg | OUT | VARCHAR2 | Error message |
Table 3 - 11. (Page 2 of 2) Account Generation Type Parameters |
i_debit_credit = 1 | Indicates a debit. |
i_debit_credit = -1 | Indicates a credit. |
i_exp = 0 | The transaction is an asset transaction. |
i_exp <> 0 | The transaction is an expense transaction. |
i_snd_rcvg_org = 1 | The organization (i_org_id) is a sending organization. |
i_snd_rcvg_org = 2 | The organization (i_org_id) is a receiving organization. |
l_error_num = 0 | The extension executed successfully. |
l_error_num <> 0 | An error occurred and the extension did not process successfully. |
Writing Account Generation Extensions for Standard Costing
Oracle Cost Management Technical Reference Manual, Release 11
Previous | Next | Contents | Index | Glossary | Library |