APPS.AHL_RM_ROUTE_PVT dependencies on AHL_ROUTE_OPERATIONS

Line 3063: DELETE AHL_ROUTE_OPERATIONS

3059: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
3060: END IF;
3061:
3062: -- 4.Delete Associated Operations
3063: DELETE AHL_ROUTE_OPERATIONS
3064: WHERE ROUTE_ID = p_route_id;
3065:
3066: -- If no records exist, then, Continue.
3067: IF ( SQL%ROWCOUNT = 0 ) THEN

Line 3329: AHL_ROUTE_OPERATIONS_S.NEXTVAL new_rt_op_id,

3325: -- Cursor top get Route - operation asscoations
3326:
3327: CURSOR get_oper_asso(c_route_id NUMBER) IS
3328: SELECT
3329: AHL_ROUTE_OPERATIONS_S.NEXTVAL new_rt_op_id,
3330: route_operation_id old_rt_op_id,
3331: 1 object_version_number,
3332: l_route_id new_route_id,
3333: OPERATION_ID,

Line 3357: FROM AHL_ROUTE_OPERATIONS_V

3353: FND_GLOBAL.user_id last_updated_by,
3354: SYSDATE creation_date,
3355: FND_GLOBAL.user_id created_by,
3356: FND_GLOBAL.login_id last_update_login
3357: FROM AHL_ROUTE_OPERATIONS_V
3358: WHERE route_id = c_route_id
3359: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;
3360:
3361:

Line 4053: /*INSERT INTO AHL_ROUTE_OPERATIONS

4049: -- pekambar changes for bug # 9342005 -- End
4050: END LOOP;
4051: -- Pekambar(Praveen) Modifed for USAF - VEE - Start
4052: -- 4.Copy Associated Operations
4053: /*INSERT INTO AHL_ROUTE_OPERATIONS
4054: (
4055: ROUTE_OPERATION_ID,
4056: OBJECT_VERSION_NUMBER,
4057: ROUTE_ID,

Line 4084: AHL_ROUTE_OPERATIONS_S.NEXTVAL,

4080: CREATED_BY,
4081: LAST_UPDATE_LOGIN
4082: )
4083: SELECT
4084: AHL_ROUTE_OPERATIONS_S.NEXTVAL,
4085: 1,
4086: l_route_id,
4087: OPERATION_ID,
4088: STEP,

Line 4111: FROM AHL_ROUTE_OPERATIONS_V

4107: FND_GLOBAL.user_id,
4108: SYSDATE,
4109: FND_GLOBAL.user_id,
4110: FND_GLOBAL.login_id
4111: FROM AHL_ROUTE_OPERATIONS_V
4112: WHERE route_id = p_route_id
4113: AND NVL( end_date_active, SYSDATE + 1 ) > SYSDATE;
4114: */
4115: FOR I in get_oper_asso( p_route_id ) LOOP

Line 4119: INSERT INTO AHL_ROUTE_OPERATIONS

4115: FOR I in get_oper_asso( p_route_id ) LOOP
4116:
4117: l_rt_op_id_tbl(I.old_rt_op_id) := I.new_rt_op_id;
4118:
4119: INSERT INTO AHL_ROUTE_OPERATIONS
4120: (
4121: ROUTE_OPERATION_ID,
4122: OBJECT_VERSION_NUMBER,
4123: ROUTE_ID,