eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 3244: from wf_item_activity_statuses_v

3240: --
3241: BEGIN
3242: select activity_label
3243: into x_current_activity
3244: from wf_item_activity_statuses_v
3245: where item_type = x_itemtype
3246: AND item_key = x_itemkey
3247: and activity_status_code = 'NOTIFIED';
3248: EXCEPTION WHEN no_data_found THEN

Line 3269: wf_item_activity_statuses_v act

3265:
3266: CURSOR bidder_list_wf_keys IS
3267: select pbp.wf_item_key wf_item_key, act.activity_label activity_label
3268: from pon_bidding_parties pbp,
3269: wf_item_activity_statuses_v act
3270: where pbp.auction_header_id = p_prev_doc_header_id and
3271: act.item_type = x_itemtype and
3272: act.item_key = pbp.wf_item_key and
3273: act.activity_status_code = 'NOTIFIED';

Line 5011: from wf_item_activity_statuses_v

5007: --
5008: BEGIN
5009: select activity_label
5010: into x_current_activity
5011: from wf_item_activity_statuses_v
5012: where item_type = x_itemtype
5013: AND item_key = x_itemkey
5014: and activity_status_code = 'NOTIFIED';
5015: EXCEPTION WHEN no_data_found THEN

Line 5794: from wf_item_activity_statuses_v

5790: --
5791: BEGIN
5792: select activity_label
5793: into x_current_activity
5794: from wf_item_activity_statuses_v
5795: where item_type = x_itemtype
5796: AND item_key = x_itemkey
5797: and activity_status_code = 'NOTIFIED';
5798: EXCEPTION WHEN no_data_found THEN

Line 5960: from wf_item_activity_statuses_v

5956: --
5957: BEGIN
5958: select activity_label
5959: into x_current_activity
5960: from wf_item_activity_statuses_v
5961: where item_type = x_itemtype
5962: AND item_key = x_itemkey
5963: and activity_status_code = 'NOTIFIED';
5964: EXCEPTION WHEN no_data_found THEN

Line 6072: from wf_item_activity_statuses_v

6068: --
6069: BEGIN
6070: select activity_label
6071: into x_current_activity
6072: from wf_item_activity_statuses_v
6073: where item_type = x_itemtype
6074: AND item_key = x_itemkey
6075: and activity_status_code = 'NOTIFIED';
6076: EXCEPTION WHEN no_data_found THEN

Line 10068: l_activity_status wf_item_activity_statuses.ACTIVITY_STATUS%type;

10064: is
10065:
10066: l_supp_ack varchar2(10);
10067: l_notification_id number;
10068: l_activity_status wf_item_activity_statuses.ACTIVITY_STATUS%type;
10069:
10070: begin
10071:
10072: BEGIN

Line 10076: from wf_item_activity_statuses

10072: BEGIN
10073:
10074: select notification_id, ACTIVITY_STATUS
10075: into l_notification_id, l_activity_status
10076: from wf_item_activity_statuses
10077: where item_key = p_wf_item_key
10078: and item_type = 'PONPBLSH'
10079: and notification_id is not null
10080: and activity_status = 'NOTIFIED'

Line 15065: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

15061: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
15062: x_disqualify_date_format:= to_char(x_disqualify_date,'Month dd, yyyy hh:mi am');
15063:
15064: --Added for Bug 10388725
15065: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15066: Begin
15067: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15068: AND ITEM_KEY=l_item_key
15069: AND ASSIGNED_USER IS NOT NULL

Line 15067: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

15063:
15064: --Added for Bug 10388725
15065: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15066: Begin
15067: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15068: AND ITEM_KEY=l_item_key
15069: AND ASSIGNED_USER IS NOT NULL
15070: AND ROWNUM<=1;
15071: EXCEPTION

Line 15436: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

15432: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
15433: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
15434: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
15435: --Added for Bug 10388725
15436: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15437: Begin
15438: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15439: AND ITEM_KEY=l_item_key
15440: AND ASSIGNED_USER IS NOT NULL

Line 15438: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

15434: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
15435: --Added for Bug 10388725
15436: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15437: Begin
15438: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15439: AND ITEM_KEY=l_item_key
15440: AND ASSIGNED_USER IS NOT NULL
15441: AND ROWNUM<=1;
15442: EXCEPTION

Line 15651: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

15647: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
15648: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
15649: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
15650: --Added for Bug 10388725
15651: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15652: Begin
15653: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15654: AND ITEM_KEY=l_item_key
15655: AND ASSIGNED_USER IS NOT NULL

Line 15653: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

15649: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
15650: --Added for Bug 10388725
15651: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15652: Begin
15653: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15654: AND ITEM_KEY=l_item_key
15655: AND ASSIGNED_USER IS NOT NULL
15656: AND ROWNUM<=1;
15657: EXCEPTION

Line 15872: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

15868: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
15869: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
15870: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
15871: --Added for Bug 10388725
15872: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15873: Begin
15874: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15875: AND ITEM_KEY=l_item_key
15876: AND ASSIGNED_USER IS NOT NULL

Line 15874: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

15870: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
15871: --Added for Bug 10388725
15872: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
15873: Begin
15874: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
15875: AND ITEM_KEY=l_item_key
15876: AND ASSIGNED_USER IS NOT NULL
15877: AND ROWNUM<=1;
15878: EXCEPTION

Line 16089: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

16085: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
16086: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
16087: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
16088: --Added for Bug 10388725
16089: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16090: Begin
16091: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16092: AND ITEM_KEY=l_item_key
16093: AND ASSIGNED_USER IS NOT NULL

Line 16091: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

16087: x_award_date_format := to_char(x_award_date,'Month dd, yyyy hh:mi am');
16088: --Added for Bug 10388725
16089: --Replacing &#NID in the Response Details URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16090: Begin
16091: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16092: AND ITEM_KEY=l_item_key
16093: AND ASSIGNED_USER IS NOT NULL
16094: AND ROWNUM<=1;
16095: EXCEPTION

Line 16261: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

16257:
16258: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
16259: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
16260: --Added for Bug 8664757
16261: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16262: Begin
16263: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16264: AND ITEM_KEY=l_item_key
16265: AND ASSIGNED_USER IS NOT NULL

Line 16263: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

16259: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
16260: --Added for Bug 8664757
16261: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16262: Begin
16263: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16264: AND ITEM_KEY=l_item_key
16265: AND ASSIGNED_USER IS NOT NULL
16266: AND ROWNUM<=1;
16267: EXCEPTION

Line 16461: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

16457: itemkey => l_item_key,
16458: aname => 'ISP_NEW_SUPPLIER_REG_URL');
16459: -- End Bug 9309785
16460: --Added for Bug 8664757
16461: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16462: Begin
16463: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16464: AND ITEM_KEY=l_item_key
16465: AND ASSIGNED_USER IS NOT NULL

Line 16463: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

16459: -- End Bug 9309785
16460: --Added for Bug 8664757
16461: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16462: Begin
16463: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16464: AND ITEM_KEY=l_item_key
16465: AND ASSIGNED_USER IS NOT NULL
16466: AND ROWNUM<=1;
16467: EXCEPTION

Line 16674: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

16670: x_preview_date_format := to_char(x_preview_date,'Month dd, yyyy hh:mi am');
16671: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
16672: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
16673: --Added for Bug 8664757
16674: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16675: Begin
16676: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16677: AND ITEM_KEY=l_item_key
16678: AND ASSIGNED_USER IS NOT NULL

Line 16676: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

16672: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
16673: --Added for Bug 8664757
16674: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16675: Begin
16676: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16677: AND ITEM_KEY=l_item_key
16678: AND ASSIGNED_USER IS NOT NULL
16679: AND ROWNUM<=1;
16680: EXCEPTION

Line 16867: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

16863: x_preview_date_format := to_char(x_preview_date,'Month dd, yyyy hh:mi am');
16864: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
16865: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
16866: --Added for Bug 8664757
16867: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16868: Begin
16869: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16870: AND ITEM_KEY=l_item_key
16871: AND ASSIGNED_USER IS NOT NULL

Line 16869: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

16865: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
16866: --Added for Bug 8664757
16867: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
16868: Begin
16869: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
16870: AND ITEM_KEY=l_item_key
16871: AND ASSIGNED_USER IS NOT NULL
16872: AND ROWNUM<=1;
16873: EXCEPTION

Line 17056: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

17052: x_preview_date_format := to_char(x_preview_date,'Month dd, yyyy hh:mi am');
17053: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
17054: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
17055: --Added for Bug 8664757
17056: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
17057: Begin
17058: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
17059: AND ITEM_KEY=l_item_key
17060: AND ASSIGNED_USER IS NOT NULL

Line 17058: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

17054: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
17055: --Added for Bug 8664757
17056: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
17057: Begin
17058: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
17059: AND ITEM_KEY=l_item_key
17060: AND ASSIGNED_USER IS NOT NULL
17061: AND ROWNUM<=1;
17062: EXCEPTION

Line 17250: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table

17246: x_preview_date_format := to_char(x_preview_date,'Month dd, yyyy hh:mi am');
17247: x_auction_start_date_format := to_char(x_auction_start_date,'Month dd, yyyy hh:mi am');
17248: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
17249: --Added for Bug 8664757
17250: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
17251: Begin
17252: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
17253: AND ITEM_KEY=l_item_key
17254: AND ASSIGNED_USER IS NOT NULL

Line 17252: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type

17248: x_auction_end_date_format := to_char(x_auction_end_date,'Month dd, yyyy hh:mi am');
17249: --Added for Bug 8664757
17250: --Replacing &#NID in the Negotiation URL with the actual Notification Id from WF_ITEM_ACTIVITY_STATUSES table
17251: Begin
17252: SELECT notification_id INTO x_notification_id from WF_ITEM_ACTIVITY_STATUSES WHERE ITEM_TYPE=l_item_type
17253: AND ITEM_KEY=l_item_key
17254: AND ASSIGNED_USER IS NOT NULL
17255: AND ROWNUM<=1;
17256: EXCEPTION