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 8298: , WF_NOTIFICATIONS wn

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
8302: AND EngSecPeople.user_name = wn.recipient_role

Line 8323: , WF_NOTIFICATIONS wn

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
8327: AND ( RoutePeople.response_code <> Eng_Workflow_Util.G_ACT_DELEGATED

Line 8345: WF_NOTIFICATIONS ntf ,

8341: ntf.RECIPIENT_ROLE,
8342: ntf.MESSAGE_NAME,
8343: ntf.message_type
8344: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8345: WF_NOTIFICATIONS ntf ,
8346: WF_NOTIFICATIONS orig_ntf
8347: WHERE ntf.STATUS = 'OPEN'
8348: AND wias.NOTIFICATION_ID = ntf.group_id
8349: AND wias.NOTIFICATION_ID IS NOT NULL

Line 8346: WF_NOTIFICATIONS orig_ntf

8342: ntf.MESSAGE_NAME,
8343: ntf.message_type
8344: FROM WF_ITEM_ACTIVITY_STATUSES wias,
8345: WF_NOTIFICATIONS ntf ,
8346: WF_NOTIFICATIONS orig_ntf
8347: WHERE ntf.STATUS = 'OPEN'
8348: AND wias.NOTIFICATION_ID = ntf.group_id
8349: AND wias.NOTIFICATION_ID IS NOT NULL
8350: AND (wias.ACTIVITY_STATUS = 'NOTIFIED' OR wias.ACTIVITY_STATUS = 'ERROR')

Line 8506: , WF_NOTIFICATIONS wn

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
8510: AND wn.notification_id = p_notification_id

Line 9961: , WF_NOTIFICATIONS wn

9957: SELECT COUNT(*)
9958: INTO l_total_pop
9959: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9960: , EGO_USER_V UserV
9961: , WF_NOTIFICATIONS wn
9962: WHERE RoutePeople.assignee_id = UserV.party_id
9963: AND RoutePeople.response_condition_code = 'MANDATORY'
9964: AND RoutePeople.step_id = StepId
9965: AND UserV.user_name = wn.recipient_role

Line 9973: , WF_NOTIFICATIONS wn

9969: SELECT COUNT(*)
9970: INTO l_total_voted
9971: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9972: , EGO_USER_V UserV
9973: , WF_NOTIFICATIONS wn
9974: WHERE RoutePeople.assignee_id = UserV.party_id
9975: AND RoutePeople.response_condition_code = 'MANDATORY'
9976: AND RoutePeople.step_id = StepId
9977: AND UserV.user_name = wn.recipient_role

Line 9987: , WF_NOTIFICATIONS wn

9983: INTO l_code_count
9984: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9985: , EGO_USER_V UserV
9986: , WF_NOTIFICATION_ATTRIBUTES wfna
9987: , WF_NOTIFICATIONS wn
9988: WHERE RoutePeople.assignee_id = UserV.party_id
9989: AND RoutePeople.response_condition_code = 'MANDATORY'
9990: AND RoutePeople.step_id = StepId
9991: AND UserV.user_name = wn.recipient_role

Line 10772: , WF_NOTIFICATIONS wf

10768: IS
10769:
10770: SELECT UserV.user_id user_id
10771: FROM EGO_USER_V UserV
10772: , WF_NOTIFICATIONS wf
10773: WHERE UserV.user_name = wf.recipient_role
10774: AND wf.notification_id = p_ntf_id ;
10775:
10776:

Line 10889: , WF_NOTIFICATIONS wf

10885: IS
10886:
10887: SELECT UserV.user_id user_id
10888: FROM EGO_USER_V UserV
10889: , WF_NOTIFICATIONS wf
10890: WHERE UserV.user_name = wf.recipient_role
10891: AND wf.notification_id = p_ntf_id ;
10892:
10893:

Line 11209: WF_NOTIFICATIONS ntf

11205: ntf.RECIPIENT_ROLE,
11206: ntf.MESSAGE_NAME,
11207: ntf.message_type
11208: FROM WF_ITEM_ACTIVITY_STATUSES wias,
11209: WF_NOTIFICATIONS ntf
11210: WHERE ntf.STATUS = 'OPEN'
11211: AND wias.NOTIFICATION_ID = ntf.group_id
11212: AND wias.NOTIFICATION_ID IS NOT NULL
11213: AND (wias.ACTIVITY_STATUS = 'NOTIFIED' OR wias.ACTIVITY_STATUS = 'ERROR')

Line 13313: , WF_NOTIFICATIONS wn

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
13317: AND ( RoutePeople.response_code IS NULL

Line 13340: , WF_NOTIFICATIONS wn

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
13344: AND ( RoutePeople.response_code IS NULL

Line 13457: , WF_NOTIFICATIONS wn

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
13461: AND wn.notification_id = p_notification_id