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