eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_DATE_TBL_TYPE

Line 112: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

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
116: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 113: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

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
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

Line 115: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_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
119: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 149: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_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
153: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

Line 150: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_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
153: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
154: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

Line 151: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_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
153: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
154: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
155: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895

Line 152: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_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
153: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
154: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
155: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895
156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 153: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_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
153: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
154: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
155: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895
156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 154: ,x_plan_end_date_new_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
153: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
154: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
155: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895
156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 335: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_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();
339: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();

Line 336: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_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();
339: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
340: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();

Line 337: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_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();
339: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
340: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
341: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();

Line 338: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_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();
339: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
340: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
341: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
342:

Line 339: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_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();
339: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
340: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
341: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
342:
343: x_rbs_element_id_tbl.extend(p_resource_assignment_id_tbl.last);

Line 340: x_plan_end_date_new_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();
339: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
340: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
341: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
342:
343: x_rbs_element_id_tbl.extend(p_resource_assignment_id_tbl.last);
344: x_txn_accum_header_id_tbl.extend(p_resource_assignment_id_tbl.last);

Line 1284: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_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()
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()

Line 1285: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_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()
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()

Line 1287: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_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()
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

Line 1288: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_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()
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()

Line 1379: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
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();

Line 1380: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 1451: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 1452: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 1453: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 1454: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 1461: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
1464: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1465: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1526: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();

Line 1527: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_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();

Line 1550: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
1554: l_ins_cal_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1551: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
1554: l_ins_cal_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1555: l_ins_index NUMBER := 1;

Line 1559: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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;
1559: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1560: l_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1561:
1562: l_rlm_id_no_of_rows NUMBER;
1563: l_elem_ver_id_no_of_rows NUMBER;

Line 1560: l_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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;
1559: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1560: l_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1561:
1562: l_rlm_id_no_of_rows NUMBER;
1563: l_elem_ver_id_no_of_rows NUMBER;
1564: l_ppl_index NUMBER;

Line 5963: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_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
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

Line 5964: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_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
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

Line 6007: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_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
6010: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6011: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 6008: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_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
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

Line 6009: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_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
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

Line 6010: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_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
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

Line 6024: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_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
6028: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 6143: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 6144: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 6145: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 6146: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 6152: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
6156: l_wbs_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 6223: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

6219:
6220: l_trace_stage NUMBER;
6221:
6222: -- Added for bug 3817356
6223: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6224: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 6224: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

6220: l_trace_stage NUMBER;
6221:
6222: -- Added for bug 3817356
6223: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6224: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6228: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

6221:
6222: -- Added for bug 3817356
6223: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6224: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6228: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6229: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

6222: -- Added for bug 3817356
6223: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6224: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6228: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
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');

Line 6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

6223: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6224: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6228: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
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:

Line 6228: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

6224: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6228: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
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

Line 6229: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

6225: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6226: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6227: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6228: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
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();

Line 6237: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
6241: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 6238: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
6241: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6242: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 6239: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
6241: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6242: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6243: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 6240: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
6241: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6242: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6243: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6244:

Line 6241: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
6241: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6242: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6243: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6244:
6245: --Added for Bug 4200168

Line 6242: l_plan_end_date_new_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();
6241: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6242: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6243: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6244:
6245: --Added for Bug 4200168
6246: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;

Line 6254: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
6258: l_txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 6255: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
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();

Line 7723: l_line_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();

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();
7727: l_txn_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 7724: l_line_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();

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();
7727: l_txn_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7728: l_txn_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 8072: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()

8068: ,p_b_cost_rate_tab => l_b_multiplier_tbl
8069: ,p_b_cost_rate_override_tab => l_burdened_rate_override_tbl
8070: ,p_bill_rate_tab => l_bill_rate_tbl
8071: ,p_bill_rate_override_tab => l_bill_rate_override_tbl
8072: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8073: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8074: ,p_apply_progress_flag => p_apply_progress_flag /* Passed by apply_progress api (sakthi's team) */
8075: --Added for Bug 4152749
8076: ,p_mfc_cost_type_id_old_tab => l_mfc_cost_type_id_old_tbl

Line 8073: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()

8069: ,p_b_cost_rate_override_tab => l_burdened_rate_override_tbl
8070: ,p_bill_rate_tab => l_bill_rate_tbl
8071: ,p_bill_rate_override_tab => l_bill_rate_override_tbl
8072: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8073: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8074: ,p_apply_progress_flag => p_apply_progress_flag /* Passed by apply_progress api (sakthi's team) */
8075: --Added for Bug 4152749
8076: ,p_mfc_cost_type_id_old_tab => l_mfc_cost_type_id_old_tbl
8077: ,p_mfc_cost_type_id_new_tab => l_mfc_cost_type_id_new_tbl

Line 8359: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_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();
8363: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';

Line 8360: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_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();
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;

Line 8365: l_planning_start_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();
8366: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8367: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8368: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8369: l_calculate_flag VARCHAR2(1);

Line 8366: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_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();
8366: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8367: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8368: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8369: l_calculate_flag VARCHAR2(1);
8370: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;

Line 8367: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_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();
8366: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8367: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8368: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8369: l_calculate_flag VARCHAR2(1);
8370: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
8371: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;

Line 8368: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();

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();
8366: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8367: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8368: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8369: l_calculate_flag VARCHAR2(1);
8370: l_projfunc_currency_code pa_projects_all.project_currency_code%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();

Line 8940: ,p_line_start_date_tab => SYSTEM.PA_DATE_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
8944: ,x_return_status => x_return_status

Line 8941: ,p_line_end_date_tab => SYSTEM.PA_DATE_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
8944: ,x_return_status => x_return_status
8945: ,x_msg_count => x_msg_count

Line 9366: l_start_date_tbl SYSTEM.pa_date_tbl_type;

9362: l_wp_version_flag VARCHAR2(1);
9363: l_ta_display_flag VARCHAR2(1);
9364:
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;

Line 9367: l_end_date_tbl SYSTEM.pa_date_tbl_type;

9363: l_ta_display_flag VARCHAR2(1);
9364:
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;

Line 11135: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

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 */
11139: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */

Line 11136: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

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 */
11139: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
11140: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */

Line 11142: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

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
11146: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895

Line 11143: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

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
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

Line 11172: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
11176: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 11173: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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();
11176: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
11177: l_index NUMBER;

Line 11179: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
11183: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 11180: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_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();
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();

Line 11217: x_planning_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();

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();
11221: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 11218: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();

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();
11221: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
11222: x_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();