1 PACKAGE PA_Client_Extn_Inv_Transfer AS
2 -- $Header: PAXPTRXS.pls 120.4 2006/07/25 06:38:55 lveerubh noship $
3 /*#
4 * This extension is used for the AR transaction type billing.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname AR Transaction Type Extension
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:category BUSINESS_ENTITY PA_INVOICE
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14 /*----------------------------------------------------------------------------*/
15 -- Start of Comments
16 -- API Name : Get_AR_Trx_Type
17 -- Type : Public
18 -- Pre-Reqs : None
19 -- Function : Oracle Projects Billing Client Extension for Determining
20 -- AR Transaction Type
21 -- Parameters :
22 -- IN P_Project_ID IN NUMBER Required
23 -- Project Identifier. Corresponds to the Column
24 -- PROJECT_ID of PA_PROJECTS_ALL Table
25 -- P_Draft_Invoice_Num IN NUMBER Required
26 -- Draft Invoice Number. Corresponds to the Column
27 -- DRAFT_INVOICE_NUM of PA_DRAFT_INVOICES_ALL Table
28 -- P_Invoice_Class IN VARCHAR2 Required
29 -- Class of the Invoice. Valid Values are
30 -- INVOICE - Regular Invoice
31 -- CREDIT_MEMO - Crediting Invoice
32 -- WRITE_OFF - Write-Off Invoice
33 -- CANCEL - Canceling Invoice
34 -- P_Invoice_Amount IN VARCHAR2 Required
35 -- Amount on the Draft Invoice.
36 -- P_AR_Trx_Type_ID IN Number Required
37 -- Transaction Type ID . Corresponds to the Column
38 -- CUST_TRX_TYPE_ID of RA_CUST_TRX_TYPES Table
39 -- OUT X_AR_Trx_Type_ID OUT Number Required
40 -- Transaction Type ID . Corresponds to the Column
41 -- CUST_TRX_TYPE_ID of RA_CUST_TRX_TYPES Table
42 -- X_Status OUT Number Required
43 -- Return Status of the Procedure. Values are
44 -- = 0 - Successfull Execution
45 -- < 0 - Oracle Error
46 -- > 0 - Application Error
47 --
48 -- End of Comments
49 /*----------------------------------------------------------------------------*/
50
51 /*#
52 * This procedure is used to obtain the AR transaction type.
53 * @param P_Project_ID The identifier of the project
54 * @rep:paraminfo {@rep:required}
55 * @param P_Draft_Invoice_Num The draft invoice number
56 * @rep:paraminfo {@rep:required}
57 * @param P_Invoice_Class The class of the invoice
58 * @rep:paraminfo {@rep:required}
59 * @param P_Project_Amount Amount of the invoice in project currency
60 * @rep:paraminfo {@rep:required}
61 * @param P_Project_Currency_Code The project currency code
62 * @rep:paraminfo {@rep:required}
63 * @param P_Inv_Currency_Code The invoice currency code
64 * @rep:paraminfo {@rep:required}
65 * @param P_Invoice_Amount Amount of the invoice in invoice currency
66 * @rep:paraminfo {@rep:required}
67 * @param P_AR_Trx_Type_ID Identifier for the AR transaction type to be used for the invoice.
68 * Oracle Projects uses the setup tables to determine the default AR transaction type and then passes it to the template.
69 * @rep:paraminfo {@rep:required}
70 * @param X_AR_Trx_Type_ID Identifier of the AR transaction type determined by the extension.
71 * After validation, Oracle Projects uses this transaction type to interface invoices to Oracle Receivables.
72 * @rep:paraminfo {@rep:required}
73 * @param X_Status Status indicating whether an error occurred. The valid values are =0 (Success), <0 (SQL Error) OR >0 (Application Error)
74 * @rep:paraminfo {@rep:required}
75 * @rep:scope public
76 * @rep:lifecycle active
77 * @rep:displayname Get AR Transaction Type
78 * @rep:compatibility S
79 */
80 Procedure Get_AR_Trx_Type ( P_Project_ID IN Number,
81 P_Draft_Invoice_Num IN Number,
82 P_Invoice_Class IN Varchar2,
83 P_Project_Amount IN Number,
84 P_Project_Currency_Code IN Varchar2,
85 P_Inv_Currency_Code IN Varchar2,
86 P_Invoice_Amount IN Number,
87 P_AR_Trx_Type_ID IN Number,
88 X_AR_Trx_Type_ID OUT NOCOPY Number, --File.Sql.39 bug 4440895
89 X_Status OUT NOCOPY Number ); --File.Sql.39 bug 4440895
90
91 END PA_Client_Extn_Inv_Transfer;