APPS.ENG_WORKFLOW_UTIL dependencies on ENG_CHANGE_ROUTE_ASSOCS

Line 13356: OBJECT_NAME, OBJECT_ID1 from ENG_CHANGE_ROUTE_ASSOCS

13352:
13353: CURSOR c_report_people_assocs (p_route_people_id NUMBER)
13354: IS
13355: SELECT ASSOC_OBJECT_NAME,ASSOC_OBJ_PK1_VALUE, ADHOC_ASSOC_FLAG,
13356: OBJECT_NAME, OBJECT_ID1 from ENG_CHANGE_ROUTE_ASSOCS
13357: where ROUTE_PEOPLE_ID=p_route_people_id;
13358:
13359: BEGIN
13360: -- Initialize API return status to success

Line 13559: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.nextval into l_new_route_assoc_id from DUAL;

13555: ) ;
13556:
13557: FOR assoc_rec in c_report_people_assocs(l_route_people_id)
13558: LOOP
13559: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.nextval into l_new_route_assoc_id from DUAL;
13560:
13561: insert into ENG_CHANGE_ROUTE_ASSOCS
13562: (
13563: ROUTE_ASSOCIATION_ID ,

Line 13561: insert into ENG_CHANGE_ROUTE_ASSOCS

13557: FOR assoc_rec in c_report_people_assocs(l_route_people_id)
13558: LOOP
13559: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.nextval into l_new_route_assoc_id from DUAL;
13560:
13561: insert into ENG_CHANGE_ROUTE_ASSOCS
13562: (
13563: ROUTE_ASSOCIATION_ID ,
13564: ROUTE_PEOPLE_ID,
13565: ASSOC_OBJECT_NAME,