APPS.PON_WF_UTL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 338: FROM wf_item_activity_statuses

334: x_neg_deleted OUT NOCOPY VARCHAR2) is
335: CURSOR wf_item_cur IS
336: SELECT item_type,
337: item_key
338: FROM wf_item_activity_statuses
339: WHERE notification_id = p_ntf_id;
340:
341:
342: -- The following cursor is to parse the CONTEXT string

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

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)
357:
358: p_message_name wf_notifications.message_name%TYPE;
359:

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

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)
357:
358: p_message_name wf_notifications.message_name%TYPE;
359:
360: BEGIN

Line 367: -- wf_item_activity_statuses for a given notification_id.

363: x_request_id := -1;
364: x_DocumentNumber :='NOTSPECIFIED';
365:
366: -- Fetch the item_type and item_key values from
367: -- wf_item_activity_statuses for a given notification_id.
368: OPEN wf_item_cur;
369: FETCH wf_item_cur INTO p_itemtype, p_itemkey;
370: CLOSE wf_item_cur;
371:

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

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