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

Line 61: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

57: l_project_parties_error_exists VARCHAR2(1) := FND_API.G_FALSE;
58: l_check_resource VARCHAR2(1);
59: l_proj_asgmt_res_format_id NUMBER;
60: l_person_id NUMBER;
61: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
62: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
63: l_named_role_tbl system.PA_VARCHAR2_80_TBL_TYPE := system.PA_VARCHAR2_80_TBL_TYPE();
64: l_proj_req_res_format_id NUMBER;
65: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

58: l_check_resource VARCHAR2(1);
59: l_proj_asgmt_res_format_id NUMBER;
60: l_person_id NUMBER;
61: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
62: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
63: l_named_role_tbl system.PA_VARCHAR2_80_TBL_TYPE := system.PA_VARCHAR2_80_TBL_TYPE();
64: l_proj_req_res_format_id NUMBER;
65: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
66: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

61: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
62: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
63: l_named_role_tbl system.PA_VARCHAR2_80_TBL_TYPE := system.PA_VARCHAR2_80_TBL_TYPE();
64: l_proj_req_res_format_id NUMBER;
65: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
66: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
67: l_last_bvid NUMBER;
68: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
69: l_update_count NUMBER;

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

62: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
63: l_named_role_tbl system.PA_VARCHAR2_80_TBL_TYPE := system.PA_VARCHAR2_80_TBL_TYPE();
64: l_proj_req_res_format_id NUMBER;
65: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
66: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
67: l_last_bvid NUMBER;
68: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
69: l_update_count NUMBER;
70: l_last_struct_version_id NUMBER;

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

64: l_proj_req_res_format_id NUMBER;
65: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
66: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
67: l_last_bvid NUMBER;
68: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
69: l_update_count NUMBER;
70: l_last_struct_version_id NUMBER;
71: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
72: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

67: l_last_bvid NUMBER;
68: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
69: l_update_count NUMBER;
70: l_last_struct_version_id NUMBER;
71: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
72: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
73: l_resource_organization_id NUMBER;
74:
75: l_person_id_tmp NUMBER;

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

68: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
69: l_update_count NUMBER;
70: l_last_struct_version_id NUMBER;
71: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
72: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
73: l_resource_organization_id NUMBER;
74:
75: l_person_id_tmp NUMBER;
76: l_fcst_job_id_tmp pa_project_assignments.fcst_job_id%TYPE;

Line 1248: l_task_assignment_id_tbl system.pa_num_tbl_type;

1244: l_error_message_code VARCHAR2(2000);
1245: l_asgn_text VARCHAR2(30);
1246: l_proj_asgmt_res_format_id NUMBER;
1247: l_person_id NUMBER;
1248: l_task_assignment_id_tbl system.pa_num_tbl_type;
1249: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1250: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1251: l_proj_req_res_format_id NUMBER;
1252: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

1245: l_asgn_text VARCHAR2(30);
1246: l_proj_asgmt_res_format_id NUMBER;
1247: l_person_id NUMBER;
1248: l_task_assignment_id_tbl system.pa_num_tbl_type;
1249: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1250: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1251: l_proj_req_res_format_id NUMBER;
1252: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1253: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

1246: l_proj_asgmt_res_format_id NUMBER;
1247: l_person_id NUMBER;
1248: l_task_assignment_id_tbl system.pa_num_tbl_type;
1249: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1250: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1251: l_proj_req_res_format_id NUMBER;
1252: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1253: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1254: l_last_bvid NUMBER;

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

1248: l_task_assignment_id_tbl system.pa_num_tbl_type;
1249: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1250: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1251: l_proj_req_res_format_id NUMBER;
1252: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1253: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1254: l_last_bvid NUMBER;
1255: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1256: l_update_count NUMBER;

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

1249: l_resource_list_member_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1250: l_project_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1251: l_proj_req_res_format_id NUMBER;
1252: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1253: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1254: l_last_bvid NUMBER;
1255: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1256: l_update_count NUMBER;
1257: l_last_struct_version_id NUMBER;

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

1251: l_proj_req_res_format_id NUMBER;
1252: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1253: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1254: l_last_bvid NUMBER;
1255: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1256: l_update_count NUMBER;
1257: l_last_struct_version_id NUMBER;
1258: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1259: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

1254: l_last_bvid NUMBER;
1255: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1256: l_update_count NUMBER;
1257: l_last_struct_version_id NUMBER;
1258: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1259: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1260:
1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;

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

1255: l_update_task_asgmt_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1256: l_update_count NUMBER;
1257: l_last_struct_version_id NUMBER;
1258: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1259: l_update_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1260:
1261: l_cur_resource_id pa_project_assignments.resource_id%TYPE;
1262: l_cur_fcst_job_id pa_project_assignments.fcst_job_id%TYPE;
1263: l_cur_exp_org_id pa_project_assignments.expenditure_organization_id%TYPE;

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

1275: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1276:
1277: -- l_unlink_flag VARCHAR2(1) := 'N';
1278:
1279: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1280: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1281: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1282: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1283: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1278:
1279: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1280: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1281: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1282: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1283: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1284: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1285: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1286: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1281: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1282: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1283: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1284: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1285: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1286: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1287: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1288: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1289: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1282: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1283: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1284: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1285: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1286: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1287: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1288: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1289: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1290: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();

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

1285: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1286: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1287: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1288: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1289: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1290: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1291: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1292: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1293: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1287: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1288: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1289: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1290: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1291: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1292: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1293: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1294: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1295: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1288: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
1289: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1290: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1291: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1292: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1293: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1294: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1295: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1296: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1289: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1290: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1291: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1292: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1293: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1294: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1295: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1296: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1297: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1290: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
1291: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1292: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1293: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1294: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1295: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1296: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1297: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1298: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1296: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1297: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1298: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1299: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1300: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1301: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1302: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1303: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1304: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();

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

1297: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1298: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1299: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1300: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1301: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1302: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1303: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1304: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1305: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1299: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1300: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1301: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1302: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1303: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1304: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1305: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1306: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1307: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1302: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1303: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1304: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1305: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1306: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1307: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1308: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1309: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1310: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

1304: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1305: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1306: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1307: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1308: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1309: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1310: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1311: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1312: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

1308: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1309: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
1310: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1311: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
1312: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
1313:
1314: l_resource_organization_id NUMBER;
1315:
1316: l_person_id_tmp NUMBER;