APPS.PON_AUCTION_APPROVAL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 58: from wf_item_activity_statuses_v

54: l_auction_approval_status = 'NOT_REQUIRED') then
55: begin
56: select activity_label
57: into l_activity_status
58: from wf_item_activity_statuses_v
59: where item_type = 'PONAPPRV'
60: and item_key = p_top_process_item_key
61: and activity_status_code = 'NOTIFIED';
62: exception when others then

Line 82: from wf_item_activity_statuses_v

78: begin
79: begin
80: select activity_label
81: into l_activity_status
82: from wf_item_activity_statuses_v
83: where item_type = 'PONAPPRV'
84: and item_key = p_top_process_item_key
85: and activity_status_code = 'NOTIFIED';
86: exception when others then

Line 139: from WF_ITEM_ACTIVITY_STATUSES

135: l_itemKey := l_parent_process_itemKey || '_' || l_user_id;
136: /* Select notification Id from the item key and user name */
137: select notification_id
138: into l_nid
139: from WF_ITEM_ACTIVITY_STATUSES
140: where ASSIGNED_USER = p_user_name
141: and ITEM_TYPE = l_itemType
142: and ITEM_KEY = l_itemkey
143: and activity_status ='NOTIFIED';

Line 192: from WF_ITEM_ACTIVITY_STATUSES

188: /* Select notification Id from the item key and user name */
189: begin
190: select notification_id
191: into l_nid
192: from WF_ITEM_ACTIVITY_STATUSES
193: where ASSIGNED_USER = p_user_name
194: and ITEM_TYPE = l_itemType
195: and ITEM_KEY = l_itemkey
196: and activity_status ='NOTIFIED';

Line 218: from wf_item_activity_statuses_v

214:
215: Procedure Close_Child_Process(p_parent_item_key Varchar2) is
216: Cursor List_of_Process(p_item_type varchar2, p_parent_item_key Varchar2) is
217: select activity_label, item_key,notification_id
218: from wf_item_activity_statuses_v
219: where item_type = p_item_type
220: and item_key like p_parent_item_key || '_%'
221: and activity_status_code = 'NOTIFIED';
222: l_item_type Varchar2(30) := 'PONAPPRV';