DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PVT dependencies on PA_NUM_TBL_TYPE

Line 574: l_task_assignment_id_tbl system.pa_num_tbl_type;

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

Line 575: l_task_version_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;

Line 576: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_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:

Line 577: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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:

Line 578: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

Line 848: /* PROCEDURE Update_Revenue_Bill_Rate (p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,

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

Line 849: p_revenue_bill_rate_tbl IN SYSTEM.pa_num_tbl_type,

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

Line 1040: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type

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

Line 1041: ,p_task_version_id_tbl IN system.pa_num_tbl_type

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

Line 1042: ,p_budget_version_id_tbl IN system.pa_num_tbl_type

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

Line 1043: ,p_struct_version_id_tbl IN system.pa_num_tbl_type

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

Line 1083: l_task_assignment_id_tbl system.pa_num_tbl_type;

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

Line 1084: l_task_version_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;

Line 1085: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

Line 1086: l_struct_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:

Line 1087: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

Line 1089: l_update_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();
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;

Line 1091: l_project_assignment_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;
1094: l_last_bvid NUMBER;
1095: l_update_count NUMBER;

Line 1092: l_resource_list_member_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;
1096:

Line 1108: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

Line 1111: l_person_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();

Line 1112: l_job_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();

Line 1115: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_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();

Line 1117: l_inventory_item_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();

Line 1118: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_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();

Line 1119: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_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();

Line 1120: l_organization_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();
1124: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1126: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_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();

Line 1127: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_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();

Line 1129: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_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();

Line 1132: l_incur_by_role_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();
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();

Line 1134: l_org_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();
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();

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