Previous  Next          Contents  Index  Glossary  Library

Writing Account Generation Extensions for Standard Costing

Cost Management provides a template package and functions as a basis for account generation type extensions. The name of the template package is CSTPSCHK.

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.

Package Function for Material and Scrap Transactions

You can use this function for either material or scrap transactions.

std_get_account_id

Table 3 - 6 lists the parameters for Account Generation type extensions that provide alternate material transaction accounts in standard costing organizations.

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

Additional Information About Parameters

Debit/Credit The valid values of i_debit_credit are as follows and indicate whether the traction is a debit or a credit:

i_debit_credit = 1 Indicates a debit.
i_debit_credit = -1 Indicates a credit.
Expense Account Indicator The valid values of i_exp are:

i_exp = 0 Expense item transaction.
i_exp = 1 Asset item transaction.
Sending/Receiving Organization The valid values of i_snd_rcvg_org are:

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.

Error Handling

o_error_num This parameter indicates the processing status of your extension as follows:

o_error_num = 0 The extension executed successfully.
o_error_num <> 0 An error condition has occurred and the extension did not process successfully.
o_error_code and o_error_msg Values for error_code, o_error_code, and error_explanation, o_error_msg, are stored in the MTL_MATERIAL_TRANSACTIONS table.

Package Function for Standard Cost Update Transactions

std_get_update_acct_id

Table 3 - 6 lists the parameters for Account Generation type extensions that provide alternate cost update accounts in standard costing organizations.

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

Additional Information About Parameters

Debit/Credit The valid values of i_debit_credit are as follows and indicate whether the traction is a debit or a credit:

i_debit_credit = 1 Indicates a debit.
i_debit_credit = -1 Indicates a credit.
Expense Account Identifier The valid values of o_error_num are:

i_exp = 0 The transaction is an asset transaction.
i_exp <> 0 The transaction is an expense transaction.

Error Handling

l_error_num This parameter indicates the processing status of your extension as follows:

o_error_num = 0 The extension executed successfully.
o_error_num <> 0 An error occurred and the extension did not process successfully.
o_error_code and o_error_msg Values for error_code, o_error_code, and error_explanation, o_error_msg, are stored in the MTL_MATERIAL_TRANSACTIONS table.

See Also

Client Extensions

Account Generation Extension

Writing Account Generation Extensions for Average Costing

Oracle Cost Management Technical Reference Manual

         Previous  Next          Contents  Index  Glossary  Library