DBA Data[Home] [Help]

APPS.PA_MCB_INVOICE_PKG dependencies on PA_PLSQL_DATATYPES

Line 18: p_task_id IN PA_PLSQL_DATATYPES.NumTabTyp,

14: (
15: p_agreement_id IN NUMBER DEFAULT 0,
16: p_project_id IN Number,
17: p_request_id IN NUMBER,
18: p_task_id IN PA_PLSQL_DATATYPES.NumTabTyp,
19: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,
20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 19: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,

15: p_agreement_id IN NUMBER DEFAULT 0,
16: p_project_id IN Number,
17: p_request_id IN NUMBER,
18: p_task_id IN PA_PLSQL_DATATYPES.NumTabTyp,
19: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,
20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

16: p_project_id IN Number,
17: p_request_id IN NUMBER,
18: p_task_id IN PA_PLSQL_DATATYPES.NumTabTyp,
19: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,
20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

17: p_request_id IN NUMBER,
18: p_task_id IN PA_PLSQL_DATATYPES.NumTabTyp,
19: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,
20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

18: p_task_id IN PA_PLSQL_DATATYPES.NumTabTyp,
19: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,
20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

19: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,
20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

20: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

21: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,
22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

22: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

23: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

24: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

25: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

26: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

27: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

28: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

29: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

30: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
38: p_shared_funds_consumption IN NUMBER,

Line 35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

31: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
38: p_shared_funds_consumption IN NUMBER,
39: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp,

Line 36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

32: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
38: p_shared_funds_consumption IN NUMBER,
39: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
40: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

33: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
38: p_shared_funds_consumption IN NUMBER,
39: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
40: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
41: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 39: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp,

35: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
38: p_shared_funds_consumption IN NUMBER,
39: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
40: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
41: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42: );
43: /* Procedure to Convert the Line Amount to Funding Amount */

Line 40: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

36: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
37: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
38: p_shared_funds_consumption IN NUMBER,
39: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp,
40: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
41: x_return_status IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42: );
43: /* Procedure to Convert the Line Amount to Funding Amount */
44: PROCEDURE Convert_Line_Event_amount (