DBA Data[Home] [Help]

APPS.PON_AUCTION_APPROVAL_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES_V

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 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';