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 717: FROM AHL_RESOURCE_MAPPINGS

713: attribute12,
714: attribute13,
715: attribute14,
716: attribute15
717: FROM AHL_RESOURCE_MAPPINGS
718: WHERE resource_mapping_id = c_resource_mapping_id;
719:
720: BEGIN
721:

Line 979: FROM ahl_resource_mappings

975: )
976: IS
977: CURSOR get_bom_res_num (c_aso_resource_id number) IS
978: SELECT count(bom_resource_id)
979: FROM ahl_resource_mappings
980: WHERE aso_resource_id = c_aso_resource_id;
981:
982: CURSOR get_bom_res_org (c_aso_resource_id number) IS
983: SELECT count(bom_resource_id)

Line 984: FROM ahl_resource_mappings

980: WHERE aso_resource_id = c_aso_resource_id;
981:
982: CURSOR get_bom_res_org (c_aso_resource_id number) IS
983: SELECT count(bom_resource_id)
984: FROM ahl_resource_mappings
985: WHERE aso_resource_id = c_aso_resource_id
986: GROUP BY aso_resource_id, bom_org_id
987: HAVING count(bom_resource_id) > 1;
988:

Line 993: FROM ahl_resource_mappings

989: --MANESING::ER 10631036, 03-Jan-11,
990: --only 1 BOM resource per dept. per organization can be associated to a cmro resource
991: CURSOR get_bom_res_org_dept (c_aso_resource_id number) IS
992: SELECT count(bom_resource_id)
993: FROM ahl_resource_mappings
994: WHERE aso_resource_id = c_aso_resource_id
995: GROUP BY aso_resource_id, bom_org_id, department_id
996: HAVING count(bom_resource_id) > 1;
997:

Line 1000: FROM ahl_resource_mappings

996: HAVING count(bom_resource_id) > 1;
997:
998: CURSOR get_bom_res_dup (c_aso_resource_id number) IS
999: SELECT bom_resource_id
1000: FROM ahl_resource_mappings
1001: WHERE aso_resource_id = c_aso_resource_id
1002: GROUP BY aso_resource_id, bom_resource_id, bom_org_id
1003: HAVING count(resource_mapping_id) >1;
1004:

Line 1015: FROM ahl_resource_mappings

1011: --checking dept conflicts among primary resources
1012: CURSOR get_dept_conflicts ( c_object_id NUMBER, c_association_type_code VARCHAR2 )
1013: IS
1014: SELECT 'X'
1015: FROM ahl_resource_mappings
1016: WHERE DEPARTMENT_ID IS NOT NULL
1017: AND aso_resource_id in
1018: (SELECT ASO_RESOURCE_ID
1019: FROM ahl_rt_oper_resources

Line 1030: FROM ahl_resource_mappings

1026: --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)
1027: CURSOR get_dept_conflicts_alt_res ( c_object_id NUMBER, c_association_type_code VARCHAR2, c_rt_oper_res_id NUMBER)
1028: IS
1029: SELECT 'X'
1030: FROM ahl_resource_mappings
1031: WHERE DEPARTMENT_ID IS NOT NULL
1032: AND aso_resource_id in
1033: (SELECT ALTR.ASO_RESOURCE_ID
1034: FROM ahl_alternate_resources ALTR,

Line 1063: FROM ahl_resource_mappings

1059: --checks for conflicts b/w the alternate resource and other primary resources. here the resource is an alternate resource(in alternate_resources table)
1060: 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)
1061: IS
1062: SELECT 'X'
1063: FROM ahl_resource_mappings
1064: WHERE DEPARTMENT_ID IS NOT NULL
1065: AND aso_resource_id in
1066: (
1067: SELECT ASO_RESOURCE_ID

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

1495:
1496: -- Set OUT values
1497: p_x_aso_resource_rec.resource_id := l_resource_id;
1498:
1499: -- Insert the records into the details table AHL_RESOURCE_MAPPINGS
1500: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP
1501: INSERT INTO AHL_RESOURCE_MAPPINGS
1502: (
1503: RESOURCE_MAPPING_ID,

Line 1501: INSERT INTO AHL_RESOURCE_MAPPINGS

1497: p_x_aso_resource_rec.resource_id := l_resource_id;
1498:
1499: -- Insert the records into the details table AHL_RESOURCE_MAPPINGS
1500: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP
1501: INSERT INTO AHL_RESOURCE_MAPPINGS
1502: (
1503: RESOURCE_MAPPING_ID,
1504: OBJECT_VERSION_NUMBER,
1505: LAST_UPDATE_DATE,

Line 1532: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1528: ATTRIBUTE14,
1529: ATTRIBUTE15
1530: ) VALUES
1531: (
1532: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1533: p_x_bom_resource_tbl(i).object_version_number,
1534: p_x_bom_resource_tbl(i).last_update_date,
1535: p_x_bom_resource_tbl(i).last_updated_by,
1536: p_x_bom_resource_tbl(i).creation_date,

Line 1600: INSERT INTO AHL_RESOURCE_MAPPINGS(

1596: -- Update(Insert or Delete) the records in details table
1597: IF p_x_bom_resource_tbl.count > 0 THEN
1598: FOR i IN p_x_bom_resource_tbl.FIRST..p_x_bom_resource_tbl.LAST LOOP
1599: IF p_x_bom_resource_tbl(i).dml_operation = 'C' THEN
1600: INSERT INTO AHL_RESOURCE_MAPPINGS(
1601: RESOURCE_MAPPING_ID,
1602: OBJECT_VERSION_NUMBER,
1603: LAST_UPDATE_DATE,
1604: LAST_UPDATED_BY,

Line 1629: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,

1625: ATTRIBUTE13,
1626: ATTRIBUTE14,
1627: ATTRIBUTE15)
1628: VALUES(
1629: AHL_RESOURCE_MAPPINGS_S.NEXTVAL,
1630: p_x_bom_resource_tbl(i).object_version_number,
1631: p_x_bom_resource_tbl(i).last_update_date,
1632: p_x_bom_resource_tbl(i).last_updated_by,
1633: p_x_bom_resource_tbl(i).creation_date,

Line 1659: UPDATE AHL_RESOURCE_MAPPINGS SET

1655: p_x_bom_resource_tbl(i).attribute15)
1656: RETURNING resource_mapping_id INTO l_resource_mapping_id;
1657: p_x_bom_resource_tbl(i).resource_mapping_id := l_resource_mapping_id;
1658: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'U' THEN
1659: UPDATE AHL_RESOURCE_MAPPINGS SET
1660: object_version_number = object_version_number + 1,
1661: last_update_date = p_x_bom_resource_tbl(i).last_update_date,
1662: last_updated_by = p_x_bom_resource_tbl(i).last_updated_by,
1663: last_update_login = p_x_bom_resource_tbl(i).last_update_login,

Line 1692: DELETE FROM AHL_RESOURCE_MAPPINGS

1688: ELSE
1689: p_x_bom_resource_tbl(i).object_version_number := p_x_bom_resource_tbl(i).object_version_number+1;
1690: END IF;
1691: ELSIF p_x_bom_resource_tbl(i).dml_operation = 'D' THEN
1692: DELETE FROM AHL_RESOURCE_MAPPINGS
1693: WHERE resource_mapping_id = p_x_bom_resource_tbl(i).resource_mapping_id
1694: AND object_version_number = p_x_bom_resource_tbl(i).object_version_number;
1695: IF ( SQL%ROWCOUNT = 0 ) THEN
1696: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

Line 1732: DELETE FROM AHL_RESOURCE_MAPPINGS

1728: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
1729: FND_MSG_PUB.add;
1730: -- Delete the detailed records in ahl_resource_skills
1731: ELSE
1732: DELETE FROM AHL_RESOURCE_MAPPINGS
1733: WHERE aso_resource_id = p_x_aso_resource_rec.resource_id;
1734: END IF;
1735: END IF;
1736: END IF;