APPS.POS_URL_PKG dependencies on WF_NOTIFICATIONS

Line 113: FROM wf_notifications

109: CURSOR wf_notif_context_cur IS
110: SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
111: SUBSTR(context,INSTR(context,':')+1,
112: (INSTR(context,':',1,2) - INSTR(context,':')-1))
113: FROM wf_notifications
114: WHERE notification_id = p_ntf_id;
115:
116: l_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE;
117: l_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE;

Line 128: -- then parse the wf_notifications.context field to

124: FETCH wf_item_cur INTO l_itemtype, l_itemkey;
125: CLOSE wf_item_cur;
126:
127: -- If the wf_item_activity_statuses does not contain an entry,
128: -- then parse the wf_notifications.context field to
129: -- get the item_type and item_key values for a given notification_id.
130: IF ((l_itemtype IS NULL) AND (l_itemkey IS NULL))
131: THEN
132: OPEN wf_notif_context_cur;