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_VARCHAR2_1_TBL_TYPE

Line 155: ,x_rlm_id_change_flag_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_1_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
159: ) IS

Line 200: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();

196: l_ra_id_count NUMBER := 0;
197: l_rbs_map_index NUMBER:=0;
198:
199: l_resource_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type :=SYSTEM.pa_varchar2_30_tbl_type();
200: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type :=SYSTEM.pa_varchar2_1_tbl_type();
201: l_ra_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
202: l_person_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
203: l_job_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
204: l_organization_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();

Line 245: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

241: l_resource_name pa_resource_list_members.alias%TYPE;
242:
243: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
244: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
245: l_rbf_rbs_prm_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
246: l_res_class_code_rbs_prm_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
247:
248: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
249:

Line 341: x_rlm_id_change_flag_tbl := SYSTEM.pa_varchar2_1_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);
345: x_mfc_cost_type_id_old_tbl.extend(p_resource_assignment_id_tbl.last);

Line 1290: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

1286: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
1287: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1288: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
1289: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1290: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1291: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
1292: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1293: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1294: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */

Line 1304: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1301: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1302: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1303: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
1304: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
1305: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE() --added for Enc
1306: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1307: ,p_pm_res_asgmt_ref IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
1308: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 1409: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1405: dml_errors EXCEPTION;
1406: PRAGMA exception_init(dml_errors, -24381);
1407:
1408: --Start of variables for Variable for Resource Attributes
1409: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1410: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1411: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1412: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1413: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1433: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1429: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1430: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1431: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1432: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1433: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1435: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1436: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1437: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1430: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1431: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1432: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1433: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1435: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1436: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1437: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1438: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 1438: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1434: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1435: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1436: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1437: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1438: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1439: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1440: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1441: l_incur_by_res_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1442: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1450: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1446: l_project_role_name_tbl SYSTEM.PA_VARCHAR2_150_TBL_TYPE := SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
1447: l_organization_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1448: l_financial_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1449: l_project_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1450: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1451: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1452: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1453: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1454: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 1460: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1456: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1457: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1458: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1459: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1460: l_unplanned_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1461: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1462: l_financial_category_name_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
1463: l_supplier_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1464: l_pm_product_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 1512: l_spread_amount_flags_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1508:
1509: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
1510: l_spread_amounts_for_ver VARCHAR2(1);
1511: l_index NUMBER := 1;
1512: l_spread_amount_flags_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1513: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1514: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1515: -- IPM Tables
1516: l_orig_count NUMBER; -- bug 5003827 issue 22

Line 1513: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

1509: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
1510: l_spread_amounts_for_ver VARCHAR2(1);
1511: l_index NUMBER := 1;
1512: l_spread_amount_flags_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1513: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1514: l_res_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1515: -- IPM Tables
1516: l_orig_count NUMBER; -- bug 5003827 issue 22
1517: -- l_count_index NUMBER;

Line 5972: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

5968: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5969: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
5970: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
5971: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
5972: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
5973: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5974: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5975: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5976: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 6000: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

5996: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5997: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5998: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5999: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6000: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6001: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6002: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
6003: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
6004: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 6001: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

5997: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5998: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
5999: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6000: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6001: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6002: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
6003: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
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

Line 6006: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE

6002: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
6003: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE
6004: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
6005: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6006: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE
6007: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6008: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6009: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6010: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 6103: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

6099: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6100: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6101: l_assignment_description_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6102: l_planning_resource_alias_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
6103: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6104: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6105: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6106: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6107: l_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 6136: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

6132: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6133: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6134: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6135: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6136: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6137: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6138: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6139: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6140: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 6137: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

6133: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6134: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6135: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6136: l_procure_resource_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6137: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6138: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6139: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
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();

Line 6142: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

6138: l_incur_by_resource_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
6139: l_Incur_by_resource_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6140: l_Incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6141: l_Incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6142: l_use_task_schedule_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6143: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6144: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6145: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6146: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();

Line 6208: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

6204: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
6205:
6206: /* End of variables for Variable for Resource Attributes
6207: */
6208: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6209: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6210: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 6209: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

6205:
6206: /* End of variables for Variable for Resource Attributes
6207: */
6208: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6209: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6210: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;

Line 6218: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

6214: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
6215: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type :=SYSTEM.pa_num_tbl_type();
6216:
6217: /* added for bug 3678814 */
6218: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6219:
6220: l_trace_stage NUMBER;
6221:
6222: -- Added for bug 3817356

Line 6243: l_rlm_id_change_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_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;
6247: l_g_miss_num CONSTANT NUMBER := FND_API.G_MISS_NUM;

Line 7729: l_delete_budget_lines_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

7725: l_txn_currency_code_tbl := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7726: l_tot_qty_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7727: l_txn_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7728: l_txn_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7729: l_delete_budget_lines_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
7730:
7731: -- If condition to delete budget lines, when dates are trucated and spread curve is not changed
7732: -- and spread curve is other than fixed date when p_distrib_amts flag is checked.
7733: IF ((l_plan_start_date_old_tbl(i) < l_plan_start_date_new_tbl(i)) OR

Line 8372: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:= SYSTEM.PA_VARCHAR2_1_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();
8373:
8374: -- Declared for Bug 3615617
8375: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8376:

Line 8397: l_res_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:=SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

8393: l_fp_cols_rec pa_fp_gen_amount_utils.fp_cols; -- IPM
8394: l_resource_class_code VARCHAR2(30);
8395: l_exp_type VARCHAR2(30);
8396: l_inv_item_id NUMBER;
8397: l_res_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE:=SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
8398:
8399: CURSOR c_calc_api_param_csr
8400: IS
8401: SELECT pfrmt.source_res_assignment_id

Line 8926: ,p_delete_budget_lines_tab => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

8922: --,p_spread_required_flag => 'N'
8923: --,p_conv_rates_required_flag => 'N'
8924: ,p_source_context => 'RESOURCE_ASSIGNMENT'
8925: ,p_resource_assignment_tab => l_calc_ra_id_tbl
8926: ,p_delete_budget_lines_tab => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
8927: -- bug fix:5726773 ,p_spread_amts_flag_tab => l_spread_amt_flag_tbl
8928: ,p_txn_currency_code_tab => l_currency_code_tbl
8929: ,p_txn_currency_override_tab => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
8930: ,p_total_qty_tab => l_quantity_tbl

Line 9340: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

9336: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
9337: ,p_calling_module IN VARCHAR2 DEFAULT NULL
9338: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9339: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9340: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
9341: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
9342: --For Bug 3937716. Calls to PJI and budget version rollup APIs will be skipped if p_rollup_required_flag is N.
9343: ,p_rollup_required_flag IN VARCHAR2 DEFAULT 'Y'
9344: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug 4200168 */

Line 9360: l_delete_task_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

9356: l_debug_mode VARCHAR2(30);
9357: --End of variables used for debugging
9358:
9359: l_module_name VARCHAR2(100):='PAFPPTPB.delete_planning_transactions';
9360: l_delete_task_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
9361: l_delete_assmt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
9362: l_wp_version_flag VARCHAR2(1);
9363: l_ta_display_flag VARCHAR2(1);
9364:

Line 9361: l_delete_assmt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

9357: --End of variables used for debugging
9358:
9359: l_module_name VARCHAR2(100):='PAFPPTPB.delete_planning_transactions';
9360: l_delete_task_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
9361: l_delete_assmt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_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;

Line 9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

9385: l_quantity_tbl SYSTEM.pa_num_tbl_type;
9386: l_task_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9387: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
9388: l_res_class_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
9390: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9391: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9392: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;
9393: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;

Line 9393: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;

9389: l_rate_based_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
9390: l_task_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9391: l_rbs_element_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9392: l_res_class_code_in_pra_tbl SYSTEM.pa_varchar2_30_tbl_type;
9393: l_rate_based_flag_in_pra_tbl SYSTEM.pa_varchar2_1_tbl_type;
9394: l_ra_id_in_pra_tbl SYSTEM.pa_num_tbl_type;
9395: --Bug 4951422
9396: l_task_assmt_ids_tbl SYSTEM.pa_num_tbl_type;
9397:

Line 11477: ,p_latest_eff_pub_flag_tbl => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

11473: ,p_task_number_tbl => SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
11474: ,p_start_date_tbl => l_planning_start_date_tbl
11475: ,p_end_date_tbl => l_planning_end_date_tbl
11476: ,p_planned_people_effort_tbl => l_planned_people_effort_tbl
11477: ,p_latest_eff_pub_flag_tbl => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
11478: ,p_resource_list_member_id_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11479: ,p_quantity_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11480: ,p_currency_code_tbl => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
11481: ,p_raw_cost_tbl => l_raw_cost_tbl