570:
571: l_return_status VARCHAR2(10);
572: l_msg_count NUMBER;
573: l_msg_data VARCHAR2(4000);
574: l_task_assignment_id_tbl system.pa_num_tbl_type;
575: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
576: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
577: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
578: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
571: l_return_status VARCHAR2(10);
572: l_msg_count NUMBER;
573: l_msg_data VARCHAR2(4000);
574: l_task_assignment_id_tbl system.pa_num_tbl_type;
575: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
576: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
577: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
578: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
579: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
572: l_msg_count NUMBER;
573: l_msg_data VARCHAR2(4000);
574: l_task_assignment_id_tbl system.pa_num_tbl_type;
575: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
576: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
577: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
578: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
579: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
580:
573: l_msg_data VARCHAR2(4000);
574: l_task_assignment_id_tbl system.pa_num_tbl_type;
575: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
576: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
577: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
578: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
579: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
580:
581:
574: l_task_assignment_id_tbl system.pa_num_tbl_type;
575: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
576: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
577: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
578: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
579: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
580:
581:
582: CURSOR get_linked_res_asgmts IS
844: FUNCTION: Update_Revenue_Bill_Rate
845: PURPOSE: This API updates the revenue_bill_rate for assignments passed
846: in. It should be only called by the Project Forecast Process.
847: -------------------------------------------------------------------- */
848: /* PROCEDURE Update_Revenue_Bill_Rate (p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
849: p_revenue_bill_rate_tbl IN SYSTEM.pa_num_tbl_type,
850: x_return_status OUT VARCHAR2) */
851: PROCEDURE Update_Revenue_Bill_Rate
852: ( p_assignment_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp
845: PURPOSE: This API updates the revenue_bill_rate for assignments passed
846: in. It should be only called by the Project Forecast Process.
847: -------------------------------------------------------------------- */
848: /* PROCEDURE Update_Revenue_Bill_Rate (p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
849: p_revenue_bill_rate_tbl IN SYSTEM.pa_num_tbl_type,
850: x_return_status OUT VARCHAR2) */
851: PROCEDURE Update_Revenue_Bill_Rate
852: ( p_assignment_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp
853: ,p_revenue_bill_rate_tbl IN PA_PLSQL_DATATYPES.NumTabTyp
1036: END Calc_Init_Transfer_Price;
1037:
1038: PROCEDURE Update_Task_Assignments
1039: ( p_mode IN VARCHAR2 := 'UPDATE'
1040: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1041: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1042: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1043: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1044: ,p_project_assignment_id IN NUMBER := NULL
1037:
1038: PROCEDURE Update_Task_Assignments
1039: ( p_mode IN VARCHAR2 := 'UPDATE'
1040: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1041: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1042: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1043: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1044: ,p_project_assignment_id IN NUMBER := NULL
1045: ,p_resource_list_member_id IN NUMBER := NULL
1038: PROCEDURE Update_Task_Assignments
1039: ( p_mode IN VARCHAR2 := 'UPDATE'
1040: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1041: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1042: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1043: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1044: ,p_project_assignment_id IN NUMBER := NULL
1045: ,p_resource_list_member_id IN NUMBER := NULL
1046: -- pass in all resource attributes
1039: ( p_mode IN VARCHAR2 := 'UPDATE'
1040: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1041: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1042: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1043: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1044: ,p_project_assignment_id IN NUMBER := NULL
1045: ,p_resource_list_member_id IN NUMBER := NULL
1046: -- pass in all resource attributes
1047: ,p_resource_class_flag IN VARCHAR2 := NULL
1079: ,p_rate_incurred_by_org_id IN NUMBER := NULL
1080: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1081: ) IS
1082:
1083: l_task_assignment_id_tbl system.pa_num_tbl_type;
1084: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1085: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1086: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1080: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1081: ) IS
1082:
1083: l_task_assignment_id_tbl system.pa_num_tbl_type;
1084: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1085: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1086: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1088: l_last_struct_version_id NUMBER;
1081: ) IS
1082:
1083: l_task_assignment_id_tbl system.pa_num_tbl_type;
1084: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1085: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1086: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1088: l_last_struct_version_id NUMBER;
1089: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1082:
1083: l_task_assignment_id_tbl system.pa_num_tbl_type;
1084: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1085: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1086: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1088: l_last_struct_version_id NUMBER;
1089: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1090:
1083: l_task_assignment_id_tbl system.pa_num_tbl_type;
1084: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1085: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1086: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1088: l_last_struct_version_id NUMBER;
1089: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1090:
1091: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1085: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1086: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1088: l_last_struct_version_id NUMBER;
1089: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1090:
1091: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1092: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1093: l_proj_req_res_format_id NUMBER;
1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1088: l_last_struct_version_id NUMBER;
1089: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1090:
1091: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1092: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1093: l_proj_req_res_format_id NUMBER;
1094: l_last_bvid NUMBER;
1095: l_update_count NUMBER;
1088: l_last_struct_version_id NUMBER;
1089: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1090:
1091: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1092: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1093: l_proj_req_res_format_id NUMBER;
1094: l_last_bvid NUMBER;
1095: l_update_count NUMBER;
1096:
1104: l_msg_count2 NUMBER;
1105:
1106: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1107: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1108: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1109: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1110: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1111: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1107: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1108: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1109: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1110: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1111: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1115: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1108: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1109: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1110: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1111: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1115: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1116: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1111: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1115: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1116: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1117: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1118: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1115: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1116: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1117: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1118: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1120: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1121: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1115: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1116: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1117: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1118: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1120: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1121: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1122: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1115: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1116: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1117: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1118: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1120: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1121: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1122: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1123: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1116: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1117: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1118: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1120: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1121: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1122: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1123: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1124: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1122: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1123: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1124: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1125: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1126: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1127: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1128: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1129: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1130: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1123: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1124: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1125: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1126: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1127: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1128: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1129: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1130: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1131: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1125: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1126: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1127: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1128: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1129: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1130: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1131: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1132: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1133: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1128: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1129: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1130: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1131: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1132: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1133: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1134: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1135: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1136: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1130: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1131: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1132: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1133: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1134: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1135: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1136: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1137: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1138: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1134: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1135: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1136: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1137: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1138: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1139:
1140: -- Added for Bug 6856934
1141: l_structure_ver_name pa_proj_elem_ver_structure.name%type;
1142: