1 PACKAGE PA_CC_AP_INV_CLIENT_EXTN AS
2 -- $Header: PACCINPS.pls 120.6 2006/07/25 06:33:50 lveerubh noship $
3 /*#
4 * When using Intercompany or Inter Project Billing, you must define organization controls using the Provider/Receiver Controls window.
5 * For each Provider and Receiver pair, you select the expenditure type and expenditure organization to use when creating the internal
6 * payables invoices. In order to further classify cost based on additional transaction information, you can use this client extension to override
7 * the payables invoice attributes.
8 * @rep:scope public
9 * @rep:product PA
10 * @rep:lifecycle active
11 * @rep:displayname Internal Payables Invoice Attributes Override Extension
12 * @rep:compatibility S
13 * @rep:category BUSINESS_ENTITY PA_PROJECT
14 * @rep:category BUSINESS_ENTITY PA_IC_TRANSACTION
15 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
16 */
17
18 /*#
19 * When using Intercompany or Inter Project Billing, you must define organization controls using the Provider/Receiver Controls window.
20 * For each Provider and Receiver pair, you select the expenditure type and expenditure organization to use when creating the internal
21 * payables invoices. In order to further classify cost based on additional transaction information, you can use this client extension to override
22 * the payables invoice attributes.
23 * @param p_internal_billing_type Determines if the internal payables invoice is created
24 * for intercompany billing invoice or inter project billing
25 * invoice. The valid values are:PA_IC_INVOICES (intercompany billing invoice) or
26 * PA_IP_INVOICES(inter project billing invoice).
27 * @rep:paraminfo {@rep:required}
28 * @param p_project_id Identifier of the provider
29 * project of an Inter project billing invoice, or the intercompany billing project for an intercompany billing
30 * @rep:paraminfo {@rep:precision 1} {@rep:required}
31 * @param p_receiver_project_id Identifier of the receiver project
32 * @rep:paraminfo {@rep:required}
33 * @param p_receiver_task_id Identifier of the receiver task for an inter project
34 * billing invoice, or the task defined as the intercompany non recoverable tax
35 * receiving task for an intercompany billing invoice
36 * @rep:paraminfo {@rep:required}
37 * @param p_draft_invoice_number Number of the corresponding
38 * intercompany invoice for which the internal payables invoice is created
39 * @rep:paraminfo {@rep:required}
40 * @param p_draft_invoice_line_num Line number of the corresponding intercompany invoice line for which the
41 * internal payables invoice line is created
42 * @rep:paraminfo {@rep:required}
43 * @param p_invoice_date Internal payables invoice date
44 * @rep:paraminfo {@rep:required}
45 * @param p_ra_invoice_number Number of the internal Payables invoice
46 * @rep:paraminfo {@rep:required}
47 * @param p_provider_org_id Identifier of the provider operating unit
48 * @rep:paraminfo {@rep:required}
49 * @param p_receiver_org_id Identifier of the receiver operating unit
50 * @rep:paraminfo {@rep:required}
51 * @param p_cc_ar_invoice_id Identifier of the corresponding invoice created in receivables for the inter company invoice
52 * @rep:paraminfo {@rep:required}
53 * @param p_cc_ar_invoice_line_num Line number of the corresponding invoice line created in receivables for the intercompany invoice
54 * @rep:paraminfo {@rep:required}
55 * @param p_project_customer_id Identifier of the provider project customer for an inter project billing invoice
56 * or the intercompany billing project customer for an intercompany billing invoice
57 * @rep:paraminfo {@rep:required}
58 * @param p_vendor_id Identifier of the supplier of the provider operating unit,based on the user setup for the provider
59 * operating unit,in the Receiver controls tab for the Provider/Receiver controls window
60 * @rep:paraminfo {@rep:required}
61 * @param p_vendor_site_id Identifier of the supplier site of the provider operating unit,based on the user setup for the
62 * provider operating unit in the receiver controls tab of the Provider/Receiver Control window
63 * @rep:paraminfo {@rep:required}
64 * @param p_expenditure_type Expenditure type for internal invoice distribution lines(Receiver Controls tab of the Provider/Receiver Controls window)
65 * @rep:paraminfo {@rep:required}
66 * @param p_expenditure_organization_id Identifier of the expenditure organization for internal invoice distribution lines(Receiver Controls tab of the
67 * Provider/Receiver Controls window)
68 * @rep:paraminfo {@rep:required}
69 * @param x_expenditure_type Expenditure type for the
70 * internal invoice distribution lines(determined by the client extension)
71 * @rep:paraminfo {@rep:required}
72 * @param x_expenditure_organization_id Identifier of the expenditure organization
73 * for the internal invoice distribution lines(determined by the client extension)
74 * @rep:paraminfo {@rep:required}
75 * @param x_status Status indicating whether an error
76 * occurred. Valid values are:=0 Success, <0 Oracle Error
77 * >0 Application Error
78 * @rep:paraminfo {@rep:required}
79 * @param x_Error_Stage Error handling stage
80 * @rep:paraminfo {@rep:required}
81 * @param X_Error_Code Error handling code
82 * @rep:paraminfo {@rep:required}
83 * @rep:scope public
84 * @rep:lifecycle active
85 * @rep:displayname Internal Payables Invoice Attributes Override Extension
86 * @rep:compatibility S
87 */
88
89
90 PROCEDURE override_exp_type_exp_org (
91 p_internal_billing_type IN VARCHAR2,
92 p_project_id IN NUMBER,
93 p_receiver_project_id IN NUMBER,
94 p_receiver_task_id IN NUMBER,
95 p_draft_invoice_number IN NUMBER,
96 p_draft_invoice_line_num IN NUMBER,
97 p_invoice_date IN DATE,
98 p_ra_invoice_number IN VARCHAR,
99 p_provider_org_id IN NUMBER,
100 p_receiver_org_id IN NUMBER,
101 p_cc_ar_invoice_id IN NUMBER,
102 p_cc_ar_invoice_line_num IN NUMBER,
103 p_project_customer_id IN NUMBER,
104 p_vendor_id IN NUMBER,
105 p_vendor_site_id IN NUMBER,
106 p_expenditure_type IN VARCHAR2,
107 p_expenditure_organization_id IN NUMBER,
108 x_expenditure_type OUT NOCOPY VARCHAR2,
109 x_expenditure_organization_id OUT NOCOPY NUMBER,
110 x_status IN OUT NOCOPY NUMBER,
111 x_Error_Stage IN OUT NOCOPY VARCHAR2,
112 X_Error_Code IN OUT NOCOPY NUMBER);
113
114
115 END PA_CC_AP_INV_CLIENT_EXTN;