APPS.AHL_RM_OP_ROUTE_AS_PVT dependencies on AHL_RT_OPER_DEPENDENCIES

Line 1109: UPDATE AHL_RT_OPER_DEPENDENCIES SET

1105:
1106: --Pekambar (Praveen) Added for 12.2 - VEE -
1107: -- 6.Update Associated Dependencies
1108: --Update from_op_step value
1109: UPDATE AHL_RT_OPER_DEPENDENCIES SET
1110: object_version_number = object_version_number + 1,
1111: from_op_step = p_x_route_operation_tbl(i).step
1112: WHERE from_rt_op_id = p_x_route_operation_tbl(i).route_operation_id;
1113:

Line 1115: UPDATE AHL_RT_OPER_DEPENDENCIES SET

1111: from_op_step = p_x_route_operation_tbl(i).step
1112: WHERE from_rt_op_id = p_x_route_operation_tbl(i).route_operation_id;
1113:
1114: --Update to_op_step value
1115: UPDATE AHL_RT_OPER_DEPENDENCIES SET
1116: object_version_number = object_version_number + 1,
1117: to_op_step = p_x_route_operation_tbl(i).step
1118: WHERE to_rt_op_id = p_x_route_operation_tbl(i).route_operation_id ;
1119:

Line 1149: DELETE FROM AHL_RT_OPER_DEPENDENCIES

1145: END IF;
1146:
1147: --Pekambar (Praveen) Added for - VEE - USAF
1148: -- 6.Copy Associated Dependencies
1149: DELETE FROM AHL_RT_OPER_DEPENDENCIES
1150: WHERE from_rt_op_id = p_x_route_operation_tbl(i).route_operation_id
1151: OR to_rt_op_id = p_x_route_operation_tbl(i).route_operation_id;
1152:
1153: END IF;