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:
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:
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;
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;
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;
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:
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;
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;
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;
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;
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;
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:
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:
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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);
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:
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
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.
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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
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 */
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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:
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;
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:
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;
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;
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;
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;
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:
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;
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:
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;
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;
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;
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;
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;