APPS.PON_AUCTION_APPROVAL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 81: FROM wf_item_activity_statuses

77:
78: CURSOR wf_item_cur IS
79: SELECT item_type,
80: item_key
81: FROM wf_item_activity_statuses
82: WHERE notification_id = pn_notification_id;
83: CURSOR wf_notif_context_cur IS
84: SELECT SUBSTR(context,1,INSTR(context,':',1)-1),
85: SUBSTR(context,INSTR(context,':')+1,

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

87: message_name
88: FROM wf_notifications
89: WHERE notification_id = pn_notification_id;
90:
91: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
92: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)
93:
94: p_message_name wf_notifications.message_name%TYPE;
95:

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

88: FROM wf_notifications
89: WHERE notification_id = pn_notification_id;
90:
91: p_itemtype WF_ITEM_ACTIVITY_STATUSES.item_type%TYPE; -- VARCHAR2(8)
92: p_itemkey WF_ITEM_ACTIVITY_STATUSES.item_key%TYPE; -- VARCHAR2(240)
93:
94: p_message_name wf_notifications.message_name%TYPE;
95:
96: BEGIN

Line 100: -- wf_item_activity_statuses for a given notification_id.

96: BEGIN
97:
98:
99: -- Fetch the item_type and item_key values from
100: -- wf_item_activity_statuses for a given notification_id.
101: OPEN wf_item_cur;
102: FETCH wf_item_cur INTO p_itemtype, p_itemkey;
103: CLOSE wf_item_cur;
104:

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

101: OPEN wf_item_cur;
102: FETCH wf_item_cur INTO p_itemtype, p_itemkey;
103: CLOSE wf_item_cur;
104:
105: -- If the wf_item_activity_statuses does not contain an entry,
106: -- then parse the wf_notifications.context field to
107: -- get the item_type and item_key values for a given notification_id.
108: IF ((p_itemtype IS NULL) AND (p_itemkey IS NULL))
109: THEN

Line 160: from wf_item_activity_statuses_v

156: l_auction_approval_status = 'NOT_REQUIRED') then
157: begin
158: select activity_label
159: into l_activity_status
160: from wf_item_activity_statuses_v
161: where item_type = 'PONAPPRV'
162: and item_key = p_top_process_item_key
163: and activity_status_code = 'NOTIFIED';
164: exception when others then

Line 208: from wf_item_activity_statuses_v

204: begin
205: begin
206: select activity_label
207: into l_activity_status
208: from wf_item_activity_statuses_v
209: where item_type = 'PONAPPRV'
210: and item_key = p_top_process_item_key
211: and activity_status_code = 'NOTIFIED';
212: exception when others then

Line 265: from WF_ITEM_ACTIVITY_STATUSES

261: l_itemKey := l_parent_process_itemKey || '_' || l_user_id;
262: /* Select notification Id from the item key and user name */
263: select notification_id
264: into l_nid
265: from WF_ITEM_ACTIVITY_STATUSES
266: where ASSIGNED_USER = p_user_name
267: and ITEM_TYPE = l_itemType
268: and ITEM_KEY = l_itemkey
269: and activity_status ='NOTIFIED';

Line 324: from WF_ITEM_ACTIVITY_STATUSES

320: /* Select notification Id from the item key and user name */
321: begin
322: select notification_id
323: into l_nid
324: from WF_ITEM_ACTIVITY_STATUSES
325: where ASSIGNED_USER = p_user_name
326: and ITEM_TYPE = l_itemType
327: and ITEM_KEY = l_itemkey
328: and activity_status ='NOTIFIED';

Line 364: from wf_item_activity_statuses_v

360:
361: Procedure Close_Child_Process(p_parent_item_key Varchar2) is
362: Cursor List_of_Process(p_item_type varchar2, p_parent_item_key Varchar2) is
363: select activity_label, item_key,notification_id
364: from wf_item_activity_statuses_v
365: where item_type = p_item_type
366: and item_key like p_parent_item_key || '_%'
367: and activity_status_code = 'NOTIFIED';
368: l_item_type Varchar2(30) := 'PONAPPRV';