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 408: FROM pon_auction_headers_all

404: auction_header_id_orig_amend
405: INTO v_doctypeId,
406: v_amendmentNumber,
407: v_auctionHeaderIdOrigAmend
408: FROM pon_auction_headers_all
409: WHERE auction_header_id = p_auctionheaderid;
410:
411: SELECT fixed_value
412: INTO v_fixedValue

Line 455: FROM PON_AUCTION_HEADERS_ALL

451: SET BID_STATUS = 'ARCHIVED',
452: LAST_UPDATE_DATE = SYSDATE
453: WHERE AUCTION_HEADER_ID in (
454: SELECT AUCTION_HEADER_ID
455: FROM PON_AUCTION_HEADERS_ALL
456: WHERE AUCTION_HEADER_ID_ORIG_AMEND = v_auctionHeaderIdOrigAmend)
457: AND BID_NUMBER <> p_bidNumber
458: AND NVL(VENDOR_SITE_ID, -1) = NVL(p_vendorSiteId, -1)
459: AND TRADING_PARTNER_ID = v_bidTradingPartnerId

Line 1164: from pon_auction_headers_all

1160: if (PON_CONTERMS_UTL_PVT.is_contracts_installed() = FND_API.G_TRUE) then
1161:
1162: begin
1163: select conterms_exist_flag into v_contermsExist
1164: from pon_auction_headers_all
1165: where auction_header_id = p_auctionHeaderId;
1166:
1167: if(v_contermsExist = 'Y') then
1168:

Line 1219: FROM pon_auction_headers_all

1215: print_log(l_api_name, 'p_auctionHeaderIdOrigRound=' || p_auctionHeaderIdOrigRound);
1216:
1217: SELECT nvl(auction_header_id_orig_round, auction_header_id)
1218: INTO p_auctionHeaderIdOrigRound
1219: FROM pon_auction_headers_all
1220: WHERE auction_header_id = p_auctionHeaderId;
1221:
1222: print_log(l_api_name || '.END', ' ');
1223: END get_auc_header_id_orig_round;

Line 1420: AND NOT (EXISTS (select 1 FROM pon_auction_headers_all ah WHERE ah.auction_header_id = p_auctionHeaderId

1416: /*Offer Enhancements : If current bid is surrogate, check only surrogate bids.
1417: * Check only supplier offers for suppliers. */
1418: AND Nvl(surrog_bid_flag,'N') = v_surrog_bid_flag
1419: /* Bug#13590450 should not consider the technical stage draft bids once the techincal stage is completed, for 2 stage neg */
1420: AND NOT (EXISTS (select 1 FROM pon_auction_headers_all ah WHERE ah.auction_header_id = p_auctionHeaderId
1421: AND Nvl(ah.two_part_flag, 'N') = 'Y'
1422: AND Nvl(ah.technical_evaluation_status, 'N') ='COMPLETED')
1423: AND Nvl(surrog_bid_flag, 'N') = 'Y'
1424:

Line 1870: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;

1866: IS
1867: --
1868: l_api_name CONSTANT VARCHAR2(30) := 'cancel_all_proxy_bid_lines';
1869:
1870: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1871: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1872: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1873: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1874: l_bidNumber pon_bid_item_prices.bid_number%TYPE;

Line 1871: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

1867: --
1868: l_api_name CONSTANT VARCHAR2(30) := 'cancel_all_proxy_bid_lines';
1869:
1870: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1871: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1872: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1873: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1874: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1875: l_price pon_bid_item_prices.price%TYPE;

Line 1872: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;

1868: l_api_name CONSTANT VARCHAR2(30) := 'cancel_all_proxy_bid_lines';
1869:
1870: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1871: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1872: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1873: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1874: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1875: l_price pon_bid_item_prices.price%TYPE;
1876: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;

Line 1873: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

1869:
1870: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1871: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1872: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1873: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1874: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1875: l_price pon_bid_item_prices.price%TYPE;
1876: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;
1877: --

Line 1888: pon_auction_headers_all paha

1884: pbip.proxy_bid_limit_price
1885: FROM
1886: pon_bid_item_prices pbip,
1887: pon_auction_item_prices_all paip,
1888: pon_auction_headers_all paha
1889: WHERE
1890: pbip.bid_number = p_bidNumber
1891: AND paip.auction_header_id = p_auctionHeaderId
1892: AND paha.auction_header_id = p_auctionHeaderId

Line 1909: FROM pon_auction_headers_all

1905:
1906: -- get the lock on the header row
1907: SELECT auction_header_id, bid_ranking, auction_status, DECODE ( NVL( is_paused, 'N'), 'Y', ( sysdate + ( close_bidding_date - last_pause_date ) ), close_bidding_date )
1908: INTO l_auctionHeaderId, l_bidRanking, l_auctionStatus, l_closeBiddingDate
1909: FROM pon_auction_headers_all
1910: WHERE auction_header_id = p_auctionHeaderId
1911: FOR UPDATE OF CLOSE_BIDDING_DATE;
1912: --
1913: BEGIN

Line 1962: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;

1958: IS
1959: --
1960: l_api_name CONSTANT VARCHAR2(30) := 'cancel_proxy_bid_line';
1961:
1962: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1963: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1964: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1965: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1966: l_bidNumber pon_bid_item_prices.bid_number%TYPE;

Line 1963: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

1959: --
1960: l_api_name CONSTANT VARCHAR2(30) := 'cancel_proxy_bid_line';
1961:
1962: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1963: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1964: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1965: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1966: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1967: l_price pon_bid_item_prices.price%TYPE;

Line 1964: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;

1960: l_api_name CONSTANT VARCHAR2(30) := 'cancel_proxy_bid_line';
1961:
1962: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1963: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1964: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1965: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1966: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1967: l_price pon_bid_item_prices.price%TYPE;
1968: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;

Line 1965: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

1961:
1962: l_auctionHeaderId pon_auction_headers_all.auction_header_id%TYPE;
1963: l_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
1964: l_auctionStatus pon_auction_headers_all.auction_status%TYPE;
1965: l_closeBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
1966: l_bidNumber pon_bid_item_prices.bid_number%TYPE;
1967: l_price pon_bid_item_prices.price%TYPE;
1968: l_proxyBidLimitPrice pon_bid_item_prices.proxy_bid_limit_price%TYPE;
1969: --

Line 1987: FROM pon_auction_headers_all

1983: IF p_bidNumber = 0 THEN
1984: -- get the lock on the header row
1985: SELECT auction_header_id, bid_ranking, auction_status, DECODE ( NVL( is_paused, 'N'), 'Y', ( sysdate + ( close_bidding_date - last_pause_date ) ), close_bidding_date )
1986: INTO l_auctionHeaderId, l_bidRanking, l_auctionStatus, l_closeBiddingDate
1987: FROM pon_auction_headers_all
1988: WHERE auction_header_id = p_auctionHeaderId
1989: FOR UPDATE OF CLOSE_BIDDING_DATE;
1990: --
1991: BEGIN

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

Line 2065: v_bidFrequencyCode pon_auction_headers_all.bid_frequency_code%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;
2067:
2068: l_api_name VARCHAR2(40) := 'check_is_bid_valid';
2069:

Line 2071: l_allow_multi_resp pon_auction_headers_all.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE;

2067:
2068: l_api_name VARCHAR2(40) := 'check_is_bid_valid';
2069:
2070: -- Multiple Active Offers
2071: l_allow_multi_resp pon_auction_headers_all.ALLOW_MULTIPLE_ACTIVE_OFFERS%TYPE;
2072:
2073:
2074: BEGIN
2075:

Line 2108: pon_auction_headers_all paha

2104: SELECT paip.line_number
2105: INTO v_negotiation_closed_line_num
2106: FROM pon_bid_item_prices pbip,
2107: pon_auction_item_prices_all paip,
2108: pon_auction_headers_all paha
2109: WHERE paip.auction_header_id = p_auctionHeaderId
2110: AND pbip.auction_header_id = p_auctionHeaderId
2111: AND paha.auction_header_id = p_auctionHeaderId
2112: AND pbip.bid_number = p_bidNumber

Line 2234: FROM pon_auction_headers_all

2230: -- if the auction is a single bid auction and another user
2231: -- from the same company has already bid then throw exception
2232: SELECT bid_frequency_code
2233: INTO v_bidFrequencyCode
2234: FROM pon_auction_headers_all
2235: WHERE auction_header_id = p_auctionHeaderId;
2236:
2237: IF v_bidFrequencyCode = 'SINGLE_BID_ONLY' THEN
2238: -- get a hold of company's tp id

Line 2291: FROM pon_auction_headers_all

2287: -- bug 4523484: do this check only for publish; not for savedraft
2288: IF(p_isSavingDraft = 'N') THEN
2289: SELECT nvl(is_paused, 'N')
2290: INTO v_is_paused
2291: FROM pon_auction_headers_all
2292: WHERE auction_header_id = p_auctionHeaderId;
2293:
2294: IF (v_is_paused = 'Y') THEN
2295: x_return_code := 'AUCTION_PAUSED';

Line 2313: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,

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

Line 2314: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,

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

Line 2636: p_rankIndicator IN pon_auction_headers_all.rank_indicator%TYPE,

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

Line 2637: p_bidRanking IN pon_auction_headers_all.bid_ranking%TYPE,

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

Line 2682: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

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

Line 2683: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

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

Line 2690: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

2686: v_batchingRequired BOOLEAN;
2687:
2688: v_numOfBids NUMBER;
2689:
2690: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
2691: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
2692: v_ignore_tech_nonshortlist VARCHAR2(1);
2693: BEGIN
2694:

Line 2691: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;

2687:
2688: v_numOfBids NUMBER;
2689:
2690: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
2691: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
2692: v_ignore_tech_nonshortlist VARCHAR2(1);
2693: BEGIN
2694:
2695:

Line 2714: FROM pon_auction_headers_all

2710: v_bidRanking,
2711: v_maxLineNumber,
2712: v_two_part_flag,
2713: v_sealed_auction_status
2714: FROM pon_auction_headers_all
2715: WHERE auction_header_id = p_auctionHeaderId
2716: FOR UPDATE OF CLOSE_BIDDING_DATE;
2717:
2718: print_log(l_api_name, 'rank_indicator = ' || v_rankIndicator ||

Line 2746: FROM pon_auction_headers_all

2742: -- Actually all archived bids are disqualified as well.
2743: -- +1 is for the currect active bid that is being disqualified.
2744: SELECT number_of_bids
2745: INTO v_numOfBids
2746: FROM pon_auction_headers_all
2747: WHERE auction_header_id = p_auctionHeaderId;
2748: print_log(l_api_name, p_bidNumber || ': original numOfBids=' || v_numOfBids);
2749:
2750: UPDATE pon_auction_headers_all

Line 2750: UPDATE pon_auction_headers_all

2746: FROM pon_auction_headers_all
2747: WHERE auction_header_id = p_auctionHeaderId;
2748: print_log(l_api_name, p_bidNumber || ': original numOfBids=' || v_numOfBids);
2749:
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

Line 2762: FROM pon_auction_headers_all

2758: WHERE auction_header_id = p_auctionHeaderId;
2759:
2760: SELECT number_of_bids
2761: INTO v_numOfBids
2762: FROM pon_auction_headers_all
2763: WHERE auction_header_id = p_auctionHeaderId;
2764: print_log(l_api_name, p_bidNumber || ': new numOfBids=' || v_numOfBids);
2765:
2766: -- for batching, we need to find out the max line number of

Line 3138: pon_auction_headers_all auctions,

3134: l_auc_pf_unit_price_formula,
3135: l_auc_pf_fixed_amount_formula,
3136: l_auc_pf_percentage_formula
3137: FROM
3138: pon_auction_headers_all auctions,
3139: pon_auction_item_prices_all items,
3140: pon_pf_supplier_formula pf_formula
3141: WHERE
3142: auctions.auction_header_id = p_auction_header_id

Line 3349: pon_auction_headers_all ah

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

Line 3377: l_contract_type pon_auction_headers_all.contract_type%TYPE;

3373: -- Unsolicited lines Project
3374: l_unsol_line_count NUMBER;
3375: l_neg_line_total NUMBER;
3376: l_unsol_line_total NUMBER;
3377: l_contract_type pon_auction_headers_all.contract_type%TYPE;
3378: l_offer_sol_line_total NUMBER;
3379: l_sol_line_no_quan_total NUMBER;
3380:
3381: BEGIN

Line 3456: --FROM pon_auction_headers_all

3452: END IF;
3453:
3454: --SELECT Decode(Nvl(has_items_flag,'N'),'Y',NULL,0)
3455: --INTO l_neg_line_total
3456: --FROM pon_auction_headers_all
3457: --WHERE auction_header_id = p_auction_header_id;
3458:
3459: END IF;
3460:

Line 3843: v_auctionType pon_auction_headers_all.auction_type%TYPE;

3839: p_maxLineNumber IN NUMBER,
3840: p_batchSize IN NUMBER,
3841: p_batchingRequired IN BOOLEAN)
3842: IS
3843: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3844: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;

Line 3844: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;

3840: p_batchSize IN NUMBER,
3841: p_batchingRequired IN BOOLEAN)
3842: IS
3843: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3844: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;

Line 3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

3841: p_batchingRequired IN BOOLEAN)
3842: IS
3843: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3844: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;

Line 3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;

3842: IS
3843: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3844: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;

Line 3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;

3843: v_auctionType pon_auction_headers_all.auction_type%TYPE;
3844: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;

Line 3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;

3844: v_bidRanking pon_auction_headers_all.bid_ranking%TYPE;
3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

Line 3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;

3845: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;
3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3853: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;

Line 3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;

3846: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3853: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3854:

Line 3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;

3847: v_autoExtendNumber pon_auction_headers_all.auto_extend_number%TYPE;
3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3853: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3854:
3855: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;

Line 3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;

3848: v_autoExtendDuration pon_auction_headers_all.auto_extend_duration%TYPE;
3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3853: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3854:
3855: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;
3856: v_bidPublishDate pon_bid_item_prices.publish_date%TYPE;

Line 3853: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;

3849: v_autoExtendTypeFlag pon_auction_headers_all.auto_extend_type_flag%TYPE;
3850: v_autoExtendMinTriggerRank pon_auction_headers_all.auto_extend_min_trigger_rank%TYPE;
3851: v_staggeredClosingInterval pon_auction_headers_all.staggered_closing_interval%TYPE;
3852: v_hdrCloseBiddingDate pon_auction_headers_all.close_bidding_date%TYPE;
3853: v_hdrNumberOfExtensions pon_auction_headers_all.number_of_extensions%TYPE;
3854:
3855: v_triggerLineCloseBiddingDate pon_auction_item_prices_all.close_bidding_date%TYPE;
3856: v_bidPublishDate pon_bid_item_prices.publish_date%TYPE;
3857:

Line 3901: pon_auction_headers_all pah

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

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

Line 4097: v_bid_change_type pon_auction_headers_all.min_bid_change_type%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;
4100: v_publish_date DATE;
4101: v_count NUMBER;

Line 4098: v_trading_partner_id pon_auction_headers_all.trading_partner_id%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;
4100: v_publish_date DATE;
4101: v_count NUMBER;
4102: v_bid_decimals NUMBER;

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

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

Line 5282: v_rankIndicator pon_auction_headers_all.rank_indicator%TYPE;

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:
5284: v_batchingRequired BOOLEAN;
5285:
5286: l_api_name CONSTANT VARCHAR2(30) := 'update_all_ranks';

Line 5300: FROM pon_auction_headers_all pah

5296: SELECT pah.bid_ranking,
5297: pah.rank_indicator
5298: INTO v_bidRanking,
5299: v_rankIndicator
5300: FROM pon_auction_headers_all pah
5301: WHERE pah.auction_header_id = p_auctionHeaderId;
5302:
5303: v_batchingRequired := (p_maxLineNumber > p_batchSize);
5304:

Line 5394: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;

5390:
5391: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info';
5392:
5393: -- auto extension variables
5394: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5395: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5396: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;

Line 5395: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;

5391: l_api_name CONSTANT VARCHAR2(30) := 'update_auction_info';
5392:
5393: -- auto extension variables
5394: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5395: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5396: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;
5399: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;

Line 5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;

5393: -- auto extension variables
5394: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5395: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5396: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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;

Line 5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;

5394: v_autoExtendFlag pon_auction_headers_all.auto_extend_flag%TYPE;
5395: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5396: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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;

Line 5399: v_supplierViewType pon_auction_headers_all.supplier_view_type%TYPE;

5395: v_autoExtendAllLinesFlag pon_auction_headers_all.auto_extend_all_lines_flag%TYPE;
5396: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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

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

5396: v_proxyEnabled pon_auc_doctype_rules.display_flag%TYPE;
5397: v_tradingPartnerId pon_auction_headers_all.trading_partner_id%TYPE;
5398: v_is_paused pon_auction_headers_all.is_paused%TYPE;
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;

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

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

Line 5414: v_pfTypeAllowed pon_auction_headers_all.pf_type_allowed%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;
5415: v_priceTiersIndicator pon_auction_headers_all.price_tiers_indicator%TYPE;
5416:
5417: v_maxLineNumber NUMBER;
5418: v_batchSize NUMBER;

Line 5415: v_priceTiersIndicator pon_auction_headers_all.price_tiers_indicator%TYPE;

5411: v_hasCloseDateReached VARCHAR2(1);
5412: v_ispricechanged VARCHAR2(1);
5413:
5414: v_pfTypeAllowed pon_auction_headers_all.pf_type_allowed%TYPE;
5415: v_priceTiersIndicator pon_auction_headers_all.price_tiers_indicator%TYPE;
5416:
5417: v_maxLineNumber NUMBER;
5418: v_batchSize NUMBER;
5419: v_batchingRequired BOOLEAN;

Line 5421: v_max_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

5417: v_maxLineNumber NUMBER;
5418: v_batchSize NUMBER;
5419: v_batchingRequired BOOLEAN;
5420:
5421: v_max_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5422: v_max_num_of_extensions pon_auction_headers_all.number_of_extensions%TYPE;
5423:
5424: l_msg_data VARCHAR2(250);
5425: l_msg_count NUMBER;

Line 5422: v_max_num_of_extensions pon_auction_headers_all.number_of_extensions%TYPE;

5418: v_batchSize NUMBER;
5419: v_batchingRequired BOOLEAN;
5420:
5421: v_max_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5422: v_max_num_of_extensions pon_auction_headers_all.number_of_extensions%TYPE;
5423:
5424: l_msg_data VARCHAR2(250);
5425: l_msg_count NUMBER;
5426: l_return_status VARCHAR2(1);

Line 5431: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;

5427: v_contermsExist VARCHAR2(1);
5428:
5429: v_extendInterval NUMBER;
5430: --for staggered closing
5431: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5432: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5433: v_is_staggered_auction varchar2(1);
5434: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5435: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

Line 5432: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;

5428:
5429: v_extendInterval NUMBER;
5430: --for staggered closing
5431: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5432: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5433: v_is_staggered_auction varchar2(1);
5434: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5435: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5436: v_discard_tech_nonshort varchar2(1);

Line 5434: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;

5430: --for staggered closing
5431: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5432: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5433: v_is_staggered_auction varchar2(1);
5434: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5435: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5436: v_discard_tech_nonshort varchar2(1);
5437:
5438: --added by Allen Yang for Surrogate Bid 2008/10/07

Line 5435: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;

5431: v_orig_close_bidding_date pon_auction_headers_all.close_bidding_date%TYPE;
5432: v_first_line_close_date pon_auction_headers_all.first_line_close_date%TYPE;
5433: v_is_staggered_auction varchar2(1);
5434: v_sealed_auction_status pon_auction_headers_all.sealed_auction_status%TYPE;
5435: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5436: v_discard_tech_nonshort varchar2(1);
5437:
5438: --added by Allen Yang for Surrogate Bid 2008/10/07
5439: v_technical_evaluation_status pon_auction_headers_all.technical_evaluation_status%TYPE;

Line 5439: v_technical_evaluation_status pon_auction_headers_all.technical_evaluation_status%TYPE;

5435: v_two_part_flag pon_auction_headers_all.two_part_flag%TYPE;
5436: v_discard_tech_nonshort varchar2(1);
5437:
5438: --added by Allen Yang for Surrogate Bid 2008/10/07
5439: v_technical_evaluation_status pon_auction_headers_all.technical_evaluation_status%TYPE;
5440:
5441: BEGIN
5442: --
5443: -- logging

Line 5510: FROM pon_auction_headers_all pah

5506: -- added by Allen Yang for Surrogate Bid 2008/10/07
5507: ---------------------------------------------------
5508: , v_technical_evaluation_status
5509: ---------------------------------------------------
5510: FROM pon_auction_headers_all pah
5511: WHERE auction_header_id = p_auctionHeaderId;
5512:
5513: SELECT publish_date,
5514: trading_partner_id,

Line 5733: UPDATE pon_auction_headers_all

5729:
5730: -- UPDATE AUCTION HEADER
5731: -- here we update fields in the auction header
5732: print_log(l_api_name, p_bidNumber || ' - updating auction header');
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

Line 5760: FROM pon_auction_headers_all

5756: nvl2(staggered_closing_interval,'Y','N')
5757: INTO v_first_line_close_date,
5758: v_orig_close_bidding_date,
5759: v_is_staggered_auction
5760: FROM pon_auction_headers_all
5761: WHERE auction_header_id = p_auctionHeaderId;
5762:
5763: print_log(l_api_name, p_bidNumber ||
5764: 'v_first_line_close_date : ' || to_char(v_first_line_close_date,'dd:mm:yy hh:mi:ss' ) ||

Line 5775: UPDATE pon_auction_headers_all

5771: v_first_line_close_date := v_first_line_close_date + (v_max_close_bidding_date -v_orig_close_bidding_date);
5772: end if;
5773: 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' ));
5774:
5775: UPDATE pon_auction_headers_all
5776: SET close_bidding_date = v_max_close_bidding_date,
5777: number_of_extensions = v_max_num_of_extensions,
5778: first_line_close_date = v_first_line_close_date
5779: WHERE auction_header_id = p_auctionHeaderId;

Line 5799: from pon_auction_headers_all

5795: if (PON_CONTERMS_UTL_PVT.is_contracts_installed() = FND_API.G_TRUE) then
5796:
5797: begin
5798: select conterms_exist_flag into v_contermsExist
5799: from pon_auction_headers_all
5800: where auction_header_id = p_auctionHeaderId;
5801:
5802: if(v_contermsExist = 'Y') then
5803: print_log(l_api_name, p_bidNumber || ': ' ||'calling subroutine PON_CONTERMS_UTL_PVT.activateDeliverables');

Line 5903: l_contract_type pon_auction_headers_all.contract_type%TYPE;

5899: l_total_price NUMBER;
5900: l_bid_line_pf_unit_price NUMBER;
5901: l_auc_pf_unit_price NUMBER;
5902:
5903: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5904: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5905: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
5906:
5907: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;

Line 5904: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;

5900: l_bid_line_pf_unit_price NUMBER;
5901: l_auc_pf_unit_price NUMBER;
5902:
5903: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5904: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5905: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
5906:
5907: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5908: l_bid_quantity pon_bid_item_prices.quantity%TYPE;

Line 5905: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;

5901: l_auc_pf_unit_price NUMBER;
5902:
5903: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5904: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5905: l_pf_type_allowed pon_auction_headers_all.pf_type_allowed%TYPE;
5906:
5907: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5908: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
5909:

Line 5930: FROM pon_auction_headers_all

5926: pf_type_allowed
5927: INTO l_contract_type,
5928: l_supplier_view_type,
5929: l_pf_type_allowed
5930: FROM pon_auction_headers_all
5931: WHERE auction_header_id = p_auction_header_id;
5932: ELSE
5933: -- assign the input parameters to the local variables.
5934: l_contract_type := p_contract_type;

Line 6703: v_rank_indicator PON_AUCTION_HEADERS_ALL.RANK_INDICATOR%TYPE;

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

Line 6704: v_bid_ranking PON_AUCTION_HEADERS_ALL.BID_RANKING%TYPE;

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

Line 6705: v_max_internal_line_num PON_AUCTION_HEADERS_ALL.MAX_INTERNAL_LINE_NUM%TYPE;

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

Line 6767: pon_auction_headers_all

6763: v_rank_indicator,
6764: v_bid_ranking,
6765: v_max_internal_line_num
6766: FROM
6767: pon_auction_headers_all
6768: WHERE
6769: auction_header_id = p_auction_header_id
6770: FOR
6771: UPDATE OF close_bidding_date;

Line 6827: pon_auction_headers_all paha

6823: END IF; -- }
6824:
6825: -- Unlock the commercial part of the auction
6826: UPDATE
6827: pon_auction_headers_all paha
6828: SET
6829: paha.last_update_date = sysdate,
6830: paha.last_updated_by = fnd_global.user_id,
6831: paha.scoring_lock_date = null,

Line 6844: AND (EXISTS (select 1 FROM pon_auction_headers_all ah WHERE ah.auction_header_id = bh.auction_header_id

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
6845: AND Nvl(ah.two_part_flag, 'N') = 'Y'
6846: AND Nvl(ah.technical_evaluation_status, 'N') ='COMPLETED')
6847: AND Nvl(bh.surrog_bid_flag, 'N') = 'Y'
6848: AND bh.bid_status = 'DRAFT'