![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
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.
CSTSCHKS.pls | Accounting Entry 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 | Accounting Entry Type Extension Package Body Template. This file contains the function that you can modify to implement the Accounting Entry 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 current transaction is done in |
i_txn_id | IN | NUMBER | Transaction identifier |
i_user_id | IN | NUMBER | User identifier |
i_login_id | IN | NUMBER | Login identifier |
i_req_id | IN | NUMBER | Request ID of the program |
i_prg_appl_id | IN | NUMBER | Application ID of the program |
i_prg_id | IN | NUMBER | Program identifier |
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 - 6. (Page 2 of 2) Accounting Entry Type Parameters |
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 actual cost work is running in |
i_cost_update_id | IN | NUMBER | Cost update identifier |
i_user_id | IN | NUMBER | User identifier |
i_login_id | IN | NUMBER | Login identifier |
i_req_id | IN | NUMBER | Request ID of the program |
i_prg_appl_id | IN | NUMBER | Application ID of the program |
i_prg_id | IN | NUMBER | Program identifier |
o_error_code | OUT | VARCHAR2 | Output error code |
o_error_num | OUT | NUMBER | Output error number |
o_error_msg | OUT | VARCHAR2 | Error message |
Table 3 - 7. (Page 1 of 1) Accounting Entry Type Parameters |
o_error_num = 0 | The extension executed successfully. |
o_error_num <> 0 | An error condition has occurred and the extension did not process successfully. |
Writing Accounting Entry Extensions for Standard Costing
Oracle Cost Management Technical Reference Manual, Release 11
Previous | Next | Contents | Index | Glossary | Library |