1 PACKAGE PA_CC_AR_AP_TRANSFER AUTHID CURRENT_USER AS
2 /* $Header: PAXARAPS.pls 120.3 2006/03/15 19:19:50 sbsivara noship $ */
3
4 G_created_by number := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
5 G_last_update_login number := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1);
6 G_last_updated_by number := G_created_by;
7 G_creation_date date := SYSDATE;
8 G_last_update_date date := SYSDATE ;
9
10 procedure Populate_ap_invoices_interface(
11 p_internal_billing_type in varchar2,
12 p_invoice_id in number,
13 p_invoice_number in varchar2,
14 p_invoice_date in date,
15 p_vendor_id in number,
16 p_vendor_site_id in number,
17 p_invoice_amount number,
18 p_invoice_currency_code in varchar2,
19 p_description in varchar2,
20 p_group_id in varchar2,
21 p_workflow_flag in varchar2,
22 p_org_id in number);
23
24 procedure Populate_ap_inv_line_interface(
25 p_invoice_id in number,
26 p_internal_billing_type in varchar2,
27 p_receiver_project_id in number,
28 p_receiver_task_id in number,
29 p_expenditure_type in PA_PLSQL_DATATYPES.Char50TabTyp,
30 p_invoice_date in date ,
31 p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,
32 p_recvr_org_id in number,
33 p_customer_trx_id in number,
34 p_project_customer_id in number,
35 p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
36 p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
37 p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
38 p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
39 p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
40 p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
41 p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
42 p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
43 p_sub_array_size in number,
44 p_invoice_type in VARCHAR2, -- added for etax changtes
45 p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406
46 );
47
48
49
50 Procedure Transfer_ar_ap_invoices_01(
51 p_debug_mode in varchar2,
52 p_process_mode in varchar2,
53 p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
54 p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
55 p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
56 p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
57 p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
58 p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
59 p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
60 p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
61 p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
62 p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
63 p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
64 p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
65 p_array_size in Number,
66 x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
67 x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
68 x_status_code out NOCOPY varchar2 /*file.sql.39*/);
69 Procedure Transfer_ar_ap_invoices(
70 p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
71 p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
72 p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
73 p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
74 p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
75 p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
76 p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
77 p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
78 p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
79 p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
80 p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
81 p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
82 p_array_size in number,
83 x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp /*file.sql.39*/,
84 x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp /*file.sql.39*/,
85 x_status_code out NOCOPY varchar2 /*file.sql.39*/);
86
87 end PA_CC_AR_AP_TRANSFER;