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 56: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

52: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
53: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
54: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
55: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
56: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
57: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
58: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
59: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
60: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 57: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

53: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
54: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
55: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
56: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
57: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
58: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
59: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
60: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
61: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 59: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

55: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
56: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
57: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
58: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
59: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
60: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
61: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
62: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
63: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 93: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

89: ,x_mfc_cost_type_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
90: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
91: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
92: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
93: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
94: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
95: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
96: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
97: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

Line 94: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

90: ,x_mfc_cost_type_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
91: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
92: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
93: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
94: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
95: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
96: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
97: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
98: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

Line 95: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

91: ,x_spread_curve_id_old_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
92: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
93: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
94: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
95: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
96: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
97: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
98: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
99: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895

Line 96: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

92: ,x_spread_curve_id_new_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
93: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
94: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
95: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
96: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
97: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
98: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
99: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895
100: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 97: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

93: ,x_sp_fixed_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
94: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
95: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
96: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
97: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
98: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
99: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895
100: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
101: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 98: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

94: ,x_sp_fixed_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
95: ,x_plan_start_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
96: ,x_plan_start_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
97: ,x_plan_end_date_old_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
98: ,x_plan_end_date_new_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
99: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE --File.Sql.39 bug 4440895
100: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
101: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
102: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 279: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();

275: x_mfc_cost_type_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
276: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
277: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
278: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
279: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
280: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
281: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
282: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
283: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();

Line 280: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();

276: x_mfc_cost_type_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
277: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
278: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
279: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
280: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
281: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
282: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
283: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
284: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();

Line 281: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();

277: x_spread_curve_id_old_tbl := SYSTEM.PA_NUM_TBL_TYPE();
278: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
279: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
280: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
281: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
282: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
283: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
284: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
285: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();

Line 282: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();

278: x_spread_curve_id_new_tbl := SYSTEM.PA_NUM_TBL_TYPE();
279: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
280: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
281: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
282: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
283: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
284: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
285: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
286:

Line 283: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();

279: x_sp_fixed_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
280: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
281: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
282: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
283: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
284: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
285: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
286:
287: x_rbs_element_id_tbl.extend(p_resource_assignment_id_tbl.last);

Line 284: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();

280: x_sp_fixed_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
281: x_plan_start_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
282: x_plan_start_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
283: x_plan_end_date_old_tbl := SYSTEM.PA_DATE_TBL_TYPE();
284: x_plan_end_date_new_tbl := SYSTEM.PA_DATE_TBL_TYPE();
285: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_tbl_type();
286:
287: x_rbs_element_id_tbl.extend(p_resource_assignment_id_tbl.last);
288: x_txn_accum_header_id_tbl.extend(p_resource_assignment_id_tbl.last);

Line 1225: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

1221: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
1222: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1223: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1224: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1225: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1226: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1227: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
1228: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1229: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 1226: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

1222: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1223: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1224: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1225: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1226: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1227: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
1228: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1229: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1230: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 1228: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

1224: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
1225: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1226: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1227: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
1228: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1229: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1230: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1231: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1232: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables

Line 1229: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

1225: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1226: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1227: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
1228: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1229: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1230: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1231: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1232: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
1233: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

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

1315: l_task_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1316: l_proj_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1317:
1318: -- Bug 3719918, these tables will only be used for insert in B/F context
1319: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1320: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1321: l_bf_proj_elem_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1322: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1323: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1320: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1316: l_proj_elem_rlm_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1317:
1318: -- Bug 3719918, these tables will only be used for insert in B/F context
1319: l_bf_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1320: l_bf_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1321: l_bf_proj_elem_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1322: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1323: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1324: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

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

1386: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1387: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1388: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1389: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1390: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1391: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1392: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1393: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1394: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1387: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1388: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1389: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1390: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1391: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1392: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1393: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1394: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1395: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1392: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1388: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1389: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1390: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1391: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1392: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1393: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1394: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1395: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1396: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1389: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1390: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1391: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1392: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1393: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1394: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1395: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1396: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1397: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1400: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1396: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1397: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1398: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1399: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1400: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1401: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1402: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1403: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1404: l_pm_res_asgmt_ref_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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

1461: l_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1462: l_call_calc_api VARCHAR2(1);
1463:
1464: -- Start of variable to be used in Calculate API Call
1465: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1466: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1467:
1468: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1469: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1462: l_call_calc_api VARCHAR2(1);
1463:
1464: -- Start of variable to be used in Calculate API Call
1465: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1466: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1467:
1468: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1469: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1470: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1483:
1484: -- Bug 3749516 Added for insert in Workplan Context
1485: l_ins_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1486: l_ins_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1487: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1488: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1489: l_ins_cal_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1490: l_ins_cal_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1491: l_ins_cal_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

1484: -- Bug 3749516 Added for insert in Workplan Context
1485: l_ins_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1486: l_ins_task_elem_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1487: l_ins_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1488: l_ins_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1489: l_ins_cal_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1490: l_ins_cal_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1491: l_ins_cal_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1492: l_ins_index NUMBER := 1;

Line 1496: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

1492: l_ins_index NUMBER := 1;
1493:
1494: l_start_date pa_resource_assignments.planning_start_date%TYPE := NULL;
1495: l_compl_date pa_resource_assignments.planning_start_date%TYPE := NULL;
1496: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1497: l_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1498:
1499: l_rlm_id_no_of_rows NUMBER;
1500: l_elem_ver_id_no_of_rows NUMBER;

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

1493:
1494: l_start_date pa_resource_assignments.planning_start_date%TYPE := NULL;
1495: l_compl_date pa_resource_assignments.planning_start_date%TYPE := NULL;
1496: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1497: l_compl_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1498:
1499: l_rlm_id_no_of_rows NUMBER;
1500: l_elem_ver_id_no_of_rows NUMBER;
1501: l_ppl_index NUMBER;

Line 5308: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

5304: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE
5305: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5307: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
5308: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5309: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5310: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5311: -- One pl/sql record in The Above tables
5312: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5309: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

5305: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5307: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE
5308: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5309: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5310: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5311: -- One pl/sql record in The Above tables
5312: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5313: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5352: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

5348: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5349: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5350: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5351: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5352: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5353: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5354: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5355: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5356: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5353: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

5349: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5350: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5351: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5352: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5353: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5354: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5355: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5356: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5357: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 5354: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

5350: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5351: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5352: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5353: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5354: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5355: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5356: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5357: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5358: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE

Line 5355: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

5351: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5352: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5353: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5354: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5355: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5356: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5357: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5358: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5359: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 5369: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

5365: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5366: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5367: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5368: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5369: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5370: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5371: ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5372: ,p_supplier_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5373: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

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

5481: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5482: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5483: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5484: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5485: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5486: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5487: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5488: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5489: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

5482: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
5483: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5484: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5485: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5486: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5487: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5488: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5489: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5490: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();

Line 5487: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

5483: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5484: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5485: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5486: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5487: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5488: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5489: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5490: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5491: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

5484: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5485: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5486: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5487: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5488: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5489: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5490: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5491: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5492: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 5494: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

5490: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5491: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5492: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5493: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5494: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5495: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5496: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
5497: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
5498: l_wbs_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

5561:
5562: l_trace_stage NUMBER;
5563:
5564: -- Added for bug 3817356
5565: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5566: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5567: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5568: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5569: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

5562: l_trace_stage NUMBER;
5563:
5564: -- Added for bug 3817356
5565: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5566: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5567: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5568: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5569: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5570: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

5563:
5564: -- Added for bug 3817356
5565: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5566: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5567: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5568: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5569: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5570: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5571: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

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

5564: -- Added for bug 3817356
5565: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5566: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5567: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5568: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5569: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5570: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5571: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5572: l_temp_gmiss_date date := to_date('01-01-4712','DD-MM-YYYY');

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

5565: l_in_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5566: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5567: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5568: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5569: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5570: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5571: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5572: l_temp_gmiss_date date := to_date('01-01-4712','DD-MM-YYYY');
5573:

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

5566: l_in_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5567: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5568: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5569: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5570: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5571: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5572: l_temp_gmiss_date date := to_date('01-01-4712','DD-MM-YYYY');
5573:
5574: --These parameters are introduced for calculate API enhancements tracked thru bug 4152749

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

5567: l_in_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5568: l_in_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5569: l_in_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5570: l_in_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5571: l_in_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5572: l_temp_gmiss_date date := to_date('01-01-4712','DD-MM-YYYY');
5573:
5574: --These parameters are introduced for calculate API enhancements tracked thru bug 4152749
5575: l_mfc_cost_type_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

5575: l_mfc_cost_type_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5576: l_mfc_cost_type_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5577: l_spread_curve_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5578: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5579: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5580: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5581: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5582: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5583: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 5580: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

5576: l_mfc_cost_type_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5577: l_spread_curve_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5578: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5579: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5580: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5581: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5582: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5583: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5584: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 5581: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

5577: l_spread_curve_id_old_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5578: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5579: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5580: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5581: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5582: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5583: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5584: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5585: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 5582: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

5578: l_spread_curve_id_new_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5579: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5580: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5581: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5582: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5583: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5584: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5585: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5586:

Line 5583: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

5579: l_sp_fixed_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5580: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5581: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5582: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5583: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5584: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5585: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5586:
5587: --Added for Bug 4200168

Line 5584: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

5580: l_sp_fixed_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5581: l_plan_start_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5582: l_plan_start_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5583: l_plan_end_date_old_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5584: l_plan_end_date_new_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5585: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5586:
5587: --Added for Bug 4200168
5588: l_g_miss_char CONSTANT VARCHAR(1) := FND_API.G_MISS_CHAR;

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

7275: ,p_b_cost_rate_tab => l_b_multiplier_tbl
7276: ,p_b_cost_rate_override_tab => l_burdened_rate_override_tbl
7277: ,p_bill_rate_tab => l_bill_rate_tbl
7278: ,p_bill_rate_override_tab => l_bill_rate_override_tbl
7279: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
7280: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
7281: ,p_apply_progress_flag => p_apply_progress_flag /* Passed by apply_progress api (sakthi's team) */
7282: --Added for Bug 4152749
7283: ,p_mfc_cost_type_id_old_tab => l_mfc_cost_type_id_old_tbl

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

7276: ,p_b_cost_rate_override_tab => l_burdened_rate_override_tbl
7277: ,p_bill_rate_tab => l_bill_rate_tbl
7278: ,p_bill_rate_override_tab => l_bill_rate_override_tbl
7279: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
7280: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
7281: ,p_apply_progress_flag => p_apply_progress_flag /* Passed by apply_progress api (sakthi's team) */
7282: --Added for Bug 4152749
7283: ,p_mfc_cost_type_id_old_tab => l_mfc_cost_type_id_old_tbl
7284: ,p_mfc_cost_type_id_new_tab => l_mfc_cost_type_id_new_tbl

Line 7533: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();

7529: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7530: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7531: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7532: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7533: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7534: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
7535: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7536: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7537: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';

Line 7534: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;

7530: l_temp_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7531: l_calc_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7532: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7533: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7534: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
7535: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7536: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7537: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';
7538: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;

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

7535: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7536: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7537: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';
7538: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;
7539: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7540: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7541: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7542: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7543: l_calculate_flag VARCHAR2(1);

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

7536: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7537: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';
7538: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;
7539: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7540: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7541: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7542: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7543: l_calculate_flag VARCHAR2(1);
7544: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;

Line 7541: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();

7537: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';
7538: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;
7539: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7540: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7541: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7542: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7543: l_calculate_flag VARCHAR2(1);
7544: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
7545: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;

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

7538: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;
7539: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7540: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7541: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7542: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7543: l_calculate_flag VARCHAR2(1);
7544: l_projfunc_currency_code pa_projects_all.project_currency_code%TYPE;
7545: l_proj_curr_code pa_projects_all.projfunc_currency_code%TYPE;
7546: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

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

8110: ,p_b_cost_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8111: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8112: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8113: ,p_bill_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8114: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8115: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8116: ,p_rollup_required_flag => l_pji_rollup_required
8117: ,p_raTxn_rollup_api_call_flag => 'N' -- Added for bug 5017855
8118: ,x_return_status => x_return_status

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

8111: ,p_b_cost_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8112: ,p_bill_rate_tab => SYSTEM.PA_NUM_TBL_TYPE()
8113: ,p_bill_rate_override_tab => SYSTEM.PA_NUM_TBL_TYPE()
8114: ,p_line_start_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8115: ,p_line_end_date_tab => SYSTEM.PA_DATE_TBL_TYPE()
8116: ,p_rollup_required_flag => l_pji_rollup_required
8117: ,p_raTxn_rollup_api_call_flag => 'N' -- Added for bug 5017855
8118: ,x_return_status => x_return_status
8119: ,x_msg_count => x_msg_count

Line 8540: l_start_date_tbl SYSTEM.pa_date_tbl_type;

8536: l_wp_version_flag VARCHAR2(1);
8537: l_ta_display_flag VARCHAR2(1);
8538:
8539: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type;
8540: l_start_date_tbl SYSTEM.pa_date_tbl_type;
8541: l_end_date_tbl SYSTEM.pa_date_tbl_type;
8542: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
8543: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
8544: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;

Line 8541: l_end_date_tbl SYSTEM.pa_date_tbl_type;

8537: l_ta_display_flag VARCHAR2(1);
8538:
8539: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type;
8540: l_start_date_tbl SYSTEM.pa_date_tbl_type;
8541: l_end_date_tbl SYSTEM.pa_date_tbl_type;
8542: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
8543: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
8544: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
8545: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;

Line 10269: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

10265: (
10266: p_project_id IN Pa_projects_all.project_id%TYPE
10267: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
10268: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
10269: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
10270: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
10271: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
10272: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
10273: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */

Line 10270: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

10266: p_project_id IN Pa_projects_all.project_id%TYPE
10267: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
10268: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
10269: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
10270: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
10271: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
10272: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
10273: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
10274: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */

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

10272: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
10273: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
10274: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
10275: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
10276: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
10277: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
10278: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
10279: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
10280: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895

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

10273: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */
10274: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
10275: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
10276: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
10277: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
10278: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
10279: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
10280: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895
10281: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug 3720357 */ --File.Sql.39 bug 4440895

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

10302: l_add_tbl_index NUMBER := 1;
10303: l_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
10304: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10305: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10306: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10307: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10308: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10309: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10310: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

10303: l_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
10304: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10305: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10306: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10307: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10308: l_planned_people_effort_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10309: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10310: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10311: l_index NUMBER;

Line 10313: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

10309: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10310: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10311: l_index NUMBER;
10312: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10313: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10314: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10315: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10316: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10317: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 10314: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

10310: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10311: l_index NUMBER;
10312: l_element_version_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10313: l_planning_start_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10314: l_planning_end_date_tbl_tmp SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
10315: l_planned_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10316: l_res_assignment_id_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10317: l_planned_ppl_effort_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
10318: l_raw_cost_tbl_tmp SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

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

10347: pa_debug.g_err_stage:='Extending the local pl/sql tbls';
10348: print_msg(pa_debug.g_err_stage,l_module_name);
10349: END IF;
10350: x_element_version_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10351: x_planning_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
10352: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
10353: x_planned_effort_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10354: x_resource_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10355: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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

10348: print_msg(pa_debug.g_err_stage,l_module_name);
10349: END IF;
10350: x_element_version_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10351: x_planning_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
10352: x_planning_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
10353: x_planned_effort_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10354: x_resource_assignment_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10355: x_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
10356: x_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();