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_AUCTION_HEADERS_ALL

Line 378: v_doctypeId pon_auction_headers_all.doctype_id%TYPE;

374: p_bidNumber IN NUMBER,
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;

Line 403: FROM pon_auction_headers_all

399: auction_header_id_orig_amend
400: INTO v_doctypeId,
401: v_amendmentNumber,
402: v_auctionHeaderIdOrigAmend
403: FROM pon_auction_headers_all
404: WHERE auction_header_id = p_auctionheaderid;
405:
406: SELECT fixed_value
407: INTO v_fixedValue

Line 436: FROM PON_AUCTION_HEADERS_ALL

432: SET BID_STATUS = 'ARCHIVED',
433: LAST_UPDATE_DATE = SYSDATE
434: WHERE AUCTION_HEADER_ID in (
435: SELECT AUCTION_HEADER_ID
436: FROM PON_AUCTION_HEADERS_ALL
437: WHERE AUCTION_HEADER_ID_ORIG_AMEND = v_auctionHeaderIdOrigAmend)
438: AND BID_NUMBER <> p_bidNumber
439: AND NVL(VENDOR_SITE_ID, -1) = NVL(p_vendorSiteId, -1)
440: AND TRADING_PARTNER_ID = v_bidTradingPartnerId

Line 1141: from pon_auction_headers_all

1137: if (PON_CONTERMS_UTL_PVT.is_contracts_installed() = FND_API.G_TRUE) then
1138:
1139: begin
1140: select conterms_exist_flag into v_contermsExist
1141: from pon_auction_headers_all
1142: where auction_header_id = p_auctionHeaderId;
1143:
1144: if(v_contermsExist = 'Y') then
1145:

Line 1196: FROM pon_auction_headers_all

1192: print_log(l_api_name, 'p_auctionHeaderIdOrigRound=' || p_auctionHeaderIdOrigRound);
1193:
1194: SELECT nvl(auction_header_id_orig_round, auction_header_id)
1195: INTO p_auctionHeaderIdOrigRound
1196: FROM pon_auction_headers_all
1197: WHERE auction_header_id = p_auctionHeaderId;
1198:
1199: print_log(l_api_name || '.END', ' ');
1200: END get_auc_header_id_orig_round;

Line 1813: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;

1809: IS
1810: --
1811: l_api_name CONSTANT VARCHAR2(30) := 'cancel_all_proxy_bid_lines';
1812:
1813: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1814: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1815: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1816: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1817: l_bidNumber pon_bid_item_prices.bid_number%TYPE;

Line 1814: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

1810: --
1811: l_api_name CONSTANT VARCHAR2(30) := 'cancel_all_proxy_bid_lines';
1812:
1813: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1814: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1815: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1816: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1817: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1818: l_price pon_bid_item_prices.price%TYPE;

Line 1815: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;

1811: l_api_name CONSTANT VARCHAR2(30) := 'cancel_all_proxy_bid_lines';
1812:
1813: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1814: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1815: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1816: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1817: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1818: l_price pon_bid_item_prices.price%TYPE;
1819: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;

Line 1816: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

1812:
1813: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1814: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1815: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1816: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1817: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1818: l_price pon_bid_item_prices.price%TYPE;
1819: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;
1820: --

Line 1831: pon_auction_headers_all paha

1827: pbip.proxy_bid_limit_price
1828: FROM
1829: pon_bid_item_prices pbip,
1830: pon_auction_item_prices_all paip,
1831: pon_auction_headers_all paha
1832: WHERE
1833: pbip.bid_number = p_bidNumber
1834: AND paip.auction_header_id = p_auctionHeaderId
1835: AND paha.auction_header_id = p_auctionHeaderId

Line 1852: FROM pon_auction_headers_all

1848:
1849: -- get the lock on the header row
1850: SELECT auction_header_id, bid_ranking, auction_status, DECODE ( NVL( is_paused, 'N'), 'Y', ( sysdate + ( close_bidding_date - last_pause_date ) ), close_bidding_date )
1851: INTO l_auctionHeaderId, l_bidRanking, l_auctionStatus, l_closeBiddingDate
1852: FROM pon_auction_headers_all
1853: WHERE auction_header_id = p_auctionHeaderId
1854: FOR UPDATE OF CLOSE_BIDDING_DATE;
1855: --
1856: BEGIN

Line 1905: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;

1901: IS
1902: --
1903: l_api_name CONSTANT VARCHAR2(30) := 'cancel_proxy_bid_line';
1904:
1905: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1906: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1907: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1908: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1909: l_bidNumber pon_bid_item_prices.bid_number%TYPE;

Line 1906: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

1902: --
1903: l_api_name CONSTANT VARCHAR2(30) := 'cancel_proxy_bid_line';
1904:
1905: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1906: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1907: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1908: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1909: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1910: l_price pon_bid_item_prices.price%TYPE;

Line 1907: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;

1903: l_api_name CONSTANT VARCHAR2(30) := 'cancel_proxy_bid_line';
1904:
1905: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1906: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1907: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1908: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1909: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1910: l_price pon_bid_item_prices.price%TYPE;
1911: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;

Line 1908: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

1904:
1905: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1906: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1907: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1908: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1909: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1910: l_price pon_bid_item_prices.price%TYPE;
1911: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;
1912: --

Line 1930: FROM pon_auction_headers_all

1926: IF p_bidNumber = 0 THEN
1927: -- get the lock on the header row
1928: SELECT auction_header_id, bid_ranking, auction_status, DECODE ( NVL( is_paused, 'N'), 'Y', ( sysdate + ( close_bidding_date - last_pause_date ) ), close_bidding_date )
1929: INTO l_auctionHeaderId, l_bidRanking, l_auctionStatus, l_closeBiddingDate
1930: FROM pon_auction_headers_all
1931: WHERE auction_header_id = p_auctionHeaderId
1932: FOR UPDATE OF CLOSE_BIDDING_DATE;
1933: --
1934: BEGIN

Line 2003: v_is_paused pon_auction_headers_all.is_paused%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;
2007: v_sameCompanyDrafts NUMBER;

Line 2008: v_bidFrequencyCode pon_auction_headers_all.bid_frequency_code%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;
2010:
2011: l_api_name VARCHAR2(40) := 'check_is_bid_valid';
2012:

Line 2047: pon_auction_headers_all paha

2043: SELECT paip.line_number
2044: INTO v_negotiation_closed_line_num
2045: FROM pon_bid_item_prices pbip,
2046: pon_auction_item_prices_all paip,
2047: pon_auction_headers_all paha
2048: WHERE paip.auction_header_id = p_auctionHeaderId
2049: AND pbip.auction_header_id = p_auctionHeaderId
2050: AND paha.auction_header_id = p_auctionHeaderId
2051: AND pbip.bid_number = p_bidNumber

Line 2165: FROM pon_auction_headers_all

2161: -- if the auction is a single bid auction and another user
2162: -- from the same company has already bid then throw exception
2163: SELECT bid_frequency_code
2164: INTO v_bidFrequencyCode
2165: FROM pon_auction_headers_all
2166: WHERE auction_header_id = p_auctionHeaderId;
2167:
2168: IF v_bidFrequencyCode = 'SINGLE_BID_ONLY' THEN
2169: -- get a hold of company's tp id

Line 2220: FROM pon_auction_headers_all

2216: -- bug 4523484: do this check only for publish; not for savedraft
2217: IF(p_isSavingDraft = 'N') THEN
2218: SELECT nvl(is_paused, 'N')
2219: INTO v_is_paused
2220: FROM pon_auction_headers_all
2221: WHERE auction_header_id = p_auctionHeaderId;
2222:
2223: IF (v_is_paused = 'Y') THEN
2224: x_return_code := 'AUCTION_PAUSED';

Line 2242: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,

2238:
2239: PROCEDURE update_disq_lines
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,

Line 2243: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,

2239: PROCEDURE update_disq_lines
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,

Line 2565: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,

2561:
2562: PROCEDURE update_disq_lines_batched
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,

Line 2566: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,

2562: PROCEDURE update_disq_lines_batched
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,

Line 2611: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

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;
2615: v_batchingRequired BOOLEAN;

Line 2612: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

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;
2615: v_batchingRequired BOOLEAN;
2616:

Line 2619: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

2615: v_batchingRequired BOOLEAN;
2616:
2617: v_numOfBids NUMBER;
2618:
2619: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
2620: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
2621: v_ignore_tech_nonshortlist VARCHAR2(1);
2622: BEGIN
2623:

Line 2620: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;

2616:
2617: v_numOfBids NUMBER;
2618:
2619: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
2620: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
2621: v_ignore_tech_nonshortlist VARCHAR2(1);
2622: BEGIN
2623:
2624:

Line 2643: FROM pon_auction_headers_all

2639: v_bidRanking,
2640: v_maxLineNumber,
2641: v_two_part_flag,
2642: v_sealed_auction_status
2643: FROM pon_auction_headers_all
2644: WHERE auction_header_id = p_auctionHeaderId
2645: FOR UPDATE OF CLOSE_BIDDING_DATE;
2646:
2647: print_log(l_api_name, 'rank_indicator = ' || v_rankIndicator ||

Line 2675: FROM pon_auction_headers_all

2671: -- Actually all archived bids are disqualified as well.
2672: -- +1 is for the currect active bid that is being disqualified.
2673: SELECT number_of_bids
2674: INTO v_numOfBids
2675: FROM pon_auction_headers_all
2676: WHERE auction_header_id = p_auctionHeaderId;
2677: print_log(l_api_name, p_bidNumber || ': original numOfBids=' || v_numOfBids);
2678:
2679: UPDATE pon_auction_headers_all

Line 2679: UPDATE pon_auction_headers_all

2675: FROM pon_auction_headers_all
2676: WHERE auction_header_id = p_auctionHeaderId;
2677: print_log(l_api_name, p_bidNumber || ': original numOfBids=' || v_numOfBids);
2678:
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

Line 2691: FROM pon_auction_headers_all

2687: WHERE auction_header_id = p_auctionHeaderId;
2688:
2689: SELECT number_of_bids
2690: INTO v_numOfBids
2691: FROM pon_auction_headers_all
2692: WHERE auction_header_id = p_auctionHeaderId;
2693: print_log(l_api_name, p_bidNumber || ': new numOfBids=' || v_numOfBids);
2694:
2695: -- for batching, we need to find out the max line number of

Line 3063: pon_auction_headers_all auctions,

3059: l_auc_pf_unit_price_formula,
3060: l_auc_pf_fixed_amount_formula,
3061: l_auc_pf_percentage_formula
3062: FROM
3063: pon_auction_headers_all auctions,
3064: pon_auction_item_prices_all items,
3065: pon_pf_supplier_formula pf_formula
3066: WHERE
3067: auctions.auction_header_id = p_auction_header_id

Line 3274: pon_auction_headers_all ah

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
3278: AND bh.trading_partner_id = p_trading_partner_id

Line 3676: v_auctionType pon_auction_headers_all.auction_type%TYPE;

3672: p_maxLineNumber IN NUMBER,
3673: p_batchSize IN NUMBER,
3674: p_batchingRequired IN BOOLEAN)
3675: IS
3676: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3677: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;

Line 3677: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

3673: p_batchSize IN NUMBER,
3674: p_batchingRequired IN BOOLEAN)
3675: IS
3676: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3677: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;

Line 3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

3674: p_batchingRequired IN BOOLEAN)
3675: IS
3676: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3677: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;

Line 3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;

3675: IS
3676: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3677: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;

Line 3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;

3676: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3677: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;

Line 3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;

3677: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

Line 3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;

3678: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3686: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;

Line 3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;

3679: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3686: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3687:

Line 3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;

3680: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3686: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3687:
3688: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;

Line 3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

3681: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3686: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3687:
3688: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;
3689: v_bidPublishDate pon_bid_item_prices.publish_date%TYPE;

Line 3686: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;

3682: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3683: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3684: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3685: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3686: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3687:
3688: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;
3689: v_bidPublishDate pon_bid_item_prices.publish_date%TYPE;
3690:

Line 3734: pon_auction_headers_all pah

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:
3738: v_hdrExtensionTime := (1 / (24 * 60)) * v_autoExtendDuration;

Line 3929: v_auction_type pon_auction_headers_all.auction_type%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;
3933: v_publish_date DATE;

Line 3930: v_bid_change_type pon_auction_headers_all.min_bid_change_type%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;
3933: v_publish_date DATE;
3934: v_count NUMBER;

Line 3931: v_trading_partner_id pon_auction_headers_all.trading_partner_id%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;
3933: v_publish_date DATE;
3934: v_count NUMBER;
3935: v_bid_decimals NUMBER;

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 5114: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

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:
5117: v_batchingRequired BOOLEAN;
5118:

Line 5115: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

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:
5117: v_batchingRequired BOOLEAN;
5118:
5119: l_api_name CONSTANT VARCHAR2(30) := 'update_all_ranks';

Line 5133: FROM pon_auction_headers_all pah

5129: SELECT pah.bid_ranking,
5130: pah.rank_indicator
5131: INTO v_bidRanking,
5132: v_rankIndicator
5133: FROM pon_auction_headers_all pah
5134: WHERE pah.auction_header_id = p_auctionHeaderId;
5135:
5136: v_batchingRequired := (p_maxLineNumber > p_batchSize);
5137:

Line 5227: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;

5223:
5224: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info';
5225:
5226: -- auto extension variables
5227: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5228: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5229: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;

Line 5228: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;

5224: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info';
5225:
5226: -- auto extension variables
5227: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5228: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5229: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;
5232: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;

Line 5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;

5226: -- auto extension variables
5227: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5228: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5229: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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;

Line 5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;

5227: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5228: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5229: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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;

Line 5232: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;

5228: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5229: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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

Line 5233: v_max_bid_color_sequence_id pon_auction_headers_all.max_bid_color_sequence_id%TYPE; -- Added for Live Cosnole

5229: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5230: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5231: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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;

Line 5239: v_rankIndicator pon_auction_headers_all.rank_indicator%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;
5243: v_oldBidStatus pon_bid_headers.bid_status%TYPE;

Line 5240: v_doctypeId pon_auction_headers_all.doctype_id%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;
5243: v_oldBidStatus pon_bid_headers.bid_status%TYPE;
5244: v_hasCloseDateReached VARCHAR2(1);

Line 5247: v_pfTypeAllowed pon_auction_headers_all.pf_type_allowed%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;
5248: v_priceTiersIndicator pon_auction_headers_all.price_tiers_indicator%TYPE;
5249:
5250: v_maxLineNumber NUMBER;
5251: v_batchSize NUMBER;

Line 5248: v_priceTiersIndicator pon_auction_headers_all.price_tiers_indicator%TYPE;

5244: v_hasCloseDateReached VARCHAR2(1);
5245: v_ispricechanged VARCHAR2(1);
5246:
5247: v_pfTypeAllowed pon_auction_headers_all.pf_type_allowed%TYPE;
5248: v_priceTiersIndicator pon_auction_headers_all.price_tiers_indicator%TYPE;
5249:
5250: v_maxLineNumber NUMBER;
5251: v_batchSize NUMBER;
5252: v_batchingRequired BOOLEAN;

Line 5254: v_max_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

5250: v_maxLineNumber NUMBER;
5251: v_batchSize NUMBER;
5252: v_batchingRequired BOOLEAN;
5253:
5254: v_max_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5255: v_max_num_of_extensions pon_auction_headers_all.number_of_extensions%TYPE;
5256:
5257: l_msg_data VARCHAR2(250);
5258: l_msg_count NUMBER;

Line 5255: v_max_num_of_extensions pon_auction_headers_all.number_of_extensions%TYPE;

5251: v_batchSize NUMBER;
5252: v_batchingRequired BOOLEAN;
5253:
5254: v_max_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5255: v_max_num_of_extensions pon_auction_headers_all.number_of_extensions%TYPE;
5256:
5257: l_msg_data VARCHAR2(250);
5258: l_msg_count NUMBER;
5259: l_return_status VARCHAR2(1);

Line 5264: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

5260: v_contermsExist VARCHAR2(1);
5261:
5262: v_extendInterval NUMBER;
5263: --for staggered closing
5264: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5265: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5266: v_is_staggered_auction varchar2(1);
5267: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5268: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

Line 5265: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;

5261:
5262: v_extendInterval NUMBER;
5263: --for staggered closing
5264: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5265: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5266: v_is_staggered_auction varchar2(1);
5267: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5268: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5269: v_discard_tech_nonshort varchar2(1);

Line 5267: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;

5263: --for staggered closing
5264: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5265: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5266: v_is_staggered_auction varchar2(1);
5267: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5268: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5269: v_discard_tech_nonshort varchar2(1);
5270:
5271: --added by Allen Yang for Surrogate Bid 2008/10/07

Line 5268: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

5264: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5265: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5266: v_is_staggered_auction varchar2(1);
5267: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5268: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5269: v_discard_tech_nonshort varchar2(1);
5270:
5271: --added by Allen Yang for Surrogate Bid 2008/10/07
5272: v_technical_evaluation_status pon_auction_headers_all.technical_evaluation_status%TYPE;

Line 5272: v_technical_evaluation_status pon_auction_headers_all.technical_evaluation_status%TYPE;

5268: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5269: v_discard_tech_nonshort varchar2(1);
5270:
5271: --added by Allen Yang for Surrogate Bid 2008/10/07
5272: v_technical_evaluation_status pon_auction_headers_all.technical_evaluation_status%TYPE;
5273:
5274: BEGIN
5275: --
5276: -- logging

Line 5343: FROM pon_auction_headers_all pah

5339: -- added by Allen Yang for Surrogate Bid 2008/10/07
5340: ---------------------------------------------------
5341: , v_technical_evaluation_status
5342: ---------------------------------------------------
5343: FROM pon_auction_headers_all pah
5344: WHERE auction_header_id = p_auctionHeaderId;
5345:
5346: SELECT publish_date,
5347: trading_partner_id,

Line 5565: UPDATE pon_auction_headers_all

5561:
5562: -- UPDATE AUCTION HEADER
5563: -- here we update fields in the auction header
5564: print_log(l_api_name, p_bidNumber || ' - updating auction header');
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

Line 5592: FROM pon_auction_headers_all

5588: nvl2(staggered_closing_interval,'Y','N')
5589: INTO v_first_line_close_date,
5590: v_orig_close_bidding_date,
5591: v_is_staggered_auction
5592: FROM pon_auction_headers_all
5593: WHERE auction_header_id = p_auctionHeaderId;
5594:
5595: print_log(l_api_name, p_bidNumber ||
5596: 'v_first_line_close_date : ' || to_char(v_first_line_close_date,'dd:mm:yy hh:mi:ss' ) ||

Line 5607: UPDATE pon_auction_headers_all

5603: v_first_line_close_date := v_first_line_close_date + (v_max_close_bidding_date -v_orig_close_bidding_date);
5604: end if;
5605: print_log(l_api_name, p_bidNumber || ' New first_line_close_date : ' || to_char(v_first_line_close_date,'dd:mm:yy hh:mi:ss' ));
5606:
5607: UPDATE pon_auction_headers_all
5608: SET close_bidding_date = v_max_close_bidding_date,
5609: number_of_extensions = v_max_num_of_extensions,
5610: first_line_close_date = v_first_line_close_date
5611: WHERE auction_header_id = p_auctionHeaderId;

Line 5631: from pon_auction_headers_all

5627: if (PON_CONTERMS_UTL_PVT.is_contracts_installed() = FND_API.G_TRUE) then
5628:
5629: begin
5630: select conterms_exist_flag into v_contermsExist
5631: from pon_auction_headers_all
5632: where auction_header_id = p_auctionHeaderId;
5633:
5634: if(v_contermsExist = 'Y') then
5635: print_log(l_api_name, p_bidNumber || ': ' ||'calling subroutine PON_CONTERMS_UTL_PVT.activateDeliverables');

Line 5735: l_contract_type pon_auction_headers_all.contract_type%TYPE;

5731: l_total_price NUMBER;
5732: l_bid_line_pf_unit_price NUMBER;
5733: l_auc_pf_unit_price NUMBER;
5734:
5735: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5736: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5737: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
5738:
5739: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;

Line 5736: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

5732: l_bid_line_pf_unit_price NUMBER;
5733: l_auc_pf_unit_price NUMBER;
5734:
5735: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5736: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5737: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
5738:
5739: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5740: l_bid_quantity pon_bid_item_prices.quantity%TYPE;

Line 5737: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;

5733: l_auc_pf_unit_price NUMBER;
5734:
5735: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5736: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5737: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
5738:
5739: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5740: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
5741:

Line 5762: FROM pon_auction_headers_all

5758: pf_type_allowed
5759: INTO l_contract_type,
5760: l_supplier_view_type,
5761: l_pf_type_allowed
5762: FROM pon_auction_headers_all
5763: WHERE auction_header_id = p_auction_header_id;
5764: ELSE
5765: -- assign the input parameters to the local variables.
5766: l_contract_type := p_contract_type;

Line 6535: v_rank_indicator PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE;

6531:
6532: l_module_name VARCHAR2(40) := 'update_auction_info_tech_short';
6533: l_reranking_required VARCHAR2(1) := 'Y';
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:

Line 6536: v_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;

6532: l_module_name VARCHAR2(40) := 'update_auction_info_tech_short';
6533: l_reranking_required VARCHAR2(1) := 'Y';
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;

Line 6537: v_max_internal_line_num PON_AUCTION_HEADERS_ALL.MAX_INTERNAL_LINE_NUM%TYPE;

6533: l_reranking_required VARCHAR2(1) := 'Y';
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;

Line 6599: pon_auction_headers_all

6595: v_rank_indicator,
6596: v_bid_ranking,
6597: v_max_internal_line_num
6598: FROM
6599: pon_auction_headers_all
6600: WHERE
6601: auction_header_id = p_auction_header_id
6602: FOR
6603: UPDATE OF close_bidding_date;

Line 6659: pon_auction_headers_all paha

6655: END IF; -- }
6656:
6657: -- Unlock the commercial part of the auction
6658: UPDATE
6659: pon_auction_headers_all paha
6660: SET
6661: paha.last_update_date = sysdate,
6662: paha.last_updated_by = fnd_global.user_id,
6663: paha.scoring_lock_date = null,