APPS.AHL_RM_RT_OP_DEP_PVT dependencies on AHL_RT_OPER_DEPENDENCIES

Line 20: FROM ahl_rt_oper_dependencies_v

16: SELECT rt_op_dependency_id, from_rt_op_id, from_op_step, dependency_code, to_rt_op_id,
17: to_op_step, security_group_id, attribute_category, attribute1, attribute2, attribute3,
18: attribute4, attribute5, attribute6, attribute7, attribute8, attribute9, attribute10,
19: attribute11, attribute12, attribute13, attribute14, attribute15
20: FROM ahl_rt_oper_dependencies_v
21: WHERE rt_op_dependency_id = c_rt_op_dependency_id;
22:
23: l_opdep_rec get_dep_details%rowtype;
24: l_api_name CONSTANT VARCHAR2(30) := 'default_missing_attributes';

Line 554: FROM ahl_rt_oper_dependencies od

550: AHL_DEBUG_PUB.DEBUG( G_PKG_NAME || '.' || L_API_NAME || ' : p_dependency_code - ' || p_dependency_code );
551: END IF;
552:
553: SELECT COUNT(*) INTO l_counter
554: FROM ahl_rt_oper_dependencies od
555: WHERE --dependency_code = p_dependency_code and -- sansatpa commented this for bug #14135529
556: from_rt_op_id
557: IN ( SELECT route_operation_id
558: FROM ahl_route_operations

Line 646: FROM ahl_rt_oper_dependencies

642:
643: CURSOR validate_depen_ovn(c_rt_op_dependency_id NUMBER, c_object_version_number NUMBER)
644: IS
645: SELECT 'X'
646: FROM ahl_rt_oper_dependencies
647: WHERE rt_op_dependency_id = c_rt_op_dependency_id and
648: object_version_number = c_object_version_number;
649:
650: CURSOR duplicate_depen(c_route_id NUMBER,c_from_rt_op_id NUMBER,c_to_rt_op_id NUMBER,c_dependency_code VARCHAR2)

Line 653: FROM ahl_rt_oper_dependencies_v

649:
650: CURSOR duplicate_depen(c_route_id NUMBER,c_from_rt_op_id NUMBER,c_to_rt_op_id NUMBER,c_dependency_code VARCHAR2)
651: IS
652: SELECT 'X'
653: FROM ahl_rt_oper_dependencies_v
654: WHERE route_id = c_route_id
655: -- Modified by sansatpa to check for flipped addition as A parallel to B is same as B parallel to A.
656: AND ((FROM_RT_OP_ID = C_FROM_RT_OP_ID AND TO_RT_OP_ID = C_TO_RT_OP_ID)
657: or (FROM_RT_OP_ID = C_TO_RT_OP_ID AND TO_RT_OP_ID = C_FROM_RT_OP_ID));

Line 921: DELETE FROM ahl_rt_oper_dependencies

917:
918: FOR i IN 1..p_x_rt_oper_dep_tbl.count LOOP
919: IF (p_x_rt_oper_dep_tbl(i).dml_operation = 'D' )
920: THEN
921: DELETE FROM ahl_rt_oper_dependencies
922: WHERE rt_op_dependency_id = p_x_rt_oper_dep_tbl(i).rt_op_dependency_id;
923:
924: IF (SQL%NOTFOUND) THEN
925: RAISE NO_DATA_FOUND;

Line 949: UPDATE ahl_rt_oper_dependencies SET

945: END IF;
946:
947: p_x_rt_oper_dep_tbl(i).object_version_number := p_x_rt_oper_dep_tbl(i).object_version_number + 1;
948:
949: UPDATE ahl_rt_oper_dependencies SET
950: object_version_number = p_x_rt_oper_dep_tbl(i).object_version_number,
951: last_update_date = SYSDATE,
952: last_updated_by = FND_GLOBAL.user_id,
953: last_update_login = FND_GLOBAL.login_id,

Line 1001: INSERT INTO ahl_rt_oper_dependencies(

997:
998:
999: p_x_rt_oper_dep_tbl(i).object_version_number := 1;
1000:
1001: INSERT INTO ahl_rt_oper_dependencies(
1002: RT_OP_DEPENDENCY_ID,
1003: OBJECT_VERSION_NUMBER,
1004: LAST_UPDATE_DATE,
1005: LAST_UPDATED_BY,