APPS.AHL_RM_ASO_RESOURCE_PVT dependencies on AHL_RESOURCES

Line 537: FROM AHL_RESOURCES

533: attribute12,
534: attribute13,
535: attribute14,
536: attribute15
537: FROM AHL_RESOURCES
538: WHERE resource_id = c_resource_id;
539:
540: BEGIN
541:

Line 542: -- Get the old record from AHL_RESOURCES.

538: WHERE resource_id = c_resource_id;
539:
540: BEGIN
541:
542: -- Get the old record from AHL_RESOURCES.
543: OPEN get_old_aso_rec( p_x_aso_resource_rec.resource_id );
544:
545: FETCH get_old_aso_rec INTO
546: l_old_aso_resource_rec.resource_id,

Line 722: -- Get the old record from AHL_RESOURCES.

718: WHERE resource_mapping_id = c_resource_mapping_id;
719:
720: BEGIN
721:
722: -- Get the old record from AHL_RESOURCES.
723: OPEN get_old_bom_rec( p_x_bom_resource_rec.resource_mapping_id );
724:
725: FETCH get_old_bom_rec INTO
726: l_old_bom_resource_rec.bom_resource_id,

Line 928: FROM AHL_RESOURCES

924:
925: CURSOR get_dup_rec ( c_resource_id NUMBER, c_name VARCHAR2)
926: IS
927: SELECT name
928: FROM AHL_RESOURCES
929: WHERE UPPER(TRIM(NAME)) = UPPER(TRIM(c_name))
930: AND (resource_id <> c_resource_id
931: OR c_resource_id IS NULL);
932:

Line 1093: from ahl_resources

1089: --pekambar ER # 9014609 -- Start
1090: CURSOR get_one_bomres_org_value(c_aso_resource_id number)
1091: IS
1092: select ONE_BOMRES_ORG
1093: from ahl_resources
1094: where RESOURCE_ID = c_aso_resource_id;
1095:
1096: l_one_bomres_org VARCHAR2(1);
1097: --pekambar ER # 9014609 -- End

Line 1433: -- Insert the record into the master table AHL_RESOURCES

1429: END IF;
1430:
1431: -- Perform the DML statement directly.
1432: IF ( p_x_aso_resource_rec.dml_operation = 'C' ) THEN
1433: -- Insert the record into the master table AHL_RESOURCES
1434: INSERT INTO AHL_RESOURCES
1435: (
1436: RESOURCE_ID,
1437: OBJECT_VERSION_NUMBER,

Line 1434: INSERT INTO AHL_RESOURCES

1430:
1431: -- Perform the DML statement directly.
1432: IF ( p_x_aso_resource_rec.dml_operation = 'C' ) THEN
1433: -- Insert the record into the master table AHL_RESOURCES
1434: INSERT INTO AHL_RESOURCES
1435: (
1436: RESOURCE_ID,
1437: OBJECT_VERSION_NUMBER,
1438: LAST_UPDATE_DATE,

Line 1466: ahl_resources_s.nextval,

1462: --pekambar added for ER # 9014609
1463: one_bomres_org
1464: ) VALUES
1465: (
1466: ahl_resources_s.nextval,
1467: p_x_aso_resource_rec.object_version_number,
1468: p_x_aso_resource_rec.last_update_date,
1469: p_x_aso_resource_rec.last_updated_by,
1470: p_x_aso_resource_rec.creation_date,

Line 1565: UPDATE AHL_RESOURCES SET

1561: END LOOP;
1562:
1563: ELSIF ( p_x_aso_resource_rec.dml_operation = 'U' OR p_x_aso_resource_rec.dml_operation IS NULL) THEN
1564: -- Update the record
1565: UPDATE AHL_RESOURCES SET
1566: object_version_number = object_version_number + 1,
1567: last_update_date = p_x_aso_resource_rec.last_update_date,
1568: last_updated_by = p_x_aso_resource_rec.last_updated_by,
1569: last_update_login = p_x_aso_resource_rec.last_update_login,

Line 1722: DELETE FROM AHL_RESOURCES

1718: /*
1719: DELETE FROM AHL_RESOURCE_SKILLS
1720: WHERE AHL_RESOURCE_ID = p_x_aso_resource_rec.resource_id;
1721: */
1722: DELETE FROM AHL_RESOURCES
1723: WHERE resource_id = p_x_aso_resource_rec.resource_id
1724: AND object_version_number = p_x_aso_resource_rec.object_version_number;
1725:
1726: -- If the record does not exist, then, abort API.