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_MCB_INVOICE_PKG dependencies on PA_PLSQL_DATATYPES

Line 16: p_task_id IN PA_PLSQL_DATATYPES.NumTabTyp ,

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

Line 17: p_event_num IN PA_PLSQL_DATATYPES.NumTabTyp,

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

Line 18: p_bill_trans_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 19: p_bill_trans_bill_amount IN PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 20: p_invproc_currency_code IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 21: p_invproc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 22: p_invproc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 23: p_invproc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 24: p_invproc_bill_amount IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 25: p_project_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 26: p_project_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 27: p_project_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 28: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 29: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 30: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 31: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

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

Line 32: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

28: p_project_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
29: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_shared_funds_consumption IN NUMBER, /* Federal */

Line 33: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

29: p_projfunc_currency_code IN PA_PLSQL_DATATYPES.Char30TabTyp,
30: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_shared_funds_consumption IN NUMBER, /* Federal */
37: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */

Line 34: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

30: p_projfunc_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
31: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_shared_funds_consumption IN NUMBER, /* Federal */
37: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */
38: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

Line 35: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

31: p_projfunc_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
32: p_projfunc_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
33: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_shared_funds_consumption IN NUMBER, /* Federal */
37: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */
38: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
39: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 37: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */

33: p_funding_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
34: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_shared_funds_consumption IN NUMBER, /* Federal */
37: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */
38: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
39: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
40:
41: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 38: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,

34: p_funding_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
35: p_funding_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
36: p_shared_funds_consumption IN NUMBER, /* Federal */
37: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */
38: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
39: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
40:
41: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 41: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;

37: p_completion_date IN PA_PLSQL_DATATYPES.Char30TabTyp, /* Federal */
38: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
39: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
40:
41: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
45:

Line 42: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;

38: x_status_tab IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp,
39: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
40:
41: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
45:
46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 43: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

39: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
40:
41: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
45:
46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;

40:
41: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
45:
46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;

42: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
45:
46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;

43: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
45:
46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
51:

Line 48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;

44: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
45:
46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
51:
52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;

45:
46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
51:
52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

46: tmp_status_project_tab PA_PLSQL_DATATYPES.Char30TabTyp;
47: tmp_status_projfunc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
51:
52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

48: tmp_status_funding_tab PA_PLSQL_DATATYPES.Char30TabTyp;
49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
51:
52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

Line 53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

49: tmp_status_invproc_tab PA_PLSQL_DATATYPES.Char30TabTyp;
50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
51:
52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
57:

Line 54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

50: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
51:
52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
57:
58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

51:
52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
57:
58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;

52: tmp_project_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
53: tmp_projfunc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
57:
58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

Line 58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

54: tmp_funding_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
57:
58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
62:

Line 59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

55: tmp_invproc_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
57:
58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
62:
63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

Line 60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

56: tmp_bill_trans_bill_amount PA_PLSQL_DATATYPES.NumTabTyp;
57:
58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
62:
63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;

57:
58: tmp_project_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
62:
63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

Line 63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;

59: tmp_projfunc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
62:
63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
66:
67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

60: tmp_funding_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
62:
63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
66:
67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
68: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;

61: tmp_invproc_exchange_rate PA_PLSQL_DATATYPES.NumTabTyp;
62:
63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
66:
67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
68: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
69: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

63: tmp_invproc_rate_type PA_PLSQL_DATATYPES.Char30TabTyp;
64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
66:
67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
68: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
69: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
70: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
71:

Line 68: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

64: tmp_invproc_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
66:
67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
68: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
69: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
70: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
71:
72:

Line 69: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

65: tmp_funding_currency_code PA_PLSQL_DATATYPES.Char30TabTyp;
66:
67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
68: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
69: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
70: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
71:
72:
73: tmp_invproc_currency_type VARCHAR2(30);

Line 70: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;

66:
67: tmp_project_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
68: tmp_projfunc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
69: tmp_funding_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
70: tmp_invproc_rate_date PA_PLSQL_DATATYPES.DateTabTyp;
71:
72:
73: tmp_invproc_currency_type VARCHAR2(30);
74:

Line 109: tmp_completion_date PA_PLSQL_DATATYPES.DateTabTyp;

105: l_last_update_login NUMBER:= fnd_global.login_id;
106:
107: /* Federal Changes */
108:
109: tmp_completion_date PA_PLSQL_DATATYPES.DateTabTyp;
110: l_agreement_start_date DATE;
111: l_agreement_exp_date DATE;
112:
113:

Line 710: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;

706: tmp_projfunc_inv_exch_rate NUMBER;
707: tmp_projfunc_inv_rate_date DATE;
708: tmp_projfunc_rate_type VARCHAR2(30);
709:
710: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
711: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 711: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;

707: tmp_projfunc_inv_rate_date DATE;
708: tmp_projfunc_rate_type VARCHAR2(30);
709:
710: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
711: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

708: tmp_projfunc_rate_type VARCHAR2(30);
709:
710: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
711: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;

709:
710: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
711: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

710: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
711: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

711: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

712: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
720: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

713: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
720: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
721: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

714: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
720: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
721: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
722:

Line 719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

715: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
720: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
721: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
722:
723: tmp_invproc_currency_type VARCHAR2(30);

Line 720: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

716: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
720: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
721: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
722:
723: tmp_invproc_currency_type VARCHAR2(30);
724:

Line 721: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

717: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
718: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
719: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
720: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
721: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
722:
723: tmp_invproc_currency_type VARCHAR2(30);
724:
725: BEGIN

Line 1176: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;

1172: x_funding_bill_amount OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1173: x_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1174: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1175:
1176: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1177: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1177: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;

1173: x_status_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1174: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1175:
1176: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1177: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1174: x_return_status IN OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
1175:
1176: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1177: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1175:
1176: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1177: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

1176: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1177: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1177: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1178: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1186: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1179: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1186: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1187: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

1180: tmp_funding_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1186: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1187: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1188:

Line 1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1181: tmp_funding_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1186: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1187: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1188:
1189: BEGIN

Line 1186: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1182: tmp_funding_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1186: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1187: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1188:
1189: BEGIN
1190:

Line 1187: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1183: tmp_funding_exchange_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1184: tmp_bill_trans_bill_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1185: tmp_bill_trans_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1186: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1187: tmp_funding_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1188:
1189: BEGIN
1190:
1191: IF g1_debug_mode = 'Y' THEN

Line 1311: tmp_pfc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1307:
1308: -- Bug : 4298230 Added the following parameters for the call to PA_MULTI_CURRENCY_BILLING.convert_amount_bulk
1309: l_reject_reason_meaning VARCHAR2(500);
1310: l_invoice_date DATE := pa_billing.GetInvoiceDate;
1311: tmp_pfc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1308: -- Bug : 4298230 Added the following parameters for the call to PA_MULTI_CURRENCY_BILLING.convert_amount_bulk
1309: l_reject_reason_meaning VARCHAR2(500);
1310: l_invoice_date DATE := pa_billing.GetInvoiceDate;
1311: tmp_pfc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;

1309: l_reject_reason_meaning VARCHAR2(500);
1310: l_invoice_date DATE := pa_billing.GetInvoiceDate;
1311: tmp_pfc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;

1310: l_invoice_date DATE := pa_billing.GetInvoiceDate;
1311: tmp_pfc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;

1311: tmp_pfc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1321: tmp_projfunc_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1321: tmp_projfunc_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1322: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1315: tmp_numerator_tab PA_PLSQL_DATATYPES.NumTabTyp;
1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1321: tmp_projfunc_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1322: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1323:

Line 1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1316: tmp_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1321: tmp_projfunc_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1322: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1323:
1324: l_sum_projfunc_bill_amount NUMBER; --Added For Bug 6084445

Line 1321: tmp_projfunc_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1317: tmp_status_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1321: tmp_projfunc_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1322: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1323:
1324: l_sum_projfunc_bill_amount NUMBER; --Added For Bug 6084445
1325: l_sum_inv_amount NUMBER; --Added For Bug 6084445

Line 1322: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1318: tmp_bill_trans_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1319: tmp_bill_trans_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1320: tmp_projfunc_rate_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1321: tmp_projfunc_rate_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1322: tmp_user_validate_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1323:
1324: l_sum_projfunc_bill_amount NUMBER; --Added For Bug 6084445
1325: l_sum_inv_amount NUMBER; --Added For Bug 6084445
1326: