![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
Previous | Next | Contents | Index | Glossary | Library |
Print out the following files before you begin writing Account Generation type extensions. The files are located in the Cost Management admin/sql directory.
CSTSCHKS.pls | Account Generation Type Extension Package Specification Template. If you create functions outside the predefined function within the CSTPSCHK package, you must also modify this file to include those new functions. |
CSTSCHKB.pls | Account 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 |
i_exp | IN | NUMBER | Expense or asset account indicator |
i_snd_rcv_org | IN | NUMBER | Sending or receiving organization indicator |
o_error_code | OUT | VARCHAR2 | Output error code. Can be any SQL code. |
o_error_num | OUT | NUMBER | Output error number |
o_error_msg | OUT | VARCHAR2 | Error message |
Table 3 - 9. (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 | Expense item transaction. |
i_exp = 1 | Asset item transaction. |
i_snd_rcvg_org = 1 | The organization (i_org_id) is a sending organization for inter-organization transactions. |
i_snd_rcvg_org = 2 | The organization (i_org_id) is a receiving organization for inter-organization transactions. |
o_error_num = 0 | The extension executed successfully. |
o_error_num <> 0 | An error condition has occurred and the extension did not process successfully. |
Parameter | Usage | Type | Description |
---|---|---|---|
i_org_id | IN | NUMBER | The organization that the cost distributor is running in |
i_update_id | IN | NUMBER | Cost update session identifier |
i_debit_credit | IN | NUMBER | Type of transaction, debit or credit |
i_cost_element_id | IN | NUMBER | Cost element identifier |
i_acct_line_type | IN | NUMBER | The accounting line type |
i_resource_id | IN | NUMBER | Resource identifier |
i_subinv | IN | VARCHAR2 | Subinventory identifier |
i_exp | IN | NUMBER | Expense or asset account indicator |
i_snd_rcv_org | IN | NUMBER | Sending or receiving organization indicator |
o_error_code | OUT | VARCHAR2 | Output error code. Can be any SQL code. |
o_error_num | OUT | NUMBER | Output error number |
o_error_msg | OUT | VARCHAR2 | Error message |
Table 3 - 10. (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. |
o_error_num = 0 | The extension executed successfully. |
o_error_num <> 0 | An error occurred and the extension did not process successfully. |
Writing Account Generation Extensions for Average Costing
Oracle Cost Management Technical Reference Manual
Previous | Next | Contents | Index | Glossary | Library |