APPS.PON_AUCTION_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 2734: from wf_item_activity_statuses_v

2730: --
2731: BEGIN
2732: select activity_label
2733: into x_current_activity
2734: from wf_item_activity_statuses_v
2735: where item_type = x_itemtype
2736: AND item_key = x_itemkey
2737: and activity_status_code = 'NOTIFIED';
2738: EXCEPTION WHEN no_data_found THEN

Line 2759: wf_item_activity_statuses_v act

2755:
2756: CURSOR bidder_list_wf_keys IS
2757: select pbp.wf_item_key wf_item_key, act.activity_label activity_label
2758: from pon_bidding_parties pbp,
2759: wf_item_activity_statuses_v act
2760: where pbp.auction_header_id = p_prev_doc_header_id and
2761: act.item_type = x_itemtype and
2762: act.item_key = pbp.wf_item_key and
2763: act.activity_status_code = 'NOTIFIED';

Line 4416: from wf_item_activity_statuses_v

4412: --
4413: BEGIN
4414: select activity_label
4415: into x_current_activity
4416: from wf_item_activity_statuses_v
4417: where item_type = x_itemtype
4418: AND item_key = x_itemkey
4419: and activity_status_code = 'NOTIFIED';
4420: EXCEPTION WHEN no_data_found THEN

Line 5198: from wf_item_activity_statuses_v

5194: --
5195: BEGIN
5196: select activity_label
5197: into x_current_activity
5198: from wf_item_activity_statuses_v
5199: where item_type = x_itemtype
5200: AND item_key = x_itemkey
5201: and activity_status_code = 'NOTIFIED';
5202: EXCEPTION WHEN no_data_found THEN

Line 5364: from wf_item_activity_statuses_v

5360: --
5361: BEGIN
5362: select activity_label
5363: into x_current_activity
5364: from wf_item_activity_statuses_v
5365: where item_type = x_itemtype
5366: AND item_key = x_itemkey
5367: and activity_status_code = 'NOTIFIED';
5368: EXCEPTION WHEN no_data_found THEN

Line 5476: from wf_item_activity_statuses_v

5472: --
5473: BEGIN
5474: select activity_label
5475: into x_current_activity
5476: from wf_item_activity_statuses_v
5477: where item_type = x_itemtype
5478: AND item_key = x_itemkey
5479: and activity_status_code = 'NOTIFIED';
5480: EXCEPTION WHEN no_data_found THEN

Line 9232: l_activity_status wf_item_activity_statuses.ACTIVITY_STATUS%type;

9228: is
9229:
9230: l_supp_ack varchar2(10);
9231: l_notification_id number;
9232: l_activity_status wf_item_activity_statuses.ACTIVITY_STATUS%type;
9233:
9234: begin
9235:
9236: BEGIN

Line 9240: from wf_item_activity_statuses

9236: BEGIN
9237:
9238: select notification_id, ACTIVITY_STATUS
9239: into l_notification_id, l_activity_status
9240: from wf_item_activity_statuses
9241: where item_key = p_wf_item_key
9242: and item_type = 'PONPBLSH'
9243: and notification_id is not null
9244: and activity_status = 'NOTIFIED'