APPS.PON_AUCTION_APPROVAL_PKG dependencies on WF_NOTIFICATIONS

Line 88: FROM wf_notifications

84: SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
85: SUBSTR(context,INSTR(context,':')+1,
86: (INSTR(context,':',1,2) - INSTR(context,':')-1)),
87: message_name
88: FROM wf_notifications
89: WHERE notification_id = pn_notification_id;
90:
91: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
92: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)

Line 94: p_message_name wf_notifications.message_name%TYPE;

90:
91: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
92: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)
93:
94: p_message_name wf_notifications.message_name%TYPE;
95:
96: BEGIN
97:
98:

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

102: FETCH wf_item_cur INTO p_itemtype, p_itemkey;
103: CLOSE wf_item_cur;
104:
105: -- If the wf_item_activity_statuses does not contain an entry,
106: -- then parse the wf_notifications.context field to
107: -- get the item_type and item_key values for a given notification_id.
108: IF ((p_itemtype IS NULL) AND (p_itemkey IS NULL))
109: THEN
110: OPEN wf_notif_context_cur;