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 840: /* PROCEDURE Update_Revenue_Bill_Rate (p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,

836: FUNCTION: Update_Revenue_Bill_Rate
837: PURPOSE: This API updates the revenue_bill_rate for assignments passed
838: in. It should be only called by the Project Forecast Process.
839: -------------------------------------------------------------------- */
840: /* PROCEDURE Update_Revenue_Bill_Rate (p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
841: p_revenue_bill_rate_tbl IN SYSTEM.pa_num_tbl_type,
842: x_return_status OUT VARCHAR2) */
843: PROCEDURE Update_Revenue_Bill_Rate
844: ( p_assignment_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp

Line 841: p_revenue_bill_rate_tbl IN SYSTEM.pa_num_tbl_type,

837: PURPOSE: This API updates the revenue_bill_rate for assignments passed
838: in. It should be only called by the Project Forecast Process.
839: -------------------------------------------------------------------- */
840: /* PROCEDURE Update_Revenue_Bill_Rate (p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type,
841: p_revenue_bill_rate_tbl IN SYSTEM.pa_num_tbl_type,
842: x_return_status OUT VARCHAR2) */
843: PROCEDURE Update_Revenue_Bill_Rate
844: ( p_assignment_id_tbl IN PA_PLSQL_DATATYPES.IdTabTyp
845: ,p_revenue_bill_rate_tbl IN PA_PLSQL_DATATYPES.NumTabTyp

Line 1032: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type

1028: END Calc_Init_Transfer_Price;
1029:
1030: PROCEDURE Update_Task_Assignments
1031: ( p_mode IN VARCHAR2 := 'UPDATE'
1032: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1033: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1034: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1035: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1036: ,p_project_assignment_id IN NUMBER := NULL

Line 1033: ,p_task_version_id_tbl IN system.pa_num_tbl_type

1029:
1030: PROCEDURE Update_Task_Assignments
1031: ( p_mode IN VARCHAR2 := 'UPDATE'
1032: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1033: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1034: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1035: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1036: ,p_project_assignment_id IN NUMBER := NULL
1037: ,p_resource_list_member_id IN NUMBER := NULL

Line 1034: ,p_budget_version_id_tbl IN system.pa_num_tbl_type

1030: PROCEDURE Update_Task_Assignments
1031: ( p_mode IN VARCHAR2 := 'UPDATE'
1032: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1033: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1034: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1035: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1036: ,p_project_assignment_id IN NUMBER := NULL
1037: ,p_resource_list_member_id IN NUMBER := NULL
1038: -- pass in all resource attributes

Line 1035: ,p_struct_version_id_tbl IN system.pa_num_tbl_type

1031: ( p_mode IN VARCHAR2 := 'UPDATE'
1032: ,p_task_assignment_id_tbl IN system.pa_num_tbl_type
1033: ,p_task_version_id_tbl IN system.pa_num_tbl_type
1034: ,p_budget_version_id_tbl IN system.pa_num_tbl_type
1035: ,p_struct_version_id_tbl IN system.pa_num_tbl_type
1036: ,p_project_assignment_id IN NUMBER := NULL
1037: ,p_resource_list_member_id IN NUMBER := NULL
1038: -- pass in all resource attributes
1039: ,p_resource_class_flag IN VARCHAR2 := NULL

Line 1075: l_task_assignment_id_tbl system.pa_num_tbl_type;

1071: ,p_rate_incurred_by_org_id IN NUMBER := NULL
1072: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1073: ) IS
1074:
1075: l_task_assignment_id_tbl system.pa_num_tbl_type;
1076: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1077: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1078: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1079: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 1076: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1072: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1073: ) IS
1074:
1075: l_task_assignment_id_tbl system.pa_num_tbl_type;
1076: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1077: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1078: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1079: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1080: l_last_struct_version_id NUMBER;

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

1073: ) IS
1074:
1075: l_task_assignment_id_tbl system.pa_num_tbl_type;
1076: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1077: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1078: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1079: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1080: l_last_struct_version_id NUMBER;
1081: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

1074:
1075: l_task_assignment_id_tbl system.pa_num_tbl_type;
1076: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1077: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1078: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1079: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1080: l_last_struct_version_id NUMBER;
1081: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1082:

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

1075: l_task_assignment_id_tbl system.pa_num_tbl_type;
1076: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1077: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1078: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1079: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1080: l_last_struct_version_id NUMBER;
1081: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1082:
1083: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 1081: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1077: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1078: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1079: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1080: l_last_struct_version_id NUMBER;
1081: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1082:
1083: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1084: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1085: l_proj_req_res_format_id NUMBER;

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

1079: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1080: l_last_struct_version_id NUMBER;
1081: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1082:
1083: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1084: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1085: l_proj_req_res_format_id NUMBER;
1086: l_last_bvid NUMBER;
1087: l_update_count NUMBER;

Line 1084: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1080: l_last_struct_version_id NUMBER;
1081: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1082:
1083: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1084: l_resource_list_member_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1085: l_proj_req_res_format_id NUMBER;
1086: l_last_bvid NUMBER;
1087: l_update_count NUMBER;
1088:

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

1096: l_msg_count2 NUMBER;
1097:
1098: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1099: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1100: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1101: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1102: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1103: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1104: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1103: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1099: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1100: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1101: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1102: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1103: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1104: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1105: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1106: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1107: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1104: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1100: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1101: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1102: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1103: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1104: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1105: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1106: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1107: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1108: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();

Line 1107: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1103: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1104: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1105: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1106: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1107: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1108: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1109: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1110: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1111: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1109: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1105: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1106: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1107: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1108: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1109: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1110: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1111: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1110: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1106: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1107: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1108: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1109: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1110: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1111: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1111: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1107: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1108: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1109: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1110: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1111: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1115: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1112: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1108: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1109: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1110: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1111: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1112: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1113: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1114: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1115: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1116: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1118: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1114: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1115: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1116: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1117: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1118: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1120: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1121: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1122: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();

Line 1119: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1115: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1116: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1117: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1118: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1120: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1121: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1122: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1123: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1121: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1117: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1118: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1119: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1120: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1121: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1122: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1123: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1124: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1125: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1124: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1120: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1121: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1122: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1123: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1124: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1125: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1126: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1127: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1128: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 1126: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1122: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1123: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1124: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1125: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1126: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1127: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1128: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1129: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1130: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 1130: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1126: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1127: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1128: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1129: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1130: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1131:
1132: -- Added for Bug 6856934
1133: l_structure_ver_name pa_proj_elem_ver_structure.name%type;
1134: