APPS.AHL_RM_OPERATION_PVT dependencies on DUAL

Line 1033: -- Procedure to validate individual operation attributes

1029: END IF;
1030:
1031: END default_unchanged_attributes;
1032:
1033: -- Procedure to validate individual operation attributes
1034: PROCEDURE validate_attributes
1035: (
1036: p_operation_rec IN operation_rec_type,
1037: x_return_status OUT NOCOPY VARCHAR2,

Line 1632: FROM DUAL;

1628:
1629: -- Get the Operation ID from the Sequence
1630: SELECT AHL_OPERATIONS_B_S.NEXTVAL
1631: INTO p_x_operation_rec.operation_id
1632: FROM DUAL;
1633: -- Insert the record
1634: AHL_OPERATIONS_PKG.insert_row
1635: (
1636: X_ROWID => l_rowid ,

Line 2390: FROM DUAL;

2386:
2387: -- Get the Operation ID from the Sequence
2388: SELECT AHL_OPERATIONS_B_S.NEXTVAL
2389: INTO l_operation_id
2390: FROM DUAL;
2391:
2392: -- Insert the record
2393: AHL_OPERATIONS_PKG.insert_row
2394: (

Line 2562: FROM dual;

2558:
2559: -- 2.Copy Resource Requirements and Alternate Resources
2560: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_operation_id) LOOP
2561: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
2562: FROM dual;
2563: INSERT INTO AHL_RT_OPER_RESOURCES
2564: (
2565: RT_OPER_RESOURCE_ID,
2566: OBJECT_VERSION_NUMBER,

Line 2706: FROM DUAL;

2702: -- 3.Copy Reference Documents
2703: FOR I in get_doc_associations( p_operation_id ) LOOP
2704: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
2705: INTO l_doc_title_assos_id
2706: FROM DUAL;
2707: -- pekambar changes for bug # 9342005 -- start
2708: -- Passing wrong values to attribute1 to attribute15 are corrected
2709: AHL_DOC_TITLE_ASSOS_PKG.insert_row
2710: (