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 PON_AUCTION_HEADERS_ALL

Line 132: from pon_auction_headers_all

128: BEGIN
129: BEGIN
130: select has_items_flag
131: into x_has_items_flag
132: from pon_auction_headers_all
133: where auction_header_id = p_auction_number;
134: EXCEPTION
135: WHEN NO_DATA_FOUND THEN
136: x_has_items_flag := 'Y';

Line 210: x_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

206: x_isAmendment VARCHAR(1) := 'N';
207: x_auction_round_number NUMBER;
208: x_auction_header_id_encrypted varchar2(2000);
209: x_auction_header_id_orig_amend NUMBER;
210: x_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
211: x_preview_date DATE;
212: x_preview_date_notspec VARCHAR2(240);
213: l_origin_user_name FND_USER.USER_NAME%TYPE;
214:

Line 265: from pon_auction_headers_all

261: null rs_contact_email
262: from pon_bid_headers
263: where x_isAmendment = 'Y' and
264: auction_header_id in (select auction_header_id
265: from pon_auction_headers_all
266: where auction_header_id_orig_amend = (select auction_header_id_orig_amend
267: from pon_auction_headers_all
268: where auction_header_id = x_auction_header_id)) and
269: bid_status in ('ACTIVE', 'RESUBMISSION', 'DISQUALIFIED', 'DRAFT') and

Line 267: from pon_auction_headers_all

263: where x_isAmendment = 'Y' and
264: auction_header_id in (select auction_header_id
265: from pon_auction_headers_all
266: where auction_header_id_orig_amend = (select auction_header_id_orig_amend
267: from pon_auction_headers_all
268: where auction_header_id = x_auction_header_id)) and
269: bid_status in ('ACTIVE', 'RESUBMISSION', 'DISQUALIFIED', 'DRAFT') and
270: trading_partner_contact_id NOT IN
271: (SELECT nvl(trading_partner_contact_id, -1)

Line 281: from pon_auction_headers_all

277: select auction_header_id_orig_amend, nvl(amendment_number,0), nvl(auction_round_number, 1), auction_type,
278: event_id, event_title, trading_partner_id,
279: trading_partner_contact_id, original_close_bidding_date, trading_partner_contact_name,
280: staggered_closing_interval
281: from pon_auction_headers_all
282: where auction_header_id = x_auction_header_id;
283:
284: BEGIN
285:

Line 819: from pon_auction_headers_all

815: -- New messages for complete customization
816:
817: select document_number
818: into x_orig_document_number
819: from pon_auction_headers_all
820: where auction_header_id = x_auction_header_id_orig_amend;
821:
822:
823: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 955: FROM pon_auction_headers_all

951: -- determine whether new round or new amendment.
952: SELECT Decode(Nvl(auction_header_id_prev_round,0),0,'N','Y'),
953: Decode(Nvl(auction_header_id_prev_amend,0),0,'N','Y')
954: INTO x_new_round_flag, x_new_amend_flag
955: FROM pon_auction_headers_all
956: WHERE auction_header_id = x_auction_header_id;
957:
958: IF(x_new_round_flag = 'Y') THEN
959: x_refund_supplier_msg := getMessage('PON_EMD_REFUND_SUP_NEW_RND');

Line 966: FROM pon_auction_headers_all

962: END IF;
963:
964: SELECT sequence INTO x_supplier_sequence FROM pon_bidding_parties
965: WHERE auction_header_id = (SELECT Decode(Nvl(auction_header_id_prev_round,0),0,Nvl(auction_header_id_prev_amend,0),auction_header_id_prev_round)
966: FROM pon_auction_headers_all
967: WHERE auction_header_id = x_auction_header_id)
968: --x_auction_header_id_orig_amend
969: AND TRADING_PARTNER_ID = bidder.trading_partner_id
970: AND vendor_site_id = bidder.vendor_site_id;

Line 975: FROM pon_auction_headers_all

971:
972:
973: SELECT 'Y' INTO x_emd_received_flag FROM pon_emd_transactions
974: WHERE auction_header_id = (SELECT Decode(Nvl(auction_header_id_prev_round,0),0,Nvl(auction_header_id_prev_amend,0),auction_header_id_prev_round)
975: FROM pon_auction_headers_all
976: WHERE auction_header_id = x_auction_header_id)
977: AND SUPPLIER_SEQUENCE = x_supplier_sequence
978: AND STATUS_LOOKUP_CODE = 'RECEIVED';
979:

Line 1112: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;

1108: x_bid VARCHAR2(10);
1109: x_bid_caps VARCHAR2(10);
1110: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
1111: x_view_quote_url_supplier VARCHAR2(2000);
1112: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
1113: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1114: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
1115: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
1116: x_preview_date DATE;

Line 1113: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

1109: x_bid_caps VARCHAR2(10);
1110: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
1111: x_view_quote_url_supplier VARCHAR2(2000);
1112: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
1113: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
1114: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
1115: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
1116: x_preview_date DATE;
1117: x_preview_date_in_tz DATE;

Line 1119: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

1115: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
1116: x_preview_date DATE;
1117: x_preview_date_in_tz DATE;
1118: x_timezone1_disp VARCHAR2(240);
1119: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
1120: x_staggered_closing_interval NUMBER;
1121: x_staggered_close_note VARCHAR2(1000);
1122: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;
1123:

Line 1258: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;

1254: -- choli update for emd
1255: PROCEDURE email_emd_admins(p_auction_header_id IN NUMBER) IS
1256:
1257: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
1258: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;
1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;
1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;

Line 1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;

1255: PROCEDURE email_emd_admins(p_auction_header_id IN NUMBER) IS
1256:
1257: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
1258: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;
1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;
1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;
1263: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.document_number%TYPE;

Line 1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;

1256:
1257: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
1258: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;
1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;
1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;
1263: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.document_number%TYPE;
1264: x_auction_title PON_AUCTION_HEADERS_ALL.auction_title%TYPE;

Line 1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;

1258: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;
1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;
1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;
1263: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.document_number%TYPE;
1264: x_auction_title PON_AUCTION_HEADERS_ALL.auction_title%TYPE;
1265: CURSOR all_emdAdmins(p_auction_header_id NUMBER) IS
1266: select u.user_name,

Line 1263: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.document_number%TYPE;

1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;
1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;
1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;
1263: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.document_number%TYPE;
1264: x_auction_title PON_AUCTION_HEADERS_ALL.auction_title%TYPE;
1265: CURSOR all_emdAdmins(p_auction_header_id NUMBER) IS
1266: select u.user_name,
1267: a.trading_partner_name,

Line 1264: x_auction_title PON_AUCTION_HEADERS_ALL.auction_title%TYPE;

1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;
1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;
1263: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.document_number%TYPE;
1264: x_auction_title PON_AUCTION_HEADERS_ALL.auction_title%TYPE;
1265: CURSOR all_emdAdmins(p_auction_header_id NUMBER) IS
1266: select u.user_name,
1267: a.trading_partner_name,
1268: a.auction_title,

Line 1270: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u

1266: select u.user_name,
1267: a.trading_partner_name,
1268: a.auction_title,
1269: a.document_number, a.cancel_date, a.event_title, a.publish_date
1270: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u
1271: where b.menu_name = 'EMD_ADMIN'
1272: and b.approver_flag = 'Y'
1273: and a.auction_header_id = b.auction_header_id
1274: and u.user_id = b.user_id

Line 1411: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

1407: x_preview_date DATE;
1408: x_difference NUMBER;
1409:
1410: x_doctype_group_name VARCHAR2(60);
1411: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1412: x_neg_summary_url_buyer VARCHAR2(2000);
1413: x_net_changes_url_buyer VARCHAR2(2000);
1414: x_msg_suffix VARCHAR2(3);
1415:

Line 1421: x_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

1417:
1418: x_timezone_disp VARCHAR2(240);
1419: x_doctype_display_name VARCHAR2(10);
1420: x_notif_subject VARCHAR2(300);
1421: x_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
1422:
1423: x_timezone1 VARCHAR2(80); -- preview timezone
1424: x_newpreviewtime DATE;
1425: x_timezone1_disp VARCHAR2(240);

Line 1440: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt

1436: hz.person_first_name || ' ' || hz.person_last_name,
1437: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 7), 1, nvl(view_by_date, open_bidding_date)+3,
1438: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 1), 1, nvl(view_by_date, open_bidding_date) + 1,
1439: nvl(view_by_date, open_bidding_date) + 1/24)) reminder_time
1440: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt
1441: where hz.party_id = auh.trading_partner_contact_id
1442: and auh.doctype_id = dt.doctype_id
1443: and auction_header_id = p_auction_header_id;
1444: BEGIN

Line 1550: from pon_auction_headers_all where auction_header_id = p_auction_header_id;

1546:
1547:
1548: select nvl(view_by_date,open_bidding_date)
1549: into x_notification_date
1550: from pon_auction_headers_all where auction_header_id = p_auction_header_id;
1551:
1552: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
1553: itemkey => x_itemkey,
1554: aname => 'AUCTION_NOTIFICATION_DATE',

Line 1615: from pon_auction_headers_all where auction_header_id = p_auction_header_id;

1611: -- 000001
1612:
1613: select view_by_date
1614: into x_preview_date
1615: from pon_auction_headers_all where auction_header_id = p_auction_header_id;
1616:
1617: if ((x_preview_date is not null) AND (p_open_bidding_date is not null)) then
1618: x_difference := p_open_bidding_date - x_preview_date;
1619: else

Line 1791: from pon_auction_headers_all

1787:
1788:
1789: select document_number
1790: into x_orig_document_number
1791: from pon_auction_headers_all
1792: where auction_header_id = x_auction_header_id_orig_amend;
1793:
1794:
1795: --- 000001

Line 1866: UPDATE pon_auction_headers_all set

1862: wf_engine.StartProcess(itemtype => x_itemtype,
1863: itemkey => x_itemkey );
1864:
1865:
1866: UPDATE pon_auction_headers_all set
1867: wf_item_key = x_itemkey,
1868: reminder_date = x_reminder_date
1869: WHERE auction_header_id = p_auction_header_id;
1870:

Line 2064: p_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

2060: x_startdate DATE;
2061: x_enddate DATE;
2062: x_doctype_group_name VARCHAR2(60);
2063: x_msg_suffix VARCHAR2(3) := '';
2064: p_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2065: p_view_quote_url VARCHAR2(2000);
2066: x_auction_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2067: p_bid_name VARCHAR2(2000); --Bug15903246 - changing the variable length same as MESSAGE_TEXT in FND_NEW_MESSAGES
2068: x_bidder_contact_id NUMBER;

Line 2066: x_auction_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

2062: x_doctype_group_name VARCHAR2(60);
2063: x_msg_suffix VARCHAR2(3) := '';
2064: p_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2065: p_view_quote_url VARCHAR2(2000);
2066: x_auction_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2067: p_bid_name VARCHAR2(2000); --Bug15903246 - changing the variable length same as MESSAGE_TEXT in FND_NEW_MESSAGES
2068: x_bidder_contact_id NUMBER;
2069: x_auctioneer_contact_id NUMBER;
2070: x_oex_timezone VARCHAR2(80);

Line 2085: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

2081: x_newstarttime1 VARCHAR2(80);
2082: p_view_quote_url_supplier VARCHAR2(2000);
2083: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2084: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2085: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
2086: x_preview_date DATE;
2087: x_preview_date_in_tz DATE;
2088: x_timezone1_disp VARCHAR2(240);
2089:

Line 2104: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

2100: nvl(substr(bhz.attribute2,0,3),''),
2101: bhz.person_first_name || ' ' || bhz.person_last_name,
2102: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2103: ah.view_by_date, ah.staggered_closing_interval
2104: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2105: where bhz.party_id = bih.trading_partner_contact_id
2106: and bih.bid_number = p_bid_id
2107: and ah.auction_header_id = bih.auction_header_id
2108: and ah.doctype_id = dt.doctype_id;

Line 2276: from pon_auction_headers_all

2272: --
2273:
2274: select open_bidding_date, close_bidding_date, trading_partner_contact_name
2275: into x_startdate, x_enddate, x_auction_tp_contact_name
2276: from pon_auction_headers_all
2277: where auction_header_id = p_auction_header_id;
2278:
2279: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2280: itemkey => x_itemkey,

Line 2341: from pon_auction_headers_all

2337: --
2338:
2339: select wf_role_name, decode(bid_visibility_code,'OPEN_BIDDING','N','SEALED_BIDDING','Y','N')
2340: into x_role_name, x_sealed_flag
2341: from pon_auction_headers_all
2342: where auction_header_id = p_auction_header_id;
2343:
2344: --
2345: -- Set the attributes

Line 2643: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

2639: x_newendtime DATE;
2640: x_newawardtime DATE;
2641: x_doctype_group_name VARCHAR2(60);
2642: x_msg_suffix VARCHAR2(3) := '';
2643: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2644: x_auction_round_number NUMBER;
2645: x_doctype_id_value NUMBER;
2646: x_oex_timezone VARCHAR2(80);
2647: x_bidder_contact_id NUMBER;

Line 2653: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;

2649: x_bid VARCHAR2(10);
2650: x_bid_caps VARCHAR2(10);
2651: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
2652: x_view_quote_url_supplier VARCHAR2(2000);
2653: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2654: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2655: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2656: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2657: x_preview_date DATE;

Line 2654: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

2650: x_bid_caps VARCHAR2(10);
2651: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
2652: x_view_quote_url_supplier VARCHAR2(2000);
2653: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
2654: x_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2655: x_tp_display_name PON_BID_HEADERS.TRADING_PARTNER_NAME%TYPE;
2656: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2657: x_preview_date DATE;
2658: x_preview_date_in_tz DATE;

Line 2660: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;

2656: x_tp_address_name PON_BID_HEADERS.VENDOR_SITE_CODE%TYPE;
2657: x_preview_date DATE;
2658: x_preview_date_in_tz DATE;
2659: x_timezone1_disp VARCHAR2(240);
2660: x_has_items_flag PON_AUCTION_HEADERS_ALL.HAS_ITEMS_FLAG%TYPE;
2661: x_staggered_closing_interval NUMBER;
2662: x_staggered_close_note VARCHAR2(1000);
2663: x_bid_award_status PON_BID_HEADERS.AWARD_STATUS%TYPE;
2664:

Line 2674: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

2670: ah.document_number, dt.doctype_group_name, dt.doctype_id,
2671: bhz.person_first_name || ' ' || bhz.person_last_name, ah.trading_partner_contact_name,
2672: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2673: view_by_date, nvl(ah.has_items_flag, 'Y'), ah.staggered_closing_interval,bih.award_status
2674: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2675: where bhz.party_id = bih.trading_partner_contact_id
2676: and bih.bid_number = p_bid_id
2677: and ah.auction_header_id = bih.auction_header_id
2678: and ah.doctype_id = dt.doctype_id;

Line 2933: from pon_auction_headers_all

2929: avalue => x_auction_type_name);
2930:
2931: select open_bidding_date, close_bidding_date, award_date, event_id
2932: into x_auction_open_bidding_date, x_auction_close_bidding_date, x_award_date, x_event_id
2933: from pon_auction_headers_all
2934: where auction_header_id = p_auction_header_id;
2935:
2936: wf_engine.SetItemAttrDate (itemtype => x_itemtype,
2937: itemkey => x_itemkey,

Line 3190: from pon_auction_headers_all

3186: aname => 'AUCTION_ID');
3187:
3188: begin
3189: select wf_item_key into x_itemkey
3190: from pon_auction_headers_all
3191: where auction_header_id = (select auction_header_id_prev_round
3192: from pon_auction_headers_all where auction_header_id = x_doc_header_id);
3193:
3194: wf_engine.completeActivity('PONAUCT', x_itemkey, 'WAIT_FOR_AUCTION_COMPLETE', 'PREPARER_COMPLETE');

Line 3192: from pon_auction_headers_all where auction_header_id = x_doc_header_id);

3188: begin
3189: select wf_item_key into x_itemkey
3190: from pon_auction_headers_all
3191: where auction_header_id = (select auction_header_id_prev_round
3192: from pon_auction_headers_all where auction_header_id = x_doc_header_id);
3193:
3194: wf_engine.completeActivity('PONAUCT', x_itemkey, 'WAIT_FOR_AUCTION_COMPLETE', 'PREPARER_COMPLETE');
3195:
3196: exception

Line 3224: from pon_auction_headers_all

3220: begin
3221:
3222: select auction_header_id_prev_amend
3223: into x_prev_doc_header_id
3224: from pon_auction_headers_all
3225: where auction_header_id = x_doc_header_id;
3226:
3227: select wf_item_key, nvl(amendment_number, 0)
3228: into x_itemkey, x_prev_doc_amendment_number

Line 3229: from pon_auction_headers_all

3225: where auction_header_id = x_doc_header_id;
3226:
3227: select wf_item_key, nvl(amendment_number, 0)
3228: into x_itemkey, x_prev_doc_amendment_number
3229: from pon_auction_headers_all
3230: where auction_header_id = x_prev_doc_header_id;
3231:
3232: -- need to complete first round supplier notifications (might be waiting on ack response)
3233: if (x_prev_doc_amendment_number = 0) then

Line 3708: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

3704: x_auction_contact_id NUMBER;
3705: x_person_party_id NUMBER;
3706: x_language VARCHAR2(60) := null;
3707: x_territory_code VARCHAR2(30) := 'AMERICA';
3708: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3709: x_startdate DATE;
3710: x_enddate DATE;
3711: x_auctioneer_user_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
3712: x_add_contact_email PON_BIDDING_PARTIES.ADDITIONAL_CONTACT_EMAIL%TYPE;

Line 3711: x_auctioneer_user_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

3707: x_territory_code VARCHAR2(30) := 'AMERICA';
3708: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3709: x_startdate DATE;
3710: x_enddate DATE;
3711: x_auctioneer_user_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
3712: x_add_contact_email PON_BIDDING_PARTIES.ADDITIONAL_CONTACT_EMAIL%TYPE;
3713: x_preview_date DATE;
3714: x_preview_date_notspec VARCHAR2(240);
3715: x_timezone1_disp VARCHAR2(240);

Line 3772: from pon_auction_headers_all where auction_header_id = x_doc_header_id;

3768: select auction_header_id_prev_round, trading_partner_contact_name,
3769: staggered_closing_interval
3770: into x_doc_header_id_prev_round, x_auctioneer_user_name,
3771: x_staggered_closing_interval
3772: from pon_auction_headers_all where auction_header_id = x_doc_header_id;
3773:
3774: select wf_role_name
3775: into x_role_name
3776: from pon_auction_headers_all

Line 3776: from pon_auction_headers_all

3772: from pon_auction_headers_all where auction_header_id = x_doc_header_id;
3773:
3774: select wf_role_name
3775: into x_role_name
3776: from pon_auction_headers_all
3777: where auction_header_id = x_doc_header_id_prev_round;
3778:
3779: FOR prevBidder IN c_prev_round_bidders(x_doc_header_id_prev_round, x_role_name) LOOP
3780:

Line 4231: UPDATE pon_auction_headers_all set

4227: null,
4228: 'ACTIVE',
4229: null);
4230:
4231: UPDATE pon_auction_headers_all set
4232: wf_role_name = x_role_name
4233: WHERE auction_header_id = x_auction_header_id;
4234:
4235: wf_engine.SetItemAttrText (itemtype => itemtype,

Line 4275: from pon_auction_headers_all

4271: x_progress := '20';
4272:
4273: select wf_role_name
4274: into x_prev_doc_role_name
4275: from pon_auction_headers_all
4276: where auction_header_id = (select auction_header_id_prev_amend
4277: from pon_auction_headers_all
4278: where auction_header_id = x_auction_header_id);
4279:

Line 4277: from pon_auction_headers_all

4273: select wf_role_name
4274: into x_prev_doc_role_name
4275: from pon_auction_headers_all
4276: where auction_header_id = (select auction_header_id_prev_amend
4277: from pon_auction_headers_all
4278: where auction_header_id = x_auction_header_id);
4279:
4280:
4281: x_progress := '30';

Line 4360: from pon_auction_headers_all

4356:
4357: CURSOR c_user_name IS
4358: select user_name
4359: from fnd_user where person_party_id = (select trading_partner_contact_id
4360: from pon_auction_headers_all
4361: where auction_header_id = x_auction_header_id)
4362: and nvl(end_date,sysdate+1) > sysdate
4363: and rownum = 1;
4364:

Line 4826: from pon_auction_headers_all

4822: x_progress := '010';
4823:
4824: select wf_role_name
4825: into x_role_name
4826: from pon_auction_headers_all
4827: where auction_header_id = p_auction_header_id;
4828:
4829: BEGIN
4830: select user_name

Line 4985: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;

4981: x_itemkey VARCHAR2(30);
4982: x_notification_date DATE;
4983: x_now DATE;
4984: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
4985: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
4986: x_current_activity VARCHAR2(30);
4987:
4988:
4989: BEGIN

Line 5000: from pon_auction_headers_all

4996: x_now := SYSDATE;
4997:
4998: select wf_item_key, sysdate, cancel_date
4999: into x_itemkey, x_now, x_cancel_date
5000: from pon_auction_headers_all
5001: where auction_header_id = p_auction_header_id;
5002:
5003:
5004: --

Line 5081: from pon_auction_headers_all pah

5077:
5078:
5079: select pah.close_bidding_date
5080: into v_end_date
5081: from pon_auction_headers_all pah
5082: where pah.auction_header_id = p_auction_header_id;
5083:
5084: RETURN v_end_date;
5085:

Line 5111: from pon_auction_headers_all pah

5107: nvl(amendment_number,0)
5108: into v_auction_status, v_creation_date, v_end_date, v_is_paused, v_last_pause_date
5109: , v_auction_header_id_orig_round, v_auction_round_number,
5110: v_amendment_number
5111: from pon_auction_headers_all pah
5112: where pah.auction_header_id = p_auction_header_id;
5113:
5114: RETURN TIME_REMAINING_ORDER( v_auction_status, v_creation_date , v_end_date, v_is_paused, v_last_pause_date, v_auction_header_id_orig_round, v_auction_round_number, v_amendment_number );
5115:

Line 5233: from pon_auction_headers_all

5229: IF (p_line_number is null) THEN
5230:
5231: select auction_status, open_bidding_date, close_bidding_date, nvl( last_pause_date, sysdate ), nvl( is_paused, 'N' ), staggered_closing_interval
5232: into v_auction_status, v_startdate, v_enddate, v_pausedate, v_ispaused, v_staggered_closing_interval
5233: from pon_auction_headers_all
5234: where auction_header_id = p_auction_header_id;
5235:
5236: ELSE
5237:

Line 5241: from pon_auction_headers_all pah, pon_auction_item_prices_all paip

5237:
5238: select pah.auction_status, pah.open_bidding_date, nvl(paip.close_bidding_date, pah.close_bidding_date),
5239: nvl( pah.last_pause_date, sysdate ), nvl( pah.is_paused, 'N' )
5240: into v_auction_status, v_startdate, v_enddate, v_pausedate, v_ispaused
5241: from pon_auction_headers_all pah, pon_auction_item_prices_all paip
5242: where pah.auction_header_id = p_auction_header_id and
5243: paip.auction_header_id = pah.auction_header_id and
5244: paip.line_number = p_line_number;
5245:

Line 5512: update pon_auction_headers_all

5508: aname => 'AUCTION_ID');
5509:
5510: x_progress := '020';
5511:
5512: update pon_auction_headers_all
5513: set auction_status = 'OPEN_FOR_BIDDING',
5514: auction_status_name = (select meaning from fnd_lookups
5515: where lookup_type = 'PON_AUCTION_STATUS' and
5516: lookup_code = 'OPEN_FOR_BIDDING')

Line 5542: update pon_auction_headers_all

5538: aname => 'AUCTION_ID');
5539:
5540: x_progress := '020';
5541:
5542: update pon_auction_headers_all
5543: set auction_status = 'CLOSED_FOR_BIDDING',
5544: auction_status_name = (select meaning from fnd_lookups
5545: where lookup_type = 'PON_AUCTION_STATUS' and
5546: lookup_code = 'CLOSED_FOR_BIDDING')

Line 5673: from pon_auction_headers_all

5669: BEGIN
5670: BEGIN
5671: select 'Y'
5672: into x_flag
5673: from pon_auction_headers_all
5674: where auction_header_id = p_auction_number
5675: and event_id is not null;
5676: EXCEPTION
5677: WHEN NO_DATA_FOUND THEN

Line 5784: from pon_auction_headers_all

5780: -- can complete the workflow
5781: --
5782: select wf_item_key, sysdate
5783: into x_itemkey, x_now
5784: from pon_auction_headers_all
5785: where auction_header_id = p_auction_header_id;
5786:
5787: --
5788: -- First, see what activity (if any) the workflow is on

Line 5921: from pon_auction_headers_all

5917: -- can complete the workflow
5918: --
5919: select wf_item_key, trading_partner_contact_id
5920: into x_itemkey, x_contact_id
5921: from pon_auction_headers_all
5922: where auction_header_id = p_auction_header_id;
5923:
5924: BEGIN
5925: select user_name

Line 6034: from pon_auction_headers_all

6030: --
6031:
6032: select wf_item_key, trading_partner_contact_id
6033: into x_itemkey, x_contact_id
6034: from pon_auction_headers_all
6035: where auction_header_id = p_auction_header_id;
6036:
6037: BEGIN
6038: select user_name

Line 6134: from pon_auction_headers_all ah,pon_auction_events event

6130: BEGIN
6131: BEGIN
6132: select event.event_title
6133: into eventTitle
6134: from pon_auction_headers_all ah,pon_auction_events event
6135: where auction_header_id = p_auction_number
6136: and ah.event_id=event.event_id;
6137: EXCEPTION
6138: WHEN NO_DATA_FOUND THEN

Line 6636: x_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;

6632: x_profile_user VARCHAR2(240) := '';
6633: x_bidder_tp_name PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE;
6634: x_vendor_site_code PON_BIDDING_PARTIES.VENDOR_SITE_CODE%TYPE;
6635: x_vendor_site_id NUMBER;
6636: x_trading_partner_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
6637: x_wf_role_name varchar2(100) := '';
6638: x_language_code varchar2(30);
6639: x_message_name varchar2(80);
6640: x_doc_number_dsp varchar2(60);

Line 6641: x_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

6637: x_wf_role_name varchar2(100) := '';
6638: x_language_code varchar2(30);
6639: x_message_name varchar2(80);
6640: x_doc_number_dsp varchar2(60);
6641: x_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
6642: x_auction_start_date date;
6643: x_auction_end_date date;
6644: x_preview_date DATE;
6645: x_timezone VARCHAR2(80);

Line 6648: x_original_close_bidding_date PON_AUCTION_HEADERS_ALL.ORIGINAL_CLOSE_BIDDING_DATE%TYPE;

6644: x_preview_date DATE;
6645: x_timezone VARCHAR2(80);
6646: x_wf_item_key VARCHAR2(240);
6647: x_change_type number; -- extend: 1, shorten: 2
6648: x_original_close_bidding_date PON_AUCTION_HEADERS_ALL.ORIGINAL_CLOSE_BIDDING_DATE%TYPE;
6649: x_event_title varchar2(240) := '';
6650: x_event_id NUMBER;
6651: x_bad_bidder varchar2(80) := null;
6652: x_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE; -- Bug 3824928 added

Line 6652: x_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE; -- Bug 3824928 added

6648: x_original_close_bidding_date PON_AUCTION_HEADERS_ALL.ORIGINAL_CLOSE_BIDDING_DATE%TYPE;
6649: x_event_title varchar2(240) := '';
6650: x_event_id NUMBER;
6651: x_bad_bidder varchar2(80) := null;
6652: x_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE; -- Bug 3824928 added
6653: x_staggered_closing_interval NUMBER;
6654:
6655:
6656: CURSOR bidders IS

Line 6715: from pon_auction_headers_all

6711: select wf_role_name, wf_item_key, original_close_bidding_date, event_id, trading_partner_contact_name,
6712: staggered_closing_interval
6713: into x_wf_role_name, x_wf_item_key, x_original_close_bidding_date, x_event_id, x_tp_contact_name,
6714: x_staggered_closing_interval
6715: from pon_auction_headers_all
6716: where auction_header_id = x_doc_number;
6717: exception
6718: when others then
6719: x_wf_role_name := '';

Line 6936: from pon_auction_headers_all

6932:
6933: BEGIN
6934:
6935: select wf_item_key into p_itemkey
6936: from pon_auction_headers_all
6937: where auction_header_id = p_auction_id;
6938:
6939: x_progress := '010';
6940:

Line 6971: from pon_auction_headers_all auh, pon_auc_doctypes dt

6967: EXCEPTION
6968: WHEN OTHERS THEN
6969: select dt.doctype_group_name
6970: into x_doctype_group_name
6971: from pon_auction_headers_all auh, pon_auc_doctypes dt
6972: where auh.auction_header_id = x_auction_header_id
6973: and auh.doctype_id = dt.doctype_id;
6974: END;
6975:

Line 7034: from pon_auction_headers_all where auction_header_id = x_auction_header_id;

7030: aname => 'NOTE_TO_BIDDERS')));
7031:
7032: select view_by_date
7033: into x_preview_date
7034: from pon_auction_headers_all where auction_header_id = x_auction_header_id;
7035:
7036: x_auction_title := wf_engine.GetItemAttrText(itemtype => p_itemtype,
7037: itemkey => p_itemkey,
7038: aname => 'AUCTION_TITLE');

Line 7240: from pon_auction_headers_all

7236:
7237: CURSOR c1_auction_type IS
7238: select auction_type, event_id, event_title, open_bidding_date, trading_partner_id,
7239: staggered_closing_interval
7240: from pon_auction_headers_all
7241: where auction_header_id = x_auction_header_id;
7242:
7243: BEGIN
7244: x_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => x_itemtype,

Line 7256: from pon_auction_headers_all

7252: RETURN;
7253: END IF;
7254:
7255: select wf_item_key , trading_partner_contact_name into p_itemkey, x_auctioneer_user_name
7256: from pon_auction_headers_all
7257: where auction_header_id = x_auction_header_id;
7258:
7259: -- x_auctioneer_user_name := wf_engine.GetItemAttrText (itemtype => p_itemtype,
7260: -- itemkey => p_itemkey,

Line 7327: from pon_auction_headers_all

7323: close c1_auction_type;
7324:
7325:
7326: select wf_role_name, wf_item_key into x_role_name, p_itemkey
7327: from pon_auction_headers_all
7328: where auction_header_id = x_auction_header_id;
7329:
7330: x_oex_timezone := Get_Oex_Time_Zone;
7331:

Line 7886: from pon_auction_headers_all

7882: x_item_key VARCHAR2(240);
7883: BEGIN
7884:
7885: select wf_item_key into x_item_key
7886: from pon_auction_headers_all
7887: where auction_header_id = p_auction_header_id;
7888:
7889: wf_engine.SetItemAttrText (itemtype => 'PONAUCT',
7890: itemkey => x_item_key,

Line 8315: FROM pon_auction_headers_all

8311: aname => 'AUCTION_ID');
8312:
8313: SELECT close_bidding_date, reminder_date
8314: INTO x_closedate, x_reminderdate
8315: FROM pon_auction_headers_all
8316: WHERE auction_header_id=x_this_auction_header_id;
8317:
8318:
8319: IF (x_closedate

Line 8373: FROM pon_auction_headers_all

8369: aname => 'NOTE_TO_BUYER');
8370:
8371: SELECT close_bidding_date,auction_status
8372: INTO x_closedate, x_auction_status
8373: FROM pon_auction_headers_all
8374: WHERE auction_header_id=x_doc_number;
8375:
8376: x_now := SYSDATE;
8377:

Line 8444: FROM pon_auction_headers_all

8440: aname => 'NOTE_TO_BUYER');
8441:
8442: SELECT close_bidding_date,auction_status
8443: INTO x_closedate, x_auction_status
8444: FROM pon_auction_headers_all
8445: WHERE auction_header_id=x_doc_number;
8446:
8447: x_now := SYSDATE;
8448:

Line 9023: x_auction_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

9019: x_doc_number NUMBER;
9020: x_neg_summary_url_supplier VARCHAR2(2000);
9021: x_isp_supplier_register_url VARCHAR2(2000);
9022: x_ack_part_url_supplier VARCHAR2(2000);
9023: x_auction_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
9024: x_preview_date DATE;
9025: x_preview_date_notspec VARCHAR2(240);
9026: x_timezone1_disp VARCHAR2(240);
9027: -- Bug 3824928: Removed obsolete columns

Line 9065: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE := '';

9061: x_newendtime DATE;
9062: x_itemtype VARCHAR2(8) := 'PONPBLSH';
9063: x_itemkey VARCHAR2(50);
9064: x_sequence NUMBER;
9065: x_auction_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE := '';
9066: x_auction_contact_dp_name varchar2(240) := '';
9067: x_tp_display_name varchar2(240) :='';
9068: x_auction_title varchar2(240) := '';
9069: x_auction_start_date date;

Line 9171: FROM pon_auction_headers_all

9167:
9168: begin
9169: SELECT wf_item_key
9170: INTO x_wf_item_key
9171: FROM pon_auction_headers_all
9172: WHERE auction_header_id=x_doc_number;
9173:
9174: select trading_partner_id, trading_partner_contact_name
9175: into x_tp_id, x_auction_tp_contact_name

Line 9176: from pon_auction_headers_all

9172: WHERE auction_header_id=x_doc_number;
9173:
9174: select trading_partner_id, trading_partner_contact_name
9175: into x_tp_id, x_auction_tp_contact_name
9176: from pon_auction_headers_all
9177: where auction_header_id = x_doc_number;
9178:
9179: END;
9180:

Line 9699: l_amendment_flag pon_auction_headers_all.amendment_flag%TYPE;

9695: x_error_code out NOCOPY varchar2,
9696: x_error_message out NOCOPY varchar2 ) is
9697:
9698: l_line_number number;
9699: l_amendment_flag pon_auction_headers_all.amendment_flag%TYPE;
9700: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
9701: l_requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE;
9702:
9703: CURSOR deletedItems IS

Line 9700: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;

9696: x_error_message out NOCOPY varchar2 ) is
9697:
9698: l_line_number number;
9699: l_amendment_flag pon_auction_headers_all.amendment_flag%TYPE;
9700: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
9701: l_requisition_line_id po_requisition_lines_all.requisition_line_id%TYPE;
9702:
9703: CURSOR deletedItems IS
9704: SELECT LINE_NUMBER

Line 9723: SELECT amendment_flag, auction_header_id INTO l_amendment_flag,l_auction_header_id FROM pon_auction_headers_all WHERE amendment_flag = 'Y' AND auction_header_id_prev_amend = x_old_negotiation_id;

9719: /* bug#10295849: Added the code to update the negotiation references of amended requistions which are added to a solicitation amendment */
9720: -----------------------------------------------------------------------------------------------------------------------------------------------
9721: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(x_new_negotiation_id) = 1 ) THEN
9722: BEGIN
9723: SELECT amendment_flag, auction_header_id INTO l_amendment_flag,l_auction_header_id FROM pon_auction_headers_all WHERE amendment_flag = 'Y' AND auction_header_id_prev_amend = x_old_negotiation_id;
9724: EXCEPTION
9725: WHEN OTHERS THEN
9726: l_amendment_flag:= NULL;
9727: END;

Line 10011: v_contract_type pon_auction_headers_all.contract_type%TYPE;

10007: FUNCTION CHECK_UNIQUE_ORDER_NUMBER (p_auction_id IN NUMBER,
10008: p_order_number IN VARCHAR2,
10009: p_bid_number IN NUMBER)
10010: RETURN VARCHAR2 IS
10011: v_contract_type pon_auction_headers_all.contract_type%TYPE;
10012: v_org_id pon_auction_headers_all.org_id%TYPE;
10013: v_old_org_id NUMBER;
10014: v_old_policy VARCHAR2(1);
10015: v_is_unique VARCHAR2(1);

Line 10012: v_org_id pon_auction_headers_all.org_id%TYPE;

10008: p_order_number IN VARCHAR2,
10009: p_bid_number IN NUMBER)
10010: RETURN VARCHAR2 IS
10011: v_contract_type pon_auction_headers_all.contract_type%TYPE;
10012: v_org_id pon_auction_headers_all.org_id%TYPE;
10013: v_old_org_id NUMBER;
10014: v_old_policy VARCHAR2(1);
10015: v_is_unique VARCHAR2(1);
10016:

Line 10032: FROM pon_auction_headers_all

10028:
10029: -- Get the org id for the negotiation
10030: SELECT org_id, contract_type
10031: INTO v_org_id, v_contract_type
10032: FROM pon_auction_headers_all
10033: WHERE auction_header_id = p_auction_id;
10034:
10035: -- Set the connection's policy context
10036: mo_global.set_policy_context('S', v_org_id);

Line 10134: from pon_auction_headers_all

10130: PROCEDURE GET_TIME_REMAINING(p_auction_header_id IN NUMBER,
10131: p_time_remaining OUT NOCOPY FLOAT) is
10132: begin
10133: select (sysdate - close_bidding_date) into p_time_remaining
10134: from pon_auction_headers_all
10135: where auction_header_id = p_auction_header_id;
10136:
10137: EXCEPTION
10138: WHEN OTHERS THEN

Line 10253: UPDATE PON_AUCTION_HEADERS_ALL

10249: x_error_code := 'SUCCESS';
10250:
10251: BEGIN
10252:
10253: UPDATE PON_AUCTION_HEADERS_ALL
10254: SET AUCTION_STATUS = 'DELETED'
10255: WHERE
10256: AUCTION_HEADER_ID_ORIG_AMEND IS NOT NULL
10257: AND AUCTION_HEADER_ID_ORIG_AMEND = x_negotiation_id;

Line 10259: UPDATE PON_AUCTION_HEADERS_ALL

10255: WHERE
10256: AUCTION_HEADER_ID_ORIG_AMEND IS NOT NULL
10257: AND AUCTION_HEADER_ID_ORIG_AMEND = x_negotiation_id;
10258:
10259: UPDATE PON_AUCTION_HEADERS_ALL
10260: SET AUCTION_STATUS = 'DELETED'
10261: WHERE
10262: AUCTION_HEADER_ID = x_negotiation_id;
10263:

Line 10293: from pon_auction_headers_all

10289: BEGIN
10290:
10291: select auction_status
10292: into v_auction_status
10293: from pon_auction_headers_all
10294: where auction_header_id = p_auction_header_id;
10295:
10296: IF (v_auction_status = 'AMENDED') THEN
10297:

Line 10300: from pon_auction_headers_all

10296: IF (v_auction_status = 'AMENDED') THEN
10297:
10298: select auction_header_id_orig_amend
10299: into v_auction_header_id_orig_amend
10300: from pon_auction_headers_all
10301: where auction_header_id = p_auction_header_id;
10302:
10303: select auction_header_id
10304: into v_most_recent_amendment

Line 10305: from pon_auction_headers_all

10301: where auction_header_id = p_auction_header_id;
10302:
10303: select auction_header_id
10304: into v_most_recent_amendment
10305: from pon_auction_headers_all
10306: where auction_header_id_orig_amend = v_auction_header_id_orig_amend and
10307: auction_status <> 'AMENDED' and auction_status <> 'DRAFT' and
10308: rownum = 1; -- rownum = 1 is a sanity check
10309:

Line 10336: -- The procedure determines the price_break_response for pon_auction_headers_all table.

10332: END GET_MEMBER_TYPE;
10333:
10334:
10335: -- this procedure is added for header price break default
10336: -- The procedure determines the price_break_response for pon_auction_headers_all table.
10337: -- It's used in plsql routines where new negotiation created,
10338: -- including negotiation copy/new round/amendment, autocreation and renegotiation.
10339: -- The logic is same as AuctionHeadersAllEO
10340:

Line 10400: l_price_break_response pon_auction_headers_all.price_break_response%type;

10396: PROCEDURE get_default_pb_settings (p_auction_header_id IN NUMBER,
10397: x_price_break_type OUT NOCOPY VARCHAR2,
10398: x_price_break_neg_flag OUT NOCOPY VARCHAR2) IS
10399:
10400: l_price_break_response pon_auction_headers_all.price_break_response%type;
10401: l_contract_type pon_auction_headers_all.contract_type%type;
10402: l_doctype_id pon_auction_headers_all.doctype_id%type;
10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;

Line 10401: l_contract_type pon_auction_headers_all.contract_type%type;

10397: x_price_break_type OUT NOCOPY VARCHAR2,
10398: x_price_break_neg_flag OUT NOCOPY VARCHAR2) IS
10399:
10400: l_price_break_response pon_auction_headers_all.price_break_response%type;
10401: l_contract_type pon_auction_headers_all.contract_type%type;
10402: l_doctype_id pon_auction_headers_all.doctype_id%type;
10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;
10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;

Line 10402: l_doctype_id pon_auction_headers_all.doctype_id%type;

10398: x_price_break_neg_flag OUT NOCOPY VARCHAR2) IS
10399:
10400: l_price_break_response pon_auction_headers_all.price_break_response%type;
10401: l_contract_type pon_auction_headers_all.contract_type%type;
10402: l_doctype_id pon_auction_headers_all.doctype_id%type;
10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;
10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
10406: l_org_id pon_auction_headers_all.org_id%type;

Line 10403: l_po_style_id pon_auction_headers_all.po_style_id%type;

10399:
10400: l_price_break_response pon_auction_headers_all.price_break_response%type;
10401: l_contract_type pon_auction_headers_all.contract_type%type;
10402: l_doctype_id pon_auction_headers_all.doctype_id%type;
10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;
10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
10406: l_org_id pon_auction_headers_all.org_id%type;
10407: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;

Line 10404: l_template_id pon_auction_headers_all.template_id%type;

10400: l_price_break_response pon_auction_headers_all.price_break_response%type;
10401: l_contract_type pon_auction_headers_all.contract_type%type;
10402: l_doctype_id pon_auction_headers_all.doctype_id%type;
10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;
10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
10406: l_org_id pon_auction_headers_all.org_id%type;
10407: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;
10408: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;

Line 10406: l_org_id pon_auction_headers_all.org_id%type;

10402: l_doctype_id pon_auction_headers_all.doctype_id%type;
10403: l_po_style_id pon_auction_headers_all.po_style_id%type;
10404: l_template_id pon_auction_headers_all.template_id%type;
10405: l_template_pb_type pon_auction_item_prices_all.price_break_type%type;
10406: l_org_id pon_auction_headers_all.org_id%type;
10407: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;
10408: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
10409: l_price_break_enabled_flag VARCHAR2(1);
10410: l_price_break_allowed VARCHAR2(1);

Line 10411: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;

10407: l_po_pb_type po_system_parameters_all.price_break_lookup_code%type;
10408: l_price_break_display_flag PON_AUC_DOCTYPE_RULES.display_flag%type;
10409: l_price_break_enabled_flag VARCHAR2(1);
10410: l_price_break_allowed VARCHAR2(1);
10411: l_price_tiers_indicator pon_auction_headers_all.price_tiers_indicator%type;
10412:
10413: l_dummy1 VARCHAR2(240);
10414: l_dummy2 VARCHAR2(240);
10415: l_dummy3 VARCHAR2(30);

Line 10428: from pon_auction_headers_all

10424: BEGIN
10425:
10426: select contract_type, doctype_id, price_break_response, po_style_id, template_id, org_id, price_tiers_indicator
10427: into l_contract_type, l_doctype_id, l_price_break_response, l_po_style_id, l_template_id, l_org_id, l_price_tiers_indicator
10428: from pon_auction_headers_all
10429: where auction_header_id = p_auction_header_id;
10430:
10431: select display_flag
10432: into l_price_break_display_flag

Line 10651: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

10647: l_module_name constant VARCHAR2(40) := 'SEND_TASK_ASSIGN_NOTIF';
10648: l_progress VARCHAR2(3);
10649: l_language_code VARCHAR2(20);
10650: l_lang_code VARCHAR2(4);
10651: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
10652: l_auction_start_date DATE;
10653: l_auction_end_date DATE;
10654: l_preview_date DATE;
10655: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

Line 10656: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

10652: l_auction_start_date DATE;
10653: l_auction_end_date DATE;
10654: l_preview_date DATE;
10655: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10656: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10657: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10658: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10659: l_task_target_date DATE;
10660: l_task_assignment_date DATE;

Line 10730: from pon_auction_headers_all auh,

10726: l_user_name,
10727: l_open_auction_now_flag,
10728: l_publish_auction_now_flag
10729:
10730: from pon_auction_headers_all auh,
10731: hz_parties hz,
10732: pon_neg_team_members pntm,
10733: fnd_user fu,
10734: pon_auc_doctypes pad

Line 10982: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

10978: l_module_name constant VARCHAR2(40) := 'SEND_TASK_COMPL_NOTIF';
10979: l_progress VARCHAR2(3);
10980: l_language_code VARCHAR2(20);
10981: l_lang_code VARCHAR2(4);
10982: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
10983: l_auction_start_date DATE;
10984: l_auction_end_date DATE;
10985: l_preview_date DATE;
10986: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;

Line 10987: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

10983: l_auction_start_date DATE;
10984: l_auction_end_date DATE;
10985: l_preview_date DATE;
10986: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10987: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10988: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10989: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10990: l_task_target_date DATE;
10991: l_task_completion_date DATE;

Line 11047: from pon_auction_headers_all auh,

11043: l_trading_partner_id,
11044: l_tp_contact_usr_id,
11045: l_open_auction_now_flag,
11046: l_publish_auction_now_flag
11047: from pon_auction_headers_all auh,
11048: pon_auc_doctypes pad,
11049: fnd_user fu
11050: where auh.auction_header_id = p_auction_header_id
11051: AND pad.doctype_id = auh.doctype_id

Line 11089: from pon_auction_headers_all auh,

11085: l_trading_partner_id,
11086: l_tp_contact_usr_id,
11087: l_open_auction_now_flag,
11088: l_publish_auction_now_flag
11089: from pon_auction_headers_all auh,
11090: pon_auc_doctypes pad,
11091: fnd_user fu
11092: where auh.auction_header_id = p_auction_header_id
11093: AND pad.doctype_id = auh.doctype_id

Line 11373: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

11369: l_itemkey VARCHAR2(50);
11370: l_auctioneer_user_name VARCHAR2(244);
11371: l_bidder_user_name VARCHAR2(244);
11372:
11373: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11374: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;

Line 11374: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

11370: l_auctioneer_user_name VARCHAR2(244);
11371: l_bidder_user_name VARCHAR2(244);
11372:
11373: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11374: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

Line 11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

11371: l_bidder_user_name VARCHAR2(244);
11372:
11373: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11374: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;

Line 11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;

11372:
11373: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11374: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;

Line 11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;

11373: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11374: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
11381: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

11374: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11375: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11376: l_tp_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
11381: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11382: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;

Line 11444: from pon_auction_headers_all auh,

11440: l_bidder_tp_name,
11441: l_bid_publish_date,
11442: l_bidder_tpc_id,
11443: l_auction_header_id
11444: from pon_auction_headers_all auh,
11445: pon_auc_doctypes pad,
11446: pon_bid_headers pbh,
11447: fnd_user fu
11448: where pbh.bid_number = p_bid_number

Line 11495: from pon_auction_headers_all auh,

11491: l_bidder_tp_name,
11492: l_bid_publish_date,
11493: l_bidder_tpc_id,
11494: l_auction_header_id
11495: from pon_auction_headers_all auh,
11496: pon_auc_doctypes pad,
11497: pon_bid_headers pbh,
11498: fnd_user fu
11499: where pbh.bid_number = p_bid_number

Line 11825: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

11821: l_module_name CONSTANT VARCHAR2(40) := 'SEND_MSG_SENT_NOTIF';
11822: l_progress VARCHAR2(3);
11823: l_language VARCHAR2(20);
11824: l_lang_code VARCHAR2(4);
11825: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11826: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11827: l_auction_start_date DATE;
11828: l_auction_end_date DATE;
11829: l_preview_date DATE;

Line 11826: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

11822: l_progress VARCHAR2(3);
11823: l_language VARCHAR2(20);
11824: l_lang_code VARCHAR2(4);
11825: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
11826: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
11827: l_auction_start_date DATE;
11828: l_auction_end_date DATE;
11829: l_preview_date DATE;
11830: l_msg_sent_date DATE;

Line 11833: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

11829: l_preview_date DATE;
11830: l_msg_sent_date DATE;
11831: l_null_date DATE;
11832: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
11833: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11834: l_subject PON_THREADS.SUBJECT%TYPE;
11835: l_sender_name VARCHAR2(350);
11836: l_recipient_name VARCHAR2(350);
11837: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

Line 12062: FROM pon_auction_headers_all auh,

12058: l_from_company_id,
12059: l_discussion_id,
12060: l_open_auction_now_flag ,
12061: l_publish_auction_now_flag
12062: FROM pon_auction_headers_all auh,
12063: pon_auc_doctypes pad,
12064: pon_thread_entries pte,
12065: pon_threads pt,
12066: pon_discussions pd

Line 13323: v_carrier_code PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE;

13319: x_payment_rate_rype_enabled OUT NOCOPY VARCHAR2
13320: ) IS
13321:
13322: v_org_id NUMBER;
13323: v_carrier_code PON_AUCTION_HEADERS_ALL.CARRIER_CODE%TYPE;
13324: v_sealed_unlock_tp_contact_id NUMBER;
13325: v_sealed_unseal_tp_contact_id NUMBER;
13326: v_is_paused VARCHAR2(1);
13327: v_trading_partner_contact_id NUMBER;

Line 13358: pon_auction_headers_all_v

13354: v_is_paused,
13355: v_staggered_closing_interval,
13356: v_trading_partner_contact_id
13357: FROM
13358: pon_auction_headers_all_v
13359: WHERE
13360: auction_header_id = p_auction_header_id;
13361:
13362: x_time_left := TIME_REMAINING(p_auction_header_id);

Line 13384: pon_auction_headers_all a,

13380: a.auction_header_id
13381: INTO
13382: v_temp
13383: FROM
13384: pon_auction_headers_all a,
13385: pon_bid_headers b
13386: WHERE
13387: a.auction_header_id = b.auction_header_id
13388: and a.auction_header_id = p_auction_header_id

Line 13470: pon_auction_headers_all_v ah,

13466: x_retainage_flag,
13467: x_payment_rate_rype_enabled
13468: FROM
13469: po_all_doc_style_lines ps,
13470: pon_auction_headers_all_v ah,
13471: po_doc_style_headers pdsh,
13472: po_style_enabled_pay_items pspay,
13473: po_lookup_codes fl_pay_item
13474: WHERE

Line 13520: v_auction_status pon_auction_headers_all.auction_status%TYPE; -- to store auction status

13516: x_error_message OUT NOCOPY VARCHAR2,
13517: p_auction_header_id IN NUMBER)
13518: RETURN VARCHAR2
13519: AS
13520: v_auction_status pon_auction_headers_all.auction_status%TYPE; -- to store auction status
13521: v_time_remaining number; -- to store the time remaining for auction to close
13522: l_show_countdown varchar2(1) := 'N'; -- return value, default 'N'
13523:
13524: BEGIN

Line 13537: FROM pon_auction_headers_all

13533: -- adsahay: bug 6319438 - replace sysdate with last_pause_date for paused auctions,
13534: -- since close_bidding_date can be in the past (lesser than sysdate).
13535: SELECT (close_bidding_date - decode(is_paused, 'Y', last_pause_date, sysdate)), auction_status
13536: INTO v_time_remaining, v_auction_status
13537: FROM pon_auction_headers_all
13538: WHERE auction_header_id = p_auction_header_id
13539: AND open_bidding_date < sysdate;
13540:
13541: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 13644: FROM pon_auction_headers_all

13640: SELECT (close_bidding_date-decode(is_paused, 'Y', last_pause_date, sysdate)), nvl2(staggered_closing_interval, 'Y', 'N'),
13641: -- if auto extend is enabled and auto extends all lines, 'N' else 'Y'
13642: decode(auto_extend_flag, 'Y', decode(auto_extend_all_lines_flag, 'N', 'Y', 'N'), 'N')
13643: INTO v_time_left, v_is_staggered, v_ext_all_lines
13644: FROM pon_auction_headers_all
13645: WHERE auction_header_id = p_auction_header_id;
13646:
13647: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13648: FND_LOG.string (log_level => FND_LOG.level_statement,

Line 13821: l_auction_title pon_auction_headers_all.auction_title%TYPE;

13817: -- other local variables
13818: x_item_key VARCHAR2(15); -- workflow item key
13819: x_item_type VARCHAR2(8) := 'PONTEVAL'; -- workflow item type
13820: l_bidder_name pon_bid_headers.trading_partner_contact_name%TYPE;
13821: l_auction_title pon_auction_headers_all.auction_title%TYPE;
13822: l_document_number pon_auction_headers_all.document_number%TYPE;
13823: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
13824:
13825: BEGIN

Line 13822: l_document_number pon_auction_headers_all.document_number%TYPE;

13818: x_item_key VARCHAR2(15); -- workflow item key
13819: x_item_type VARCHAR2(8) := 'PONTEVAL'; -- workflow item type
13820: l_bidder_name pon_bid_headers.trading_partner_contact_name%TYPE;
13821: l_auction_title pon_auction_headers_all.auction_title%TYPE;
13822: l_document_number pon_auction_headers_all.document_number%TYPE;
13823: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
13824:
13825: BEGIN
13826: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 13823: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;

13819: x_item_type VARCHAR2(8) := 'PONTEVAL'; -- workflow item type
13820: l_bidder_name pon_bid_headers.trading_partner_contact_name%TYPE;
13821: l_auction_title pon_auction_headers_all.auction_title%TYPE;
13822: l_document_number pon_auction_headers_all.document_number%TYPE;
13823: l_trading_partner_name pon_auction_headers_all.trading_partner_name%TYPE;
13824:
13825: BEGIN
13826: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13827: FND_LOG.string (log_level => FND_LOG.level_statement,

Line 13838: FROM pon_auction_headers_all

13834: BEGIN
13835: -- get auction information
13836: SELECT auction_title, document_number, trading_partner_name
13837: INTO l_auction_title, l_document_number, l_trading_partner_name
13838: FROM pon_auction_headers_all
13839: WHERE auction_header_id = p_auction_header_id;
13840: EXCEPTION
13841: WHEN NO_DATA_FOUND THEN
13842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 13849: message => 'NO_DATA_FOUND in pon_auction_headers_all for p_auction_header_id :'

13845:
13846: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
13847: FND_LOG.string (log_level => FND_LOG.level_exception,
13848: module => g_module_prefix || '.notify_bidders_tech_complete',
13849: message => 'NO_DATA_FOUND in pon_auction_headers_all for p_auction_header_id :'
13850: || p_auction_header_id || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
13851: END IF;
13852:
13853: WHEN TOO_MANY_ROWS THEN

Line 13861: message => 'TOO_MANY_ROWS in pon_auction_headers_all for p_auction_header_id :'

13857:
13858: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.g_current_runtime_level) THEN
13859: FND_LOG.string (log_level => FND_LOG.level_exception,
13860: module => g_module_prefix || '.notify_bidders_tech_complete',
13861: message => 'TOO_MANY_ROWS in pon_auction_headers_all for p_auction_header_id :'
13862: || p_auction_header_id || ' Error Number :' || SQLCODE || ' Exception Message :' || SUBSTR(SQLERRM, 1, 200) );
13863: END IF;
13864:
13865: WHEN OTHERS THEN

Line 14000: p_auction_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,

13996:
13997: END notify_bidders_tech_complete;
13998:
13999: FUNCTION GET_AUCTION_STATUS_DISPLAY(
14000: p_auction_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,
14001: p_user_trading_partner_id IN pon_auction_headers_all.TRADING_PARTNER_ID%TYPE)
14002: RETURN VARCHAR2
14003: AS
14004:

Line 14001: p_user_trading_partner_id IN pon_auction_headers_all.TRADING_PARTNER_ID%TYPE)

13997: END notify_bidders_tech_complete;
13998:
13999: FUNCTION GET_AUCTION_STATUS_DISPLAY(
14000: p_auction_header_id IN pon_auction_headers_all.AUCTION_HEADER_ID%TYPE,
14001: p_user_trading_partner_id IN pon_auction_headers_all.TRADING_PARTNER_ID%TYPE)
14002: RETURN VARCHAR2
14003: AS
14004:
14005: l_is_buyer BOOLEAN;

Line 14006: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%type;

14002: RETURN VARCHAR2
14003: AS
14004:
14005: l_is_buyer BOOLEAN;
14006: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%type;
14007: l_technical_lock_status pon_auction_headers_all.TECHNICAL_LOCK_STATUS%type;
14008: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%type;
14009: l_message VARCHAR2(100);
14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;

Line 14007: l_technical_lock_status pon_auction_headers_all.TECHNICAL_LOCK_STATUS%type;

14003: AS
14004:
14005: l_is_buyer BOOLEAN;
14006: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%type;
14007: l_technical_lock_status pon_auction_headers_all.TECHNICAL_LOCK_STATUS%type;
14008: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%type;
14009: l_message VARCHAR2(100);
14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;
14011: l_auction_status pon_auction_headers_all.auction_status%type;

Line 14008: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%type;

14004:
14005: l_is_buyer BOOLEAN;
14006: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%type;
14007: l_technical_lock_status pon_auction_headers_all.TECHNICAL_LOCK_STATUS%type;
14008: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%type;
14009: l_message VARCHAR2(100);
14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;
14011: l_auction_status pon_auction_headers_all.auction_status%type;
14012: l_auction_status2 pon_auction_headers_all.auction_status%type;

Line 14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;

14006: l_two_part_flag pon_auction_headers_all.TWO_PART_FLAG%type;
14007: l_technical_lock_status pon_auction_headers_all.TECHNICAL_LOCK_STATUS%type;
14008: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%type;
14009: l_message VARCHAR2(100);
14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;
14011: l_auction_status pon_auction_headers_all.auction_status%type;
14012: l_auction_status2 pon_auction_headers_all.auction_status%type;
14013: l_award_status pon_auction_headers_all.award_status%type;
14014:

Line 14011: l_auction_status pon_auction_headers_all.auction_status%type;

14007: l_technical_lock_status pon_auction_headers_all.TECHNICAL_LOCK_STATUS%type;
14008: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%type;
14009: l_message VARCHAR2(100);
14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;
14011: l_auction_status pon_auction_headers_all.auction_status%type;
14012: l_auction_status2 pon_auction_headers_all.auction_status%type;
14013: l_award_status pon_auction_headers_all.award_status%type;
14014:
14015: l_auction_trading_partner_id pon_auction_headers_all.trading_partner_id%type;

Line 14012: l_auction_status2 pon_auction_headers_all.auction_status%type;

14008: l_technical_evaluation_status pon_auction_headers_all.TECHNICAL_EVALUATION_STATUS%type;
14009: l_message VARCHAR2(100);
14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;
14011: l_auction_status pon_auction_headers_all.auction_status%type;
14012: l_auction_status2 pon_auction_headers_all.auction_status%type;
14013: l_award_status pon_auction_headers_all.award_status%type;
14014:
14015: l_auction_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
14016: l_technical_lock_meaning VARCHAR2(30);

Line 14013: l_award_status pon_auction_headers_all.award_status%type;

14009: l_message VARCHAR2(100);
14010: l_commercial_lock_status pon_auction_headers_all.sealed_auction_status%type;
14011: l_auction_status pon_auction_headers_all.auction_status%type;
14012: l_auction_status2 pon_auction_headers_all.auction_status%type;
14013: l_award_status pon_auction_headers_all.award_status%type;
14014:
14015: l_auction_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
14016: l_technical_lock_meaning VARCHAR2(30);
14017: l_commercial_lock_meaning VARCHAR2(30);

Line 14015: l_auction_trading_partner_id pon_auction_headers_all.trading_partner_id%type;

14011: l_auction_status pon_auction_headers_all.auction_status%type;
14012: l_auction_status2 pon_auction_headers_all.auction_status%type;
14013: l_award_status pon_auction_headers_all.award_status%type;
14014:
14015: l_auction_trading_partner_id pon_auction_headers_all.trading_partner_id%type;
14016: l_technical_lock_meaning VARCHAR2(30);
14017: l_commercial_lock_meaning VARCHAR2(30);
14018:
14019: BEGIN

Line 14049: FROM pon_auction_headers_all

14045: l_auction_status,
14046: l_auction_trading_partner_id,
14047: l_auction_status2,
14048: l_award_status
14049: FROM pon_auction_headers_all
14050: WHERE auction_header_id = p_auction_header_id;
14051:
14052: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
14053: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 14124: FROM fnd_lookups fl, pon_auction_headers_all_v pav

14120: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14121: or lookup_code = pav.technical_lock_status))
14122: ||')', '')
14123: INTO l_buyer_meaning, l_buyer_sealed_meaning
14124: FROM fnd_lookups fl, pon_auction_headers_all_v pav
14125: WHERE pav.auction_header_id = p_auction_header_id
14126: AND fl.lookup_type = 'PON_AUCTION_STATUS'
14127: AND fl.lookup_code = pav.negotiation_status;
14128:

Line 14172: FROM fnd_lookups fl, pon_auction_headers_all_v pav

14168: (nvl(pav.two_part_flag, 'N') <> 'Y' and lookup_code = pav.sealed_auction_status)
14169: or lookup_code = decode(pav.sealed_auction_status, 'UNLOCKED', pav.sealed_auction_status,pav.technical_lock_status)) )
14170: ||')', '')
14171: INTO l_supp_meaning, l_supp_sealed_meaning
14172: FROM fnd_lookups fl, pon_auction_headers_all_v pav
14173: WHERE pav.auction_header_id = p_auction_header_id
14174: AND fl.lookup_type = 'PON_AUCTION_STATUS'
14175: AND fl.lookup_code = pav.suppl_negotiation_status;
14176:

Line 14218: FROM pon_auction_headers_all

14214: (SELECT meaning from fnd_lookups
14215: WHERE lookup_type = 'PON_SEALED_AUCTION_STATUS' and
14216: lookup_code = nvl(sealed_auction_status,'')) --commercial status
14217: INTO l_technical_lock_meaning, l_commercial_lock_meaning
14218: FROM pon_auction_headers_all
14219: WHERE auction_header_id = p_auction_header_id;
14220:
14221: IF (FND_LOG.level_statement>= FND_LOG.g_current_runtime_level) THEN
14222: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 14581: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v

14577: -- p_view_by_date - view_by_date column
14578: -- p_open_bidding_date - open_bidding_date column
14579: -- p_close_bidding_date - close_bidding_date column
14580: --
14581: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
14582: -- view to get the value for the suppl_negotiation_status
14583: -- column in the view. Prior to the use of this function the
14584: -- same code existed as decodes in the view itself.
14585: --========================================================================

Line 14649: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v

14645: -- p_award_status - award_status column
14646: -- p_award_approval_status - award_approval_status column
14647: -- p_outcome_status - outcome_status column
14648: --
14649: -- COMMENT : This procedure will be used in the pon_auction_headers_all_v
14650: -- view to get the value for the negotiation_status
14651: -- column in the view. Prior to the use of this function the
14652: -- same code existed as decodes in the view itself.
14653: --========================================================================

Line 15343: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;

15339: x_timezone_disp VARCHAR2(240);
15340: x_bid_id NUMBER;
15341: x_bid_caps VARCHAR2(10);
15342: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
15343: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
15344: x_number_awarded NUMBER;
15345: x_number_rejected NUMBER;
15346: x_preview_date_format VARCHAR2(80);
15347: x_auction_start_date_format VARCHAR2(80);

Line 15561: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;

15557: x_timezone_disp VARCHAR2(240);
15558: x_bid_id NUMBER;
15559: x_bid_caps VARCHAR2(10);
15560: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
15561: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
15562: x_preview_date_format VARCHAR2(80);
15563: x_auction_start_date_format VARCHAR2(80);
15564: x_auction_end_date_format VARCHAR2(80);
15565: x_award_date_format VARCHAR2(80);

Line 15770: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;

15766: x_timezone_disp VARCHAR2(240);
15767: x_bid_id NUMBER;
15768: x_bid_caps VARCHAR2(10);
15769: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
15770: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
15771: x_event_title varchar2(80);
15772: x_number_awarded NUMBER;
15773: x_number_rejected NUMBER;
15774: x_preview_date_format VARCHAR2(80);

Line 16001: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;

15997: x_timezone_disp VARCHAR2(240);
15998: x_bid_id NUMBER;
15999: x_bid_caps VARCHAR2(10);
16000: x_note_to_supplier PON_BID_HEADERS.NOTE_TO_SUPPLIER%TYPE;
16001: x_award_date PON_AUCTION_HEADERS_ALL.AWARD_DATE%TYPE;
16002: x_event_title varchar2(80);
16003: x_preview_date_format VARCHAR2(80);
16004: x_auction_start_date_format VARCHAR2(80);
16005: x_auction_end_date_format VARCHAR2(80);

Line 16362: x_auction_title pon_auction_headers_all.auction_title%TYPE;

16358: x_auction_start_date_format VARCHAR2(80);
16359: x_auction_end_date_format VARCHAR2(80);
16360:
16361: -- Bug 9309785
16362: x_auction_title pon_auction_headers_all.auction_title%TYPE;
16363: x_doc_number pon_auction_headers_all.document_number%TYPE;
16364: x_auction_owner_tp_name VARCHAR2(640);
16365: x_isp_new_supplier_reg_url VARCHAR2(500);
16366:

Line 16363: x_doc_number pon_auction_headers_all.document_number%TYPE;

16359: x_auction_end_date_format VARCHAR2(80);
16360:
16361: -- Bug 9309785
16362: x_auction_title pon_auction_headers_all.auction_title%TYPE;
16363: x_doc_number pon_auction_headers_all.document_number%TYPE;
16364: x_auction_owner_tp_name VARCHAR2(640);
16365: x_isp_new_supplier_reg_url VARCHAR2(500);
16366:
16367: x_notification_id NUMBER;

Line 17401: from PON_AUCTION_HEADERS_ALL

17397: aname => 'DOC_AMENDMENT_NUMBER');
17398:
17399: select DECODE(nvl(revision,0), 0, x_doc_number, x_doc_amendment_number)
17400: into x_doc_number_wf
17401: from PON_AUCTION_HEADERS_ALL
17402: where AUCTION_HEADER_ID = x_auction_header_id;
17403:
17404: FOR preparer IN preparer_list LOOP
17405:

Line 17477: FROM pon_auction_headers_all

17473: BEGIN
17474:
17475: SELECT internal_only_flag
17476: INTO l_internal_only_flag
17477: FROM pon_auction_headers_all
17478: WHERE auction_header_id = p_auction_header_id;
17479:
17480: RETURN (l_internal_only_flag = 'Y');
17481:

Line 17514: l_intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%TYPE;

17510: -- Begin Supplier Management: Bug 9222914
17511: PROCEDURE SYNC_BID_HEADER_ATTACHMENTS(p_auction_header_id IN NUMBER)
17512: AS
17513:
17514: l_intgr_hdr_attach_flag pon_auction_headers_all.intgr_hdr_attach_flag%TYPE;
17515: l_bid_number pon_bid_headers.bid_number%TYPE;
17516: l_vendor_id pon_bid_headers.vendor_id%TYPE;
17517:
17518: CURSOR get_intgr_hdr_attach_flag IS

Line 17520: FROM pon_auction_headers_all

17516: l_vendor_id pon_bid_headers.vendor_id%TYPE;
17517:
17518: CURSOR get_intgr_hdr_attach_flag IS
17519: SELECT intgr_hdr_attach_flag
17520: FROM pon_auction_headers_all
17521: WHERE auction_header_id = p_auction_header_id;
17522:
17523: CURSOR bids_cursor IS
17524: SELECT bid_number, vendor_id

Line 17581: l_auction_title pon_auction_headers_all.auction_title%TYPE;

17577: l_document VARCHAR2(32000) := '';
17578: l_item_type wf_items.item_type%TYPE;
17579: l_item_key wf_items.item_key%TYPE;
17580:
17581: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17582: l_doc_number pon_auction_headers_all.document_number%TYPE;
17583: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;
17584: l_auction_end_date DATE;
17585: l_auction_end_date_format VARCHAR2(80);

Line 17582: l_doc_number pon_auction_headers_all.document_number%TYPE;

17578: l_item_type wf_items.item_type%TYPE;
17579: l_item_key wf_items.item_key%TYPE;
17580:
17581: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17582: l_doc_number pon_auction_headers_all.document_number%TYPE;
17583: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;
17584: l_auction_end_date DATE;
17585: l_auction_end_date_format VARCHAR2(80);
17586: l_timezone_disp VARCHAR2(240);

Line 17583: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;

17579: l_item_key wf_items.item_key%TYPE;
17580:
17581: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17582: l_doc_number pon_auction_headers_all.document_number%TYPE;
17583: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;
17584: l_auction_end_date DATE;
17585: l_auction_end_date_format VARCHAR2(80);
17586: l_timezone_disp VARCHAR2(240);
17587: l_isp_new_supplier_reg_url VARCHAR2(500);

Line 17662: l_auction_title pon_auction_headers_all.auction_title%TYPE;

17658: l_document VARCHAR2(32000) := '';
17659: l_item_type wf_items.item_type%TYPE;
17660: l_item_key wf_items.item_key%TYPE;
17661:
17662: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17663: l_doc_number pon_auction_headers_all.document_number%TYPE;
17664: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;
17665: l_auction_end_date DATE;
17666: l_auction_end_date_format VARCHAR2(80);

Line 17663: l_doc_number pon_auction_headers_all.document_number%TYPE;

17659: l_item_type wf_items.item_type%TYPE;
17660: l_item_key wf_items.item_key%TYPE;
17661:
17662: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17663: l_doc_number pon_auction_headers_all.document_number%TYPE;
17664: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;
17665: l_auction_end_date DATE;
17666: l_auction_end_date_format VARCHAR2(80);
17667: l_timezone_disp VARCHAR2(240);

Line 17664: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;

17660: l_item_key wf_items.item_key%TYPE;
17661:
17662: l_auction_title pon_auction_headers_all.auction_title%TYPE;
17663: l_doc_number pon_auction_headers_all.document_number%TYPE;
17664: l_auction_owner_tp_name pon_auction_headers_all.trading_partner_name%TYPE;
17665: l_auction_end_date DATE;
17666: l_auction_end_date_format VARCHAR2(80);
17667: l_timezone_disp VARCHAR2(240);
17668: l_isp_new_supplier_reg_url VARCHAR2(500);