eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CC_AR_AP_TRANSFER dependencies on PA_PLSQL_DATATYPES

Line 9: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,

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,

Line 10: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,

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,

Line 11: p_draft_invoice_number in PA_PLSQL_DATATYPES.NumTabTyp,

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,

Line 12: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,

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,

Line 13: p_prvdr_org_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,

Line 14: p_recvr_org_id in PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 15: p_customer_trx_id in PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 16: p_project_customer_id in PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 17: p_invoice_date in PA_PLSQL_DATATYPES.Char15TabTyp,

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,

Line 18: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,

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*/

Line 19: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,

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*/

Line 20: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,

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

Line 22: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/file.sql.39/

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;

Line 23: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/file.sql.39/

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;

Line 26: --v_project_id 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;

Line 27: --v_draft_invoice_number 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;

Line 28: v_prvdr_org_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;

Line 29: v_recvr_org_id PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 30: v_customer_trx_id PA_PLSQL_DATATYPES.NumTabTyp;

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);

Line 31: v_project_customer_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);
35: v_process_mode varchar2(10);

Line 32: v_invoice_date PA_PLSQL_DATATYPES.DateTabTyp;

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:

Line 79: p_internal_billing_type in PA_PLSQL_DATATYPES.Char20TabTyp,

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,

Line 80: p_project_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,

Line 81: p_draft_invoice_number 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,

Line 82: p_ra_invoice_number in PA_PLSQL_DATATYPES.Char20TabTyp,

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,

Line 83: p_prvdr_org_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,

Line 84: p_recvr_org_id in PA_PLSQL_DATATYPES.NumTabTyp,

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,

Line 85: p_customer_trx_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,
89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,

Line 86: p_project_customer_id 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,
90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,

Line 87: p_invoice_date in PA_PLSQL_DATATYPES.DateTabTyp,

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,

Line 88: p_invoice_comment in PA_PLSQL_DATATYPES.Char240TabTyp,

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*/

Line 89: p_inv_currency_code in PA_PLSQL_DATATYPES.Char15TabTyp,

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*/

Line 90: p_compute_flag in PA_PLSQL_DATATYPES.Char1TabTyp,

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

Line 92: x_transfer_status_code out NOCOPY PA_PLSQL_DATATYPES.Char1TabTyp,/file.sql.39/

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

Line 93: x_transfer_error_code out NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,/file.sql.39/

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 ,

Line 194: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;

190: v_process_mode varchar2(10);
191: v_old_stack VARCHAR2(630);
192: v_invoice_type varchar2(30); -- added for etax changes
193: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
194: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
195: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;

Line 195: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;

191: v_old_stack VARCHAR2(630);
192: v_invoice_type varchar2(30); -- added for etax changes
193: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
194: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
195: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;

Line 196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;

192: v_invoice_type varchar2(30); -- added for etax changes
193: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
194: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
195: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;

Line 197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;

193: v_invoice_lines_rec c_invoice_lines%ROWTYPE;
194: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
195: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;

Line 198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;

194: v_invoice_line_num PA_PLSQL_DATATYPES.NumTabTyp;
195: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
202: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;

Line 199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;

195: v_inv_amount PA_PLSQL_DATATYPES.NumTabTyp;
196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
202: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
203: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406

Line 200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;

196: v_description PA_PLSQL_DATATYPES.Char240TabTyp;
197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
202: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
203: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
204: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;

Line 201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;

197: v_tax_code PA_PLSQL_DATATYPES.Char50TabTyp;
198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
202: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
203: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
204: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;
205: v_lines_counter number;

Line 202: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;

198: --v_tax_id PA_PLSQL_DATATYPES.NumTabTyp;
199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
202: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
203: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
204: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;
205: v_lines_counter number;
206: v_counter number :=0;

Line 203: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406

199: v_project_id PA_PLSQL_DATATYPES.NumTabTyp;
200: v_task_id PA_PLSQL_DATATYPES.NumTabTyp;
201: v_pa_quantity PA_PLSQL_DATATYPES.NumTabTyp;
202: v_pa_cc_ar_inv_line_num PA_PLSQL_DATATYPES.NumTabTyp;
203: v_cust_trx_line_id PA_PLSQL_DATATYPES.NumTabTyp; -- bug 5045406
204: v_lines_counter_rec c_invoice_lines_counter%ROWTYPE;
205: v_lines_counter number;
206: v_counter number :=0;
207:

Line 220: v_arr_exp_type PA_PLSQL_DATATYPES.Char50TabTyp;

216:
217: l_receiver_project_id number;
218: l_receiver_task_id number;
219:
220: v_arr_exp_type PA_PLSQL_DATATYPES.Char50TabTyp;
221: v_arr_exp_organization_id PA_PLSQL_DATATYPES.NumTabTyp;
222:
223: -- DevDrop2 Changes End
224:

Line 221: v_arr_exp_organization_id PA_PLSQL_DATATYPES.NumTabTyp;

217: l_receiver_project_id number;
218: l_receiver_task_id number;
219:
220: v_arr_exp_type PA_PLSQL_DATATYPES.Char50TabTyp;
221: v_arr_exp_organization_id PA_PLSQL_DATATYPES.NumTabTyp;
222:
223: -- DevDrop2 Changes End
224:
225: Begin

Line 651: p_expenditure_type in PA_PLSQL_DATATYPES.Char50TabTyp,

647: p_invoice_id in number,
648: p_internal_billing_type in varchar2,
649: p_receiver_project_id in number,
650: p_receiver_task_id in number,
651: p_expenditure_type in PA_PLSQL_DATATYPES.Char50TabTyp,
652: p_invoice_date in date ,
653: p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,
654: p_recvr_org_id in number,
655: p_customer_trx_id in number,

Line 653: p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,

649: p_receiver_project_id in number,
650: p_receiver_task_id in number,
651: p_expenditure_type in PA_PLSQL_DATATYPES.Char50TabTyp,
652: p_invoice_date in date ,
653: p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,
654: p_recvr_org_id in number,
655: p_customer_trx_id in number,
656: p_project_customer_id in number,
657: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,

Line 657: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,

653: p_expenditure_organization_id in PA_PLSQL_DATATYPES.NumTabTyp,
654: p_recvr_org_id in number,
655: p_customer_trx_id in number,
656: p_project_customer_id in number,
657: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,

Line 658: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,

654: p_recvr_org_id in number,
655: p_customer_trx_id in number,
656: p_project_customer_id in number,
657: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,

Line 659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,

655: p_customer_trx_id in number,
656: p_project_customer_id in number,
657: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,

Line 660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,

656: p_project_customer_id in number,
657: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
664: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,

Line 661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,

657: p_invoice_line_number in PA_PLSQL_DATATYPES.NumTabTyp,
658: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
664: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
665: p_sub_array_size in number,

Line 662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,

658: p_inv_amount in PA_PLSQL_DATATYPES.NumTabTyp,
659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
664: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
665: p_sub_array_size in number,
666: p_invoice_type in VARCHAR2, -- added for etax changtes

Line 663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,

659: p_description in PA_PLSQL_DATATYPES.Char240TabTyp,
660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
664: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
665: p_sub_array_size in number,
666: p_invoice_type in VARCHAR2, -- added for etax changtes
667: p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406

Line 664: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,

660: p_tax_code in PA_PLSQL_DATATYPES.Char50TabTyp,
661: p_project_id in PA_PLSQL_DATATYPES.NumTabTyp,
662: p_task_id in PA_PLSQL_DATATYPES.NumTabTyp,
663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
664: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
665: p_sub_array_size in number,
666: p_invoice_type in VARCHAR2, -- added for etax changtes
667: p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406
668: )

Line 667: p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406

663: p_pa_quantity in PA_PLSQL_DATATYPES.NumTabTyp,
664: p_pa_cc_ar_inv_line_num in PA_PLSQL_DATATYPES.NumTabTyp,
665: p_sub_array_size in number,
666: p_invoice_type in VARCHAR2, -- added for etax changtes
667: p_cust_trx_line_id in PA_PLSQL_DATATYPES.NumTabTyp -- added for bug 5045406
668: )
669: IS
670:
671: -- the following var declarations added for etax changes