APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on WF_NOTIFICATIONS

Line 12: l_item_key WF_NOTIFICATIONS.ITEM_KEY%TYPE;

8: p_notficationId in varchar2)
9: return varchar2
10: is
11:
12: l_item_key WF_NOTIFICATIONS.ITEM_KEY%TYPE;
13: l_item_type WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
14: l_tc_owner_resource_id varchar2(30);
15: l_app_resource_id FND_USER.EMPLOYEE_ID%TYPE;
16:

Line 13: l_item_type WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;

9: return varchar2
10: is
11:
12: l_item_key WF_NOTIFICATIONS.ITEM_KEY%TYPE;
13: l_item_type WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE;
14: l_tc_owner_resource_id varchar2(30);
15: l_app_resource_id FND_USER.EMPLOYEE_ID%TYPE;
16:
17:

Line 18: cursor cur_get_tcapprover_and_ItemKey(l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE)

14: l_tc_owner_resource_id varchar2(30);
15: l_app_resource_id FND_USER.EMPLOYEE_ID%TYPE;
16:
17:
18: cursor cur_get_tcapprover_and_ItemKey(l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE)
19: is
20: select fuser.employee_id,wf.message_type,wf.item_key
21: from wf_notifications wf,
22: fnd_user fuser

Line 21: from wf_notifications wf,

17:
18: cursor cur_get_tcapprover_and_ItemKey(l_notification_id WF_NOTIFICATIONS.NOTIFICATION_ID%TYPE)
19: is
20: select fuser.employee_id,wf.message_type,wf.item_key
21: from wf_notifications wf,
22: fnd_user fuser
23: where wf.notification_id = l_notification_id
24: and fuser.user_name = wf.RECIPIENT_ROLE;
25:

Line 992: wf_notifications wn

988: is
989: select wn.original_recipient
990: from wf_item_activity_statuses wias,
991: wf_process_activities wpa,
992: wf_notifications wn
993: where wias.item_type = p_itemtype
994: and wias.item_key = p_itemkey
995: and wias.process_activity = wpa.instance_id
996: and wpa.activity_name IN('TC_APR_NOTIFICATION', 'TC_APR_NOTIFICATION_ABS')