eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_ECO_PVT dependencies on ENG_CHANGE_ROUTE_PEOPLE_S

Line 17323: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17319: AND assignee_id = l_assignee_id;
17320:
17321: IF (l_people_existed_flag = 0) THEN
17322: -- generate new people id
17323: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17324: into l_people_id
17325: FROM DUAL;
17326:
17327: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE

Line 17405: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17401: END IF;
17402:
17403: ELSE
17404: -- generate new people id
17405: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17406: into l_people_id
17407: FROM DUAL;
17408:
17409: --insert an 'Unassigned' assignee record

Line 17505: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17501: AND assignee_id = l_requestor_id;
17502:
17503: IF (l_people_existed_flag = 0) THEN
17504: -- generate new people id
17505: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17506: into l_people_id
17507: FROM DUAL;
17508:
17509: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE

Line 17587: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17583: END IF;
17584:
17585: ELSE
17586: -- generate new people id
17587: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17588: into l_people_id
17589: FROM DUAL;
17590:
17591: --insert an 'Unassigned' assignee record

Line 17686: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17682: AND assignee_id = cr2.member_person_id;
17683:
17684: IF (l_people_existed_flag = 0) THEN
17685: -- generate new people id
17686: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17687: into l_people_id
17688: FROM DUAL;
17689:
17690: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE

Line 17788: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17784: AND assignee_id = l_items_org_role_table(t_index).party_id;
17785:
17786: IF (l_people_existed_flag = 0) THEN
17787: -- generate new people id
17788: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17789: into l_people_id
17790: FROM DUAL;
17791:
17792: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE

Line 17881: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17877: AND assignee_id = cr2.member_person_id;
17878:
17879: IF (l_people_existed_flag = 0) THEN
17880: -- generate new people id
17881: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17882: into l_people_id
17883: FROM DUAL;
17884:
17885: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE

Line 17984: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

17980: AND assignee_id = l_items_org_role_table(t_index).party_id;
17981:
17982: IF (l_people_existed_flag = 0) THEN
17983: -- generate new people id
17984: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
17985: into l_people_id
17986: FROM DUAL;
17987:
17988: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE

Line 18077: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

18073: AND assignee_id = cr2.member_person_id;
18074:
18075: IF (l_people_existed_flag = 0) THEN
18076: -- generate new people id
18077: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
18078: into l_people_id
18079: FROM DUAL;
18080:
18081: INSERT INTO ENG_CHANGE_ROUTE_PEOPLE

Line 18169: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL

18165: END IF;
18166: END LOOP; -- FOR t_index in 1..l_items_org_role_table.last
18167: IF(l_row_inserted_flag = 0) THEN -- bug 13860012
18168: -- generate new people id
18169: SELECT ENG_CHANGE_ROUTE_PEOPLE_S.NEXTVAL
18170: into l_people_id
18171: FROM DUAL;
18172:
18173: --insert an 'Unassigned' assignee record