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_WORKFLOW_UTIL dependencies on ENG_SECURITY_PEOPLE_V

Line 763: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

759:
760: CURSOR c_party (p_party_id NUMBER)
761: IS
762: SELECT EngSecPeople.user_name user_role
763: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
764: WHERE EngSecPeople.person_id = p_party_id ;
765:
766: BEGIN
767:

Line 998: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

994:
995: CURSOR c_route_people (p_route_id NUMBER)
996: IS
997: SELECT EngSecPeople.user_name user_role
998: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
999: , ENG_CHANGE_ROUTE_PEOPLE step_people
1000: , ENG_CHANGE_ROUTE_STEPS step
1001: WHERE EngSecPeople.person_id = step_people.assignee_id
1002: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 1052: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1048: -- In case of Instance Route, Assignee Id is always person's party id
1049: CURSOR c_step_people (p_route_step_id NUMBER)
1050: IS
1051: SELECT EngSecPeople.user_name user_role
1052: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1053: , ENG_CHANGE_ROUTE_PEOPLE step_people
1054: WHERE EngSecPeople.person_id = step_people.assignee_id
1055: AND step_people.assignee_id <> -1
1056: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 1244: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1240:
1241: CURSOR c_party (p_party_id NUMBER)
1242: IS
1243: SELECT EngSecPeople.user_name user_role
1244: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1245: WHERE EngSecPeople.person_id = p_party_id ;
1246:
1247: BEGIN
1248:

Line 1401: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1397:
1398: CURSOR c_route_people (p_route_id NUMBER)
1399: IS
1400: SELECT EngSecPeople.user_name user_role
1401: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1402: , ENG_CHANGE_ROUTE_PEOPLE step_people
1403: , ENG_CHANGE_ROUTE_STEPS step
1404: WHERE EngSecPeople.person_id = step_people.assignee_id
1405: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 1437: FROM ENG_SECURITY_PEOPLE_V EngSecPeople

1433: -- In case of Instance Route, Assignee Id is always person's party id
1434: CURSOR c_step_people (p_route_step_id NUMBER)
1435: IS
1436: SELECT EngSecPeople.user_name user_role
1437: FROM ENG_SECURITY_PEOPLE_V EngSecPeople
1438: , ENG_CHANGE_ROUTE_PEOPLE step_people
1439: WHERE EngSecPeople.person_id = step_people.assignee_id
1440: AND step_people.assignee_id <> -1
1441: AND step_people.assignee_type_code = Eng_Workflow_Util.G_PERSON

Line 8297: , ENG_SECURITY_PEOPLE_V EngSecPeople

8293: , RoutePeople.original_assignee_id
8294: , RoutePeople.original_assignee_type_code
8295: , RoutePeople.response_condition_code
8296: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8297: , ENG_SECURITY_PEOPLE_V EngSecPeople
8298: , WF_NOTIFICATIONS wn
8299: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8300: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
8301: AND RoutePeople.step_id = p_step_id

Line 8322: , ENG_SECURITY_PEOPLE_V EngSecPeople

8318: , RoutePeople.original_assignee_id
8319: , RoutePeople.original_assignee_type_code
8320: , RoutePeople.response_condition_code
8321: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8322: , ENG_SECURITY_PEOPLE_V EngSecPeople
8323: , WF_NOTIFICATIONS wn
8324: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8325: AND RoutePeople.step_id = p_step_id
8326: AND EngSecPeople.user_name = wn.recipient_role

Line 8505: , ENG_SECURITY_PEOPLE_V EngSecPeople

8501: begin
8502: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
8503: into l_chg_rte_cnt_nonull_ntfid
8504: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8505: , ENG_SECURITY_PEOPLE_V EngSecPeople
8506: , WF_NOTIFICATIONS wn
8507: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8508: AND RoutePeople.step_id = l_step_id
8509: AND EngSecPeople.user_name = wn.recipient_role

Line 13312: , ENG_SECURITY_PEOPLE_V EngSecPeople

13308: , RoutePeople.original_assignee_id
13309: , RoutePeople.original_assignee_type_code
13310: , RoutePeople.response_condition_code
13311: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13312: , ENG_SECURITY_PEOPLE_V EngSecPeople
13313: , WF_NOTIFICATIONS wn
13314: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13315: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13316: AND RoutePeople.step_id = p_step_id

Line 13339: , ENG_SECURITY_PEOPLE_V EngSecPeople

13335: , RoutePeople.original_assignee_id
13336: , RoutePeople.original_assignee_type_code
13337: , RoutePeople.response_condition_code
13338: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13339: , ENG_SECURITY_PEOPLE_V EngSecPeople
13340: , WF_NOTIFICATIONS wn
13341: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13342: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13343: AND RoutePeople.step_id = p_step_id

Line 13420: FROM ENG_SECURITY_PEOPLE_V

13416: -- 14060173, wrap it in exception handler, and show msg,
13417: -- Cannot transfer notification to invalid role '&ROLE'
13418: begin
13419: SELECT person_id into l_new_party_id
13420: FROM ENG_SECURITY_PEOPLE_V
13421: WHERE user_name = WF_ENGINE.context_new_role;
13422: exception
13423: when no_data_found then
13424: IF g_debug_flag THEN

Line 13456: , ENG_SECURITY_PEOPLE_V EngSecPeople

13452: begin
13453: SELECT /*+ push_pred(ENGSECPEOPLE) */ 1
13454: into l_chg_rte_cnt_nonull_ntfid
13455: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13456: , ENG_SECURITY_PEOPLE_V EngSecPeople
13457: , WF_NOTIFICATIONS wn
13458: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13459: AND RoutePeople.step_id = l_step_id
13460: AND EngSecPeople.user_name = wn.recipient_role