APPS.POS_URL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 106: FROM wf_item_activity_statuses

102: IS
103: CURSOR wf_item_cur IS
104: SELECT item_type,
105: item_key
106: FROM wf_item_activity_statuses
107: WHERE notification_id = p_ntf_id;
108:
109: CURSOR wf_notif_context_cur IS
110: SELECT SUBSTR(context,1,INSTR(context,':',1)-1),

Line 116: l_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE;

112: (INSTR(context,':',1,2) - INSTR(context,':')-1))
113: FROM wf_notifications
114: WHERE notification_id = p_ntf_id;
115:
116: l_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE;
117: l_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE;
118:
119: BEGIN
120:

Line 117: l_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE;

113: FROM wf_notifications
114: WHERE notification_id = p_ntf_id;
115:
116: l_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE;
117: l_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE;
118:
119: BEGIN
120:
121: -- Fetch the item_type and item_key values from

Line 122: -- wf_item_activity_statuses for a given notification_id.

118:
119: BEGIN
120:
121: -- Fetch the item_type and item_key values from
122: -- wf_item_activity_statuses for a given notification_id.
123: OPEN wf_item_cur;
124: FETCH wf_item_cur INTO l_itemtype, l_itemkey;
125: CLOSE wf_item_cur;
126:

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

123: OPEN wf_item_cur;
124: FETCH wf_item_cur INTO l_itemtype, l_itemkey;
125: CLOSE wf_item_cur;
126:
127: -- If the wf_item_activity_statuses does not contain an entry,
128: -- then parse the wf_notifications.context field to
129: -- get the item_type and item_key values for a given notification_id.
130: IF ((l_itemtype IS NULL) AND (l_itemkey IS NULL))
131: THEN