5: --Procedure Transfer_ar_ap_invoices is a wrapper to convert the
6: --data types for input parameters
7: ----------------------------------------------------------------
8: Procedure Transfer_ar_ap_invoices(
9: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
10: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
6: --data types for input parameters
7: ----------------------------------------------------------------
8: Procedure Transfer_ar_ap_invoices(
9: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
10: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
7: ----------------------------------------------------------------
8: Procedure Transfer_ar_ap_invoices(
9: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
10: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
8: Procedure Transfer_ar_ap_invoices(
9: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
10: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
9: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
10: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
10: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
13: p_prvdr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
21: p_array_size in number,
14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
21: p_array_size in number,
22: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
21: p_array_size in number,
22: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
23: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,
17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
21: p_array_size in number,
22: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
23: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
24: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
21: p_array_size in number,
22: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
23: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
24: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
25:
26: --v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
21: p_array_size in number,
22: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
23: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
24: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
25:
26: --v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
27: --v_draft_invoice_number PA_PLSQL_DATATYPES.NumTabTyp;
22: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
23: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
24: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
25:
26: --v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
27: --v_draft_invoice_number PA_PLSQL_DATATYPES.NumTabTyp;
28: v_prvdr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;
23: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
24: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
25:
26: --v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
27: --v_draft_invoice_number PA_PLSQL_DATATYPES.NumTabTyp;
28: v_prvdr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;
31: v_project_customer_id PA_PLSQL_DATATYPES.NumTabTyp;
24: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
25:
26: --v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
27: --v_draft_invoice_number PA_PLSQL_DATATYPES.NumTabTyp;
28: v_prvdr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;
31: v_project_customer_id PA_PLSQL_DATATYPES.NumTabTyp;
32: v_invoice_date PA_PLSQL_DATATYPES.DateTabTyp;
25:
26: --v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
27: --v_draft_invoice_number PA_PLSQL_DATATYPES.NumTabTyp;
28: v_prvdr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;
31: v_project_customer_id PA_PLSQL_DATATYPES.NumTabTyp;
32: v_invoice_date PA_PLSQL_DATATYPES.DateTabTyp;
33: --v_array_size number;
26: --v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
27: --v_draft_invoice_number PA_PLSQL_DATATYPES.NumTabTyp;
28: v_prvdr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;
31: v_project_customer_id PA_PLSQL_DATATYPES.NumTabTyp;
32: v_invoice_date PA_PLSQL_DATATYPES.DateTabTyp;
33: --v_array_size number;
34: v_debug_mode varchar2(2);
27: --v_draft_invoice_number PA_PLSQL_DATATYPES.NumTabTyp;
28: v_prvdr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;
31: v_project_customer_id PA_PLSQL_DATATYPES.NumTabTyp;
32: v_invoice_date PA_PLSQL_DATATYPES.DateTabTyp;
33: --v_array_size number;
34: v_debug_mode varchar2(2);
35: v_process_mode varchar2(10);
28: v_prvdr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;
30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;
31: v_project_customer_id PA_PLSQL_DATATYPES.NumTabTyp;
32: v_invoice_date PA_PLSQL_DATATYPES.DateTabTyp;
33: --v_array_size number;
34: v_debug_mode varchar2(2);
35: v_process_mode varchar2(10);
36:
75: -----------------------------------------------------------
76: Procedure Transfer_ar_ap_invoices_01(
77: p_debug_mode in varchar2,
78: p_process_mode in varchar2,
79: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
80: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
81: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
76: Procedure Transfer_ar_ap_invoices_01(
77: p_debug_mode in varchar2,
78: p_process_mode in varchar2,
79: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
80: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
81: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
77: p_debug_mode in varchar2,
78: p_process_mode in varchar2,
79: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
80: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
81: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
78: p_process_mode in varchar2,
79: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
80: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
81: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
79: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,
80: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
81: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
80: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
81: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
81: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
83: p_prvdr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
91: p_array_size in Number,
84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
91: p_array_size in Number,
92: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
85: p_customer_trx_id in PA_PLSQL_DATATYPES.NumTabTyp,
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
91: p_array_size in Number,
92: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
93: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
86: p_project_customer_id in PA_PLSQL_DATATYPES.NumTabTyp,
87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
91: p_array_size in Number,
92: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
93: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
94: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
91: p_array_size in Number,
92: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
93: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
94: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
95:
96: Cursor c_setup_info(p_prvdr_org_id in number, p_recvr_org_id in number) is
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,
91: p_array_size in Number,
92: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/*file.sql.39*/
93: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/*file.sql.39*/
94: x_status_code out NOCOPY varchar2 /*file.sql.39*/) IS
95:
96: Cursor c_setup_info(p_prvdr_org_id in number, p_recvr_org_id in number) is
97: select a.vendor_site_id vendor_site_id ,
193: v_process_mode varchar2(10);
194: v_old_stack VARCHAR2(630);
195: v_invoice_type varchar2(30); -- added for etax changes
196: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
197: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
198: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
199: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
194: v_old_stack VARCHAR2(630);
195: v_invoice_type varchar2(30); -- added for etax changes
196: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
197: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
198: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
199: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
195: v_invoice_type varchar2(30); -- added for etax changes
196: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
197: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
198: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
199: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
196: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
197: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
198: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
199: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
204: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
197: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
198: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
199: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
204: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
205: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
198: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
199: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
204: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
205: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
206: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
199: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
204: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
205: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
206: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
207: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;
200: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
204: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
205: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
206: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
207: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;
208: v_lines_counter number;
201: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
204: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
205: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
206: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
207: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;
208: v_lines_counter number;
209: v_counter number :=0;
202: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
203: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
204: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
205: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
206: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
207: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;
208: v_lines_counter number;
209: v_counter number :=0;
210:
219:
220: l_receiver_project_id number;
221: l_receiver_task_id number;
222:
223: v_arr_exp_type PA_PLSQL_DATATYPES.Char50TabTyp;
224: v_arr_exp_organization_id PA_PLSQL_DATATYPES.NumTabTyp;
225:
226: -- DevDrop2 Changes End
227:
220: l_receiver_project_id number;
221: l_receiver_task_id number;
222:
223: v_arr_exp_type PA_PLSQL_DATATYPES.Char50TabTyp;
224: v_arr_exp_organization_id PA_PLSQL_DATATYPES.NumTabTyp;
225:
226: -- DevDrop2 Changes End
227:
228: Begin
651: p_invoice_id in number,
652: p_internal_billing_type in varchar2,
653: p_receiver_project_id in number,
654: p_receiver_task_id in number,
655: p_expenditure_type in PA_PLSQL_DATATYPES.Char50TabTyp,
656: p_invoice_date in date ,
657: p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_recvr_org_id in number,
659: p_customer_trx_id in number,
653: p_receiver_project_id in number,
654: p_receiver_task_id in number,
655: p_expenditure_type in PA_PLSQL_DATATYPES.Char50TabTyp,
656: p_invoice_date in date ,
657: p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_recvr_org_id in number,
659: p_customer_trx_id in number,
660: p_project_customer_id in number,
661: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
657: p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_recvr_org_id in number,
659: p_customer_trx_id in number,
660: p_project_customer_id in number,
661: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_recvr_org_id in number,
659: p_customer_trx_id in number,
660: p_project_customer_id in number,
661: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
666: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
659: p_customer_trx_id in number,
660: p_project_customer_id in number,
661: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
666: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
667: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
660: p_project_customer_id in number,
661: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
666: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
667: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
668: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
661: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
666: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
667: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
668: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
669: p_sub_array_size in number,
662: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
666: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
667: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
668: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
669: p_sub_array_size in number,
670: p_invoice_type in VARCHAR2, -- added for etax changtes
663: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
666: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
667: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
668: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
669: p_sub_array_size in number,
670: p_invoice_type in VARCHAR2, -- added for etax changtes
671: p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406
664: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
665: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
666: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
667: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
668: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
669: p_sub_array_size in number,
670: p_invoice_type in VARCHAR2, -- added for etax changtes
671: p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406
672: )
667: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
668: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
669: p_sub_array_size in number,
670: p_invoice_type in VARCHAR2, -- added for etax changtes
671: p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406
672: )
673: IS
674:
675: -- the following var declarations added for etax changes