APPS.ENG_CHANGE_ORDER_TYPES_PKG dependencies on ENG_CHANGE_TYPE_ROUTES

Line 147: FROM eng_change_type_routes

143: AND ENTITY_ID1 = X_PARENT_CHANGE_TYPE_ID;
144: -- Bug 12617831 start
145: CURSOR typeroutes (l_CHANGE_LIFECYCLE_STATUS_ID in NUMBER) IS
146: SELECT *
147: FROM eng_change_type_routes
148: WHERE CHANGE_LIFECYCLE_STATUS_ID = l_CHANGE_LIFECYCLE_STATUS_ID;
149: -- Bug 12617831 end
150:
151: BEGIN

Line 194: INSERT INTO eng_change_type_routes(

190:
191: -- But 12617831 start
192: FOR ectr in typeroutes(cl.CHANGE_LIFECYCLE_STATUS_ID)
193: LOOP
194: INSERT INTO eng_change_type_routes(
195: change_type_route_id,
196: change_type_id,
197: route_id,
198: default_route_flag,

Line 206: ENG_CHANGE_TYPE_ROUTES_S.NEXTVAL,

202: last_updated_by,
203: last_update_login,
204: change_lifecycle_status_id)
205: VALUES(
206: ENG_CHANGE_TYPE_ROUTES_S.NEXTVAL,
207: X_CHANGE_ORDER_TYPE_ID,
208: ectr.route_id,
209: ectr.default_route_flag,
210: X_CREATION_DATE,