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 WF_NOTIFICATIONS

Line 2331: WF_NOTIFICATIONS ntf

2327: , na.NUMBER_VALUE
2328: , na.DATE_VALUE
2329: FROM WF_NOTIFICATION_ATTRIBUTES na,
2330: WF_MESSAGE_ATTRIBUTES ma,
2331: WF_NOTIFICATIONS ntf
2332: WHERE ntf.NOTIFICATION_ID = p_orig_ntf_id
2333: AND na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
2334: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
2335: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE

Line 7571: , WF_NOTIFICATIONS wn

7567: CURSOR c_ntf (p_notification_id NUMBER)
7568: IS
7569: SELECT fu.user_id
7570: FROM FND_USER fu
7571: , WF_NOTIFICATIONS wn
7572: WHERE fu.user_name = wn.recipient_role
7573: AND wn.notification_id = p_notification_id ;
7574:
7575:

Line 8293: , WF_NOTIFICATIONS wn

8289: , RoutePeople.original_assignee_type_code
8290: , RoutePeople.response_condition_code
8291: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
8292: , ENG_SECURITY_PEOPLE_V EngSecPeople
8293: , WF_NOTIFICATIONS wn
8294: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
8295: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
8296: AND RoutePeople.step_id = p_step_id
8297: AND EngSecPeople.user_name = wn.recipient_role

Line 8310: WF_NOTIFICATIONS ntf ,

8306: ntf.RECIPIENT_ROLE,
8307: ntf.MESSAGE_NAME,
8308: ntf.message_type
8309: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8310: WF_NOTIFICATIONS ntf ,
8311: WF_NOTIFICATIONS orig_ntf
8312: WHERE ntf.STATUS = 'OPEN'
8313: AND wias.NOTIFICATION_ID = ntf.group_id
8314: AND wias.NOTIFICATION_ID IS NOT NULL

Line 8311: WF_NOTIFICATIONS orig_ntf

8307: ntf.MESSAGE_NAME,
8308: ntf.message_type
8309: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8310: WF_NOTIFICATIONS ntf ,
8311: WF_NOTIFICATIONS orig_ntf
8312: WHERE ntf.STATUS = 'OPEN'
8313: AND wias.NOTIFICATION_ID = ntf.group_id
8314: AND wias.NOTIFICATION_ID IS NOT NULL
8315: AND (wias.ACTIVITY_STATUS = 'NOTIFIED' OR wias.ACTIVITY_STATUS = 'ERROR')

Line 9885: , WF_NOTIFICATIONS wn

9881: SELECT COUNT(*)
9882: INTO l_total_pop
9883: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9884: , EGO_USER_V UserV
9885: , WF_NOTIFICATIONS wn
9886: WHERE RoutePeople.assignee_id = UserV.party_id
9887: AND RoutePeople.response_condition_code = 'MANDATORY'
9888: AND RoutePeople.step_id = StepId
9889: AND UserV.user_name = wn.recipient_role

Line 9897: , WF_NOTIFICATIONS wn

9893: SELECT COUNT(*)
9894: INTO l_total_voted
9895: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9896: , EGO_USER_V UserV
9897: , WF_NOTIFICATIONS wn
9898: WHERE RoutePeople.assignee_id = UserV.party_id
9899: AND RoutePeople.response_condition_code = 'MANDATORY'
9900: AND RoutePeople.step_id = StepId
9901: AND UserV.user_name = wn.recipient_role

Line 9911: , WF_NOTIFICATIONS wn

9907: INTO l_code_count
9908: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9909: , EGO_USER_V UserV
9910: , WF_NOTIFICATION_ATTRIBUTES wfna
9911: , WF_NOTIFICATIONS wn
9912: WHERE RoutePeople.assignee_id = UserV.party_id
9913: AND RoutePeople.response_condition_code = 'MANDATORY'
9914: AND RoutePeople.step_id = StepId
9915: AND UserV.user_name = wn.recipient_role

Line 10696: , WF_NOTIFICATIONS wf

10692: IS
10693:
10694: SELECT UserV.user_id user_id
10695: FROM EGO_USER_V UserV
10696: , WF_NOTIFICATIONS wf
10697: WHERE UserV.user_name = wf.recipient_role
10698: AND wf.notification_id = p_ntf_id ;
10699:
10700:

Line 10813: , WF_NOTIFICATIONS wf

10809: IS
10810:
10811: SELECT UserV.user_id user_id
10812: FROM EGO_USER_V UserV
10813: , WF_NOTIFICATIONS wf
10814: WHERE UserV.user_name = wf.recipient_role
10815: AND wf.notification_id = p_ntf_id ;
10816:
10817:

Line 11133: WF_NOTIFICATIONS ntf

11129: ntf.RECIPIENT_ROLE,
11130: ntf.MESSAGE_NAME,
11131: ntf.message_type
11132: FROM WF_ITEM_ACTIVITY_STATUSES wias,
11133: WF_NOTIFICATIONS ntf
11134: WHERE ntf.STATUS = 'OPEN'
11135: AND wias.NOTIFICATION_ID = ntf.group_id
11136: AND wias.NOTIFICATION_ID IS NOT NULL
11137: AND (wias.ACTIVITY_STATUS = 'NOTIFIED' OR wias.ACTIVITY_STATUS = 'ERROR')

Line 13234: , WF_NOTIFICATIONS wn

13230: , RoutePeople.original_assignee_type_code
13231: , RoutePeople.response_condition_code
13232: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
13233: , ENG_SECURITY_PEOPLE_V EngSecPeople
13234: , WF_NOTIFICATIONS wn
13235: WHERE RoutePeople.assignee_id = EngSecPeople.person_id
13236: -- AND RoutePeople.assignee_type_code = p_assignee_type_code
13237: AND RoutePeople.step_id = p_step_id
13238: AND ( RoutePeople.response_code IS NULL