106: (
107: p_context IN VARCHAR2
108: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
109: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
110: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
111: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
112: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
113: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
114: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
107: p_context IN VARCHAR2
108: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
109: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
110: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
111: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
112: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
113: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
114: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
115: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
110: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
111: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
112: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
113: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
114: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
115: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
116: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
117: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
118: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
113: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
114: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
115: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
116: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
117: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
118: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
119: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
120: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
121: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
115: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
116: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
117: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
118: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
119: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
120: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
121: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
122: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
123: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
116: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
117: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
118: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
119: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
120: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
121: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
122: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
123: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
124: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
117: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
118: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
119: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
120: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
121: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
122: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
123: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
124: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
125: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
121: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
122: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
123: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
124: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
125: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
126: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
127: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
128: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
129: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
122: ,p_event_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
123: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
124: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
125: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
126: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
127: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
128: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
129: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
130: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
123: ,p_expenditure_category_tbl IN SYSTEM.pa_varchar2_30_tbl_type
124: ,p_revenue_category_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
125: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
126: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
127: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
128: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
129: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
130: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
131: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
125: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
126: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
127: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
128: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
129: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
130: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
131: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
132: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
127: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
128: ,p_person_type_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
129: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
130: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
131: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
132: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
129: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
130: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
131: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
132: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
130: ,p_named_role_tbl IN SYSTEM.pa_varchar2_80_tbl_type
131: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
132: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
131: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
132: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
132: ,p_fixed_date_sp_id IN pa_spread_curves_b.spread_curve_id%TYPE -- Added for Bug 3607061
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
133: ,px_total_qty_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
134: ,px_total_raw_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
135: ,px_total_burdened_cost_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
136: ,px_total_revenue_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
137: ,px_raw_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
138: ,px_b_cost_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
146: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
139: ,px_bill_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
146: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
147: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
140: ,px_raw_cost_override_rate_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
146: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
147: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
148: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
141: ,px_b_cost_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
146: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
147: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
148: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
149: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
142: ,px_bill_rate_override_tbl IN OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
146: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
147: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
148: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
149: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
150: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
143: ,x_rbs_element_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
146: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
147: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
148: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
149: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
150: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
151: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
144: ,x_txn_accum_header_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
145: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
146: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
147: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
148: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
149: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
150: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
151: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
152: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
197: l_rbs_map_index NUMBER:=0;
198:
199: l_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
200: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
201: l_ra_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
202: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
203: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
204: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
205: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
198:
199: l_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
200: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
201: l_ra_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
202: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
203: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
204: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
205: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
206: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
199: l_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
200: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
201: l_ra_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
202: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
203: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
204: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
205: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
206: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
207: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
200: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
201: l_ra_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
202: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
203: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
204: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
205: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
206: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
207: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
208: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
204: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
205: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
206: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
207: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
208: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
209: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
210: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
211: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
212: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
205: l_event_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
206: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
207: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
208: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
209: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
210: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
211: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
212: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
213: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
206: l_exp_category_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
207: l_rev_cat_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
208: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
209: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
210: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
211: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
212: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
213: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
214: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
208: l_inv_item_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
209: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
210: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
211: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
212: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
213: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
214: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
215: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
216: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
209: l_item_cat_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
210: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
211: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
212: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
213: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
214: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
215: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
216: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
217: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
210: l_bom_res_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
211: l_per_type_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
212: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
213: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
214: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
215: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
216: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
217: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
218: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
212: l_supplier_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
213: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
214: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
215: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
216: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
217: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
218: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
219: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
220: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
213: l_rbs_element_id_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
214: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
215: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
216: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
217: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
218: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
219: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
220: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
221: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
214: l_inventory_item_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
215: l_expenditure_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
216: l_person_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
217: l_job_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
218: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
219: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
220: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
221: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
222: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
218: l_organization_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
219: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
220: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
221: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
222: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
223: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
224: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
225: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
226: l_supplier_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
219: l_event_type_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
220: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
221: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
222: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
223: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
224: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
225: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
226: l_supplier_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
227: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
220: l_expenditure_category_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
221: l_revenue_category_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
222: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
223: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
224: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
225: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
226: l_supplier_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
227: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
228: l_exp_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
222: l_item_category_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
223: l_bom_resource_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
224: l_project_role_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
225: l_person_type_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
226: l_supplier_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
227: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
228: l_exp_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
229: l_non_labor_resource_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
230: l_non_labor_res_rbs_prm_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
228: l_exp_type_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
229: l_non_labor_resource_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
230: l_non_labor_res_rbs_prm_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
231: l_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
232: l_project_role_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
233: l_named_role_rbs_prm_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
234: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
235: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
236: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
230: l_non_labor_res_rbs_prm_tbl SYSTEM.pa_varchar2_20_tbl_type :=SYSTEM.pa_varchar2_20_tbl_type();
231: l_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
232: l_project_role_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
233: l_named_role_rbs_prm_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
234: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
235: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
236: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
237: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
238: -- Added for Bug 3762278
231: l_named_role_tbl SYSTEM.pa_varchar2_80_tbl_type :=SYSTEM.pa_varchar2_80_tbl_type();
232: l_project_role_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
233: l_named_role_rbs_prm_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
234: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
235: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
236: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
237: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
238: -- Added for Bug 3762278
239: l_project_name pa_projects_all.name%TYPE;
232: l_project_role_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
233: l_named_role_rbs_prm_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
234: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
235: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
236: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
237: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
238: -- Added for Bug 3762278
239: l_project_name pa_projects_all.name%TYPE;
240: l_task_name pa_proj_elements.name%TYPE;
233: l_named_role_rbs_prm_tbl SYSTEM.pa_varchar2_80_tbl_type := SYSTEM.pa_varchar2_80_tbl_type();
234: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
235: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
236: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
237: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
238: -- Added for Bug 3762278
239: l_project_name pa_projects_all.name%TYPE;
240: l_task_name pa_proj_elements.name%TYPE;
241: l_resource_name pa_resource_list_members.alias%TYPE;
239: l_project_name pa_projects_all.name%TYPE;
240: l_task_name pa_proj_elements.name%TYPE;
241: l_resource_name pa_resource_list_members.alias%TYPE;
242:
243: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
244: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
245: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
246: l_res_class_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
247:
240: l_task_name pa_proj_elements.name%TYPE;
241: l_resource_name pa_resource_list_members.alias%TYPE;
242:
243: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
244: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
245: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
246: l_res_class_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
247:
248: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
325: IF l_debug_mode = 'Y' THEN
326: pa_debug.g_err_stage:='Extending input params';
327: print_msg(pa_debug.g_err_stage,l_module_name);
328: END IF;
329: x_rbs_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
330: x_txn_accum_header_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
331: x_mfc_cost_type_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
332: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
333: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
326: pa_debug.g_err_stage:='Extending input params';
327: print_msg(pa_debug.g_err_stage,l_module_name);
328: END IF;
329: x_rbs_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
330: x_txn_accum_header_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
331: x_mfc_cost_type_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
332: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
333: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
334: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
327: print_msg(pa_debug.g_err_stage,l_module_name);
328: END IF;
329: x_rbs_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
330: x_txn_accum_header_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
331: x_mfc_cost_type_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
332: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
333: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
334: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
335: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
328: END IF;
329: x_rbs_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
330: x_txn_accum_header_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
331: x_mfc_cost_type_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
332: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
333: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
334: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
335: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
336: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
329: x_rbs_element_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
330: x_txn_accum_header_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
331: x_mfc_cost_type_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
332: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
333: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
334: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
335: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
336: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
337: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
330: x_txn_accum_header_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
331: x_mfc_cost_type_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
332: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
333: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
334: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
335: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
336: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
337: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
338: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
1275: ,p_calling_module IN VARCHAR2 DEFAULT NULL
1276: ,p_project_id IN Pa_projects_all.project_id%TYPE
1277: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1278: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1279: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1280: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
1281: DEFAULT SYSTEM.PA_NUM_TBL_TYPE() --bug#16200605
1282: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1283: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1276: ,p_project_id IN Pa_projects_all.project_id%TYPE
1277: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1278: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1279: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1280: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
1281: DEFAULT SYSTEM.PA_NUM_TBL_TYPE() --bug#16200605
1282: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1283: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1284: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1277: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
1278: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1279: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1280: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
1281: DEFAULT SYSTEM.PA_NUM_TBL_TYPE() --bug#16200605
1282: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1283: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1284: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1285: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1285: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1286: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
1287: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1288: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1289: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1290: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1291: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
1292: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1293: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1288: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1289: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1290: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1291: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
1292: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1293: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1294: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
1295: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1289: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1290: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1291: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
1292: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1293: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1294: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
1295: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1291: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
1292: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1293: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1294: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
1295: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1293: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1294: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
1295: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1301: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1294: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
1295: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1301: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1302: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1295: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1301: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1302: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1303: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1301: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1302: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1303: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1304: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1301: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1302: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1303: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1304: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1305: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE() --added for Enc
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1301: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1302: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1303: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1304: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1305: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE() --added for Enc
1306: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1336: ,p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1337: ,p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1338: ,p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
1339: ,p_apply_progress_flag IN VARCHAR2 DEFAULT 'N' /* Bug# 3720357 */
1340: ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE() --For bug 3948128
1341: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug# 4200168 */
1342: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1343: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1344: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1365: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1366: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1372: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1373:
1366: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE; -- Bug 3749516 dummy Variable
1367: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1368: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1369: l_eligible_rlm_ids_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1370: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1372: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1373:
1374: -- Added for Bug 3719918 -- USED FOR INSERT WHEN p-one-t-one-mapping-flag is Y
1371: l_proj_element_id pa_proj_element_versions.proj_element_id%TYPE;
1372: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1373:
1374: -- Added for Bug 3719918 -- USED FOR INSERT WHEN p-one-t-one-mapping-flag is Y
1375: l_task_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1376: l_proj_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1377:
1378: -- Bug 3719918, these tables will only be used for insert in B/F context
1379: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1372: l_fixed_date_sp_id pa_spread_curves_b.spread_curve_id%TYPE; -- bug 3607061
1373:
1374: -- Added for Bug 3719918 -- USED FOR INSERT WHEN p-one-t-one-mapping-flag is Y
1375: l_task_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1376: l_proj_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1377:
1378: -- Bug 3719918, these tables will only be used for insert in B/F context
1379: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1380: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1377:
1378: -- Bug 3719918, these tables will only be used for insert in B/F context
1379: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1380: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1381: l_bf_proj_elem_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1383: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1378: -- Bug 3719918, these tables will only be used for insert in B/F context
1379: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1380: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1381: l_bf_proj_elem_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1383: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1379: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1380: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1381: l_bf_proj_elem_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1383: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1387: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1380: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1381: l_bf_proj_elem_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1383: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1387: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1388: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1381: l_bf_proj_elem_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1382: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1383: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1387: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1388: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1389: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1383: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1387: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1388: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1389: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1390: l_dup_flag varchar2(1) :='N';
1391: --Bug 4207150. These pl/sql tbls will be used to store the task/rlms that are inserted in B/F Flow
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1387: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1388: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1389: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1390: l_dup_flag varchar2(1) :='N';
1391: --Bug 4207150. These pl/sql tbls will be used to store the task/rlms that are inserted in B/F Flow
1392: l_bf_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1387: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1388: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1389: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1390: l_dup_flag varchar2(1) :='N';
1391: --Bug 4207150. These pl/sql tbls will be used to store the task/rlms that are inserted in B/F Flow
1392: l_bf_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1393: l_bf_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1388: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1389: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1390: l_dup_flag varchar2(1) :='N';
1391: --Bug 4207150. These pl/sql tbls will be used to store the task/rlms that are inserted in B/F Flow
1392: l_bf_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1393: l_bf_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1394: l_bf_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1389: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1390: l_dup_flag varchar2(1) :='N';
1391: --Bug 4207150. These pl/sql tbls will be used to store the task/rlms that are inserted in B/F Flow
1392: l_bf_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1393: l_bf_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1394: l_bf_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1390: l_dup_flag varchar2(1) :='N';
1391: --Bug 4207150. These pl/sql tbls will be used to store the task/rlms that are inserted in B/F Flow
1392: l_bf_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1393: l_bf_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1394: l_bf_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1391: --Bug 4207150. These pl/sql tbls will be used to store the task/rlms that are inserted in B/F Flow
1392: l_bf_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1393: l_bf_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1394: l_bf_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1392: l_bf_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1393: l_bf_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1394: l_bf_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1400: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1393: l_bf_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1394: l_bf_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1400: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1401: l_bf_ins_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1394: l_bf_rlm_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1400: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1401: l_bf_ins_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1402: l_bf_ins_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1400: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1401: l_bf_ins_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1402: l_bf_ins_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1403: l_temp NUMBER;
1404: l_job_id_temp NUMBER; --bug#13566990
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1400: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1401: l_bf_ins_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1402: l_bf_ins_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1403: l_temp NUMBER;
1404: l_job_id_temp NUMBER; --bug#13566990
1405: dml_errors EXCEPTION;
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1400: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1401: l_bf_ins_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1402: l_bf_ins_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1403: l_temp NUMBER;
1404: l_job_id_temp NUMBER; --bug#13566990
1405: dml_errors EXCEPTION;
1406: PRAGMA exception_init(dml_errors, -24381);
1407:
1408: --Start of variables for Variable for Resource Attributes
1409: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1410: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1411: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1412: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1413: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1414: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1415: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1409: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1410: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1411: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1412: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1413: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1414: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1415: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1416: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1417: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1410: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1411: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1412: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1413: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1414: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1415: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1416: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1417: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1418: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
1413: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1414: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1415: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1416: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1417: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1418: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
1419: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1420: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1421: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1415: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1416: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1417: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1418: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
1419: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1420: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1421: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1422: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1423: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1416: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1417: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1418: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
1419: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1420: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1421: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1422: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1423: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1424: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); --EnC
1417: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1418: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
1419: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1420: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1421: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1422: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1423: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1424: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); --EnC
1425: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1418: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
1419: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1420: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1421: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1422: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1423: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1424: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); --EnC
1425: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1426: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1424: l_direct_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); --EnC
1425: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1426: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1427: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1428: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1429: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1430: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1431: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1432: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1426: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1427: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1428: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1429: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1430: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1431: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1432: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1433: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1428: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1429: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1430: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1431: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1432: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1433: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1435: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1436: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1432: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1433: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1435: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1436: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1437: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1438: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1439: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1440: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1433: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1435: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1436: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1437: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1438: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1439: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1440: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1441: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1438: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1439: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1440: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1441: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1442: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1443: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1444: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1445: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1446: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1445: l_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1446: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1447: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1448: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1449: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1450: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1451: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1452: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1453: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1451: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1452: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1453: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1454: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1455: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1456: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1457: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1458: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1459: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1453: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1454: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1455: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1456: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1457: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1458: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1459: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1460: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1461: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1454: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1455: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1456: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1457: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1458: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1459: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1460: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1461: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1462: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1455: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1456: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1457: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1458: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1459: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1460: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1461: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1462: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1463: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1494: l_ATTRIBUTE28_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1495: l_ATTRIBUTE29_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1496: l_ATTRIBUTE30_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1497: --For bug 3948128
1498: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1499: --End of variables for Variable for Resource Attributes
1500:
1501: --Start of variables for Variable for TA Validations for p_context = TASK_ASSIGNMENTS
1502: l_task_rec_tbl pa_task_assignment_utils.l_task_rec_tbl_type;
1501: --Start of variables for Variable for TA Validations for p_context = TASK_ASSIGNMENTS
1502: l_task_rec_tbl pa_task_assignment_utils.l_task_rec_tbl_type;
1503: l_resource_rec_tbl pa_task_assignment_utils.l_resource_rec_tbl_type;
1504: l_del_task_level_rec_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1505: l_ra_id_del_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1506: l_ra_id_del_count NUMBER;
1507: --End of variables for Variable for TA Validations for p_context = TASK_ASSIGNMENTS
1508:
1509: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
1510: l_spread_amounts_for_ver VARCHAR2(1);
1511: l_index NUMBER := 1;
1512: l_spread_amount_flags_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1513: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1514: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1515: -- IPM Tables
1516: l_orig_count NUMBER; -- bug 5003827 issue 22
1517: -- l_count_index NUMBER;
1518: l_ra_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1514: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1515: -- IPM Tables
1516: l_orig_count NUMBER; -- bug 5003827 issue 22
1517: -- l_count_index NUMBER;
1518: l_ra_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1519: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1520: --
1521: l_res_assignment_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1522: l_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1517: -- l_count_index NUMBER;
1518: l_ra_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1519: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1520: --
1521: l_res_assignment_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1522: l_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1523: l_call_calc_api VARCHAR2(1);
1524:
1525: -- Start of variable to be used in Calculate API Call
1526: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1527: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1528:
1529: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1530: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1531: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1534: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1527: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1528:
1529: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1530: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1531: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1534: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1535: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1528:
1529: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1530: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1531: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1534: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1535: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1536: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1529: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1530: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1531: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1534: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1535: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1536: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1537: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1530: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1531: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1534: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1535: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1536: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1537: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1538: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1531: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1534: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1535: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1536: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1537: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1538: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1539: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1534: l_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1535: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1536: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1537: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1538: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1539: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1540: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1535: l_burden_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1536: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1537: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1538: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1539: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1540: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1541: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1542: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1543:
1536: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1537: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1538: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1539: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1540: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1541: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1542: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1543:
1544: -- End of variable to be used in Calculate API Call
1537: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1538: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1539: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1540: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1541: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1542: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1543:
1544: -- End of variable to be used in Calculate API Call
1545:
1538: l_txn_src_typ_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1539: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1540: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1541: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1542: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1543:
1544: -- End of variable to be used in Calculate API Call
1545:
1546: -- Bug 3749516 Added for insert in Workplan Context
1543:
1544: -- End of variable to be used in Calculate API Call
1545:
1546: -- Bug 3749516 Added for insert in Workplan Context
1547: l_ins_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1548: l_ins_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1549: l_ins_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- satya
1550: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1551: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1544: -- End of variable to be used in Calculate API Call
1545:
1546: -- Bug 3749516 Added for insert in Workplan Context
1547: l_ins_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1548: l_ins_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1549: l_ins_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- satya
1550: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1551: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1552: l_ins_cal_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1545:
1546: -- Bug 3749516 Added for insert in Workplan Context
1547: l_ins_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1548: l_ins_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1549: l_ins_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- satya
1550: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1551: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1552: l_ins_cal_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1553: l_ins_cal_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1548: l_ins_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1549: l_ins_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- satya
1550: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1551: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1552: l_ins_cal_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1553: l_ins_cal_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1554: l_ins_cal_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1555: l_ins_index NUMBER := 1;
1556:
1549: l_ins_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- satya
1550: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1551: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1552: l_ins_cal_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1553: l_ins_cal_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1554: l_ins_cal_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1555: l_ins_index NUMBER := 1;
1556:
1557: l_start_date pa_resource_assignments.planning_start_date%TYPE := NULL;
1550: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1551: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1552: l_ins_cal_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1553: l_ins_cal_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1554: l_ins_cal_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1555: l_ins_index NUMBER := 1;
1556:
1557: l_start_date pa_resource_assignments.planning_start_date%TYPE := NULL;
1558: l_compl_date pa_resource_assignments.planning_start_date%TYPE := NULL;
1575: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
1576: l_rm_temp_count number;
1577:
1578: -- Bug 8370812
1579: l_ra_id_rollup_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1580: l_curr_code_rollup_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1581: l_rollup_index NUMBER;
1582: l_add_flag BOOLEAN;
1583: --CBS related Chnages
1630: l_prj_cbs_enabled VARCHAR2(1) := 'N'; --bug#16200605
1631: L_CBS_FLAG_TEMP VARCHAR2(1) := 'N'; --bug#16200605
1632: L_ALT_TSK_TEMP VARCHAR2(1) := 'N'; --bug#16200605
1633: l_alt_tsk_valid VARCHAR2(1) := 'N'; --bug#16200605
1634: l_cbs_id_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();--bug#16200605
1635:
1636:
1637: BEGIN
1638: l_trace_stage := 10;
5956: p_context IN VARCHAR2
5957: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
5958: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
5959: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
5960: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5961: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5962: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
5963: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5964: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5961: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5962: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
5963: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5964: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5965: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5966: -- One pl/sql record in The Above tables
5967: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5968: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5969: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5963: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5964: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5965: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5966: -- One pl/sql record in The Above tables
5967: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5968: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5969: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5970: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5971: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5964: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5965: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5966: -- One pl/sql record in The Above tables
5967: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5968: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5969: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5970: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5971: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5972: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5966: -- One pl/sql record in The Above tables
5967: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5968: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5969: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5970: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5971: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5972: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5973: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5974: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5970: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5971: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5972: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5973: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5974: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5975: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5976: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5977: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5978: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5974: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5975: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5976: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5977: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5978: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5979: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5980: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5981: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5982: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE
5975: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5976: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5977: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5978: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5979: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5980: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5981: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5982: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE
5983: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5977: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- bug fix 3461537
5978: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5979: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5980: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5981: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5982: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE
5983: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5984: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5985: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5979: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5980: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5981: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5982: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE
5983: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5984: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5985: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5986: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5987: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5980: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5981: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5982: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE
5983: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5984: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5985: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5986: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5987: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5988: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5981: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5982: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE
5983: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5984: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5985: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5986: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5987: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5988: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5989: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5983: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5984: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5985: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5986: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
5987: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5988: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5989: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5990: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5991: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5991: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5992: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5993: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5994: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5995: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5996: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5997: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5998: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5999: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5993: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5994: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5995: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5996: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5997: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5998: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5999: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6000: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6001: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5995: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5996: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5997: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5998: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5999: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6000: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6001: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6002: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
6003: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
6001: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6002: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
6003: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
6004: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
6005: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6006: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6007: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6008: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6009: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6007: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6008: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6009: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6010: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6011: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6012: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6013: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6010: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6011: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6012: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6013: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6011: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6012: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6013: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6012: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6013: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6013: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6021: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6021: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6022: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6021: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6022: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6023: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6021: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6022: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6023: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6024: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6021: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6022: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6023: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6024: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6025: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
6018: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6021: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6022: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6023: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6024: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6025: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
6026: ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
6019: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6020: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6021: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6022: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6023: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6024: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6025: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
6026: ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
6027: ,p_supplier_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
6056: ,p_attribute28_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
6057: ,p_attribute29_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
6058: ,p_attribute30_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
6059: ,p_apply_progress_flag IN VARCHAR2 /* Passed from apply_progress api (sakthi's team) */
6060: ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type --For bug 3948128
6061: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug# 4200168 */
6062: ,p_upd_cost_amts_too_for_ta_flg IN VARCHAR2 DEFAULT 'N' --Added for bug #4538286
6063: ,p_distrib_amts IN VARCHAR2 DEFAULT 'Y' -- Bug 5684639.
6064: ,p_direct_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE() --added for Enc
6095: */
6096:
6097: /* Start of variables for Variable for Resource Attributes
6098: */
6099: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6100: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6101: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6102: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6103: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6096:
6097: /* Start of variables for Variable for Resource Attributes
6098: */
6099: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6100: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6101: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6102: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6103: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6104: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6101: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6102: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6103: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6104: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6105: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6106: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6107: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6108: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6109: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6104: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6105: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6106: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6107: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6108: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6109: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6110: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6111: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6112: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
6105: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6106: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6107: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6108: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6109: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6110: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6111: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6112: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
6113: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6107: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6108: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6109: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6110: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6111: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6112: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
6113: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6114: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6115: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6109: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6110: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6111: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6112: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
6113: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6114: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6115: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6116: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6117: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6110: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6111: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6112: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
6113: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6114: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6115: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6116: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6117: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6118: -- bug 3455288, 19-FEB-04, jwhite: Changed varchar2 length to 240 from 30 --------------------------------
6111: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6112: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := SYSTEM.PA_VARCHAR2_20_TBL_TYPE();
6113: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6114: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6115: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6116: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6117: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6118: -- bug 3455288, 19-FEB-04, jwhite: Changed varchar2 length to 240 from 30 --------------------------------
6119: -- l_organization_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6113: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6114: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6115: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6116: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6117: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6118: -- bug 3455288, 19-FEB-04, jwhite: Changed varchar2 length to 240 from 30 --------------------------------
6119: -- l_organization_name_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6120:
6121: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6127: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6128: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6129: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6130: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6131: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6132: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6133: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6134: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6135: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6129: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6130: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6131: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6132: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6133: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6134: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6135: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6136: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6137: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6131: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6132: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6133: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6134: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6135: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6136: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6137: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6138: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6139: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6137: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6138: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6139: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6140: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6141: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6142: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6143: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6144: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6145: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6143: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6144: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6145: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6146: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6147: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6148: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6149: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6150: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6151: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6145: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6146: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6147: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6148: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6149: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6150: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6151: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6152: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6153: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6146: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6147: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6148: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6149: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6150: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6151: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6152: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6153: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6154: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6147: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6148: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6149: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6150: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6151: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6152: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6153: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6154: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6155: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6152: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6153: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6154: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6155: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6156: l_wbs_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6157: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6158: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6159: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6160: l_attribute2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6153: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6154: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6155: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6156: l_wbs_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6157: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6158: l_attribute_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6159: l_attribute1_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6160: l_attribute2_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6161: l_attribute3_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6185: l_attribute27_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6186: l_attribute28_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6187: l_attribute29_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6188: l_attribute30_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6189: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6190: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6191: l_b_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6186: l_attribute28_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6187: l_attribute29_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6188: l_attribute30_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6189: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6190: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6191: l_b_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6187: l_attribute29_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6188: l_attribute30_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6189: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6190: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6191: l_b_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6195: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6188: l_attribute30_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
6189: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6190: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6191: l_b_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6195: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6196: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6189: l_bill_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6190: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6191: l_b_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6195: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6196: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6197: --For bug 3948128
6190: l_bill_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6191: l_b_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6195: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6196: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6197: --For bug 3948128
6198: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6191: l_b_multiplier_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6195: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6196: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6197: --For bug 3948128
6198: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6199:
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6195: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6196: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6197: --For bug 3948128
6198: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6199:
6200: -- Added for bug 3698458
6201: l_rate_exp_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6202: l_rate_exp_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6197: --For bug 3948128
6198: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6199:
6200: -- Added for bug 3698458
6201: l_rate_exp_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6202: l_rate_exp_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6203: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6204: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6205:
6210: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
6214: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
6215: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
6216:
6217: /* added for bug 3678814 */
6218: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
6214: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
6215: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
6216:
6217: /* added for bug 3678814 */
6218: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6219:
6229: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6230: l_temp_gmiss_date date := to_date('01-01-4712','DD-MM-YYYY');
6231:
6232: --These parameters are introduced for calculate API enhancements tracked thru bug 4152749
6233: l_mfc_cost_type_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6234: l_mfc_cost_type_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6235: l_spread_curve_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6236: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6237: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6230: l_temp_gmiss_date date := to_date('01-01-4712','DD-MM-YYYY');
6231:
6232: --These parameters are introduced for calculate API enhancements tracked thru bug 4152749
6233: l_mfc_cost_type_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6234: l_mfc_cost_type_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6235: l_spread_curve_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6236: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6237: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6238: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6231:
6232: --These parameters are introduced for calculate API enhancements tracked thru bug 4152749
6233: l_mfc_cost_type_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6234: l_mfc_cost_type_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6235: l_spread_curve_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6236: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6237: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6238: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6239: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6232: --These parameters are introduced for calculate API enhancements tracked thru bug 4152749
6233: l_mfc_cost_type_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6234: l_mfc_cost_type_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6235: l_spread_curve_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6236: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6237: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6238: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6239: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6240: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6249:
6250: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
6251:
6252: -- Bug 5906826
6253: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6254: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6255: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6256: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6257: l_tot_qty_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6253: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6254: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6255: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6256: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6257: l_tot_qty_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6258: l_txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6259: l_txn_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6260: l_cal_api_called_flg VARCHAR2(1) := 'N';
6261: --CBS related Chnages
6254: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6255: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6256: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6257: l_tot_qty_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6258: l_txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6259: l_txn_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6260: l_cal_api_called_flg VARCHAR2(1) := 'N';
6261: --CBS related Chnages
6262: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
6255: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6256: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6257: l_tot_qty_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6258: l_txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6259: l_txn_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6260: l_cal_api_called_flg VARCHAR2(1) := 'N';
6261: --CBS related Chnages
6262: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
6263: BEGIN
7718: */
7719:
7720: FOR i IN l_resource_assignment_id_tbl.FIRST .. l_resource_assignment_id_tbl.LAST LOOP
7721:
7722: l_ra_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7723: l_line_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7724: l_line_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7725: l_txn_currency_code_tbl := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7726: l_tot_qty_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7722: l_ra_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7723: l_line_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7724: l_line_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7725: l_txn_currency_code_tbl := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7726: l_tot_qty_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7727: l_txn_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7728: l_txn_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7729: l_delete_budget_lines_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
7730:
7723: l_line_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7724: l_line_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7725: l_txn_currency_code_tbl := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7726: l_tot_qty_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7727: l_txn_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7728: l_txn_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7729: l_delete_budget_lines_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
7730:
7731: -- If condition to delete budget lines, when dates are trucated and spread curve is not changed
7724: l_line_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7725: l_txn_currency_code_tbl := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7726: l_tot_qty_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7727: l_txn_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7728: l_txn_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7729: l_delete_budget_lines_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
7730:
7731: -- If condition to delete budget lines, when dates are trucated and spread curve is not changed
7732: -- and spread curve is other than fixed date when p_distrib_amts flag is checked.
8321: ,p_src_project_id IN pa_projects_all.project_id%TYPE
8322: ,p_target_project_id IN pa_projects_all.project_id%TYPE
8323: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8324: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8325: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8326: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8327: ,p_copy_people_flag IN VARCHAR2 := NULL
8328: ,p_copy_equip_flag IN VARCHAR2 := NULL
8329: ,p_copy_mat_item_flag IN VARCHAR2 := NULL
8322: ,p_target_project_id IN pa_projects_all.project_id%TYPE
8323: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8324: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
8325: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8326: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
8327: ,p_copy_people_flag IN VARCHAR2 := NULL
8328: ,p_copy_equip_flag IN VARCHAR2 := NULL
8329: ,p_copy_mat_item_flag IN VARCHAR2 := NULL
8330: ,p_copy_fin_elem_flag IN VARCHAR2 := NULL
8350: j NUMBER;
8351: l_row_count NUMBER;
8352: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8353: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8354: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8355: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8356: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8357: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8358: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8351: l_row_count NUMBER;
8352: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8353: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8354: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8355: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8356: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8357: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8358: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8359: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8352: l_src_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8353: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8354: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8355: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8356: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8357: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8358: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8359: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8360: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
8353: l_targ_budget_version_id pa_budget_versions.budget_version_id%TYPE;
8354: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8355: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8356: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8357: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8358: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8359: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8360: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
8361: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8354: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8355: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8356: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8357: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8358: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8359: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8360: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
8361: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8362: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
8357: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8358: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8359: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8360: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
8361: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8362: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
8363: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';
8364: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;
8365: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8371: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8372: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
8373:
8374: -- Declared for Bug 3615617
8375: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8376:
8377: l_tot_rc_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8378: l_pji_rollup_required VARCHAR2(1);
8379:
8373:
8374: -- Declared for Bug 3615617
8375: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8376:
8377: l_tot_rc_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8378: l_pji_rollup_required VARCHAR2(1);
8379:
8380: --Code addition for bug#4200168 starts here.
8381: TYPE l_txn_curr_code_table IS TABLE OF PA_BUDGET_LINES.TXN_CURRENCY_CODE%type
8928: ,p_txn_currency_code_tab => l_currency_code_tbl
8929: ,p_txn_currency_override_tab => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
8930: ,p_total_qty_tab => l_quantity_tbl
8931: ,p_total_raw_cost_tab => l_tot_rc_tbl
8932: ,p_total_burdened_cost_tab => SYSTEM.PA_NUM_TBL_TYPE()
8933: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
8934: ,p_raw_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8929: ,p_txn_currency_override_tab => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
8930: ,p_total_qty_tab => l_quantity_tbl
8931: ,p_total_raw_cost_tab => l_tot_rc_tbl
8932: ,p_total_burdened_cost_tab => SYSTEM.PA_NUM_TBL_TYPE()
8933: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
8934: ,p_raw_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8937: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8930: ,p_total_qty_tab => l_quantity_tbl
8931: ,p_total_raw_cost_tab => l_tot_rc_tbl
8932: ,p_total_burdened_cost_tab => SYSTEM.PA_NUM_TBL_TYPE()
8933: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
8934: ,p_raw_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8937: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8938: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8931: ,p_total_raw_cost_tab => l_tot_rc_tbl
8932: ,p_total_burdened_cost_tab => SYSTEM.PA_NUM_TBL_TYPE()
8933: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
8934: ,p_raw_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8937: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8938: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8939: ,p_bill_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8932: ,p_total_burdened_cost_tab => SYSTEM.PA_NUM_TBL_TYPE()
8933: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
8934: ,p_raw_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8937: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8938: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8939: ,p_bill_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8940: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8933: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
8934: ,p_raw_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8937: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8938: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8939: ,p_bill_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8940: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8941: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8934: ,p_raw_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8937: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8938: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8939: ,p_bill_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8940: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8941: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8942: ,p_rollup_required_flag => l_pji_rollup_required
8935: ,p_rw_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8936: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8937: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8938: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8939: ,p_bill_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8940: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8941: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8942: ,p_rollup_required_flag => l_pji_rollup_required
8943: ,p_raTxn_rollup_api_call_flag => 'N' -- Added for bug 5017855
9323: (
9324: p_context IN VARCHAR2
9325: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
9326: ,p_task_or_res IN VARCHAR2 DEFAULT 'TASKS'
9327: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9328: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
9329: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
9330: ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9331: --Introduced for bug 3589130. If this parameter is passed as Y then an error will be thrown
9326: ,p_task_or_res IN VARCHAR2 DEFAULT 'TASKS'
9327: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9328: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
9329: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
9330: ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9331: --Introduced for bug 3589130. If this parameter is passed as Y then an error will be thrown
9332: --When its required to delete a resource assignment containing budget lines. This parameter
9333: --will be considered only for BUDGET and FORECAST context
9334: ,p_validate_delete_flag IN VARCHAR2 DEFAULT 'N'
9334: ,p_validate_delete_flag IN VARCHAR2 DEFAULT 'N'
9335: -- This param will be used for B/F Context. Bug - 3719918
9336: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
9337: ,p_calling_module IN VARCHAR2 DEFAULT NULL
9338: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9339: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9340: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
9341: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
9342: --For Bug 3937716. Calls to PJI and budget version rollup APIs will be skipped if p_rollup_required_flag is N.
9335: -- This param will be used for B/F Context. Bug - 3719918
9336: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
9337: ,p_calling_module IN VARCHAR2 DEFAULT NULL
9338: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9339: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9340: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
9341: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
9342: --For Bug 3937716. Calls to PJI and budget version rollup APIs will be skipped if p_rollup_required_flag is N.
9343: ,p_rollup_required_flag IN VARCHAR2 DEFAULT 'Y'
9365: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type;
9366: l_start_date_tbl SYSTEM.pa_date_tbl_type;
9367: l_end_date_tbl SYSTEM.pa_date_tbl_type;
9368: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
9369: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9370: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9366: l_start_date_tbl SYSTEM.pa_date_tbl_type;
9367: l_end_date_tbl SYSTEM.pa_date_tbl_type;
9368: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
9369: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9370: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9367: l_end_date_tbl SYSTEM.pa_date_tbl_type;
9368: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
9369: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9370: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9375: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9368: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
9369: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9370: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9375: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9376: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9369: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9370: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9375: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9376: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9377: l_revenue_tbl SYSTEM.pa_num_tbl_type;
9370: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9375: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9376: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9377: l_revenue_tbl SYSTEM.pa_num_tbl_type;
9378: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9375: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9376: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9377: l_revenue_tbl SYSTEM.pa_num_tbl_type;
9378: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9379: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9375: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9376: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9377: l_revenue_tbl SYSTEM.pa_num_tbl_type;
9378: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9379: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9380: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9373: l_project_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9374: l_project_revenue_tbl SYSTEM.pa_num_tbl_type;
9375: l_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9376: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9377: l_revenue_tbl SYSTEM.pa_num_tbl_type;
9378: l_cost_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9379: l_revenue_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9380: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9381: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
9380: l_burden_rejection_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9381: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
9382: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9383: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9384: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
9385: l_quantity_tbl SYSTEM.pa_num_tbl_type;
9386: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9387: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9388: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
9381: l_other_rejection_code SYSTEM.pa_varchar2_30_tbl_type;
9382: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9383: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9384: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
9385: l_quantity_tbl SYSTEM.pa_num_tbl_type;
9386: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9387: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9388: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
9382: l_pc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9383: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9384: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
9385: l_quantity_tbl SYSTEM.pa_num_tbl_type;
9386: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9387: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9388: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
9390: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9383: l_pfc_cur_conv_rej_code_tbl SYSTEM.pa_varchar2_30_tbl_type;
9384: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type;
9385: l_quantity_tbl SYSTEM.pa_num_tbl_type;
9386: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9387: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9388: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
9390: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9391: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9386: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9387: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9388: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
9390: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9391: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9392: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;
9393: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;
9394: l_ra_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9387: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9388: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
9390: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9391: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9392: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;
9393: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;
9394: l_ra_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9395: --Bug 4951422
9390: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9391: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9392: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;
9393: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;
9394: l_ra_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9395: --Bug 4951422
9396: l_task_assmt_ids_tbl SYSTEM.pa_num_tbl_type;
9397:
9398: l_counter NUMBER;
9392: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;
9393: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;
9394: l_ra_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9395: --Bug 4951422
9396: l_task_assmt_ids_tbl SYSTEM.pa_num_tbl_type;
9397:
9398: l_counter NUMBER;
9399: l_ra_index NUMBER;
9400: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
9415: l_project_id pa_projects_all.project_id%TYPE; --Bug 4218331
9416: l_project_currency_code VARCHAR2(30);
9417: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
9418:
9419: l_cbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type() ; --bug#16688443
9420:
9421: BEGIN
9422:
9423: delete pa_resource_asgn_curr_tmp;
9584: END IF;
9585:
9586: --Bug 4951422. Initialize these tbls to avoid "ORA-06531: Reference to uninitialized collection" error
9587: --when the element version id tbl passed do not have corresponding resource assignment ids
9588: l_resource_assignment_id_tbl := SYSTEM.pa_num_tbl_type();
9589: l_ra_id_in_pra_tbl := SYSTEM.pa_num_tbl_type();
9590:
9591: /** when the context is Task assignment Call the Validation API
9592: * Modified Delete logic for Bug 3808720. Since Validate Delete Assignments API
9585:
9586: --Bug 4951422. Initialize these tbls to avoid "ORA-06531: Reference to uninitialized collection" error
9587: --when the element version id tbl passed do not have corresponding resource assignment ids
9588: l_resource_assignment_id_tbl := SYSTEM.pa_num_tbl_type();
9589: l_ra_id_in_pra_tbl := SYSTEM.pa_num_tbl_type();
9590:
9591: /** when the context is Task assignment Call the Validation API
9592: * Modified Delete logic for Bug 3808720. Since Validate Delete Assignments API
9593: * needs to be called for WORKPLAN context as well. Merginng Delete Logic for
9871: ,l_txn_currency_code_tbl(i)
9872: ,'Y'
9873: FROM DUAL;
9874: /*Start bug#16688443 */
9875: l_cbs_element_id_tbl := SYSTEM.pa_num_tbl_type();
9876: l_cbs_element_id_tbl.extend(l_resource_assignment_id_tbl.last);
9877: FOR i IN l_resource_assignment_id_tbl.first..l_resource_assignment_id_tbl.last LOOP
9878: select cbs_element_id into l_cbs_element_id_tbl(i) from pa_resource_assignments where resource_assignment_id = l_resource_assignment_id_tbl (i);
9879: END LOOP; /*End bug#16688443 */
10025: ,'Y'
10026: FROM DUAL;
10027:
10028: /*Start bug#16688443 */
10029: l_cbs_element_id_tbl := SYSTEM.pa_num_tbl_type();
10030: l_cbs_element_id_tbl.extend(l_resource_assignment_id_tbl.last);
10031: FOR i IN l_resource_assignment_id_tbl.first..l_resource_assignment_id_tbl.last LOOP
10032: select cbs_element_id into l_cbs_element_id_tbl(i) from pa_resource_assignments where resource_assignment_id = l_resource_assignment_id_tbl (i);
10033: END LOOP; /*End bug#16688443 */
10192: ,'Y'
10193: FROM DUAL;
10194:
10195: /*Start bug#16688443 */
10196: l_cbs_element_id_tbl := SYSTEM.pa_num_tbl_type();
10197: l_cbs_element_id_tbl.extend(l_resource_assignment_id_tbl.last);
10198: FOR i IN l_resource_assignment_id_tbl.first..l_resource_assignment_id_tbl.last LOOP
10199: select cbs_element_id into l_cbs_element_id_tbl(i) from pa_resource_assignments where resource_assignment_id = l_resource_assignment_id_tbl (i);
10200: END LOOP; /*End bug#16688443 */
10417: ,'Y'
10418: FROM DUAL;
10419:
10420: /*Start bug#16688443 */
10421: l_cbs_element_id_tbl := SYSTEM.pa_num_tbl_type();
10422: l_cbs_element_id_tbl.extend(l_resource_assignment_id_tbl.last);
10423: FOR i IN l_resource_assignment_id_tbl.first..l_resource_assignment_id_tbl.last LOOP
10424: select cbs_element_id into l_cbs_element_id_tbl(i) from pa_resource_assignments where resource_assignment_id = l_resource_assignment_id_tbl (i);
10425: END LOOP; /*End bug#16688443 */
11130: PROCEDURE check_and_create_task_rec_info
11131: (
11132: p_project_id IN Pa_projects_all.project_id%TYPE
11133: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
11134: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11135: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11136: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11137: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11138: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11133: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
11134: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11135: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11136: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11137: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11138: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11139: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11140: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
11141: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11134: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11135: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11136: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11137: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11138: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11139: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11140: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
11141: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11142: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11135: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11136: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
11137: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11138: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11139: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11140: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
11141: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11142: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11143: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11137: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
11138: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11139: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11140: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
11141: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11142: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11143: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11144: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11145: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11140: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
11141: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11142: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11143: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11144: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11145: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11146: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11147: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11141: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11142: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11143: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11144: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11145: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11146: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11147: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11149: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11142: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11143: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11144: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11145: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11146: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11147: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11149: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11150: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
11143: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
11144: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11145: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
11146: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11147: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
11148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11149: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
11150: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
11151: ) AS
11166: l_ra_id_cnt NUMBER := 0;
11167: l_out_tbl_index NUMBER := 1;
11168: l_add_tbl_index NUMBER := 1;
11169: l_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
11170: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11171: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11172: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11173: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11174: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11167: l_out_tbl_index NUMBER := 1;
11168: l_add_tbl_index NUMBER := 1;
11169: l_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
11170: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11171: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11172: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11173: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11174: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11175: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11170: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11171: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11172: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11173: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11174: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11175: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11176: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11177: l_index NUMBER;
11178: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11171: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11172: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11173: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11174: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11175: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11176: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11177: l_index NUMBER;
11178: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11179: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11172: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11173: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11174: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11175: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11176: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11177: l_index NUMBER;
11178: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11179: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11180: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11174: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11175: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11176: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11177: l_index NUMBER;
11178: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11179: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11180: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11181: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11182: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11177: l_index NUMBER;
11178: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11179: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11180: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11181: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11182: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11183: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11184: l_raw_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11185: l_burdened_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11178: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11179: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11180: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11181: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11182: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11183: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11184: l_raw_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11185: l_burdened_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11186:
11179: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11180: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11181: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11182: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11183: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11184: l_raw_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11185: l_burdened_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11186:
11187:
11180: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
11181: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11182: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11183: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11184: l_raw_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11185: l_burdened_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11186:
11187:
11188: cursor c_res_assignment_id(c_wbs_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE) IS
11181: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11182: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11183: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11184: l_raw_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11185: l_burdened_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11186:
11187:
11188: cursor c_res_assignment_id(c_wbs_element_version_id pa_resource_assignments.wbs_element_version_id%TYPE) IS
11189: SELECT resource_assignment_id,resource_class_code
11212: IF l_debug_mode = 'Y' THEN
11213: pa_debug.g_err_stage:='Extending the local pl/sql tbls';
11214: print_msg(pa_debug.g_err_stage,l_module_name);
11215: END IF;
11216: x_element_version_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11217: x_planning_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11218: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11219: x_planned_effort_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11220: x_resource_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11215: END IF;
11216: x_element_version_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11217: x_planning_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11218: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11219: x_planned_effort_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11220: x_resource_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11221: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11222: x_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11223: l_element_version_id_tbl.extend(l_elem_ver_id_cnt);
11216: x_element_version_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11217: x_planning_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11218: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11219: x_planned_effort_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11220: x_resource_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11221: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11222: x_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11223: l_element_version_id_tbl.extend(l_elem_ver_id_cnt);
11224: l_planning_start_date_tbl.extend(l_elem_ver_id_cnt);
11217: x_planning_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11218: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11219: x_planned_effort_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11220: x_resource_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11221: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11222: x_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11223: l_element_version_id_tbl.extend(l_elem_ver_id_cnt);
11224: l_planning_start_date_tbl.extend(l_elem_ver_id_cnt);
11225: l_planning_end_date_tbl.extend(l_elem_ver_id_cnt);
11218: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
11219: x_planned_effort_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11220: x_resource_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11221: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11222: x_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11223: l_element_version_id_tbl.extend(l_elem_ver_id_cnt);
11224: l_planning_start_date_tbl.extend(l_elem_ver_id_cnt);
11225: l_planning_end_date_tbl.extend(l_elem_ver_id_cnt);
11226: l_planned_people_effort_tbl.extend(l_elem_ver_id_cnt);
11474: ,p_start_date_tbl => l_planning_start_date_tbl
11475: ,p_end_date_tbl => l_planning_end_date_tbl
11476: ,p_planned_people_effort_tbl => l_planned_people_effort_tbl
11477: ,p_latest_eff_pub_flag_tbl => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
11478: ,p_resource_list_member_id_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11479: ,p_quantity_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11480: ,p_currency_code_tbl => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
11481: ,p_raw_cost_tbl => l_raw_cost_tbl
11482: ,p_burdened_cost_tbl => l_burdened_cost_tbl
11475: ,p_end_date_tbl => l_planning_end_date_tbl
11476: ,p_planned_people_effort_tbl => l_planned_people_effort_tbl
11477: ,p_latest_eff_pub_flag_tbl => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
11478: ,p_resource_list_member_id_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11479: ,p_quantity_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11480: ,p_currency_code_tbl => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
11481: ,p_raw_cost_tbl => l_raw_cost_tbl
11482: ,p_burdened_cost_tbl => l_burdened_cost_tbl
11483: ,p_revenue_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11479: ,p_quantity_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11480: ,p_currency_code_tbl => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
11481: ,p_raw_cost_tbl => l_raw_cost_tbl
11482: ,p_burdened_cost_tbl => l_burdened_cost_tbl
11483: ,p_revenue_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11484: ,p_cost_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11485: ,p_bill_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11486: ,p_burdened_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11487: ,p_apply_progress_flag => p_apply_progress_flag
11480: ,p_currency_code_tbl => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
11481: ,p_raw_cost_tbl => l_raw_cost_tbl
11482: ,p_burdened_cost_tbl => l_burdened_cost_tbl
11483: ,p_revenue_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11484: ,p_cost_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11485: ,p_bill_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11486: ,p_burdened_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11487: ,p_apply_progress_flag => p_apply_progress_flag
11488: ,x_return_status => l_return_status
11481: ,p_raw_cost_tbl => l_raw_cost_tbl
11482: ,p_burdened_cost_tbl => l_burdened_cost_tbl
11483: ,p_revenue_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11484: ,p_cost_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11485: ,p_bill_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11486: ,p_burdened_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11487: ,p_apply_progress_flag => p_apply_progress_flag
11488: ,x_return_status => l_return_status
11489: ,x_msg_count => l_msg_count
11482: ,p_burdened_cost_tbl => l_burdened_cost_tbl
11483: ,p_revenue_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11484: ,p_cost_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11485: ,p_bill_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11486: ,p_burdened_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11487: ,p_apply_progress_flag => p_apply_progress_flag
11488: ,x_return_status => l_return_status
11489: ,x_msg_count => l_msg_count
11490: ,x_msg_data => l_msg_data
11593: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11594: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11596:
11597: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11598: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11599: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11600: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11601:
11594: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11596:
11597: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11598: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11599: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11600: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11601:
11602: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11595: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
11596:
11597: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11598: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11599: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11600: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11601:
11602: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11603:
11596:
11597: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11598: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11599: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11600: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11601:
11602: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11603:
11604: -- IPM changes Bug 5003827 Issue 22
11598: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11599: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11600: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11601:
11602: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11603:
11604: -- IPM changes Bug 5003827 Issue 22
11605: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols;
11606: l_delete_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11602: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11603:
11604: -- IPM changes Bug 5003827 Issue 22
11605: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols;
11606: l_delete_ra_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
11607: l_delete_flag VARCHAR2(1); -- Bug 5003827 Issue 28
11608: l_rollup_flag VARCHAR2(1); -- Bug 5003827 Issue 28
11609: -- END of IPM changes Bug 5003827 Issue 22
11610:
12057: nvl(p_time_phase_change_flag, 'N') = 'Y' OR
12058: nvl(p_rev_der_method_change,'N') ='Y' )--Bug 5462471
12059: THEN
12060: -- populating the l_budget_version_id_tbl with p_budget_version_id
12061: l_budget_version_id_tbl := SYSTEM.pa_num_tbl_type(p_budget_version_id);
12062:
12063: IF l_debug_mode = 'Y' THEN
12064: pa_debug.g_err_stage:='Calling PJI_FM_XBS_ACCUM_MAINT.PLAN_DELETE';
12065: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,3);
12243: and p_calling_context = 'SELECT_TASKS');
12244:
12245: l_max_fetch_size NUMBER := 200;
12246:
12247: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
12248:
12249: --l_proj_element_id_tbl element_versions_tbl1_type;
12250: --l_element_version_id_tbl element_versions_tbl2_type;
12251: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
12247: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
12248:
12249: --l_proj_element_id_tbl element_versions_tbl1_type;
12250: --l_element_version_id_tbl element_versions_tbl2_type;
12251: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
12252:
12253: l_start_date pa_projects_all.start_date%TYPE;
12254: l_completion_date pa_projects_all.completion_date%TYPE;
12255:
12628: l_error_msg_code VARCHAR2(30);
12629:
12630: --End of variables used for debugging
12631:
12632: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12633: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12634: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12635: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12636: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12629:
12630: --End of variables used for debugging
12631:
12632: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12633: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12634: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12635: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12636: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12637: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12630: --End of variables used for debugging
12631:
12632: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12633: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12634: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12635: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12636: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12637: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12638:
12633: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12634: l_task_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12635: l_task_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12636: l_task_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
12637: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12638:
12639: l_people_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12640: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12640: l_equip_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12643:
12644: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12645: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12646: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12647: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12648:
12641: l_fin_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12643:
12644: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12645: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12646: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12647: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12648:
12649: l_res_assignment_count NUMBER;
12642: l_mat_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
12643:
12644: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12645: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12646: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12647: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12648:
12649: l_res_assignment_count NUMBER;
12650: l_wp_versioning_enabled_flag VARCHAR2(1);
12643:
12644: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12645: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12646: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12647: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12648:
12649: l_res_assignment_count NUMBER;
12650: l_wp_versioning_enabled_flag VARCHAR2(1);
12651: l_pub_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12647: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
12648:
12649: l_res_assignment_count NUMBER;
12650: l_wp_versioning_enabled_flag VARCHAR2(1);
12651: l_pub_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12652: l_pub_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12653: l_proj_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12654:
12655:
12648:
12649: l_res_assignment_count NUMBER;
12650: l_wp_versioning_enabled_flag VARCHAR2(1);
12651: l_pub_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12652: l_pub_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12653: l_proj_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12654:
12655:
12656: CURSOR parent_plan_type_cur IS
12649: l_res_assignment_count NUMBER;
12650: l_wp_versioning_enabled_flag VARCHAR2(1);
12651: l_pub_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12652: l_pub_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12653: l_proj_struct_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
12654:
12655:
12656: CURSOR parent_plan_type_cur IS
12657: SELECT pfo.proj_fp_options_id
13524:
13525: input_budget_version_rec input_budget_version_cur%ROWTYPE;
13526:
13527:
13528: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13529: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13530: l_resource_list_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13531:
13532: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13525: input_budget_version_rec input_budget_version_cur%ROWTYPE;
13526:
13527:
13528: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13529: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13530: l_resource_list_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13531:
13532: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13533: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13526:
13527:
13528: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13529: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13530: l_resource_list_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13531:
13532: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13533: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13534: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13528: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13529: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13530: l_resource_list_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13531:
13532: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13533: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13534: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13535: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13536:
13529: l_proj_fp_options_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13530: l_resource_list_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13531:
13532: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13533: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13534: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13535: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13536:
13537: BEGIN
13530: l_resource_list_id_tbl SYSTEM.PA_NUM_TBL_TYPE :=SYSTEM.pa_num_tbl_type();
13531:
13532: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13533: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13534: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13535: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13536:
13537: BEGIN
13538:
13531:
13532: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13533: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13534: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13535: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13536:
13537: BEGIN
13538:
13539: x_msg_count := 0;
13611:
13612: END IF;
13613:
13614: l_proj_fp_options_id_tbl :=
13615: SYSTEM.pa_num_tbl_type(input_budget_version_rec.proj_fp_options_id);
13616: l_budget_version_id_tbl :=
13617: SYSTEM.pa_num_tbl_type(input_budget_version_rec.fin_plan_version_id);
13618: l_resource_list_id_tbl :=
13619: SYSTEM.pa_num_tbl_type(input_budget_version_rec.resource_list_id);
13613:
13614: l_proj_fp_options_id_tbl :=
13615: SYSTEM.pa_num_tbl_type(input_budget_version_rec.proj_fp_options_id);
13616: l_budget_version_id_tbl :=
13617: SYSTEM.pa_num_tbl_type(input_budget_version_rec.fin_plan_version_id);
13618: l_resource_list_id_tbl :=
13619: SYSTEM.pa_num_tbl_type(input_budget_version_rec.resource_list_id);
13620:
13621: ELSE
13615: SYSTEM.pa_num_tbl_type(input_budget_version_rec.proj_fp_options_id);
13616: l_budget_version_id_tbl :=
13617: SYSTEM.pa_num_tbl_type(input_budget_version_rec.fin_plan_version_id);
13618: l_resource_list_id_tbl :=
13619: SYSTEM.pa_num_tbl_type(input_budget_version_rec.resource_list_id);
13620:
13621: ELSE
13622:
13623: OPEN working_budget_Versions_cur;