APPS.PON_WF_UTL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 333: FROM wf_item_activity_statuses

329: x_neg_deleted OUT NOCOPY VARCHAR2) is
330: CURSOR wf_item_cur IS
331: SELECT item_type,
332: item_key
333: FROM wf_item_activity_statuses
334: WHERE notification_id = p_ntf_id;
335:
336:
337: -- The following cursor is to parse the CONTEXT string

Line 350: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)

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)
352:
353: p_message_name wf_notifications.message_name%TYPE;
354:

Line 351: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)

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)
352:
353: p_message_name wf_notifications.message_name%TYPE;
354:
355: BEGIN

Line 362: -- wf_item_activity_statuses for a given notification_id.

358: x_request_id := -1;
359: x_DocumentNumber :='NOTSPECIFIED';
360:
361: -- Fetch the item_type and item_key values from
362: -- wf_item_activity_statuses for a given notification_id.
363: OPEN wf_item_cur;
364: FETCH wf_item_cur INTO p_itemtype, p_itemkey;
365: CLOSE wf_item_cur;
366:

Line 367: -- If the wf_item_activity_statuses does not contain an entry,

363: OPEN wf_item_cur;
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