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.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on FND_USER

Line 33: FROM fnd_user usr

29: ( b_notification_id NUMBER
30: )
31: IS
32: SELECT user_id
33: FROM fnd_user usr
34: , wf_notifications wno
35: , wf_notification_attributes wna
36: WHERE usr.user_name = wna.text_value
37: AND wna.notification_id = wno.notification_id

Line 52: FROM fnd_user usr

48: ( b_notification_id NUMBER
49: )
50: IS
51: SELECT user_id
52: FROM fnd_user usr
53: , wf_notifications wfn
54: WHERE wfn.recipient_role = usr.user_name
55: AND wfn.MESSAGE_TYPE = 'CS_MSGS'
56: AND wfn.MESSAGE_NAME = 'FYI_MESSAGE'

Line 109: /* First check if sender and recipient are fnd users. */

105: , 'Entering Procedure INSERT_NOTIFICATION_ATTRIBUTE'
106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
107: END IF;
108:
109: /*** First check if sender and recipient are fnd users. ***/
110: /*** Then check if sender and recipient are mobile resources. ***/
111:
112: /*** Get user_id of sender ***/
113: OPEN c_get_sender ( p_notification_id );

Line 361: FND_USER USR,

357: CURSOR c_notification_sender (b_resource_id NUMBER) IS
358: SELECT DISTINCT WNO.NOTIFICATION_ID
359: FROM WF_NOTIFICATIONS WNO,
360: WF_NOTIFICATION_ATTRIBUTES WNA,
361: FND_USER USR,
362: ASG_USER ADU
363: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID
364: AND WNA.NAME = 'SENDER'
365: AND WNO.MESSAGE_TYPE = 'CS_MSGS'

Line 376: FND_USER USR,

372:
373: CURSOR c_notification_receive (b_resource_id NUMBER) IS
374: SELECT DISTINCT WNO.NOTIFICATION_ID
375: FROM WF_NOTIFICATIONS WNO,
376: FND_USER USR,
377: ASG_USER ADU
378: WHERE WNO.RECIPIENT_ROLE = USR.USER_NAME
379: AND USR.USER_ID = ADU.USER_ID
380: AND ADU.RESOURCE_ID = b_resource_id

Line 401: FROM FND_USER

397: WHERE WNA_DEL.NOTIFICATION_ID = WNO.NOTIFICATION_ID
398: AND WNA_DEL.NAME = 'SENDER'
399: AND WNA_DEL.TEXT_VALUE IN (
400: SELECT USER_NAME
401: FROM FND_USER
402: )
403: );
404: r_notification_receive c_notification_receive%ROWTYPE;
405:

Line 540: FND_USER USR,

536: SELECT DISTINCT WNO.NOTIFICATION_ID,
537: USR.USER_ID
538: FROM WF_NOTIFICATIONS WNO,
539: WF_NOTIFICATION_ATTRIBUTES WNA,
540: FND_USER USR,
541: ASG_USER ADU
542: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID
543: AND WNA.NAME = 'SENDER'
544: AND WNA.TEXT_VALUE = USR.USER_NAME

Line 553: FND_USER USR,

549: CURSOR c_notification_receive (b_resource_id NUMBER) IS
550: SELECT DISTINCT WNO.NOTIFICATION_ID,
551: USR.USER_ID
552: FROM WF_NOTIFICATIONS WNO,
553: FND_USER USR,
554: ASG_USER ADU
555: WHERE WNO.RECIPIENT_ROLE = USR.USER_NAME
556: AND USR.USER_ID = ADU.USER_ID
557: AND ADU.RESOURCE_ID = b_resource_id

Line 616: /Call CSL_FND_USER_ACC_PKG to delete the sender fnd_user from the acc table/

612: ,p_pk1_name => g_pk1_name
613: ,p_pk1_num_value => r_notification_sender.notification_id
614: ,p_resource_id => p_resource_id
615: );
616: /*Call CSL_FND_USER_ACC_PKG to delete the sender fnd_user from the acc table*/
617: CSL_FND_USER_ACC_PKG.Delete_User(r_notification_sender.user_id , p_resource_id);
618:
619: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
620: FETCH c_get_attribute_name INTO r_get_attribute_name;

Line 617: CSL_FND_USER_ACC_PKG.Delete_User(r_notification_sender.user_id , p_resource_id);

613: ,p_pk1_num_value => r_notification_sender.notification_id
614: ,p_resource_id => p_resource_id
615: );
616: /*Call CSL_FND_USER_ACC_PKG to delete the sender fnd_user from the acc table*/
617: CSL_FND_USER_ACC_PKG.Delete_User(r_notification_sender.user_id , p_resource_id);
618:
619: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
620: FETCH c_get_attribute_name INTO r_get_attribute_name;
621: IF c_get_attribute_name%NOTFOUND THEN

Line 671: CSL_FND_USER_ACC_PKG.Delete_User(r_notification_receive.user_id , p_resource_id);

667: , p_pk1_num_value => r_notification_receive.notification_id
668: , p_resource_id => p_resource_id
669: );
670: /*Delete the receiving user*/
671: CSL_FND_USER_ACC_PKG.Delete_User(r_notification_receive.user_id , p_resource_id);
672:
673: OPEN c_get_attribute_name ( r_notification_receive.notification_id );
674: FETCH c_get_attribute_name INTO r_get_attribute_name;
675: IF c_get_attribute_name%NOTFOUND THEN