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_RESOURCE_MAPPING dependencies on PA_RESOURCE_PREC_PUB

Line 281: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;

277: p_resource_class_id IN NUMBER,
278: p_eff_res_format_id IN NUMBER
279: ) RETURN SYSTEM.pa_varchar2_30_tbl_type IS
280:
281: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
282: l_format pa_plan_res_format;
283: l_token_string VARCHAR2(30);
284: l_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
285:

Line 290: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;

286: BEGIN
287:
288: --Get all resource tokens for a given effective format
289: IF p_resource_class_id = 1 THEN
290: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
291: ELSIF p_resource_class_id = 2 THEN
292: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
293: ELSIF p_resource_class_id = 3 THEN
294: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

Line 292: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;

288: --Get all resource tokens for a given effective format
289: IF p_resource_class_id = 1 THEN
290: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
291: ELSIF p_resource_class_id = 2 THEN
292: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
293: ELSIF p_resource_class_id = 3 THEN
294: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
295: ELSIF p_resource_class_id = 4 THEN
296: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

Line 294: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

290: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
291: ELSIF p_resource_class_id = 2 THEN
292: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
293: ELSIF p_resource_class_id = 3 THEN
294: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
295: ELSIF p_resource_class_id = 4 THEN
296: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
297: END IF;
298:

Line 296: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

292: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
293: ELSIF p_resource_class_id = 3 THEN
294: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
295: ELSIF p_resource_class_id = 4 THEN
296: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
297: END IF;
298:
299: l_format := l_plan_res_formats (p_eff_res_format_id);
300: l_token_string := l_format.res_tokens;

Line 1053: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;

1049: FROM
1050: pa_resource_classes_b;
1051:
1052: l_res_list_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1053: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1054: l_format NUMBER;
1055: l_eff_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1056:
1057: l_SQL_statement VARCHAR2 (2000);

Line 1069: PA_RESOURCE_PREC_PUB.format_precedence_init();

1065: -- Initialize the return status to success
1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067:
1068: --Call function to initialize format precedence
1069: PA_RESOURCE_PREC_PUB.format_precedence_init();
1070:
1071: --Update numeric identifiers for non-numeric resource types
1072: --update_resource_element_map;(Not required for resource list
1073: --mapping but is a must for RBS mapping)

Line 1111: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;

1107: FOR res_class_rec IN resource_classes LOOP
1108:
1109: --Get all resource tokens for a given effective format
1110: IF res_class_rec.resource_class_id = 1 THEN
1111: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1112: ELSIF res_class_rec.resource_class_id = 2 THEN
1113: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1114: ELSIF res_class_rec.resource_class_id = 3 THEN
1115: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

Line 1113: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;

1109: --Get all resource tokens for a given effective format
1110: IF res_class_rec.resource_class_id = 1 THEN
1111: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1112: ELSIF res_class_rec.resource_class_id = 2 THEN
1113: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1114: ELSIF res_class_rec.resource_class_id = 3 THEN
1115: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1116: ELSIF res_class_rec.resource_class_id = 4 THEN
1117: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

Line 1115: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

1111: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1112: ELSIF res_class_rec.resource_class_id = 2 THEN
1113: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1114: ELSIF res_class_rec.resource_class_id = 3 THEN
1115: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1116: ELSIF res_class_rec.resource_class_id = 4 THEN
1117: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1118: END IF;
1119:

Line 1117: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

1113: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1114: ELSIF res_class_rec.resource_class_id = 3 THEN
1115: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1116: ELSIF res_class_rec.resource_class_id = 4 THEN
1117: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1118: END IF;
1119:
1120: --get all the effective formats for this resource class
1121: --filtered by the formats for the processed resource list

Line 1254: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;

1250: x_format_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER,
1251: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1252: x_msg_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
1253: IS
1254: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1255: BEGIN
1256: -- Initialize the return status to success
1257: x_return_status := FND_API.G_RET_STS_SUCCESS;
1258:

Line 1260: PA_RESOURCE_PREC_PUB.format_precedence_init();

1256: -- Initialize the return status to success
1257: x_return_status := FND_API.G_RET_STS_SUCCESS;
1258:
1259: --Call function to initialize format precedence
1260: PA_RESOURCE_PREC_PUB.format_precedence_init();
1261:
1262: IF p_resource_class_id = 1 THEN
1263: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1264: ELSIF p_resource_class_id = 2 THEN

Line 1263: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;

1259: --Call function to initialize format precedence
1260: PA_RESOURCE_PREC_PUB.format_precedence_init();
1261:
1262: IF p_resource_class_id = 1 THEN
1263: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1264: ELSIF p_resource_class_id = 2 THEN
1265: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1266: ELSIF p_resource_class_id = 3 THEN
1267: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

Line 1265: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;

1261:
1262: IF p_resource_class_id = 1 THEN
1263: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1264: ELSIF p_resource_class_id = 2 THEN
1265: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1266: ELSIF p_resource_class_id = 3 THEN
1267: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1268: ELSIF p_resource_class_id = 4 THEN
1269: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

Line 1267: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

1263: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1264: ELSIF p_resource_class_id = 2 THEN
1265: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1266: ELSIF p_resource_class_id = 3 THEN
1267: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1268: ELSIF p_resource_class_id = 4 THEN
1269: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1270: END IF;
1271:

Line 1269: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

1265: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1266: ELSIF p_resource_class_id = 3 THEN
1267: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1268: ELSIF p_resource_class_id = 4 THEN
1269: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1270: END IF;
1271:
1272: FOR i IN 1..l_res_class_formats.COUNT LOOP
1273: