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_OPEN_ASSIGNMENT_PVT dependencies on PA_NUM_TBL_TYPE

Line 67: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --Fix for bug#9095861

63: l_starting_status_code pa_action_sets.status_code%TYPE;
64: l_new_action_set_id NUMBER;
65: l_adv_action_set_id NUMBER;
66: l_start_adv_action_set_flag VARCHAR2(1);
67: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --Fix for bug#9095861
68: l_proj_req_res_format_id NUMBER;
69: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
70: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
71: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

65: l_adv_action_set_id NUMBER;
66: l_start_adv_action_set_flag VARCHAR2(1);
67: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --Fix for bug#9095861
68: l_proj_req_res_format_id NUMBER;
69: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
70: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
71: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
72: l_last_bvid NUMBER;
73: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

66: l_start_adv_action_set_flag VARCHAR2(1);
67: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --Fix for bug#9095861
68: l_proj_req_res_format_id NUMBER;
69: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
70: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
71: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
72: l_last_bvid NUMBER;
73: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
74: l_update_count NUMBER;

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

67: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type(); --Fix for bug#9095861
68: l_proj_req_res_format_id NUMBER;
69: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
70: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
71: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
72: l_last_bvid NUMBER;
73: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
74: l_update_count NUMBER;
75: l_last_struct_version_id NUMBER;

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

69: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
70: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
71: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
72: l_last_bvid NUMBER;
73: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
74: l_update_count NUMBER;
75: l_last_struct_version_id NUMBER;
76: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
77: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

72: l_last_bvid NUMBER;
73: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
74: l_update_count NUMBER;
75: l_last_struct_version_id NUMBER;
76: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
77: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
78:
79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;

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

73: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
74: l_update_count NUMBER;
75: l_last_struct_version_id NUMBER;
76: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
77: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
78:
79: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
80: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
81: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;

Line 1155: l_task_assignment_id_tbl system.pa_num_tbl_type;

1151: l_error_message_code fnd_new_messages.message_name%TYPE;
1152: l_msg_data FND_NEW_MESSAGES.message_text%TYPE;
1153: l_req_text FND_NEW_MESSAGES.message_text%TYPE;
1154: l_proj_req_res_format_id NUMBER;
1155: l_task_assignment_id_tbl system.pa_num_tbl_type;
1156: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1157: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1158: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 1156: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1152: l_msg_data FND_NEW_MESSAGES.message_text%TYPE;
1153: l_req_text FND_NEW_MESSAGES.message_text%TYPE;
1154: l_proj_req_res_format_id NUMBER;
1155: l_task_assignment_id_tbl system.pa_num_tbl_type;
1156: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1157: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1158: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160: l_last_bvid NUMBER;

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

1153: l_req_text FND_NEW_MESSAGES.message_text%TYPE;
1154: l_proj_req_res_format_id NUMBER;
1155: l_task_assignment_id_tbl system.pa_num_tbl_type;
1156: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1157: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1158: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160: l_last_bvid NUMBER;
1161: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

1154: l_proj_req_res_format_id NUMBER;
1155: l_task_assignment_id_tbl system.pa_num_tbl_type;
1156: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1157: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1158: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160: l_last_bvid NUMBER;
1161: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1162: l_update_count NUMBER;

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

1155: l_task_assignment_id_tbl system.pa_num_tbl_type;
1156: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1157: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1158: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160: l_last_bvid NUMBER;
1161: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1162: l_update_count NUMBER;
1163: l_last_struct_version_id NUMBER;

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

1157: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1158: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1159: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1160: l_last_bvid NUMBER;
1161: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1162: l_update_count NUMBER;
1163: l_last_struct_version_id NUMBER;
1164: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1165: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

1160: l_last_bvid NUMBER;
1161: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1162: l_update_count NUMBER;
1163: l_last_struct_version_id NUMBER;
1164: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1165: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1166:
1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;

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

1161: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1162: l_update_count NUMBER;
1163: l_last_struct_version_id NUMBER;
1164: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1165: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1166:
1167: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1168: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1169: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;

Line 1185: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

1181: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1182:
1183: -- l_unlink_flag VARCHAR2(1) := 'N';
1184:
1185: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1186: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1187: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1188: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1189: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1184:
1185: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1186: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1187: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1188: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1189: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1190: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1191: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1192: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1187: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1188: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1189: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1190: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1191: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1192: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1193: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1194: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1195: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1188: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1189: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1190: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1191: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1192: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1193: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1194: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1195: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1196: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();

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

1191: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1192: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1193: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1194: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1195: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1196: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1197: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1198: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1199: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1193: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1194: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1195: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1196: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1197: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1198: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1199: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1200: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1201: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1194: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1195: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1196: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1197: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1198: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1199: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1200: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1201: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1202: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1195: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1196: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1197: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1198: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1199: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1200: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1201: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1202: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1203: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1196: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1197: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1198: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1199: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1200: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1201: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1202: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1203: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1204: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1202: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1203: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1204: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1205: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1206: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1207: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1208: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1209: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1210: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();

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

1203: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1204: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1205: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1206: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1207: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1208: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1209: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1210: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1211: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1205: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1206: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1207: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1208: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1209: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1210: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1211: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1212: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1213: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1208: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1209: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1210: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1211: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1212: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1213: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1214: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1215: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1216: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1210: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1211: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1212: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1213: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1214: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1215: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1216: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1217: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1218: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1214: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1215: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1216: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1217: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1218: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1219:
1220: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;
1221: l_expenditure_org_id_tmp pa_project_assignments.expenditure_organization_id%TYPE;
1222: l_expenditure_type_tmp pa_project_assignments.expenditure_type%TYPE;