![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
|
Previous | Next | Contents | Index | Navigation | Glossary | Library |
Print out the following files before you begin writing AR transaction type extensions. The files are located in the Oracle Projects admin/sql directory.
PAXITRXB.pls | AR Transaction Type Extension Package Body Template. This file contains the procedure that you can modify to implement the AR transaction type extension. |
PAXITRXS.pls | AR Transaction Type Extension Package Specification Template. If you create procedures outside the predefined procedure within the pa_client_extn_inv_transfer package, you must also modify this file to include those new procedures. |
Suggestion: After you write the procedure, do not forget to compile it and store it in the database. See: Writing PL/SQL Procedures.
Parameter | Usage | Type | Description |
---|---|---|---|
p_project_id | IN | NUMBER | Identifier of the project to which the draft invoice number is attached. |
p_draft_ invoice_num | IN | NUMBER | The draft invoice number. |
p_invoice_class | IN | VARCHAR2 | The class of the invoice. |
p_invoice_amount | IN | NUMBER | Amount on the invoice. |
p_ar_trx_type_id | IN | NUMBER | Identifier of the AR Transaction Type to be used for the invoice. Oracle Projects uses its setup tables to determine the default AR transaction type and then passes it to the template. |
x_ar_trx_type_id | OUT | NUMBER | Identifier of the AR Transaction Type determined by the extension. After validation, Oracle Projects uses this transaction type to interface invoices to Oracle Receivables. |
x_status | OUT | NUMBER | Status of the procedure: 0 = successful execution <0 = Oracle8 error >0 = application error |
Table 1 - 123. (Page 2 of 2) AR Transaction Type Parameters |
INVOICE | regular invoice |
CREDIT_MEMO | crediting invoice |
WRITE_OFF | write-off invoice |
CANCEL | canceling invoice |
x_status = 0 | The extension executed successfully. |
x_status < 0 | An Oracle8 error occurred and the process did not complete. Oracle Projects writes an error message to the process log file. |
x_status > 0 | An application error occurred. Oracle Projects writes a rejection reason to the PA_DISTRIBUTION_WARNINGS table. The invoice is not approved or released. |
Previous | Next | Contents | Index | Navigation | Glossary | Library |