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.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_RESOURCE_MAPPINGS

Line 702: FROM AHL_RESOURCE_MAPPINGS

698: attribute12,
699: attribute13,
700: attribute14,
701: attribute15
702: FROM AHL_RESOURCE_MAPPINGS
703: WHERE resource_mapping_id = c_resource_mapping_id;
704:
705: BEGIN
706:

Line 964: FROM ahl_resource_mappings

960: )
961: IS
962: CURSOR get_bom_res_num (c_aso_resource_id number) IS
963: SELECT count(bom_resource_id)
964: FROM ahl_resource_mappings
965: WHERE aso_resource_id = c_aso_resource_id;
966: CURSOR get_bom_res_org (c_aso_resource_id number) IS
967: SELECT count(bom_resource_id)
968: FROM ahl_resource_mappings

Line 968: FROM ahl_resource_mappings

964: FROM ahl_resource_mappings
965: WHERE aso_resource_id = c_aso_resource_id;
966: CURSOR get_bom_res_org (c_aso_resource_id number) IS
967: SELECT count(bom_resource_id)
968: FROM ahl_resource_mappings
969: WHERE aso_resource_id = c_aso_resource_id
970: GROUP BY aso_resource_id, bom_org_id
971: HAVING count(bom_resource_id) > 1;
972: CURSOR get_bom_res_dup (c_aso_resource_id number) IS

Line 974: FROM ahl_resource_mappings

970: GROUP BY aso_resource_id, bom_org_id
971: HAVING count(bom_resource_id) > 1;
972: CURSOR get_bom_res_dup (c_aso_resource_id number) IS
973: SELECT bom_resource_id
974: FROM ahl_resource_mappings
975: WHERE aso_resource_id = c_aso_resource_id
976: GROUP BY aso_resource_id, bom_resource_id, bom_org_id
977: HAVING count(resource_mapping_id) >1;
978:

Line 988: FROM ahl_resource_mappings

984: --checking dept conflicts among primary resources
985: CURSOR get_dept_conflicts ( c_object_id NUMBER, c_association_type_code VARCHAR2 )
986: IS
987: SELECT 'X'
988: FROM ahl_resource_mappings
989: WHERE DEPARTMENT_ID IS NOT NULL
990: AND aso_resource_id in
991: (SELECT ASO_RESOURCE_ID
992: FROM ahl_rt_oper_resources

Line 1003: FROM ahl_resource_mappings

999: --checking dept conflicts b/w the primary resource and alt resources of OTHER primary resources.here the resource is a primary resource(in rt_oper_resources table)
1000: CURSOR get_dept_conflicts_alt_res ( c_object_id NUMBER, c_association_type_code VARCHAR2, c_rt_oper_res_id NUMBER)
1001: IS
1002: SELECT 'X'
1003: FROM ahl_resource_mappings
1004: WHERE DEPARTMENT_ID IS NOT NULL
1005: AND aso_resource_id in
1006: (SELECT ALTR.ASO_RESOURCE_ID
1007: FROM ahl_alternate_resources ALTR,

Line 1036: FROM ahl_resource_mappings

1032: --checks for conflicts b/w the alternate resource and other primary resources. here the resource is an alternate resource(in alternate_resources table)
1033: CURSOR get_dept_conflicts_alt_pri ( c_object_id NUMBER, c_association_type_code VARCHAR2, c_aso_res_id NUMBER, c_alt_res_id NUMBER)
1034: IS
1035: SELECT 'X'
1036: FROM ahl_resource_mappings
1037: WHERE DEPARTMENT_ID IS NOT NULL
1038: AND aso_resource_id in
1039: (
1040: SELECT ASO_RESOURCE_ID

Line 1416: -- Insert the records into the details table AHL_RESOURCE_MAPPINGS

1412:
1413: -- Set OUT values
1414: p_x_aso_resource_rec.resource_id := l_resource_id;
1415:
1416: -- Insert the records into the details table AHL_RESOURCE_MAPPINGS
1417: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP
1418: INSERT INTO AHL_RESOURCE_MAPPINGS
1419: (
1420: RESOURCE_MAPPING_ID,

Line 1418: INSERT INTO AHL_RESOURCE_MAPPINGS

1414: p_x_aso_resource_rec.resource_id := l_resource_id;
1415:
1416: -- Insert the records into the details table AHL_RESOURCE_MAPPINGS
1417: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP
1418: INSERT INTO AHL_RESOURCE_MAPPINGS
1419: (
1420: RESOURCE_MAPPING_ID,
1421: OBJECT_VERSION_NUMBER,
1422: LAST_UPDATE_DATE,

Line 1449: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1445: ATTRIBUTE14,
1446: ATTRIBUTE15
1447: ) VALUES
1448: (
1449: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1450: p_x_bom_resource_tbl(i).object_version_number,
1451: p_x_bom_resource_tbl(i).last_update_date,
1452: p_x_bom_resource_tbl(i).last_updated_by,
1453: p_x_bom_resource_tbl(i).creation_date,

Line 1517: INSERT INTO AHL_RESOURCE_MAPPINGS(

1513: -- Update(Insert or Delete) the records in details table
1514: IF p_x_bom_resource_tbl.count > 0 THEN
1515: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP
1516: IF p_x_bom_resource_tbl(i).dml_operation = 'C' THEN
1517: INSERT INTO AHL_RESOURCE_MAPPINGS(
1518: RESOURCE_MAPPING_ID,
1519: OBJECT_VERSION_NUMBER,
1520: LAST_UPDATE_DATE,
1521: LAST_UPDATED_BY,

Line 1546: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1542: ATTRIBUTE13,
1543: ATTRIBUTE14,
1544: ATTRIBUTE15)
1545: VALUES(
1546: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1547: p_x_bom_resource_tbl(i).object_version_number,
1548: p_x_bom_resource_tbl(i).last_update_date,
1549: p_x_bom_resource_tbl(i).last_updated_by,
1550: p_x_bom_resource_tbl(i).creation_date,

Line 1576: UPDATE AHL_RESOURCE_MAPPINGS SET

1572: p_x_bom_resource_tbl(i).attribute15)
1573: RETURNING resource_mapping_id INTO l_resource_mapping_id;
1574: p_x_bom_resource_tbl(i).resource_mapping_id := l_resource_mapping_id;
1575: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'U' THEN
1576: UPDATE AHL_RESOURCE_MAPPINGS SET
1577: object_version_number = object_version_number + 1,
1578: last_update_date = p_x_bom_resource_tbl(i).last_update_date,
1579: last_updated_by = p_x_bom_resource_tbl(i).last_updated_by,
1580: last_update_login = p_x_bom_resource_tbl(i).last_update_login,

Line 1609: DELETE FROM AHL_RESOURCE_MAPPINGS

1605: ELSE
1606: p_x_bom_resource_tbl(i).object_version_number := p_x_bom_resource_tbl(i).object_version_number+1;
1607: END IF;
1608: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'D' THEN
1609: DELETE FROM AHL_RESOURCE_MAPPINGS
1610: WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
1611: AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;
1612: IF ( SQL%ROWCOUNT = 0 ) THEN
1613: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

Line 1649: DELETE FROM AHL_RESOURCE_MAPPINGS

1645: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1646: FND_MSG_PUB.add;
1647: -- Delete the detailed records in ahl_resource_skills
1648: ELSE
1649: DELETE FROM AHL_RESOURCE_MAPPINGS
1650: WHERE aso_resource_id = p_x_aso_resource_rec.resource_id;
1651: END IF;
1652: END IF;
1653: END IF;