521: attribute12,
522: attribute13,
523: attribute14,
524: attribute15
525: FROM AHL_RESOURCES
526: WHERE resource_id = c_resource_id;
527:
528: BEGIN
529:
526: WHERE resource_id = c_resource_id;
527:
528: BEGIN
529:
530: -- Get the old record from AHL_RESOURCES.
531: OPEN get_old_aso_rec( p_x_aso_resource_rec.resource_id );
532:
533: FETCH get_old_aso_rec INTO
534: l_old_aso_resource_rec.resource_id,
703: WHERE resource_mapping_id = c_resource_mapping_id;
704:
705: BEGIN
706:
707: -- Get the old record from AHL_RESOURCES.
708: OPEN get_old_bom_rec( p_x_bom_resource_rec.resource_mapping_id );
709:
710: FETCH get_old_bom_rec INTO
711: l_old_bom_resource_rec.bom_resource_id,
909:
910: CURSOR get_dup_rec ( c_resource_id NUMBER, c_name VARCHAR2)
911: IS
912: SELECT name
913: FROM AHL_RESOURCES
914: WHERE UPPER(TRIM(NAME)) = UPPER(TRIM(c_name))
915: AND (resource_id <> c_resource_id
916: OR c_resource_id IS NULL);
917:
1350: END IF;
1351:
1352: -- Perform the DML statement directly.
1353: IF ( p_x_aso_resource_rec.dml_operation = 'C' ) THEN
1354: -- Insert the record into the master table AHL_RESOURCES
1355: INSERT INTO AHL_RESOURCES
1356: (
1357: RESOURCE_ID,
1358: OBJECT_VERSION_NUMBER,
1351:
1352: -- Perform the DML statement directly.
1353: IF ( p_x_aso_resource_rec.dml_operation = 'C' ) THEN
1354: -- Insert the record into the master table AHL_RESOURCES
1355: INSERT INTO AHL_RESOURCES
1356: (
1357: RESOURCE_ID,
1358: OBJECT_VERSION_NUMBER,
1359: LAST_UPDATE_DATE,
1381: ATTRIBUTE14,
1382: ATTRIBUTE15
1383: ) VALUES
1384: (
1385: ahl_resources_s.nextval,
1386: p_x_aso_resource_rec.object_version_number,
1387: p_x_aso_resource_rec.last_update_date,
1388: p_x_aso_resource_rec.last_updated_by,
1389: p_x_aso_resource_rec.creation_date,
1478: END LOOP;
1479:
1480: ELSIF ( p_x_aso_resource_rec.dml_operation = 'U' OR p_x_aso_resource_rec.dml_operation IS NULL) THEN
1481: -- Update the record
1482: UPDATE AHL_RESOURCES SET
1483: object_version_number = object_version_number + 1,
1484: last_update_date = p_x_aso_resource_rec.last_update_date,
1485: last_updated_by = p_x_aso_resource_rec.last_updated_by,
1486: last_update_login = p_x_aso_resource_rec.last_update_login,
1635: /*
1636: DELETE FROM AHL_RESOURCE_SKILLS
1637: WHERE AHL_RESOURCE_ID = p_x_aso_resource_rec.resource_id;
1638: */
1639: DELETE FROM AHL_RESOURCES
1640: WHERE resource_id = p_x_aso_resource_rec.resource_id
1641: AND object_version_number = p_x_aso_resource_rec.object_version_number;
1642:
1643: -- If the record does not exist, then, abort API.