DBA Data[Home] [Help]

APPS.PA_RESOURCE_MAPPING dependencies on PA_RESOURCE_PREC_PUB

Line 301: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;

297: p_resource_class_id IN NUMBER,
298: p_eff_res_format_id IN NUMBER
299: ) RETURN SYSTEM.pa_varchar2_30_tbl_type IS
300:
301: l_plan_res_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
302: l_format pa_plan_res_format;
303: l_token_string VARCHAR2(30);
304: l_tokens SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
305:

Line 310: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;

306: BEGIN
307:
308: --Get all resource tokens for a given effective format
309: IF p_resource_class_id = 1 THEN
310: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
311: ELSIF p_resource_class_id = 2 THEN
312: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
313: ELSIF p_resource_class_id = 3 THEN
314: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

Line 312: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;

308: --Get all resource tokens for a given effective format
309: IF p_resource_class_id = 1 THEN
310: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
311: ELSIF p_resource_class_id = 2 THEN
312: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
313: ELSIF p_resource_class_id = 3 THEN
314: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
315: ELSIF p_resource_class_id = 4 THEN
316: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

Line 314: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

310: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
311: ELSIF p_resource_class_id = 2 THEN
312: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
313: ELSIF p_resource_class_id = 3 THEN
314: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
315: ELSIF p_resource_class_id = 4 THEN
316: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
317: END IF;
318:

Line 316: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

312: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
313: ELSIF p_resource_class_id = 3 THEN
314: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
315: ELSIF p_resource_class_id = 4 THEN
316: l_plan_res_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
317: END IF;
318:
319: IF g_resource_class_flag = 'Y' THEN --cbs change
320: l_format := l_plan_res_formats (p_eff_res_format_id);

Line 1276: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;

1272: FROM dual
1273: WHERE g_resource_class_flag = 'N' ;
1274:
1275: l_res_list_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1276: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1277: l_format NUMBER;
1278: l_eff_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_res_prec_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1280: l_eff_res_class_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- added for cbs project

Line 1294: PA_RESOURCE_PREC_PUB.format_precedence_init();

1290: -- Initialize the return status to success
1291: x_return_status := FND_API.G_RET_STS_SUCCESS;
1292:
1293: --Call function to initialize format precedence
1294: PA_RESOURCE_PREC_PUB.format_precedence_init();
1295:
1296: --Update numeric identifiers for non-numeric resource types
1297: --update_resource_element_map;(Not required for resource list
1298: --mapping but is a must for RBS mapping)

Line 1339: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;

1335: FOR res_class_rec IN resource_classes LOOP
1336:
1337: --Get all resource tokens for a given effective format
1338: IF res_class_rec.resource_class_id = 1 THEN
1339: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1340: ELSIF res_class_rec.resource_class_id = 2 THEN
1341: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1342: ELSIF res_class_rec.resource_class_id = 3 THEN
1343: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

Line 1341: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;

1337: --Get all resource tokens for a given effective format
1338: IF res_class_rec.resource_class_id = 1 THEN
1339: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1340: ELSIF res_class_rec.resource_class_id = 2 THEN
1341: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1342: ELSIF res_class_rec.resource_class_id = 3 THEN
1343: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1344: ELSIF res_class_rec.resource_class_id = 4 THEN
1345: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

Line 1343: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

1339: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1340: ELSIF res_class_rec.resource_class_id = 2 THEN
1341: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1342: ELSIF res_class_rec.resource_class_id = 3 THEN
1343: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1344: ELSIF res_class_rec.resource_class_id = 4 THEN
1345: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1346: END IF;
1347:

Line 1345: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

1341: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1342: ELSIF res_class_rec.resource_class_id = 3 THEN
1343: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1344: ELSIF res_class_rec.resource_class_id = 4 THEN
1345: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1346: END IF;
1347:
1348: --get all the effective formats for this resource class
1349: --filtered by the formats for the processed resource list

Line 1514: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;

1510: x_format_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER,
1511: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1512: x_msg_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
1513: IS
1514: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1515: BEGIN
1516: -- Initialize the return status to success
1517: x_return_status := FND_API.G_RET_STS_SUCCESS;
1518:

Line 1520: PA_RESOURCE_PREC_PUB.format_precedence_init();

1516: -- Initialize the return status to success
1517: x_return_status := FND_API.G_RET_STS_SUCCESS;
1518:
1519: --Call function to initialize format precedence
1520: PA_RESOURCE_PREC_PUB.format_precedence_init();
1521:
1522: IF p_resource_class_id = 1 THEN
1523: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1524: ELSIF p_resource_class_id = 2 THEN

Line 1523: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;

1519: --Call function to initialize format precedence
1520: PA_RESOURCE_PREC_PUB.format_precedence_init();
1521:
1522: IF p_resource_class_id = 1 THEN
1523: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1524: ELSIF p_resource_class_id = 2 THEN
1525: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1526: ELSIF p_resource_class_id = 3 THEN
1527: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

Line 1525: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;

1521:
1522: IF p_resource_class_id = 1 THEN
1523: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1524: ELSIF p_resource_class_id = 2 THEN
1525: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1526: ELSIF p_resource_class_id = 3 THEN
1527: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1528: ELSIF p_resource_class_id = 4 THEN
1529: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

Line 1527: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;

1523: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_people_formats;
1524: ELSIF p_resource_class_id = 2 THEN
1525: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1526: ELSIF p_resource_class_id = 3 THEN
1527: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1528: ELSIF p_resource_class_id = 4 THEN
1529: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1530: END IF;
1531:

Line 1529: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;

1525: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_equipment_formats;
1526: ELSIF p_resource_class_id = 3 THEN
1527: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_material_formats;
1528: ELSIF p_resource_class_id = 4 THEN
1529: l_res_class_formats := PA_RESOURCE_PREC_PUB.g_fin_element_formats;
1530: END IF;
1531:
1532: FOR i IN 1..l_res_class_formats.COUNT LOOP
1533: