APPS.PON_WF_UTL_PKG dependencies on WF_NOTIFICATIONS

Line 343: -- in the wf_notifications table to fetch the item type and item key.

339: WHERE notification_id = p_ntf_id;
340:
341:
342: -- The following cursor is to parse the CONTEXT string
343: -- in the wf_notifications table to fetch the item type and item key.
344: -- The format for the context string is ITEMTYPE:ITEM_KEY:OTHER
345: -- For eg: The context PONAUCT:7136-1466:6566 will return
346: -- PONAUCT as ItemType, and 7136-1466 as ItemKey.
347: CURSOR wf_notif_context_cur IS

Line 352: FROM wf_notifications

348: SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
349: SUBSTR(context,INSTR(context,':')+1,
350: (INSTR(context,':',1,2) - INSTR(context,':')-1)),
351: message_name
352: FROM wf_notifications
353: WHERE notification_id = p_ntf_id;
354:
355: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
356: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)

Line 358: p_message_name wf_notifications.message_name%TYPE;

354:
355: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
356: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)
357:
358: p_message_name wf_notifications.message_name%TYPE;
359:
360: BEGIN
361: x_bid_number := -1;
362: x_site_id := -1;

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

369: FETCH wf_item_cur INTO p_itemtype, p_itemkey;
370: CLOSE wf_item_cur;
371:
372: -- If the wf_item_activity_statuses does not contain an entry,
373: -- then parse the wf_notifications.context field to
374: -- get the item_type and item_key values for a given notification_id.
375: IF ((p_itemtype IS NULL) AND (p_itemkey IS NULL))
376: THEN
377: OPEN wf_notif_context_cur;