APPS.AHL_RM_OPERATION_PVT dependencies on DUAL

Line 967: -- Procedure to validate individual operation attributes

963: END IF;
964:
965: END default_unchanged_attributes;
966:
967: -- Procedure to validate individual operation attributes
968: PROCEDURE validate_attributes
969: (
970: p_operation_rec IN operation_rec_type,
971: x_return_status OUT NOCOPY VARCHAR2

Line 1443: FROM DUAL;

1439:
1440: -- Get the Operation ID from the Sequence
1441: SELECT AHL_OPERATIONS_B_S.NEXTVAL
1442: INTO p_x_operation_rec.operation_id
1443: FROM DUAL;
1444: -- Insert the record
1445: AHL_OPERATIONS_PKG.insert_row
1446: (
1447: X_ROWID => l_rowid ,

Line 2186: FROM DUAL;

2182:
2183: -- Get the Operation ID from the Sequence
2184: SELECT AHL_OPERATIONS_B_S.NEXTVAL
2185: INTO l_operation_id
2186: FROM DUAL;
2187:
2188: -- Insert the record
2189: AHL_OPERATIONS_PKG.insert_row
2190: (

Line 2348: FROM dual;

2344:
2345: -- 2.Copy Resource Requirements and Alternate Resources
2346: FOR l_get_rt_oper_resources IN get_rt_oper_resources(p_operation_id) LOOP
2347: SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
2348: FROM dual;
2349: INSERT INTO AHL_RT_OPER_RESOURCES
2350: (
2351: RT_OPER_RESOURCE_ID,
2352: OBJECT_VERSION_NUMBER,

Line 2492: FROM DUAL;

2488: -- 3.Copy Reference Documents
2489: FOR I in get_doc_associations( p_operation_id ) LOOP
2490: SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
2491: INTO l_doc_title_assos_id
2492: FROM DUAL;
2493:
2494: AHL_DOC_TITLE_ASSOS_PKG.insert_row
2495: (
2496: X_ROWID => l_rowid,