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 385: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE; --Multiple Active Offers

381: v_fixedValue pon_auc_doctype_rules.fixed_value%TYPE;
382: v_amendmentNumber NUMBER;
383: v_auctionHeaderIdOrigAmend NUMBER;
384:
385: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE; --Multiple Active Offers
386: v_allow_multiple_resp VARCHAR2(1);
387:
388: l_api_name CONSTANT VARCHAR2(30) := 'archive_prev_active_bids';
389: BEGIN

Line 399: FROM pon_bid_headers

395: Nvl(surrog_bid_flag,'N') --Multiple Active Offers
396: INTO v_bidTradingPartnerId,
397: v_bidTradingPartnerContactId,
398: v_surrog_bid_flag --Multiple Active Offers
399: FROM pon_bid_headers
400: WHERE bid_number = p_bidNumber;
401:
402: SELECT doctype_id,
403: nvl(amendment_number, 0),

Line 429: UPDATE PON_BID_HEADERS

425: -- Update the previous active bid to archived for current auction
426: IF (p_oldBidNumber is not null) THEN
427: /* Multiple Active Offers : Archive old bid even when it is on previous auction.*/
428: IF v_allow_multiple_resp = 'Y' THEN
429: UPDATE PON_BID_HEADERS
430: SET BID_STATUS = 'ARCHIVED',
431: LAST_UPDATE_DATE = SYSDATE
432: WHERE bid_number = p_oldBidNumber
433: AND bid_status IN ('ACTIVE','RESUBMISSION');

Line 435: UPDATE PON_BID_HEADERS

431: LAST_UPDATE_DATE = SYSDATE
432: WHERE bid_number = p_oldBidNumber
433: AND bid_status IN ('ACTIVE','RESUBMISSION');
434: ELSE
435: UPDATE PON_BID_HEADERS
436: SET BID_STATUS = 'ARCHIVED',
437: LAST_UPDATE_DATE = SYSDATE
438: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
439: AND BID_NUMBER = p_oldBidNumber

Line 450: UPDATE PON_BID_HEADERS

446: IF (v_amendmentNumber > 0) THEN
447:
448: /* Multiple Active Offers : Archive when multiple active offers are not allowed. */
449: IF v_allow_multiple_resp <> 'Y' THEN
450: UPDATE PON_BID_HEADERS
451: SET BID_STATUS = 'ARCHIVED',
452: LAST_UPDATE_DATE = SYSDATE
453: WHERE AUCTION_HEADER_ID in (
454: SELECT AUCTION_HEADER_ID

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

492: -- PARAMETERS:
493: -- VERSION : current version 1.x
494: -- initial version 1.0
495: -- COMMENT : called by update_auction_info, this procedure calculates
496: -- the partial response flag and sets it in pon_bid_headers
497: --========================================================================
498:
499: PROCEDURE set_partial_response_flag(p_bidNumber IN NUMBER)
500: IS

Line 505: UPDATE pon_bid_headers bh

501: l_api_name CONSTANT VARCHAR2(30) := 'set_partial_response_flag';
502: BEGIN
503:
504: print_log(l_api_name || '.BEGIN', p_bidNumber ||' Begin - set_partial_response_flag');
505: UPDATE pon_bid_headers bh
506: SET partial_response_flag = 'N'
507: WHERE bh.bid_number = p_bidNumber;
508:
509: UPDATE pon_bid_headers bh

Line 509: UPDATE pon_bid_headers bh

505: UPDATE pon_bid_headers bh
506: SET partial_response_flag = 'N'
507: WHERE bh.bid_number = p_bidNumber;
508:
509: UPDATE pon_bid_headers bh
510: SET partial_response_flag = 'Y'
511: WHERE bh.bid_number = p_bidNumber
512: AND (EXISTS (select 'x'
513: from pon_bid_item_prices bl,

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

708: FROM fnd_documents dc, fnd_documents_tl dt, fnd_attached_documents fndat
709: WHERE fndat.document_id = dt.document_id
710: AND dt.document_id = dc.document_id
711: AND dt.language = userenv('LANG')
712: AND fndat.entity_name IN ('PON_BID_ITEM_PRICES', 'PON_BID_HEADERS')
713: AND fndat.pk1_value = to_char(p_auctionHeaderId)
714: AND fndat.pk2_value = to_char(p_oldBidNum);
715: --
716: SHORT_TEXT number := 1;

Line 818: SELECT pon_bid_headers_s.nextval

814: print_log(l_api_name, 'p_bidNumber=' || p_bidNumber);
815: print_log(l_api_name, 'p_new_publish_date=' || p_new_publish_date);
816: print_log(l_api_name, 'p_triggerBidNumber=' || p_triggerBidNumber);
817:
818: SELECT pon_bid_headers_s.nextval
819: INTO v_nextBid
820: FROM dual;
821: --
822:

Line 826: INSERT INTO pon_bid_headers (

822:
823: -- need to activate deliverables for the new bid triggered due to proxy
824: -- xxx
825: --
826: INSERT INTO pon_bid_headers (
827: bid_status,
828: bid_status_name,
829: bid_number,
830: shortlist_flag,

Line 951: FROM PON_BID_HEADERS

947: -1,
948: partial_response_flag,
949: color_sequence_id,
950: old_bid_number
951: FROM PON_BID_HEADERS
952: WHERE auction_header_id= p_auctionHeaderId
953: AND bid_number = p_bidNumber;
954: --
955: INSERT INTO pon_bid_item_prices (

Line 1132: UPDATE pon_bid_headers

1128: --
1129: print_log(l_api_name, 'calling subroutine copy_attachments');
1130: copy_attachments(p_auctionHeaderId, p_bidNumber, v_nextBid);
1131: --
1132: UPDATE pon_bid_headers
1133: SET bid_status = 'ARCHIVED',
1134: bid_status_name = (SELECT meaning
1135: FROM fnd_lookups
1136: WHERE lookup_type='PON_BID_STATUS'

Line 1290: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1286: PROCEDURE get_previous_bid( p_auctionHeaderId IN NUMBER,
1287: p_bidNumber IN NUMBER,
1288: v_oldBidNumber OUT NOCOPY NUMBER) IS
1289:
1290: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1291: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1292: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;
1293:
1294: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_bid';

Line 1291: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1287: p_bidNumber IN NUMBER,
1288: v_oldBidNumber OUT NOCOPY NUMBER) IS
1289:
1290: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1291: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1292: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;
1293:
1294: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_bid';
1295:

Line 1292: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;

1288: v_oldBidNumber OUT NOCOPY NUMBER) IS
1289:
1290: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1291: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1292: v_vendorSiteId pon_bid_headers.vendor_site_id%TYPE;
1293:
1294: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_bid';
1295:
1296: BEGIN

Line 1313: FROM pon_bid_headers

1309: vendor_site_id
1310: INTO v_tpid,
1311: v_tpcid,
1312: v_vendorSiteId
1313: FROM pon_bid_headers
1314: WHERE auction_header_id = p_auctionHeaderId
1315: AND bid_number = p_bidNumber;
1316:
1317:

Line 1326: FROM pon_bid_headers

1322: -- due to draft bid project ?
1323:
1324: SELECT max(bid_number)
1325: INTO v_oldBidNumber
1326: FROM pon_bid_headers
1327: WHERE auction_header_id = p_auctionHeaderId
1328: AND trading_partner_id = v_tpid
1329: AND trading_partner_contact_id = v_tpcid
1330: AND nvl(vendor_site_id,-1) = nvl(v_vendorSiteId, -1)

Line 1345: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1341: p_bidNumber IN NUMBER,
1342: p_vendorSiteId IN NUMBER,
1343: v_oldNonProxyBidNumber OUT NOCOPY NUMBER) IS
1344:
1345: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1346: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1347: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_nonproxy_bid';
1348:
1349: --------- Supplier Management: Supplier Evaluation ---------

Line 1346: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1342: p_vendorSiteId IN NUMBER,
1343: v_oldNonProxyBidNumber OUT NOCOPY NUMBER) IS
1344:
1345: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1346: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1347: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_nonproxy_bid';
1348:
1349: --------- Supplier Management: Supplier Evaluation ---------
1350: v_evaluator_id pon_bid_headers.evaluator_id%TYPE;

Line 1350: v_evaluator_id pon_bid_headers.evaluator_id%TYPE;

1346: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1347: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_nonproxy_bid';
1348:
1349: --------- Supplier Management: Supplier Evaluation ---------
1350: v_evaluator_id pon_bid_headers.evaluator_id%TYPE;
1351: v_eval_flag pon_bid_headers.evaluation_flag%TYPE;
1352: ------------------------------------------------------------
1353:
1354: --Offer Enhancements

Line 1351: v_eval_flag pon_bid_headers.evaluation_flag%TYPE;

1347: l_api_name CONSTANT VARCHAR2(30) := 'get_previous_nonproxy_bid';
1348:
1349: --------- Supplier Management: Supplier Evaluation ---------
1350: v_evaluator_id pon_bid_headers.evaluator_id%TYPE;
1351: v_eval_flag pon_bid_headers.evaluation_flag%TYPE;
1352: ------------------------------------------------------------
1353:
1354: --Offer Enhancements
1355: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

Line 1355: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;

1351: v_eval_flag pon_bid_headers.evaluation_flag%TYPE;
1352: ------------------------------------------------------------
1353:
1354: --Offer Enhancements
1355: v_surrog_bid_flag pon_bid_headers.surrog_bid_flag%TYPE;
1356:
1357: BEGIN
1358:
1359: -- logging

Line 1381: FROM pon_bid_headers

1377: v_tpcid,
1378: v_evaluator_id,
1379: v_eval_flag,
1380: v_surrog_bid_flag --Offer Enhancements
1381: FROM pon_bid_headers
1382: WHERE auction_header_id = p_auctionHeaderId
1383: AND bid_number = p_bidnumber;
1384:
1385:

Line 1405: FROM pon_bid_headers

1401: -- Add evaluator_id and evaluation_flag to the query --
1402: --------------------------------------------------------
1403: SELECT max(bid_number)
1404: INTO v_oldNonProxyBidNumber
1405: FROM pon_bid_headers
1406: WHERE auction_header_id = p_auctionHeaderId
1407: AND trading_partner_id = v_tpid
1408: AND trading_partner_contact_id = v_tpcid
1409: AND nvl(vendor_site_id, -1) = nvl(p_vendorSiteId, -1)

Line 1438: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1434: p_bidNumber IN NUMBER,
1435: v_activeBidNumber OUT NOCOPY NUMBER,
1436: v_recentBidStatus OUT NOCOPY VARCHAR2) IS
1437:
1438: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1439: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1440: l_api_name CONSTANT VARCHAR2(30) := 'get_most_recent_active_bid';
1441:
1442: BEGIN

Line 1439: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1435: v_activeBidNumber OUT NOCOPY NUMBER,
1436: v_recentBidStatus OUT NOCOPY VARCHAR2) IS
1437:
1438: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1439: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1440: l_api_name CONSTANT VARCHAR2(30) := 'get_most_recent_active_bid';
1441:
1442: BEGIN
1443: --

Line 1455: FROM pon_bid_headers

1451: SELECT trading_partner_id,
1452: trading_partner_contact_id
1453: INTO v_tpid,
1454: v_tpcid
1455: FROM pon_bid_headers
1456: WHERE auction_header_id = p_auctionHeaderId
1457: AND bid_number = p_bidnumber;
1458:
1459: --

Line 1474: FROM pon_bid_headers

1470: BEGIN
1471:
1472: SELECT max(bid_number)
1473: INTO v_activeBidNumber
1474: FROM pon_bid_headers
1475: WHERE auction_header_id = p_auctionHeaderId
1476: AND trading_partner_id = v_tpid
1477: AND trading_partner_contact_id = v_tpcid
1478: AND ((proxy_bid_flag IS null) OR (proxy_bid_flag <> 'Y'))

Line 1483: FROM pon_bid_headers

1479: AND nvl(award_status, 'NONE') <> 'COMMITTED';
1480:
1481: SELECT bid_status
1482: INTO v_recentBidStatus
1483: FROM pon_bid_headers
1484: WHERE bid_number = v_activeBidNumber;
1485:
1486: EXCEPTION
1487:

Line 1523: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

1519:
1520: v_publish_date DATE;
1521: v_oldBid NUMBER;
1522: v_rank NUMBER;
1523: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1524: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1525:
1526: l_api_name CONSTANT VARCHAR2(30) := 'update_unchanged_rank';
1527:

Line 1524: v_tpid pon_bid_headers.trading_partner_id%TYPE;

1520: v_publish_date DATE;
1521: v_oldBid NUMBER;
1522: v_rank NUMBER;
1523: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
1524: v_tpid pon_bid_headers.trading_partner_id%TYPE;
1525:
1526: l_api_name CONSTANT VARCHAR2(30) := 'update_unchanged_rank';
1527:
1528: BEGIN

Line 1544: FROM pon_bid_headers

1540: trading_partner_contact_id
1541: INTO v_publish_date,
1542: v_tpid,
1543: v_tpcid
1544: FROM pon_bid_headers
1545: WHERE bid_number = p_bidNumber;
1546:
1547:
1548: -- Get the user's most recent non-disqualified bid...if it exists

Line 1551: FROM pon_bid_headers

1547:
1548: -- Get the user's most recent non-disqualified bid...if it exists
1549: SELECT max(bid_number)
1550: INTO v_oldBid
1551: FROM pon_bid_headers
1552: WHERE auction_header_id = p_auctionHeaderId
1553: AND trading_partner_id = v_tpid
1554: AND trading_partner_contact_id = v_tpcid
1555: AND bid_status <> 'DISQUALIFIED'

Line 1675: FROM pon_bid_headers

1671: x_bid_number NUMBER := NULL;
1672:
1673: CURSOR bid_number IS
1674: SELECT bid_number
1675: FROM pon_bid_headers
1676: WHERE auction_header_id = x_auction_header_id
1677: AND trading_partner_id = x_trading_partner_id
1678: AND trading_partner_contact_id = x_trading_partner_contact_id
1679: AND bid_status IN ('ACTIVE', 'DRAFT', 'DISQUALIFIED')

Line 1800: FROM pon_bid_headers

1796: print_log(l_api_name, 'p_tradingPartnerContactId=' || p_tradingPartnerContactId);
1797:
1798: SELECT bid_number
1799: INTO x_bidNumber
1800: FROM pon_bid_headers
1801: WHERE auction_header_id = p_auctionHeaderId
1802: AND trading_partner_id = p_tradingPartnerId
1803: AND trading_partner_contact_id = p_tradingPartnerContactId
1804: AND bid_status = 'ACTIVE';

Line 2055: v_oldBidNumber pon_bid_headers.bid_number%TYPE;

2051: x_return_status OUT NOCOPY NUMBER,
2052: x_return_code OUT NOCOPY VARCHAR2)
2053:
2054: IS
2055: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
2056: v_bidStatus pon_bid_headers.bid_status%TYPE;
2057: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2058: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2059: v_recentBidStatus pon_bid_headers.bid_status%TYPE;

Line 2056: v_bidStatus pon_bid_headers.bid_status%TYPE;

2052: x_return_code OUT NOCOPY VARCHAR2)
2053:
2054: IS
2055: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
2056: v_bidStatus pon_bid_headers.bid_status%TYPE;
2057: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2058: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2059: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2060: v_is_paused pon_auction_headers_all.is_paused%TYPE;

Line 2057: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;

2053:
2054: IS
2055: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
2056: v_bidStatus pon_bid_headers.bid_status%TYPE;
2057: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2058: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2059: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2060: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2061:

Line 2058: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;

2054: IS
2055: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
2056: v_bidStatus pon_bid_headers.bid_status%TYPE;
2057: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2058: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2059: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2060: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2061:
2062: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;

Line 2059: v_recentBidStatus pon_bid_headers.bid_status%TYPE;

2055: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
2056: v_bidStatus pon_bid_headers.bid_status%TYPE;
2057: v_oldNonProxyBidNumber pon_bid_headers.bid_number%TYPE;
2058: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2059: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2060: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2061:
2062: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
2063: v_sameCompanyBids NUMBER;

Line 2062: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;

2058: v_recentActiveBidNumber pon_bid_headers.bid_number%TYPE;
2059: v_recentBidStatus pon_bid_headers.bid_status%TYPE;
2060: v_is_paused pon_auction_headers_all.is_paused%TYPE;
2061:
2062: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
2063: v_sameCompanyBids NUMBER;
2064: v_sameCompanyDrafts NUMBER;
2065: v_bidFrequencyCode pon_auction_headers_all.bid_frequency_code%TYPE;
2066: v_negotiation_closed_line_num NUMBER;

Line 2136: FROM pon_bid_headers

2132: --
2133: IF (v_oldBidNumber is not null) THEN
2134: SELECT bid_status
2135: INTO v_bidStatus
2136: FROM pon_bid_headers
2137: WHERE bid_number = v_oldBidNumber;
2138:
2139: IF(nvl(p_isRebid,'N') = 'Y') THEN
2140:

Line 2241: FROM PON_BID_HEADERS

2237: IF v_bidFrequencyCode = 'SINGLE_BID_ONLY' THEN
2238: -- get a hold of company's tp id
2239: SELECT TRADING_PARTNER_ID
2240: INTO v_bidTradingPartnerId
2241: FROM PON_BID_HEADERS
2242: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2243: AND BID_NUMBER = p_bidNumber;
2244: --
2245: -- check if there is more than one row in pon_bid_headers

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

2241: FROM PON_BID_HEADERS
2242: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2243: AND BID_NUMBER = p_bidNumber;
2244: --
2245: -- check if there is more than one row in pon_bid_headers
2246: -- one from previous user's bid, one ours
2247:
2248: SELECT COUNT(bid_number)
2249: INTO v_sameCompanyBids

Line 2250: FROM PON_BID_HEADERS

2246: -- one from previous user's bid, one ours
2247:
2248: SELECT COUNT(bid_number)
2249: INTO v_sameCompanyBids
2250: FROM PON_BID_HEADERS
2251: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2252: AND BID_STATUS = 'ACTIVE'
2253: AND TRADING_PARTNER_ID = v_bidTradingPartnerId
2254: AND NVL(VENDOR_SITE_ID, -1) = NVL(p_vendorSiteId, -1)

Line 2268: FROM PON_BID_HEADERS

2264: -- created in the meanwhile
2265:
2266: SELECT COUNT(bid_number)
2267: INTO v_sameCompanyDrafts
2268: FROM PON_BID_HEADERS
2269: WHERE AUCTION_HEADER_ID = p_auctionHeaderId
2270: AND (BID_STATUS = 'ACTIVE')
2271: AND TRADING_PARTNER_ID = v_bidTradingPartnerId
2272: AND NVL(VENDOR_SITE_ID, -1) = NVL(p_vendorSiteId, -1)

Line 2315: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,

2311: ( p_auctionHeaderId IN NUMBER,
2312: p_bidNumber IN NUMBER,
2313: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2314: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2315: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2316: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2317: p_batchStart IN NUMBER,
2318: p_batchEnd IN NUMBER,
2319: p_ignore_tech_nonshortlist IN VARCHAR2)

Line 2316: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,

2312: p_bidNumber IN NUMBER,
2313: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2314: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2315: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2316: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2317: p_batchStart IN NUMBER,
2318: p_batchEnd IN NUMBER,
2319: p_ignore_tech_nonshortlist IN VARCHAR2)
2320: IS

Line 2352: FROM pon_bid_item_prices pbip, pon_bid_headers pbh

2348:
2349:
2350: CURSOR all_lines_cursor IS
2351: SELECT pbip.line_number, pbip.rank, pbh.technical_shortlist_flag
2352: FROM pon_bid_item_prices pbip, pon_bid_headers pbh
2353: WHERE pbh.auction_header_id = p_auctionHeaderId
2354: AND pbip.auction_header_id = pbh.auction_header_id
2355: AND pbh.bid_number = p_bidNumber
2356: AND pbip.bid_number = pbh.bid_number

Line 2442: pon_bid_headers bidheader

2438: bidheader.bid_currency_code,
2439: bidline.first_bid_price,
2440: bidline.proxy_bid_limit_price
2441: FROM pon_bid_item_prices bidline,
2442: pon_bid_headers bidheader
2443: WHERE bidline.auction_header_id = p_auctionHeaderId
2444: AND bidheader.auction_header_id = bidline.auction_header_id
2445: AND bidheader.bid_number = bidline.bid_number
2446: AND bidheader.bid_status = 'ACTIVE'

Line 2532: pon_bid_headers bidheader

2528: bidline.bid_number,
2529: bidline.bid_currency_price,
2530: bidheader.bid_currency_code
2531: FROM pon_bid_item_prices bidline,
2532: pon_bid_headers bidheader
2533: WHERE bidline.auction_header_id = p_auctionHeaderId
2534: AND bidheader.auction_header_id = bidline.auction_header_id
2535: AND bidheader.bid_number = bidline.bid_number
2536: AND bidheader.bid_status = 'ACTIVE'

Line 2584: FROM pon_bid_headers bh,

2580: v_counter := 1;
2581: FOR bid_item_record IN all_lines_cursor LOOP -- {
2582:
2583: SELECT number_of_bids - (SELECT COUNT(bh.bid_number)
2584: FROM pon_bid_headers bh,
2585: pon_bid_item_prices bip
2586: WHERE bh.auction_header_id = p_auctionHeaderId
2587: AND bh.trading_partner_contact_id = p_tpcId
2588: AND bh.trading_partner_id = p_tpId

Line 2613: FROM pon_bid_headers h

2609: SET rank = rank - 1
2610: WHERE auction_header_id = p_auctionHeaderId
2611: AND line_number = bid_item_record.line_number
2612: AND EXISTS (SELECT 1
2613: FROM pon_bid_headers h
2614: WHERE h.bid_number = bip.bid_number
2615: AND h.bid_status = 'ACTIVE')
2616: AND rank > bid_item_record.rank;
2617:

Line 2638: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,

2634: ( p_auctionHeaderId IN NUMBER,
2635: p_bidNumber IN NUMBER,
2636: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2637: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2638: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2639: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2640: p_maxLineNumber IN NUMBER,
2641: p_batchSize IN NUMBER,
2642: p_ignore_tech_nonshortlist IN VARCHAR2)

Line 2639: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,

2635: p_bidNumber IN NUMBER,
2636: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,
2637: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,
2638: p_tpId IN pon_bid_headers.trading_partner_id%TYPE,
2639: p_tpcId IN pon_bid_headers.trading_partner_contact_id%TYPE,
2640: p_maxLineNumber IN NUMBER,
2641: p_batchSize IN NUMBER,
2642: p_ignore_tech_nonshortlist IN VARCHAR2)
2643: IS

Line 2680: v_tpcId pon_bid_headers.trading_partner_contact_id%TYPE;

2676: IS
2677:
2678: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info_disqualify';
2679:
2680: v_tpcId pon_bid_headers.trading_partner_contact_id%TYPE;
2681: v_tpId pon_bid_headers.trading_partner_id%TYPE;
2682: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
2683: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
2684: v_maxLineNumber NUMBER;

Line 2681: v_tpId pon_bid_headers.trading_partner_id%TYPE;

2677:
2678: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info_disqualify';
2679:
2680: v_tpcId pon_bid_headers.trading_partner_contact_id%TYPE;
2681: v_tpId pon_bid_headers.trading_partner_id%TYPE;
2682: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
2683: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
2684: v_maxLineNumber NUMBER;
2685: v_batchSize NUMBER;

Line 2737: FROM pon_bid_headers

2733: SELECT trading_partner_contact_id,
2734: trading_partner_id
2735: INTO v_tpcId,
2736: v_tpId
2737: FROM pon_bid_headers
2738: WHERE bid_number = p_bidNumber;
2739:
2740: -- UPDATE AUCTION'S NUMBER OF BIDS
2741: -- BUG: 1540882

Line 2754: FROM pon_bid_headers

2750: UPDATE pon_auction_headers_all
2751: SET last_update_date = sysdate,
2752: number_of_bids = (number_of_bids -
2753: (SELECT count(*)+1
2754: FROM pon_bid_headers
2755: WHERE auction_header_id = p_auctionHeaderId
2756: AND trading_partner_contact_id = v_tpcId
2757: AND bid_status = 'ARCHIVED'))
2758: WHERE auction_header_id = p_auctionHeaderId;

Line 2786: UPDATE pon_bid_headers

2782: print_log(l_api_name, p_bidNumber || ': disqualifying previous archived bids');
2783: /*
2784: Bug 13414255
2785:
2786: UPDATE pon_bid_headers
2787: SET bid_status = 'DISQUALIFIED'
2788: WHERE auction_header_id = p_auctionHeaderId
2789: AND trading_partner_contact_id = v_tpcId
2790: AND bid_status = 'ARCHIVED';

Line 2843: from pon_bid_item_prices ip, pon_bid_headers h

2839: --
2840: print_log(l_api_name, 'calling subroutine is_better_proxy_price_by_score');
2841: select count(*) + 1
2842: into v_new_rank
2843: from pon_bid_item_prices ip, pon_bid_headers h
2844: where ip.auction_header_id = h.auction_header_id
2845: and h.auction_header_id = p_auctionHeaderId
2846: and h.bid_number = ip.bid_number
2847: and ip.line_number = p_lineNumber

Line 2880: from pon_bid_headers h

2876: set rank = rank + 1
2877: where auction_header_id = p_auctionHeaderId
2878: and line_number = p_lineNumber
2879: and exists (select 1
2880: from pon_bid_headers h
2881: where h.bid_number = ip.bid_number
2882: and h.bid_status = 'ACTIVE')
2883: and rank between v_new_rank and p_oldRank;
2884: --

Line 2892: from pon_bid_headers h

2888: set rank = rank - 1
2889: where auction_header_id = p_auctionHeaderId
2890: and line_number = p_lineNumber
2891: and exists (select 1
2892: from pon_bid_headers h
2893: where h.bid_number = ip.bid_number
2894: and h.bid_status = 'ACTIVE')
2895: and rank between p_oldRank and v_new_rank ;
2896: --

Line 3329: UPDATE pon_bid_headers

3325: IS
3326: l_api_name CONSTANT VARCHAR2(30) := 'recover_prev_amend_draft';
3327: BEGIN
3328: print_log(l_api_name, ' BEGIN recover_prev_amend_draft');
3329: UPDATE pon_bid_headers
3330: SET
3331: bid_status = 'DRAFT',
3332: last_update_date = SYSDATE,
3333: last_updated_by = p_login_user_id

Line 3348: pon_bid_headers bh,

3344: 'DISQUALIFIED', 1) bid_status_order,
3345: nvl(ah.amendment_number, 0) amendment_number,
3346: bh.publish_date
3347: FROM
3348: pon_bid_headers bh,
3349: pon_auction_headers_all ah
3350: WHERE
3351: bh.auction_header_id = ah.auction_header_id
3352: AND ah.auction_header_id_orig_amend = p_auction_header_id_orig_amend

Line 3396: UPDATE pon_bid_headers pbh

3392: * populate buyer_bid_total column.
3393: */
3394: IF l_unsol_line_count = 0 THEN
3395:
3396: UPDATE pon_bid_headers pbh
3397: SET buyer_bid_total = (SELECT sum(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(pbip.quantity, paip.quantity)) *
3398: pbip.price)
3399: -- hack to set bid total to null if at least one line has a quantity of null
3400: + decode(min(decode(paip.order_type_lookup_code, 'FIXED PRICE', 1, nvl(paip.quantity, -9999))), -9999, NULL, 0) bid_total

Line 3473: UPDATE pon_bid_headers pbh

3469: pbip.auction_line_number = -1 AND
3470: Nvl(pbip.clm_info_flag,'N') = 'N';
3471:
3472: IF l_unsol_line_total IS NOT NULL THEN
3473: UPDATE pon_bid_headers pbh
3474: SET buyer_bid_total = (l_neg_line_total + l_unsol_line_total)
3475: WHERE pbh.auction_header_id = p_auction_header_id AND
3476: pbh.bid_number = p_bid_number;
3477: END IF;

Line 3719: FROM pon_bid_headers bh,

3715: p_bidPublishDate + p_hdrExtensionTime)
3716: WHERE auction_header_id = p_auctionHeaderId
3717: AND line_number IN
3718: (SELECT al.line_number
3719: FROM pon_bid_headers bh,
3720: pon_bid_item_prices bl,
3721: pon_auction_item_prices_all al
3722: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3723: AND bl.bid_number = bh.bid_number

Line 3900: pon_bid_headers bh,

3896: v_autoExtendMinTriggerRank,
3897: v_staggeredClosingInterval,
3898: v_bidPublishDate
3899: from
3900: pon_bid_headers bh,
3901: pon_auction_headers_all pah
3902: where bh.bid_number = p_bidNumber
3903: AND pah.auction_header_id = bh.auction_header_id;
3904:

Line 4089: v_tpid pon_bid_headers.trading_partner_id%TYPE;

4085: v_bid_min_change NUMBER;
4086: v_oldBidNum NUMBER;
4087: v_newBidNum NUMBER;
4088: v_idx NUMBER;
4089: v_tpid pon_bid_headers.trading_partner_id%TYPE;
4090: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4093: v_rate pon_bid_headers.rate%TYPE;

Line 4090: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;

4086: v_oldBidNum NUMBER;
4087: v_newBidNum NUMBER;
4088: v_idx NUMBER;
4089: v_tpid pon_bid_headers.trading_partner_id%TYPE;
4090: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4093: v_rate pon_bid_headers.rate%TYPE;
4094: v_best_bid_rate pon_bid_headers.rate%TYPE;

Line 4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;

4087: v_newBidNum NUMBER;
4088: v_idx NUMBER;
4089: v_tpid pon_bid_headers.trading_partner_id%TYPE;
4090: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4093: v_rate pon_bid_headers.rate%TYPE;
4094: v_best_bid_rate pon_bid_headers.rate%TYPE;
4095: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;

Line 4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;

4088: v_idx NUMBER;
4089: v_tpid pon_bid_headers.trading_partner_id%TYPE;
4090: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4093: v_rate pon_bid_headers.rate%TYPE;
4094: v_best_bid_rate pon_bid_headers.rate%TYPE;
4095: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
4096: v_auction_type pon_auction_headers_all.auction_type%TYPE;

Line 4093: v_rate pon_bid_headers.rate%TYPE;

4089: v_tpid pon_bid_headers.trading_partner_id%TYPE;
4090: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4093: v_rate pon_bid_headers.rate%TYPE;
4094: v_best_bid_rate pon_bid_headers.rate%TYPE;
4095: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
4096: v_auction_type pon_auction_headers_all.auction_type%TYPE;
4097: v_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;

Line 4094: v_best_bid_rate pon_bid_headers.rate%TYPE;

4090: v_tpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4093: v_rate pon_bid_headers.rate%TYPE;
4094: v_best_bid_rate pon_bid_headers.rate%TYPE;
4095: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
4096: v_auction_type pon_auction_headers_all.auction_type%TYPE;
4097: v_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
4098: v_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;

Line 4095: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;

4091: v_bestTpid pon_bid_headers.trading_partner_id%TYPE;
4092: v_bestTpcid pon_bid_headers.trading_partner_contact_id%TYPE;
4093: v_rate pon_bid_headers.rate%TYPE;
4094: v_best_bid_rate pon_bid_headers.rate%TYPE;
4095: v_best_bid_decimals pon_bid_headers.number_price_decimals%TYPE;
4096: v_auction_type pon_auction_headers_all.auction_type%TYPE;
4097: v_bid_change_type pon_auction_headers_all.min_bid_change_type%TYPE;
4098: v_trading_partner_id pon_auction_headers_all.trading_partner_id%TYPE;
4099: v_auction_decimals NUMBER;

Line 4130: from pon_bid_headers bestbid,

4126: bestbid.trading_partner_contact_id as best_bid_tpc_id,
4127: NVL(bestbid.min_bid_change,0) as best_bid_min_change,
4128: NVL(bestbid.rate,1.0) as best_bid_rate,
4129: NVL(bestbid.number_price_decimals,10) as best_bid_decimals
4130: from pon_bid_headers bestbid,
4131: pon_bid_item_prices biditem,
4132: pon_auction_item_prices_all item
4133: where bestbid.bid_number = item.best_bid_number
4134: and item.auction_header_id = biditem.auction_header_id

Line 4186: FROM pon_bid_headers bid,pon_auction_headers_all auc

4182: v_rate,
4183: v_publish_date,
4184: v_bid_decimals,
4185: v_revision_number
4186: FROM pon_bid_headers bid,pon_auction_headers_all auc
4187: WHERE auc.auction_header_id = bid.auction_header_id
4188: AND bid.bid_number = p_bidNumber;
4189:
4190: -- initialize this price changed flag to not changed

Line 4503: pon_bid_headers groupheader

4499:
4500: CURSOR bid_group_cursor(v_line_number NUMBER) IS
4501: SELECT groupline.bid_number
4502: FROM pon_bid_item_prices groupline,
4503: pon_bid_headers groupheader
4504: WHERE groupline.auction_header_id = p_auctionHeaderId
4505: AND groupline.bid_number = groupheader.bid_number
4506: AND (groupheader.bid_status = 'ACTIVE'
4507: OR groupheader.bid_number = p_bidNumber)

Line 4621: pon_bid_headers bidheader,

4617:
4618: CURSOR bid_items_to_be_reranked(v_publish_date DATE) IS
4619: SELECT bidline.line_number
4620: FROM pon_bid_item_prices bidline,
4621: pon_bid_headers bidheader,
4622: pon_bid_headers bestbidheader,
4623: pon_auction_item_prices_all auctionline
4624: WHERE auctionline.auction_header_id = bidline.auction_header_id
4625: AND bidline.bid_number = p_bidNumber

Line 4622: pon_bid_headers bestbidheader,

4618: CURSOR bid_items_to_be_reranked(v_publish_date DATE) IS
4619: SELECT bidline.line_number
4620: FROM pon_bid_item_prices bidline,
4621: pon_bid_headers bidheader,
4622: pon_bid_headers bestbidheader,
4623: pon_auction_item_prices_all auctionline
4624: WHERE auctionline.auction_header_id = bidline.auction_header_id
4625: AND bidline.bid_number = p_bidNumber
4626: AND bidline.line_number = auctionline.line_number

Line 4638: pon_bid_headers bidheader,

4634:
4635: CURSOR mas_bid_items_to_be_reranked(v_publish_date DATE) IS
4636: SELECT bidline.line_number
4637: FROM pon_bid_item_prices bidline,
4638: pon_bid_headers bidheader,
4639: pon_bid_headers bestbidheader,
4640: pon_auction_item_prices_all auctionline
4641: WHERE auctionline.auction_header_id = bidline.auction_header_id
4642: AND bidline.bid_number = p_bidNumber

Line 4639: pon_bid_headers bestbidheader,

4635: CURSOR mas_bid_items_to_be_reranked(v_publish_date DATE) IS
4636: SELECT bidline.line_number
4637: FROM pon_bid_item_prices bidline,
4638: pon_bid_headers bidheader,
4639: pon_bid_headers bestbidheader,
4640: pon_auction_item_prices_all auctionline
4641: WHERE auctionline.auction_header_id = bidline.auction_header_id
4642: AND bidline.bid_number = p_bidNumber
4643: AND bidline.line_number = auctionline.line_number

Line 4723: pon_bid_headers bidheader

4719: bidheader.bid_currency_code,
4720: bidline.first_bid_price,
4721: bidline.proxy_bid_limit_price
4722: FROM pon_bid_item_prices bidline,
4723: pon_bid_headers bidheader
4724: WHERE bidline.auction_header_id = p_auctionHeaderId
4725: AND bidheader.auction_header_id = bidline.auction_header_id
4726: AND bidheader.bid_number = bidline.bid_number
4727: AND (

Line 4793: pon_bid_headers bidheader

4789: bidline.bid_number,
4790: bidline.bid_currency_price,
4791: bidheader.bid_currency_code
4792: FROM pon_bid_item_prices bidline,
4793: pon_bid_headers bidheader
4794: WHERE bidline.auction_header_id = p_auctionHeaderId
4795: AND bidheader.auction_header_id = bidline.auction_header_id
4796: AND bidheader.bid_number = bidline.bid_number
4797: AND (

Line 4988: FROM pon_bid_headers bidheader

4984: WHERE auction_header_id = p_auctionHeaderId
4985: AND bid_number <> p_bidNumber
4986: AND line_number = v_line_number
4987: AND EXISTS (SELECT 'x'
4988: FROM pon_bid_headers bidheader
4989: WHERE bidheader.bid_number = bidline.bid_number
4990: AND bidheader.bid_status = 'ACTIVE'
4991: AND decode (p_discard_tech_nonshort, 'Y', bidheader.technical_shortlist_flag, 'Y') = 'Y')
4992: AND rank BETWEEN DECODE(sign(v_new_rank - v_old_rank), 1, v_old_rank, v_new_rank)

Line 5028: pon_bid_headers bidheader

5024:
5025: SELECT count(*) + 1
5026: INTO v_newRank
5027: FROM pon_bid_item_prices bidline,
5028: pon_bid_headers bidheader
5029: WHERE bidline.auction_header_id = bidheader.auction_header_id
5030: AND bidheader.auction_header_id = p_auctionHeaderId
5031: AND bidheader.bid_number = bidline.bid_number
5032: AND bidline.line_number = rerank_line.line_number

Line 5278: v_publishDate pon_bid_headers.publish_date%TYPE;

5274: p_batchSize NUMBER,
5275: p_discard_tech_nonshort VARCHAR2)
5276: IS
5277:
5278: v_publishDate pon_bid_headers.publish_date%TYPE;
5279: v_bidCurrencyCode pon_bid_headers.bid_currency_code%TYPE;
5280:
5281: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
5282: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

Line 5279: v_bidCurrencyCode pon_bid_headers.bid_currency_code%TYPE;

5275: p_discard_tech_nonshort VARCHAR2)
5276: IS
5277:
5278: v_publishDate pon_bid_headers.publish_date%TYPE;
5279: v_bidCurrencyCode pon_bid_headers.bid_currency_code%TYPE;
5280:
5281: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
5282: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5283:

Line 5293: FROM pon_bid_headers

5289: SELECT publish_date,
5290: bid_currency_code
5291: INTO v_publishDate,
5292: v_bidCurrencyCode
5293: FROM pon_bid_headers
5294: WHERE bid_number = p_bidNumber;
5295:
5296: SELECT pah.bid_ranking,
5297: pah.rank_indicator

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

5399: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;
5400: v_max_bid_color_sequence_id pon_auction_headers_all.max_bid_color_sequence_id%TYPE; -- Added for Live Cosnole
5401: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5402: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5403: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5404: v_publishDate DATE;
5405: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5406: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5407: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;

Line 5405: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;

5401: v_closeBiddingDateH pon_auction_item_prices_all.close_bidding_date%TYPE;
5402: v_closeBiddingDate_old pon_auction_item_prices_all.close_bidding_date%TYPE;
5403: v_color_sequence_id pon_bid_headers.color_sequence_id%TYPE; --Added for Live Console
5404: v_publishDate DATE;
5405: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5406: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5407: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5408: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5409: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;

Line 5408: v_oldBidNumber pon_bid_headers.bid_number%TYPE;

5404: v_publishDate DATE;
5405: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5406: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5407: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5408: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5409: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;
5410: v_oldBidStatus pon_bid_headers.bid_status%TYPE;
5411: v_hasCloseDateReached VARCHAR2(1);
5412: v_ispricechanged VARCHAR2(1);

Line 5409: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;

5405: v_bidTradingPartnerId pon_bid_headers.trading_partner_id%TYPE;
5406: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5407: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5408: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5409: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;
5410: v_oldBidStatus pon_bid_headers.bid_status%TYPE;
5411: v_hasCloseDateReached VARCHAR2(1);
5412: v_ispricechanged VARCHAR2(1);
5413:

Line 5410: v_oldBidStatus pon_bid_headers.bid_status%TYPE;

5406: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
5407: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;
5408: v_oldBidNumber pon_bid_headers.bid_number%TYPE;
5409: v_prevActiveBidNumber pon_bid_headers.bid_number%TYPE;
5410: v_oldBidStatus pon_bid_headers.bid_status%TYPE;
5411: v_hasCloseDateReached VARCHAR2(1);
5412: v_ispricechanged VARCHAR2(1);
5413:
5414: v_pfTypeAllowed pon_auction_headers_all.pf_type_allowed%TYPE;

Line 5463: FROM pon_bid_headers

5459:
5460: IF (v_oldBidNumber is not null) THEN
5461: SELECT bid_status
5462: INTO v_oldBidStatus
5463: FROM pon_bid_headers
5464: WHERE bid_number = v_oldBidNumber;
5465:
5466: IF(v_oldBidStatus = 'DISQUALIFIED') THEN
5467: v_oldBidNumber := NULL;

Line 5519: FROM pon_bid_headers

5515: color_sequence_id --Added for Live Console
5516: INTO v_publishDate,
5517: v_bidTradingPartnerId,
5518: v_color_sequence_id --Added for Live Console
5519: FROM pon_bid_headers
5520: WHERE bid_number = p_bidNumber;
5521:
5522: -- check whether this bid is being placed
5523: -- after close date has been reached, note that

Line 5694: UPDATE PON_BID_HEADERS

5690: -- on the bid monitor charts. If this bid does not have
5691: -- a color yet, assign one.
5692: IF (v_color_sequence_id IS NULL) THEN
5693: print_log(l_api_name, p_bidNumber || ' - updating color sequences');
5694: UPDATE PON_BID_HEADERS
5695: SET Color_Sequence_Id = v_max_bid_color_sequence_id +1
5696: WHERE bid_number = p_bidNumber;
5697:
5698: v_max_bid_color_sequence_id := v_max_bid_color_sequence_id +1;

Line 5737: FROM pon_bid_headers

5733: UPDATE pon_auction_headers_all
5734: SET max_bid_color_sequence_id = v_max_bid_color_sequence_id, --Added for Live Console
5735: last_update_date = sysdate,
5736: number_of_bids = (SELECT COUNT(auction_header_id)
5737: FROM pon_bid_headers
5738: WHERE auction_header_id = p_auctionHeaderId
5739: AND (bid_status in ('ACTIVE', 'ARCHIVED')
5740: OR bid_number = p_bidNumber))
5741: WHERE auction_header_id = p_auctionHeaderId;

Line 5986: pon_bid_headers pbh

5982: )
5983: INTO l_auc_pf_unit_price
5984: FROM pon_pf_supplier_formula ppsf,
5985: pon_auction_item_prices_all aip,
5986: pon_bid_headers pbh
5987: WHERE ppsf.auction_header_id = p_auction_header_id
5988: AND ppsf.line_number = p_line_number
5989: AND ppsf.trading_partner_id = pbh.trading_partner_id
5990: AND ppsf.vendor_site_id = pbh.vendor_site_id

Line 6117: v_bid_number pon_bid_headers.bid_number%TYPE;

6113: IS
6114:
6115: l_module_name VARCHAR2(40) := 'updt_tech_short_lines';
6116:
6117: v_bid_number pon_bid_headers.bid_number%TYPE;
6118: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
6119: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
6120: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
6121: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;

Line 6120: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;

6116:
6117: v_bid_number pon_bid_headers.bid_number%TYPE;
6118: v_best_bid_number pon_auction_item_prices_all.best_bid_number%TYPE;
6119: v_best_bid_bid_number pon_auction_item_prices_all.best_bid_bid_number%TYPE;
6120: v_bestbid_shortlist_flag pon_bid_headers.shortlist_flag%TYPE;
6121: v_currentline_group_type pon_auction_item_prices_all.group_type%TYPE;
6122: t_price pon_bid_item_prices.price%TYPE;
6123: t_quantity pon_bid_item_prices.quantity%TYPE;
6124: t_promised_date pon_bid_item_prices.promised_date%TYPE;

Line 6127: t_bid_currency_code pon_bid_headers.bid_currency_code%TYPE;

6123: t_quantity pon_bid_item_prices.quantity%TYPE;
6124: t_promised_date pon_bid_item_prices.promised_date%TYPE;
6125: t_bid_number pon_bid_item_prices.bid_number%TYPE;
6126: t_bid_currency_price pon_bid_item_prices.bid_currency_price%TYPE;
6127: t_bid_currency_code pon_bid_headers.bid_currency_code%TYPE;
6128: t_first_bid_price pon_bid_item_prices.first_bid_price%TYPE;
6129: t_proxy_bid_limit_price pon_bid_item_prices.proxy_bid_limit_price%TYPE;
6130: t_score pon_bid_item_prices.total_weighted_score%TYPE;
6131:

Line 6163: pon_bid_headers pbh

6159: INTO
6160: v_bid_number
6161: FROM
6162: pon_bid_item_prices pbip,
6163: pon_bid_headers pbh
6164: WHERE
6165: pbh.auction_header_id = p_auction_header_id
6166: AND pbip.bid_number = pbh.bid_number
6167: AND nvl (pbh.shortlist_flag, 'Y') = 'N'

Line 6231: pon_bid_headers pbh

6227: nvl (pbh.shortlist_flag, 'Y')
6228: INTO
6229: v_bestbid_shortlist_flag
6230: FROM
6231: pon_bid_headers pbh
6232: WHERE
6233: pbh.bid_number = v_best_bid_number;
6234:
6235: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{

Line 6256: pon_bid_headers pbh

6252: nvl (pbh.shortlist_flag, 'Y')
6253: INTO
6254: v_bestbid_shortlist_flag
6255: FROM
6256: pon_bid_headers pbh
6257: WHERE
6258: pbh.bid_number = v_best_bid_bid_number;
6259:
6260: END IF; -- }

Line 6312: pon_bid_headers bidheader

6308: bidline.first_bid_price,
6309: bidline.proxy_bid_limit_price
6310: FROM
6311: pon_bid_item_prices bidline,
6312: pon_bid_headers bidheader
6313: WHERE
6314: bidline.auction_header_id = p_auction_header_id
6315: AND bidheader.auction_header_id = bidline.auction_header_id
6316: AND bidheader.bid_number = bidline.bid_number

Line 6455: pon_bid_headers bidheader

6451: bidline.bid_currency_price,
6452: bidheader.bid_currency_code
6453: FROM
6454: pon_bid_item_prices bidline,
6455: pon_bid_headers bidheader
6456: WHERE
6457: bidline.auction_header_id = p_auction_header_id
6458: AND bidheader.auction_header_id = bidline.auction_header_id
6459: AND bidheader.bid_number = bidline.bid_number

Line 6532: pon_bid_headers pbh,

6528: BULK COLLECT INTO
6529: v_bid_numbers_bulk,
6530: v_rank_bulk
6531: FROM
6532: pon_bid_headers pbh,
6533: pon_bid_item_prices pbip
6534: WHERE
6535: pbh.auction_header_id = p_auction_header_id
6536: AND pbh.bid_number = pbip.bid_number

Line 6706: v_bid_number PON_BID_HEADERS.BID_NUMBER%TYPE;

6702:
6703: v_rank_indicator PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE;
6704: v_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;
6705: v_max_internal_line_num PON_AUCTION_HEADERS_ALL.MAX_INTERNAL_LINE_NUM%TYPE;
6706: v_bid_number PON_BID_HEADERS.BID_NUMBER%TYPE;
6707:
6708: v_batch_size NUMBER;
6709: v_batching_required BOOLEAN;
6710:

Line 6731: pon_bid_headers

6727: bid_number
6728: INTO
6729: v_bid_number
6730: FROM
6731: pon_bid_headers
6732: WHERE
6733: auction_header_id = p_auction_header_id
6734: AND nvl (shortlist_flag, 'Y') = 'N'
6735: AND bid_status = 'ACTIVE'

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

6777: ', bid_ranking = ' || v_bid_ranking ||
6778: ', max_internal_line_num = ' || v_max_internal_line_num);
6779: END IF; --}
6780:
6781: -- Copy over the shortlist flag into technical_short_flag in pon_bid_headers
6782: UPDATE
6783: pon_bid_headers pbh
6784: SET
6785: pbh.last_update_date = sysdate,

Line 6783: pon_bid_headers pbh

6779: END IF; --}
6780:
6781: -- Copy over the shortlist flag into technical_short_flag in pon_bid_headers
6782: UPDATE
6783: pon_bid_headers pbh
6784: SET
6785: pbh.last_update_date = sysdate,
6786: pbh.last_updated_by = fnd_global.user_id,
6787: pbh.technical_shortlist_flag = decode (pbh.bid_status, 'ACTIVE', nvl (pbh.shortlist_flag, 'Y'), 'N')

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

6790:
6791: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6792: FND_LOG.string(log_level => FND_LOG.level_statement,
6793: module => g_module_prefix || l_module_name,
6794: message => 'Done with updating pon_bid_headers.');
6795: END IF; --}
6796:
6797: --While commercial unlocking the 2 part RFQ, reset the scores to 'not entered'
6798: -- so that user will enter scores for commercial stage.

Line 6840: UPDATE pon_bid_headers bh

6836: WHERE
6837: paha.auction_header_id = p_auction_header_id;
6838:
6839: -- Bug#13590450 make the draft bids of technical stage as archived_draft
6840: UPDATE pon_bid_headers bh
6841: SET bh.bid_status='ARCHIVED_DRAFT'
6842: WHERE
6843: bh.auction_header_id = p_auction_header_id
6844: AND (EXISTS (select 1 FROM pon_auction_headers_all ah WHERE ah.auction_header_id = bh.auction_header_id