APPS.ENG_WORKFLOW_UTIL dependencies on ENG_CHANGE_ROUTE_ASSOCS

Line 13247: OBJECT_NAME, OBJECT_ID1 from ENG_CHANGE_ROUTE_ASSOCS

13243:
13244: CURSOR c_report_people_assocs (p_route_people_id NUMBER)
13245: IS
13246: SELECT ASSOC_OBJECT_NAME,ASSOC_OBJ_PK1_VALUE, ADHOC_ASSOC_FLAG,
13247: OBJECT_NAME, OBJECT_ID1 from ENG_CHANGE_ROUTE_ASSOCS
13248: where ROUTE_PEOPLE_ID=p_route_people_id;
13249:
13250: BEGIN
13251: -- Initialize API return status to success

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

13410: ) ;
13411:
13412: FOR assoc_rec in c_report_people_assocs(l_route_people_id)
13413: LOOP
13414: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.nextval into l_new_route_assoc_id from DUAL;
13415:
13416: insert into ENG_CHANGE_ROUTE_ASSOCS
13417: (
13418: ROUTE_ASSOCIATION_ID ,

Line 13416: insert into ENG_CHANGE_ROUTE_ASSOCS

13412: FOR assoc_rec in c_report_people_assocs(l_route_people_id)
13413: LOOP
13414: SELECT ENG_CHANGE_ROUTE_ASSOCS_S.nextval into l_new_route_assoc_id from DUAL;
13415:
13416: insert into ENG_CHANGE_ROUTE_ASSOCS
13417: (
13418: ROUTE_ASSOCIATION_ID ,
13419: ROUTE_PEOPLE_ID,
13420: ASSOC_OBJECT_NAME,