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_HEADERS_PKG dependencies on PON_BID_HEADERS

Line 227: FROM pon_bid_headers

223: IF l_supplier_sequence_number <> -1 THEN
224: -- determine the currency rate for the response
225: SELECT rate
226: INTO l_currency_rate
227: FROM pon_bid_headers
228: WHERE bid_number = p_bid_number;
229:
230: -- 1) add the Line Price price factor to each bid line that has an applicable buyer factor
231: -- if the supplier view type of the auction is UNTRANSFORMED

Line 379: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;

375: p_vendorSiteId IN NUMBER,
376: p_oldBidNumber IN NUMBER)
377: IS
378: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
379: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
380: v_bidTradingPartnerContactId pon_bid_headers.trading_partner_contact_id%TYPE;
381: v_fixedValue pon_auc_doctype_rules.fixed_value%TYPE;
382: v_amendmentNumber NUMBER;
383: v_auctionHeaderIdOrigAmend NUMBER;

Line 380: v_bidTradingPartnerContactId pon_bid_headers.trading_partner_contact_id%TYPE;

376: p_oldBidNumber IN NUMBER)
377: IS
378: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
379: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
380: v_bidTradingPartnerContactId pon_bid_headers.trading_partner_contact_id%TYPE;
381: v_fixedValue pon_auc_doctype_rules.fixed_value%TYPE;
382: v_amendmentNumber NUMBER;
383: v_auctionHeaderIdOrigAmend NUMBER;
384:

Line 394: FROM pon_bid_headers

390: SELECT trading_partner_id,
391: trading_partner_contact_id
392: INTO v_bidTradingPartnerId,
393: v_bidTradingPartnerContactId
394: FROM pon_bid_headers
395: WHERE bid_number = p_bidNumber;
396:
397: SELECT doctype_id,
398: nvl(amendment_number, 0),

Line 419: UPDATE PON_BID_HEADERS

415: IF (v_fixedValue <> 'COMMIT') THEN
416:
417: -- Update the previous active bid to archived for current auction
418: IF (p_oldBidNumber is not null) THEN
419: UPDATE PON_BID_HEADERS
420: SET BID_STATUS = 'ARCHIVED',
421: LAST_UPDATE_DATE = SYSDATE
422: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
423: AND BID_NUMBER = p_oldBidNumber

Line 431: UPDATE PON_BID_HEADERS

427:
428: -- Go back to previous amendments, update all the active or
429: -- resubmission one to archived
430: IF (v_amendmentNumber > 0) THEN
431: UPDATE PON_BID_HEADERS
432: SET BID_STATUS = 'ARCHIVED',
433: LAST_UPDATE_DATE = SYSDATE
434: WHERE AUCTION_HEADER_ID in (
435: SELECT AUCTION_HEADER_ID

Line 477: -- the partial response flag and sets it in pon_bid_headers

473: -- PARAMETERS:
474: -- VERSION : current version 1.x
475: -- initial version 1.0
476: -- COMMENT : called by update_auction_info, this procedure calculates
477: -- the partial response flag and sets it in pon_bid_headers
478: --========================================================================
479:
480: PROCEDURE set_partial_response_flag(p_bidNumber IN NUMBER)
481: IS

Line 486: UPDATE pon_bid_headers bh

482: l_api_name CONSTANT VARCHAR2(30) := 'set_partial_response_flag';
483: BEGIN
484:
485: print_log(l_api_name || '.BEGIN', p_bidNumber ||' Begin - set_partial_response_flag');
486: UPDATE pon_bid_headers bh
487: SET partial_response_flag = 'N'
488: WHERE bh.bid_number = p_bidNumber;
489:
490: UPDATE pon_bid_headers bh

Line 490: UPDATE pon_bid_headers bh

486: UPDATE pon_bid_headers bh
487: SET partial_response_flag = 'N'
488: WHERE bh.bid_number = p_bidNumber;
489:
490: UPDATE pon_bid_headers bh
491: SET partial_response_flag = 'Y'
492: WHERE bh.bid_number = p_bidNumber
493: AND (EXISTS (select 'x'
494: from pon_bid_item_prices bl,

Line 689: AND fndat.entity_name IN ('PON_BID_ITEM_PRICES', 'PON_BID_HEADERS')

685: FROM fnd_documents dc, fnd_documents_tl dt, fnd_attached_documents fndat
686: WHERE fndat.document_id = dt.document_id
687: AND dt.document_id = dc.document_id
688: AND dt.language = userenv('LANG')
689: AND fndat.entity_name IN ('PON_BID_ITEM_PRICES', 'PON_BID_HEADERS')
690: AND fndat.pk1_value = p_auctionHeaderId
691: AND fndat.pk2_value = p_oldBidNum;
692: --
693: SHORT_TEXT number := 1;

Line 795: SELECT pon_bid_headers_s.nextval

791: print_log(l_api_name, 'p_bidNumber=' || p_bidNumber);
792: print_log(l_api_name, 'p_new_publish_date=' || p_new_publish_date);
793: print_log(l_api_name, 'p_triggerBidNumber=' || p_triggerBidNumber);
794:
795: SELECT pon_bid_headers_s.nextval
796: INTO v_nextBid
797: FROM dual;
798: --
799:

Line 803: INSERT INTO pon_bid_headers (

799:
800: -- need to activate deliverables for the new bid triggered due to proxy
801: -- xxx
802: --
803: INSERT INTO pon_bid_headers (
804: bid_status,
805: bid_status_name,
806: bid_number,
807: shortlist_flag,

Line 928: FROM PON_BID_HEADERS

924: -1,
925: partial_response_flag,
926: color_sequence_id,
927: old_bid_number
928: FROM PON_BID_HEADERS
929: WHERE auction_header_id= p_auctionHeaderId
930: AND bid_number = p_bidNumber;
931: --
932: INSERT INTO pon_bid_item_prices (

Line 1109: UPDATE pon_bid_headers

1105: --
1106: print_log(l_api_name, 'calling subroutine copy_attachments');
1107: copy_attachments(p_auctionHeaderId, p_bidNumber, v_nextBid);
1108: --
1109: UPDATE pon_bid_headers
1110: SET bid_status = 'ARCHIVED',
1111: bid_status_name = (SELECT meaning
1112: FROM fnd_lookups
1113: WHERE lookup_type='PON_BID_STATUS'

Line 1267: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1263: PROCEDURE get_previous_bid( p_auctionHeaderId IN NUMBER,
1264: p_bidNumber IN NUMBER,
1265: v_oldBidNumber OUT NOCOPY NUMBER) IS
1266:
1267: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1268: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1269: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;
1270:
1271: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_bid';

Line 1268: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1264: p_bidNumber IN NUMBER,
1265: v_oldBidNumber OUT NOCOPY NUMBER) IS
1266:
1267: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1268: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1269: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;
1270:
1271: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_bid';
1272:

Line 1269: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;

1265: v_oldBidNumber OUT NOCOPY NUMBER) IS
1266:
1267: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1268: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1269: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;
1270:
1271: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_bid';
1272:
1273: BEGIN

Line 1290: FROM pon_bid_headers

1286: vendor_site_id
1287: INTO v_tpid,
1288: v_tpcid,
1289: v_vendorSiteId
1290: FROM pon_bid_headers
1291: WHERE auction_header_id = p_auctionHeaderId
1292: AND bid_number = p_bidNumber;
1293:
1294:

Line 1303: FROM pon_bid_headers

1299: -- due to draft bid project ?
1300:
1301: SELECT max(bid_number)
1302: INTO v_oldBidNumber
1303: FROM pon_bid_headers
1304: WHERE auction_header_id = p_auctionHeaderId
1305: AND trading_partner_id = v_tpid
1306: AND trading_partner_contact_id = v_tpcid
1307: AND nvl(vendor_site_id,-1) = nvl(v_vendorSiteId, -1)

Line 1322: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1318: p_bidNumber IN NUMBER,
1319: p_vendorSiteId IN NUMBER,
1320: v_oldNonProxyBidNumber OUT NOCOPY NUMBER) IS
1321:
1322: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1323: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1324: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_nonproxy_bid';
1325:
1326: BEGIN

Line 1323: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1319: p_vendorSiteId IN NUMBER,
1320: v_oldNonProxyBidNumber OUT NOCOPY NUMBER) IS
1321:
1322: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1323: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1324: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_nonproxy_bid';
1325:
1326: BEGIN
1327:

Line 1341: FROM pon_bid_headers

1337: SELECT trading_partner_id,
1338: trading_partner_contact_id
1339: INTO v_tpid,
1340: v_tpcid
1341: FROM pon_bid_headers
1342: WHERE auction_header_id = p_auctionHeaderId
1343: AND bid_number = p_bidnumber;
1344:
1345:

Line 1361: FROM pon_bid_headers

1357: -- due to the validation logic in update_auction_info
1358: -- the fix here is to exclude the disqualifed bid
1359: SELECT max(bid_number)
1360: INTO v_oldNonProxyBidNumber
1361: FROM pon_bid_headers
1362: WHERE auction_header_id = p_auctionHeaderId
1363: AND trading_partner_id = v_tpid
1364: AND trading_partner_contact_id = v_tpcid
1365: AND nvl(vendor_site_id, -1) = nvl(p_vendorSiteId, -1)

Line 1381: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1377: p_bidNumber IN NUMBER,
1378: v_activeBidNumber OUT NOCOPY NUMBER,
1379: v_recentBidStatus OUT NOCOPY VARCHAR2) IS
1380:
1381: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1382: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1383: l_api_name CONSTANT VARCHAR2(30) := 'get_most_recent_active_bid';
1384:
1385: BEGIN

Line 1382: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1378: v_activeBidNumber OUT NOCOPY NUMBER,
1379: v_recentBidStatus OUT NOCOPY VARCHAR2) IS
1380:
1381: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1382: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1383: l_api_name CONSTANT VARCHAR2(30) := 'get_most_recent_active_bid';
1384:
1385: BEGIN
1386: --

Line 1398: FROM pon_bid_headers

1394: SELECT trading_partner_id,
1395: trading_partner_contact_id
1396: INTO v_tpid,
1397: v_tpcid
1398: FROM pon_bid_headers
1399: WHERE auction_header_id = p_auctionHeaderId
1400: AND bid_number = p_bidnumber;
1401:
1402: --

Line 1417: FROM pon_bid_headers

1413: BEGIN
1414:
1415: SELECT max(bid_number)
1416: INTO v_activeBidNumber
1417: FROM pon_bid_headers
1418: WHERE auction_header_id = p_auctionHeaderId
1419: AND trading_partner_id = v_tpid
1420: AND trading_partner_contact_id = v_tpcid
1421: AND ((proxy_bid_flag IS null) OR (proxy_bid_flag <> 'Y'))

Line 1426: FROM pon_bid_headers

1422: AND nvl(award_status, 'NONE') <> 'COMMITTED';
1423:
1424: SELECT bid_status
1425: INTO v_recentBidStatus
1426: FROM pon_bid_headers
1427: WHERE bid_number = v_activeBidNumber;
1428:
1429: EXCEPTION
1430:

Line 1466: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1462:
1463: v_publish_date DATE;
1464: v_oldBid NUMBER;
1465: v_rank NUMBER;
1466: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1467: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1468:
1469: l_api_name CONSTANT VARCHAR2(30) := 'update_unchanged_rank';
1470:

Line 1467: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1463: v_publish_date DATE;
1464: v_oldBid NUMBER;
1465: v_rank NUMBER;
1466: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1467: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1468:
1469: l_api_name CONSTANT VARCHAR2(30) := 'update_unchanged_rank';
1470:
1471: BEGIN

Line 1487: FROM pon_bid_headers

1483: trading_partner_contact_id
1484: INTO v_publish_date,
1485: v_tpid,
1486: v_tpcid
1487: FROM pon_bid_headers
1488: WHERE bid_number = p_bidNumber;
1489:
1490:
1491: -- Get the user's most recent non-disqualified bid...if it exists

Line 1494: FROM pon_bid_headers

1490:
1491: -- Get the user's most recent non-disqualified bid...if it exists
1492: SELECT max(bid_number)
1493: INTO v_oldBid
1494: FROM pon_bid_headers
1495: WHERE auction_header_id = p_auctionHeaderId
1496: AND trading_partner_id = v_tpid
1497: AND trading_partner_contact_id = v_tpcid
1498: AND bid_status <> 'DISQUALIFIED'

Line 1618: FROM pon_bid_headers

1614: x_bid_number NUMBER := NULL;
1615:
1616: CURSOR bid_number IS
1617: SELECT bid_number
1618: FROM pon_bid_headers
1619: WHERE auction_header_id = x_auction_header_id
1620: AND trading_partner_id = x_trading_partner_id
1621: AND trading_partner_contact_id = x_trading_partner_contact_id
1622: AND bid_status IN ('ACTIVE', 'DRAFT', 'DISQUALIFIED')

Line 1743: FROM pon_bid_headers

1739: print_log(l_api_name, 'p_tradingPartnerContactId=' || p_tradingPartnerContactId);
1740:
1741: SELECT bid_number
1742: INTO x_bidNumber
1743: FROM pon_bid_headers
1744: WHERE auction_header_id = p_auctionHeaderId
1745: AND trading_partner_id = p_tradingPartnerId
1746: AND trading_partner_contact_id = p_tradingPartnerContactId
1747: AND bid_status = 'ACTIVE';

Line 1998: v_oldBidNumber pon_bid_headers.bid_number%TYPE;

1994: x_return_status OUT NOCOPY NUMBER,
1995: x_return_code OUT NOCOPY VARCHAR2)
1996:
1997: IS
1998: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
1999: v_bidStatus pon_bid_headers.bid_status%TYPE;
2000: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2001: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2002: v_recentBidStatus pon_bid_headers.bid_status%TYPE;

Line 1999: v_bidStatus pon_bid_headers.bid_status%TYPE;

1995: x_return_code OUT NOCOPY VARCHAR2)
1996:
1997: IS
1998: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
1999: v_bidStatus pon_bid_headers.bid_status%TYPE;
2000: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2001: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2002: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2003: v_is_paused pon_auction_headers_all.is_paused%TYPE;

Line 2000: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;

1996:
1997: IS
1998: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
1999: v_bidStatus pon_bid_headers.bid_status%TYPE;
2000: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2001: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2002: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2003: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2004:

Line 2001: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;

1997: IS
1998: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
1999: v_bidStatus pon_bid_headers.bid_status%TYPE;
2000: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2001: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2002: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2003: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2004:
2005: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;

Line 2002: v_recentBidStatus pon_bid_headers.bid_status%TYPE;

1998: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
1999: v_bidStatus pon_bid_headers.bid_status%TYPE;
2000: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2001: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2002: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2003: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2004:
2005: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
2006: v_sameCompanyBids NUMBER;

Line 2005: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;

2001: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2002: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2003: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2004:
2005: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
2006: v_sameCompanyBids NUMBER;
2007: v_sameCompanyDrafts NUMBER;
2008: v_bidFrequencyCode pon_auction_headers_all.bid_frequency_code%TYPE;
2009: v_negotiation_closed_line_num NUMBER;

Line 2075: FROM pon_bid_headers

2071: --
2072: IF (v_oldBidNumber is not null) THEN
2073: SELECT bid_status
2074: INTO v_bidStatus
2075: FROM pon_bid_headers
2076: WHERE bid_number = v_oldBidNumber;
2077:
2078: IF(nvl(p_isRebid,'N') = 'Y') THEN
2079:

Line 2172: FROM PON_BID_HEADERS

2168: IF v_bidFrequencyCode = 'SINGLE_BID_ONLY' THEN
2169: -- get a hold of company's tp id
2170: SELECT TRADING_PARTNER_ID
2171: INTO v_bidTradingPartnerId
2172: FROM PON_BID_HEADERS
2173: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2174: AND BID_NUMBER = p_bidNumber;
2175: --
2176: -- check if there is more than one row in pon_bid_headers

Line 2176: -- check if there is more than one row in pon_bid_headers

2172: FROM PON_BID_HEADERS
2173: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2174: AND BID_NUMBER = p_bidNumber;
2175: --
2176: -- check if there is more than one row in pon_bid_headers
2177: -- one from previous user's bid, one ours
2178:
2179: SELECT COUNT(bid_number)
2180: INTO v_sameCompanyBids

Line 2181: FROM PON_BID_HEADERS

2177: -- one from previous user's bid, one ours
2178:
2179: SELECT COUNT(bid_number)
2180: INTO v_sameCompanyBids
2181: FROM PON_BID_HEADERS
2182: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2183: AND BID_STATUS = 'ACTIVE'
2184: AND TRADING_PARTNER_ID = v_bidTradingPartnerId
2185: AND NVL(VENDOR_SITE_ID, -1) = NVL(p_vendorSiteId, -1);

Line 2198: FROM PON_BID_HEADERS

2194: -- created in the meanwhile
2195:
2196: SELECT COUNT(bid_number)
2197: INTO v_sameCompanyDrafts
2198: FROM PON_BID_HEADERS
2199: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2200: AND (BID_STATUS = 'ACTIVE' OR BID_STATUS = 'DRAFT')
2201: AND TRADING_PARTNER_ID = v_bidTradingPartnerId
2202: AND NVL(VENDOR_SITE_ID, -1) = NVL(p_vendorSiteId, -1);

Line 2244: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,

2240: ( p_auctionHeaderId IN NUMBER,
2241: p_bidNumber IN NUMBER,
2242: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2243: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2244: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2245: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2246: p_batchStart IN NUMBER,
2247: p_batchEnd IN NUMBER,
2248: p_ignore_tech_nonshortlist IN VARCHAR2)

Line 2245: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,

2241: p_bidNumber IN NUMBER,
2242: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2243: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2244: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2245: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2246: p_batchStart IN NUMBER,
2247: p_batchEnd IN NUMBER,
2248: p_ignore_tech_nonshortlist IN VARCHAR2)
2249: IS

Line 2281: FROM pon_bid_item_prices pbip, pon_bid_headers pbh

2277:
2278:
2279: CURSOR all_lines_cursor IS
2280: SELECT pbip.line_number, pbip.rank, pbh.technical_shortlist_flag
2281: FROM pon_bid_item_prices pbip, pon_bid_headers pbh
2282: WHERE pbh.auction_header_id = p_auctionHeaderId
2283: AND pbip.auction_header_id = pbh.auction_header_id
2284: AND pbh.bid_number = p_bidNumber
2285: AND pbip.bid_number = pbh.bid_number

Line 2371: pon_bid_headers bidheader

2367: bidheader.bid_currency_code,
2368: bidline.first_bid_price,
2369: bidline.proxy_bid_limit_price
2370: FROM pon_bid_item_prices bidline,
2371: pon_bid_headers bidheader
2372: WHERE bidline.auction_header_id = p_auctionHeaderId
2373: AND bidheader.auction_header_id = bidline.auction_header_id
2374: AND bidheader.bid_number = bidline.bid_number
2375: AND bidheader.bid_status = 'ACTIVE'

Line 2461: pon_bid_headers bidheader

2457: bidline.bid_number,
2458: bidline.bid_currency_price,
2459: bidheader.bid_currency_code
2460: FROM pon_bid_item_prices bidline,
2461: pon_bid_headers bidheader
2462: WHERE bidline.auction_header_id = p_auctionHeaderId
2463: AND bidheader.auction_header_id = bidline.auction_header_id
2464: AND bidheader.bid_number = bidline.bid_number
2465: AND bidheader.bid_status = 'ACTIVE'

Line 2513: FROM pon_bid_headers bh,

2509: v_counter := 1;
2510: FOR bid_item_record IN all_lines_cursor LOOP -- {
2511:
2512: SELECT number_of_bids - (SELECT COUNT(bh.bid_number)
2513: FROM pon_bid_headers bh,
2514: pon_bid_item_prices bip
2515: WHERE bh.auction_header_id = p_auctionHeaderId
2516: AND bh.trading_partner_contact_id = p_tpcId
2517: AND bh.trading_partner_id = p_tpId

Line 2542: FROM pon_bid_headers h

2538: SET rank = rank - 1
2539: WHERE auction_header_id = p_auctionHeaderId
2540: AND line_number = bid_item_record.line_number
2541: AND EXISTS (SELECT 1
2542: FROM pon_bid_headers h
2543: WHERE h.bid_number = bip.bid_number
2544: AND h.bid_status = 'ACTIVE')
2545: AND rank > bid_item_record.rank;
2546:

Line 2567: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,

2563: ( p_auctionHeaderId IN NUMBER,
2564: p_bidNumber IN NUMBER,
2565: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2566: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2567: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2568: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2569: p_maxLineNumber IN NUMBER,
2570: p_batchSize IN NUMBER,
2571: p_ignore_tech_nonshortlist IN VARCHAR2)

Line 2568: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,

2564: p_bidNumber IN NUMBER,
2565: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2566: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2567: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2568: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2569: p_maxLineNumber IN NUMBER,
2570: p_batchSize IN NUMBER,
2571: p_ignore_tech_nonshortlist IN VARCHAR2)
2572: IS

Line 2609: v_tpcId pon_bid_headers.trading_partner_contact_id%TYPE;

2605: IS
2606:
2607: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info_disqualify';
2608:
2609: v_tpcId pon_bid_headers.trading_partner_contact_id%TYPE;
2610: v_tpId pon_bid_headers.trading_partner_id%TYPE;
2611: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
2612: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
2613: v_maxLineNumber NUMBER;

Line 2610: v_tpId pon_bid_headers.trading_partner_id%TYPE;

2606:
2607: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info_disqualify';
2608:
2609: v_tpcId pon_bid_headers.trading_partner_contact_id%TYPE;
2610: v_tpId pon_bid_headers.trading_partner_id%TYPE;
2611: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
2612: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
2613: v_maxLineNumber NUMBER;
2614: v_batchSize NUMBER;

Line 2666: FROM pon_bid_headers

2662: SELECT trading_partner_contact_id,
2663: trading_partner_id
2664: INTO v_tpcId,
2665: v_tpId
2666: FROM pon_bid_headers
2667: WHERE bid_number = p_bidNumber;
2668:
2669: -- UPDATE AUCTION'S NUMBER OF BIDS
2670: -- BUG: 1540882

Line 2683: FROM pon_bid_headers

2679: UPDATE pon_auction_headers_all
2680: SET last_update_date = sysdate,
2681: number_of_bids = (number_of_bids -
2682: (SELECT count(*)+1
2683: FROM pon_bid_headers
2684: WHERE auction_header_id = p_auctionHeaderId
2685: AND trading_partner_contact_id = v_tpcId
2686: AND bid_status = 'ARCHIVED'))
2687: WHERE auction_header_id = p_auctionHeaderId;

Line 2712: UPDATE pon_bid_headers

2708: END IF;
2709:
2710: -- DISQ ALL PREVIOUS ARCHIVED BIDS
2711: print_log(l_api_name, p_bidNumber || ': disqualifying previous archived bids');
2712: UPDATE pon_bid_headers
2713: SET bid_status = 'DISQUALIFIED'
2714: WHERE auction_header_id = p_auctionHeaderId
2715: AND trading_partner_contact_id = v_tpcId
2716: AND bid_status = 'ARCHIVED';

Line 2768: from pon_bid_item_prices ip, pon_bid_headers h

2764: --
2765: print_log(l_api_name, 'calling subroutine is_better_proxy_price_by_score');
2766: select count(*) + 1
2767: into v_new_rank
2768: from pon_bid_item_prices ip, pon_bid_headers h
2769: where ip.auction_header_id = h.auction_header_id
2770: and h.auction_header_id = p_auctionHeaderId
2771: and h.bid_number = ip.bid_number
2772: and ip.line_number = p_lineNumber

Line 2805: from pon_bid_headers h

2801: set rank = rank + 1
2802: where auction_header_id = p_auctionHeaderId
2803: and line_number = p_lineNumber
2804: and exists (select 1
2805: from pon_bid_headers h
2806: where h.bid_number = ip.bid_number
2807: and h.bid_status = 'ACTIVE')
2808: and rank between v_new_rank and p_oldRank;
2809: --

Line 2817: from pon_bid_headers h

2813: set rank = rank - 1
2814: where auction_header_id = p_auctionHeaderId
2815: and line_number = p_lineNumber
2816: and exists (select 1
2817: from pon_bid_headers h
2818: where h.bid_number = ip.bid_number
2819: and h.bid_status = 'ACTIVE')
2820: and rank between p_oldRank and v_new_rank ;
2821: --

Line 3254: UPDATE pon_bid_headers

3250: IS
3251: l_api_name CONSTANT VARCHAR2(30) := 'recover_prev_amend_draft';
3252: BEGIN
3253: print_log(l_api_name, ' BEGIN recover_prev_amend_draft');
3254: UPDATE pon_bid_headers
3255: SET
3256: bid_status = 'DRAFT',
3257: last_update_date = SYSDATE,
3258: last_updated_by = p_login_user_id

Line 3273: pon_bid_headers bh,

3269: 'DISQUALIFIED', 1) bid_status_order,
3270: nvl(ah.amendment_number, 0) amendment_number,
3271: bh.publish_date
3272: FROM
3273: pon_bid_headers bh,
3274: pon_auction_headers_all ah
3275: WHERE
3276: bh.auction_header_id = ah.auction_header_id
3277: AND ah.auction_header_id_orig_amend = p_auction_header_id_orig_amend

Line 3300: UPDATE pon_bid_headers pbh

3296: IS
3297: l_api_name CONSTANT VARCHAR2(30) := 'set_buyer_bid_total';
3298: BEGIN
3299: print_log(l_api_name, p_bid_number||': BEGIN set_buyer_bid_total');
3300: UPDATE pon_bid_headers pbh
3301: SET buyer_bid_total = (SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(pbip.quantity, paip.quantity)) *
3302: pbip.price)
3303: -- hack to set bid total to null if at least one line has a quantity of null
3304: + decode(min(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(paip.quantity, -9999))), -9999, NULL, 0) bid_total

Line 3552: FROM pon_bid_headers bh,

3548: p_bidPublishDate + p_hdrExtensionTime)
3549: WHERE auction_header_id = p_auctionHeaderId
3550: AND line_number IN
3551: (SELECT al.line_number
3552: FROM pon_bid_headers bh,
3553: pon_bid_item_prices bl,
3554: pon_auction_item_prices_all al
3555: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3556: AND bl.bid_number = bh.bid_number

Line 3733: pon_bid_headers bh,

3729: v_autoExtendMinTriggerRank,
3730: v_staggeredClosingInterval,
3731: v_bidPublishDate
3732: from
3733: pon_bid_headers bh,
3734: pon_auction_headers_all pah
3735: where bh.bid_number = p_bidNumber
3736: AND pah.auction_header_id = bh.auction_header_id;
3737:

Line 3922: v_tpid pon_bid_headers.trading_partner_id%TYPE;

3918: v_bid_min_change NUMBER;
3919: v_oldBidNum NUMBER;
3920: v_newBidNum NUMBER;
3921: v_idx NUMBER;
3922: v_tpid pon_bid_headers.trading_partner_id%TYPE;
3923: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3926: v_rate pon_bid_headers.rate%TYPE;

Line 3923: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

3919: v_oldBidNum NUMBER;
3920: v_newBidNum NUMBER;
3921: v_idx NUMBER;
3922: v_tpid pon_bid_headers.trading_partner_id%TYPE;
3923: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3926: v_rate pon_bid_headers.rate%TYPE;
3927: v_best_bid_rate pon_bid_headers.rate%TYPE;

Line 3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;

3920: v_newBidNum NUMBER;
3921: v_idx NUMBER;
3922: v_tpid pon_bid_headers.trading_partner_id%TYPE;
3923: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3926: v_rate pon_bid_headers.rate%TYPE;
3927: v_best_bid_rate pon_bid_headers.rate%TYPE;
3928: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;

Line 3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;

3921: v_idx NUMBER;
3922: v_tpid pon_bid_headers.trading_partner_id%TYPE;
3923: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3926: v_rate pon_bid_headers.rate%TYPE;
3927: v_best_bid_rate pon_bid_headers.rate%TYPE;
3928: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
3929: v_auction_type pon_auction_headers_all.auction_type%TYPE;

Line 3926: v_rate pon_bid_headers.rate%TYPE;

3922: v_tpid pon_bid_headers.trading_partner_id%TYPE;
3923: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3926: v_rate pon_bid_headers.rate%TYPE;
3927: v_best_bid_rate pon_bid_headers.rate%TYPE;
3928: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
3929: v_auction_type pon_auction_headers_all.auction_type%TYPE;
3930: v_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;

Line 3927: v_best_bid_rate pon_bid_headers.rate%TYPE;

3923: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3926: v_rate pon_bid_headers.rate%TYPE;
3927: v_best_bid_rate pon_bid_headers.rate%TYPE;
3928: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
3929: v_auction_type pon_auction_headers_all.auction_type%TYPE;
3930: v_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
3931: v_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;

Line 3928: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;

3924: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
3925: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
3926: v_rate pon_bid_headers.rate%TYPE;
3927: v_best_bid_rate pon_bid_headers.rate%TYPE;
3928: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
3929: v_auction_type pon_auction_headers_all.auction_type%TYPE;
3930: v_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
3931: v_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
3932: v_auction_decimals NUMBER;

Line 3963: from pon_bid_headers bestbid,

3959: bestbid.trading_partner_contact_id as best_bid_tpc_id,
3960: NVL(bestbid.min_bid_change,0) as best_bid_min_change,
3961: NVL(bestbid.rate,1.0) as best_bid_rate,
3962: NVL(bestbid.number_price_decimals,10) as best_bid_decimals
3963: from pon_bid_headers bestbid,
3964: pon_bid_item_prices biditem,
3965: pon_auction_item_prices_all item
3966: where bestbid.bid_number = item.best_bid_number
3967: and item.auction_header_id = biditem.auction_header_id

Line 4019: FROM pon_bid_headers bid,pon_auction_headers_all auc

4015: v_rate,
4016: v_publish_date,
4017: v_bid_decimals,
4018: v_revision_number
4019: FROM pon_bid_headers bid,pon_auction_headers_all auc
4020: WHERE auc.auction_header_id = bid.auction_header_id
4021: AND bid.bid_number = p_bidNumber;
4022:
4023: -- initialize this price changed flag to not changed

Line 4336: pon_bid_headers groupheader

4332:
4333: CURSOR bid_group_cursor(v_line_number NUMBER) IS
4334: SELECT groupline.bid_number
4335: FROM pon_bid_item_prices groupline,
4336: pon_bid_headers groupheader
4337: WHERE groupline.auction_header_id = p_auctionHeaderId
4338: AND groupline.bid_number = groupheader.bid_number
4339: AND (groupheader.bid_status = 'ACTIVE'
4340: OR groupheader.bid_number = p_bidNumber)

Line 4454: pon_bid_headers bidheader,

4450:
4451: CURSOR bid_items_to_be_reranked(v_publish_date DATE) IS
4452: SELECT bidline.line_number
4453: FROM pon_bid_item_prices bidline,
4454: pon_bid_headers bidheader,
4455: pon_bid_headers bestbidheader,
4456: pon_auction_item_prices_all auctionline
4457: WHERE auctionline.auction_header_id = bidline.auction_header_id
4458: AND bidline.bid_number = p_bidNumber

Line 4455: pon_bid_headers bestbidheader,

4451: CURSOR bid_items_to_be_reranked(v_publish_date DATE) IS
4452: SELECT bidline.line_number
4453: FROM pon_bid_item_prices bidline,
4454: pon_bid_headers bidheader,
4455: pon_bid_headers bestbidheader,
4456: pon_auction_item_prices_all auctionline
4457: WHERE auctionline.auction_header_id = bidline.auction_header_id
4458: AND bidline.bid_number = p_bidNumber
4459: AND bidline.line_number = auctionline.line_number

Line 4471: pon_bid_headers bidheader,

4467:
4468: CURSOR mas_bid_items_to_be_reranked(v_publish_date DATE) IS
4469: SELECT bidline.line_number
4470: FROM pon_bid_item_prices bidline,
4471: pon_bid_headers bidheader,
4472: pon_bid_headers bestbidheader,
4473: pon_auction_item_prices_all auctionline
4474: WHERE auctionline.auction_header_id = bidline.auction_header_id
4475: AND bidline.bid_number = p_bidNumber

Line 4472: pon_bid_headers bestbidheader,

4468: CURSOR mas_bid_items_to_be_reranked(v_publish_date DATE) IS
4469: SELECT bidline.line_number
4470: FROM pon_bid_item_prices bidline,
4471: pon_bid_headers bidheader,
4472: pon_bid_headers bestbidheader,
4473: pon_auction_item_prices_all auctionline
4474: WHERE auctionline.auction_header_id = bidline.auction_header_id
4475: AND bidline.bid_number = p_bidNumber
4476: AND bidline.line_number = auctionline.line_number

Line 4556: pon_bid_headers bidheader

4552: bidheader.bid_currency_code,
4553: bidline.first_bid_price,
4554: bidline.proxy_bid_limit_price
4555: FROM pon_bid_item_prices bidline,
4556: pon_bid_headers bidheader
4557: WHERE bidline.auction_header_id = p_auctionHeaderId
4558: AND bidheader.auction_header_id = bidline.auction_header_id
4559: AND bidheader.bid_number = bidline.bid_number
4560: AND (

Line 4626: pon_bid_headers bidheader

4622: bidline.bid_number,
4623: bidline.bid_currency_price,
4624: bidheader.bid_currency_code
4625: FROM pon_bid_item_prices bidline,
4626: pon_bid_headers bidheader
4627: WHERE bidline.auction_header_id = p_auctionHeaderId
4628: AND bidheader.auction_header_id = bidline.auction_header_id
4629: AND bidheader.bid_number = bidline.bid_number
4630: AND (

Line 4821: FROM pon_bid_headers bidheader

4817: WHERE auction_header_id = p_auctionHeaderId
4818: AND bid_number <> p_bidNumber
4819: AND line_number = v_line_number
4820: AND EXISTS (SELECT 'x'
4821: FROM pon_bid_headers bidheader
4822: WHERE bidheader.bid_number = bidline.bid_number
4823: AND bidheader.bid_status = 'ACTIVE'
4824: AND decode (p_discard_tech_nonshort, 'Y', bidheader.technical_shortlist_flag, 'Y') = 'Y')
4825: AND rank BETWEEN DECODE(sign(v_new_rank - v_old_rank), 1, v_old_rank, v_new_rank)

Line 4861: pon_bid_headers bidheader

4857:
4858: SELECT count(*) + 1
4859: INTO v_newRank
4860: FROM pon_bid_item_prices bidline,
4861: pon_bid_headers bidheader
4862: WHERE bidline.auction_header_id = bidheader.auction_header_id
4863: AND bidheader.auction_header_id = p_auctionHeaderId
4864: AND bidheader.bid_number = bidline.bid_number
4865: AND bidline.line_number = rerank_line.line_number

Line 5111: v_publishDate pon_bid_headers.publish_date%TYPE;

5107: p_batchSize NUMBER,
5108: p_discard_tech_nonshort VARCHAR2)
5109: IS
5110:
5111: v_publishDate pon_bid_headers.publish_date%TYPE;
5112: v_bidCurrencyCode pon_bid_headers.bid_currency_code%TYPE;
5113:
5114: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
5115: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

Line 5112: v_bidCurrencyCode pon_bid_headers.bid_currency_code%TYPE;

5108: p_discard_tech_nonshort VARCHAR2)
5109: IS
5110:
5111: v_publishDate pon_bid_headers.publish_date%TYPE;
5112: v_bidCurrencyCode pon_bid_headers.bid_currency_code%TYPE;
5113:
5114: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
5115: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5116:

Line 5126: FROM pon_bid_headers

5122: SELECT publish_date,
5123: bid_currency_code
5124: INTO v_publishDate,
5125: v_bidCurrencyCode
5126: FROM pon_bid_headers
5127: WHERE bid_number = p_bidNumber;
5128:
5129: SELECT pah.bid_ranking,
5130: pah.rank_indicator

Line 5236: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console

5232: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;
5233: v_max_bid_color_sequence_id pon_auction_headers_all.max_bid_color_sequence_id%TYPE; -- Added for Live Cosnole
5234: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5235: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5236: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5237: v_publishDate DATE;
5238: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5239: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5240: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;

Line 5238: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;

5234: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5235: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5236: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5237: v_publishDate DATE;
5238: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5239: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5240: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5241: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5242: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;

Line 5241: v_oldBidNumber pon_bid_headers.bid_number%TYPE;

5237: v_publishDate DATE;
5238: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5239: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5240: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5241: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5242: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;
5243: v_oldBidStatus pon_bid_headers.bid_status%TYPE;
5244: v_hasCloseDateReached VARCHAR2(1);
5245: v_ispricechanged VARCHAR2(1);

Line 5242: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;

5238: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5239: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5240: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5241: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5242: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;
5243: v_oldBidStatus pon_bid_headers.bid_status%TYPE;
5244: v_hasCloseDateReached VARCHAR2(1);
5245: v_ispricechanged VARCHAR2(1);
5246:

Line 5243: v_oldBidStatus pon_bid_headers.bid_status%TYPE;

5239: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5240: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5241: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5242: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;
5243: v_oldBidStatus pon_bid_headers.bid_status%TYPE;
5244: v_hasCloseDateReached VARCHAR2(1);
5245: v_ispricechanged VARCHAR2(1);
5246:
5247: v_pfTypeAllowed pon_auction_headers_all.pf_type_allowed%TYPE;

Line 5296: FROM pon_bid_headers

5292:
5293: IF (v_oldBidNumber is not null) THEN
5294: SELECT bid_status
5295: INTO v_oldBidStatus
5296: FROM pon_bid_headers
5297: WHERE bid_number = v_oldBidNumber;
5298:
5299: IF(v_oldBidStatus = 'DISQUALIFIED') THEN
5300: v_oldBidNumber := NULL;

Line 5352: FROM pon_bid_headers

5348: color_sequence_id --Added for Live Console
5349: INTO v_publishDate,
5350: v_bidTradingPartnerId,
5351: v_color_sequence_id --Added for Live Console
5352: FROM pon_bid_headers
5353: WHERE bid_number = p_bidNumber;
5354:
5355: -- check whether this bid is being placed
5356: -- after close date has been reached, note that

Line 5526: UPDATE PON_BID_HEADERS

5522: -- on the bid monitor charts. If this bid does not have
5523: -- a color yet, assign one.
5524: IF (v_color_sequence_id IS NULL) THEN
5525: print_log(l_api_name, p_bidNumber || ' - updating color sequences');
5526: UPDATE PON_BID_HEADERS
5527: SET Color_Sequence_Id = v_max_bid_color_sequence_id +1
5528: WHERE bid_number = p_bidNumber;
5529:
5530: v_max_bid_color_sequence_id := v_max_bid_color_sequence_id +1;

Line 5569: FROM pon_bid_headers

5565: UPDATE pon_auction_headers_all
5566: SET max_bid_color_sequence_id = v_max_bid_color_sequence_id, --Added for Live Console
5567: last_update_date = sysdate,
5568: number_of_bids = (SELECT COUNT(auction_header_id)
5569: FROM pon_bid_headers
5570: WHERE auction_header_id = p_auctionHeaderId
5571: AND (bid_status in ('ACTIVE', 'ARCHIVED')
5572: OR bid_number = p_bidNumber))
5573: WHERE auction_header_id = p_auctionHeaderId;

Line 5818: pon_bid_headers pbh

5814: )
5815: INTO l_auc_pf_unit_price
5816: FROM pon_pf_supplier_formula ppsf,
5817: pon_auction_item_prices_all aip,
5818: pon_bid_headers pbh
5819: WHERE ppsf.auction_header_id = p_auction_header_id
5820: AND ppsf.line_number = p_line_number
5821: AND ppsf.trading_partner_id = pbh.trading_partner_id
5822: AND ppsf.vendor_site_id = pbh.vendor_site_id

Line 5949: v_bid_number pon_bid_headers.bid_number%TYPE;

5945: IS
5946:
5947: l_module_name VARCHAR2(40) := 'updt_tech_short_lines';
5948:
5949: v_bid_number pon_bid_headers.bid_number%TYPE;
5950: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
5951: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
5952: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
5953: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;

Line 5952: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;

5948:
5949: v_bid_number pon_bid_headers.bid_number%TYPE;
5950: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
5951: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
5952: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
5953: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
5954: t_price pon_bid_item_prices.price%TYPE;
5955: t_quantity pon_bid_item_prices.quantity%TYPE;
5956: t_promised_date pon_bid_item_prices.promised_date%TYPE;

Line 5959: t_bid_currency_code pon_bid_headers.bid_currency_code%TYPE;

5955: t_quantity pon_bid_item_prices.quantity%TYPE;
5956: t_promised_date pon_bid_item_prices.promised_date%TYPE;
5957: t_bid_number pon_bid_item_prices.bid_number%TYPE;
5958: t_bid_currency_price pon_bid_item_prices.bid_currency_price%TYPE;
5959: t_bid_currency_code pon_bid_headers.bid_currency_code%TYPE;
5960: t_first_bid_price pon_bid_item_prices.first_bid_price%TYPE;
5961: t_proxy_bid_limit_price pon_bid_item_prices.proxy_bid_limit_price%TYPE;
5962: t_score pon_bid_item_prices.total_weighted_score%TYPE;
5963:

Line 5995: pon_bid_headers pbh

5991: INTO
5992: v_bid_number
5993: FROM
5994: pon_bid_item_prices pbip,
5995: pon_bid_headers pbh
5996: WHERE
5997: pbh.auction_header_id = p_auction_header_id
5998: AND pbip.bid_number = pbh.bid_number
5999: AND nvl (pbh.shortlist_flag, 'Y') = 'N'

Line 6063: pon_bid_headers pbh

6059: nvl (pbh.shortlist_flag, 'Y')
6060: INTO
6061: v_bestbid_shortlist_flag
6062: FROM
6063: pon_bid_headers pbh
6064: WHERE
6065: pbh.bid_number = v_best_bid_number;
6066:
6067: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

Line 6088: pon_bid_headers pbh

6084: nvl (pbh.shortlist_flag, 'Y')
6085: INTO
6086: v_bestbid_shortlist_flag
6087: FROM
6088: pon_bid_headers pbh
6089: WHERE
6090: pbh.bid_number = v_best_bid_bid_number;
6091:
6092: END IF; -- }

Line 6144: pon_bid_headers bidheader

6140: bidline.first_bid_price,
6141: bidline.proxy_bid_limit_price
6142: FROM
6143: pon_bid_item_prices bidline,
6144: pon_bid_headers bidheader
6145: WHERE
6146: bidline.auction_header_id = p_auction_header_id
6147: AND bidheader.auction_header_id = bidline.auction_header_id
6148: AND bidheader.bid_number = bidline.bid_number

Line 6287: pon_bid_headers bidheader

6283: bidline.bid_currency_price,
6284: bidheader.bid_currency_code
6285: FROM
6286: pon_bid_item_prices bidline,
6287: pon_bid_headers bidheader
6288: WHERE
6289: bidline.auction_header_id = p_auction_header_id
6290: AND bidheader.auction_header_id = bidline.auction_header_id
6291: AND bidheader.bid_number = bidline.bid_number

Line 6364: pon_bid_headers pbh,

6360: BULK COLLECT INTO
6361: v_bid_numbers_bulk,
6362: v_rank_bulk
6363: FROM
6364: pon_bid_headers pbh,
6365: pon_bid_item_prices pbip
6366: WHERE
6367: pbh.auction_header_id = p_auction_header_id
6368: AND pbh.bid_number = pbip.bid_number

Line 6538: v_bid_number PON_BID_HEADERS.BID_NUMBER%TYPE;

6534:
6535: v_rank_indicator PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE;
6536: v_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
6537: v_max_internal_line_num PON_AUCTION_HEADERS_ALL.MAX_INTERNAL_LINE_NUM%TYPE;
6538: v_bid_number PON_BID_HEADERS.BID_NUMBER%TYPE;
6539:
6540: v_batch_size NUMBER;
6541: v_batching_required BOOLEAN;
6542:

Line 6563: pon_bid_headers

6559: bid_number
6560: INTO
6561: v_bid_number
6562: FROM
6563: pon_bid_headers
6564: WHERE
6565: auction_header_id = p_auction_header_id
6566: AND nvl (shortlist_flag, 'Y') = 'N'
6567: AND bid_status = 'ACTIVE'

Line 6613: -- Copy over the shortlist flag into technical_short_flag in pon_bid_headers

6609: ', bid_ranking = ' || v_bid_ranking ||
6610: ', max_internal_line_num = ' || v_max_internal_line_num);
6611: END IF; --}
6612:
6613: -- Copy over the shortlist flag into technical_short_flag in pon_bid_headers
6614: UPDATE
6615: pon_bid_headers pbh
6616: SET
6617: pbh.last_update_date = sysdate,

Line 6615: pon_bid_headers pbh

6611: END IF; --}
6612:
6613: -- Copy over the shortlist flag into technical_short_flag in pon_bid_headers
6614: UPDATE
6615: pon_bid_headers pbh
6616: SET
6617: pbh.last_update_date = sysdate,
6618: pbh.last_updated_by = fnd_global.user_id,
6619: pbh.technical_shortlist_flag = decode (pbh.bid_status, 'ACTIVE', nvl (pbh.shortlist_flag, 'Y'), 'N')

Line 6626: message => 'Done with updating pon_bid_headers.');

6622:
6623: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6624: FND_LOG.string(log_level => FND_LOG.level_statement,
6625: module => g_module_prefix || l_module_name,
6626: message => 'Done with updating pon_bid_headers.');
6627: END IF; --}
6628:
6629: --While commercial unlocking the 2 part RFQ, reset the scores to 'not entered'
6630: -- so that user will enter scores for commercial stage.