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

Line 20: l_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;

16: l_pfc_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
17: l_pc_project_value PA_PROJECTS_ALL.PROJECT_VALUE%TYPE;
18: l_pfc_burdened_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE := 0;
19: l_pfc_revenue PA_BUDGET_VERSIONS.REVENUE%TYPE := 0;
20: l_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
21: l_rev NUMBER;
22: l_running_rev NUMBER := 0;
23: l_diff NUMBER;
24:

Line 31: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

27: l_data VARCHAR2(2000);
28: l_msg_index_out NUMBER:=0;
29:
30: --l_total_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE;
31: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
32: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35:

Line 32: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

28: l_msg_index_out NUMBER:=0;
29:
30: --l_total_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE;
31: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
32: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35:
36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

29:
30: --l_total_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE;
31: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
32: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35:
36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

30: --l_total_cost PA_BUDGET_VERSIONS.BURDENED_COST%TYPE;
31: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
32: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35:
36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

32: l_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35:
36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40:

Line 37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

33: l_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35:
36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40:
41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

34: l_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
35:
36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40:
41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

35:
36: l_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40:
41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;

37: l_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40:
41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
45: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;

38: l_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40:
41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
45: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
46: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;

39: l_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
40:
41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
45: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
46: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
47:

Line 44: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

40:
41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
45: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
46: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
47:
48:

Line 45: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

41: l_txn_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
45: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
46: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
47:
48:
49: l_running_txn_rev NUMBER := 0;

Line 46: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

42: l_pc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
43: l_pfc_rev_tab PA_PLSQL_DATATYPES.NumTabTyp;
44: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
45: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
46: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
47:
48:
49: l_running_txn_rev NUMBER := 0;
50: l_running_pc_rev NUMBER := 0;

Line 67: --l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

63: l_approved_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE;
64:
65: l_cost_or_rev_code VARCHAR2(30) := 'COST';
66:
67: --l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
71:

Line 68: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

64:
65: l_cost_or_rev_code VARCHAR2(30) := 'COST';
66:
67: --l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
71:
72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 69: l_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

65: l_cost_or_rev_code VARCHAR2(30) := 'COST';
66:
67: --l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
71:
72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

66:
67: --l_pfc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
68: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
71:
72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

Line 72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

68: l_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
69: l_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
71:
72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
75:
76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

Line 73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

69: l_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
71:
72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
75:
76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

Line 74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

70: l_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
71:
72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
75:
76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
78: l_start_date_tmp PA_BUDGET_LINES.START_DATE%TYPE;

Line 85: l_budget_line_id_upd_tab PA_PLSQL_DATATYPES.IdTabTyp;

81:
82: l_upd_count NUMBER := 0;
83: l_del_count NUMBER := 0;
84: l_dup_bl_id NUMBER;
85: l_budget_line_id_upd_tab PA_PLSQL_DATATYPES.IdTabTyp;
86: l_budget_line_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
87: l_txn_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 86: l_budget_line_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;

82: l_upd_count NUMBER := 0;
83: l_del_count NUMBER := 0;
84: l_dup_bl_id NUMBER;
85: l_budget_line_id_upd_tab PA_PLSQL_DATATYPES.IdTabTyp;
86: l_budget_line_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
87: l_txn_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
90:

Line 87: l_txn_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

83: l_del_count NUMBER := 0;
84: l_dup_bl_id NUMBER;
85: l_budget_line_id_upd_tab PA_PLSQL_DATATYPES.IdTabTyp;
86: l_budget_line_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
87: l_txn_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
90:
91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

84: l_dup_bl_id NUMBER;
85: l_budget_line_id_upd_tab PA_PLSQL_DATATYPES.IdTabTyp;
86: l_budget_line_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
87: l_txn_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
90:
91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

85: l_budget_line_id_upd_tab PA_PLSQL_DATATYPES.IdTabTyp;
86: l_budget_line_id_del_tab PA_PLSQL_DATATYPES.IdTabTyp;
87: l_txn_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
90:
91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

87: l_txn_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
90:
91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
94:
95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

88: l_pc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
90:
91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
94:
95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
96: l_pc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

89: l_pfc_burdened_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
90:
91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
94:
95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
96: l_pc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
97: l_pfc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

91: l_txn_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
94:
95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
96: l_pc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
97: l_pfc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
98:
99: l_quantity_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 96: l_pc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

92: l_pc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
94:
95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
96: l_pc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
97: l_pfc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
98:
99: l_quantity_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
100:

Line 97: l_pfc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

93: l_pfc_raw_cost_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
94:
95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
96: l_pc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
97: l_pfc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
98:
99: l_quantity_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
100:
101: l_dup_bl_num NUMBER;

Line 99: l_quantity_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;

95: l_txn_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
96: l_pc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
97: l_pfc_revenue_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
98:
99: l_quantity_upd_tab PA_PLSQL_DATATYPES.NumTabTyp;
100:
101: l_dup_bl_num NUMBER;
102: l_bill_amt_pfc_revenue NUMBER;
103: l_bill_amt_pc_revenue NUMBER;

Line 105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

101: l_dup_bl_num NUMBER;
102: l_bill_amt_pfc_revenue NUMBER;
103: l_bill_amt_pc_revenue NUMBER;
104:
105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
106:
107: --Added foll 3 variables for bug 4127427 to calculate l_ratio for PC seperately
108: l_pc_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE := 0;
109: l_pc_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE := 0;

Line 116: l_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

112: /* Variables added for Bug 4549862 */
113: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
114:
115: -- Variables added for IPM Enhancements
116: l_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_ipm_currency_code_tab PA_PLSQL_DATATYPES.Char15TabTyp;
118: l_rc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
119: l_bc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
120: l_calling_module VARCHAR2(30);

Line 117: l_ipm_currency_code_tab PA_PLSQL_DATATYPES.Char15TabTyp;

113: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
114:
115: -- Variables added for IPM Enhancements
116: l_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_ipm_currency_code_tab PA_PLSQL_DATATYPES.Char15TabTyp;
118: l_rc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
119: l_bc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
120: l_calling_module VARCHAR2(30);
121:

Line 118: l_rc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

114:
115: -- Variables added for IPM Enhancements
116: l_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_ipm_currency_code_tab PA_PLSQL_DATATYPES.Char15TabTyp;
118: l_rc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
119: l_bc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
120: l_calling_module VARCHAR2(30);
121:
122: -- Added in IPM to track if a record in the existing set of

Line 119: l_bc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

115: -- Variables added for IPM Enhancements
116: l_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
117: l_ipm_currency_code_tab PA_PLSQL_DATATYPES.Char15TabTyp;
118: l_rc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
119: l_bc_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
120: l_calling_module VARCHAR2(30);
121:
122: -- Added in IPM to track if a record in the existing set of
123: -- pl/sql tables needs to be removed.

Line 124: l_remove_record_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;

120: l_calling_module VARCHAR2(30);
121:
122: -- Added in IPM to track if a record in the existing set of
123: -- pl/sql tables needs to be removed.
124: l_remove_record_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
125: l_remove_records_flag VARCHAR2(1);
126:
127: l_tmp_index NUMBER;
128: l_tmp_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 128: l_tmp_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

124: l_remove_record_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
125: l_remove_records_flag VARCHAR2(1);
126:
127: l_tmp_index NUMBER;
128: l_tmp_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_tmp_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 129: l_tmp_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

125: l_remove_records_flag VARCHAR2(1);
126:
127: l_tmp_index NUMBER;
128: l_tmp_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_tmp_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

126:
127: l_tmp_index NUMBER;
128: l_tmp_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_tmp_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

127: l_tmp_index NUMBER;
128: l_tmp_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_tmp_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

128: l_tmp_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
129: l_tmp_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

129: l_tmp_txn_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

130: l_tmp_pc_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

131: l_tmp_burdened_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

132: l_tmp_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
140: l_tmp_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

133: l_tmp_txn_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
140: l_tmp_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
141: l_tmp_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

134: l_tmp_pc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
140: l_tmp_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
141: l_tmp_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
142:

Line 139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

135: l_tmp_pfc_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
140: l_tmp_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
141: l_tmp_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
142:
143: BEGIN

Line 140: l_tmp_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

136: l_tmp_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
140: l_tmp_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
141: l_tmp_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
142:
143: BEGIN
144: /* Setting initial values */

Line 141: l_tmp_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;

137: l_tmp_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
138: l_tmp_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
139: l_tmp_txn_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
140: l_tmp_project_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
141: l_tmp_revenue_tab PA_PLSQL_DATATYPES.NumTabTyp;
142:
143: BEGIN
144: /* Setting initial values */
145: X_MSG_COUNT := 0;

Line 1816: l_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

1812: AND tmp.txn_currency_code = bl.txn_currency_code ) > 0;
1813:
1814: /* Variables added for Bug 4549862 */
1815:
1816: l_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1817: l_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1817: l_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;

1813:
1814: /* Variables added for Bug 4549862 */
1815:
1816: l_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1817: l_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

1814: /* Variables added for Bug 4549862 */
1815:
1816: l_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1817: l_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

1815:
1816: l_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1817: l_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1816: l_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1817: l_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;

1817: l_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1825:

Line 1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1818: l_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1825:
1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1819: l_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1825:
1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

1820: l_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1821: l_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1825:
1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1822: l_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1825:
1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1823: l_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1825:
1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

1824: l_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1825:
1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1832:

Line 1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1825:
1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1832:
1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1826: l_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1832:
1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

1827: l_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1828: l_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1832:
1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1829: l_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1832:
1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1830: l_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1832:
1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1831: l_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1832:
1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1832:
1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1833: l_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1841:

Line 1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1834: l_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1841:
1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

Line 1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1835: l_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1841:
1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;

Line 1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1836: l_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1837: l_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1841:
1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;

1838: l_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1841:
1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;

1839: l_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1841:
1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

1840: l_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1841:
1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;

1841:
1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1842: l_upd_bl_RES_ASSIGNMENT_ID_tab PA_PLSQL_DATATYPES.IDTabTyp;
1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;

1843: l_upd_bl_TXN_CURRENCY_CODE_tab PA_PLSQL_DATATYPES.Char15TabTyp;
1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1851:

Line 1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1844: l_upd_bl_START_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1851:
1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1845: l_upd_bl_END_DATE_tab PA_PLSQL_DATATYPES.DateTabTyp;
1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1851:
1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

1846: l_upd_bl_PERIOD_NAME_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1847: l_upd_bl_QUANTITY_tab PA_PLSQL_DATATYPES.NumTabTyp;
1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1851:
1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1848: l_upd_bl_TXN_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1851:
1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1849: l_upd_bl_TXN_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1851:
1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

1850: l_upd_bl_TXN_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1851:
1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1858:

Line 1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1851:
1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1858:
1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;

1852: l_upd_bl_PC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1858:
1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;

1853: l_upd_bl_PC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1854: l_upd_bl_PC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1858:
1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1855: l_upd_bl_PFC_RAW_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1858:
1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1856: l_upd_bl_PFC_BURDENED_COST_tab PA_PLSQL_DATATYPES.NumTabTyp;
1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1858:
1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1857: l_upd_bl_PFC_REVENUE_tab PA_PLSQL_DATATYPES.NumTabTyp;
1858:
1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1858:
1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1859: l_upd_bl_COST_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1867:

Line 1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1860: l_upd_bl_BURDEN_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1867:
1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1861: l_upd_bl_PC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1867:
1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1869: l_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1862: l_upd_bl_PFC_CUR_REJ_CODE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1863: l_upd_bl_PC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1867:
1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1869: l_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1870:

Line 1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1864: l_upd_bl_PFC_COST_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1867:
1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1869: l_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1870:
1871: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1869: l_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1865: l_upd_bl_PC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1866: l_upd_bl_PFC_REV_RT_TYPE_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1867:
1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1869: l_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1870:
1871: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1873:

Line 1871: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1867:
1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1869: l_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1870:
1871: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1873:
1874: l_txn_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1868: l_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1869: l_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1870:
1871: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1873:
1874: l_txn_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1876: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1874: l_txn_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

1870:
1871: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1873:
1874: l_txn_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1876: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1877:
1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

1871: l_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1873:
1874: l_txn_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1876: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1877:
1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1879: l_upd_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1876: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

1872: l_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1873:
1874: l_txn_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1876: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1877:
1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1879: l_upd_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1880:

Line 1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1874: l_txn_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1876: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1877:
1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1879: l_upd_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1880:
1881: l_upd_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1879: l_upd_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1875: l_txn_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1876: l_txn_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1877:
1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1879: l_upd_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1880:
1881: l_upd_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1883:

Line 1881: l_upd_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1877:
1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1879: l_upd_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1880:
1881: l_upd_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1883:
1884: l_upd_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1885: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

1878: l_upd_cost_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1879: l_upd_cost_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1880:
1881: l_upd_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1883:
1884: l_upd_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1885: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1886: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1884: l_upd_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

1880:
1881: l_upd_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1883:
1884: l_upd_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1885: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1886: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1887:
1888: l_last_updated_by NUMBER := FND_GLOBAL.user_id;

Line 1885: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

1881: l_upd_rev_pc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1883:
1884: l_upd_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1885: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1886: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1887:
1888: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1889: l_last_update_login NUMBER := FND_GLOBAL.login_id;

Line 1886: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;

1882: l_upd_rev_pfc_exchg_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
1883:
1884: l_upd_rcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1885: l_upd_bcost_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1886: l_upd_bill_rate_override_tab PA_PLSQL_DATATYPES.NumTabTyp;
1887:
1888: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1889: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1890: l_sysdate DATE := SYSDATE;