APPS.PON_WF_UTL_PKG dependencies on WF_NOTIFICATIONS

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

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

Line 347: FROM wf_notifications

343: SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
344: SUBSTR(context,INSTR(context,':')+1,
345: (INSTR(context,':',1,2) - INSTR(context,':')-1)),
346: message_name
347: FROM wf_notifications
348: WHERE notification_id = p_ntf_id;
349:
350: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
351: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)

Line 353: p_message_name wf_notifications.message_name%TYPE;

349:
350: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
351: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)
352:
353: p_message_name wf_notifications.message_name%TYPE;
354:
355: BEGIN
356: x_bid_number := -1;
357: x_site_id := -1;

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

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