[Home] [Help]
685: decode(NVL(paha.TECHNICAL_EVALUATION_STATUS, 'NOT_COMPLETED'), 'NOT_COMPLETED',
686: decode(NVL(pbh.surrog_bid_flag, 'N'), 'Y',
687: decode(NVL(paha.FULL_QUANTITY_BID_CODE, 'FULL_QTY_BIDS_REQD'), 'FULL_QTY_BIDS_REQD', 1,
688: Decode( Decode(paip.order_type_lookup_code,'QUANTITY','Y','N'),'N',1,
689: Decode( Decode(paha.contract_type,'STANDARD','Y','N'),'N',1,
690: 0))), 0), 0), 0))) s_has_bid_count,
691: sum(decode(bl.is_changed_line_flag, 'Y', 1, 0)) s_changed_line_count,
692: sum(decode(paip.group_type, 'LINE', 1, 'LOT', 1, 'GROUP_LINE', 1, 0)) s_avail_bidded_lines,
693: --sum(decode(bl.has_bid_flag, 'Y', decode(paip.group_type, 'LINE', 1, 'LOT', 1, 'GROUP_LINE', 1, 0), 0)) s_bidded_lines
699: decode(NVL(paha.TECHNICAL_EVALUATION_STATUS, 'NOT_COMPLETED'), 'NOT_COMPLETED',
700: decode(NVL(pbh.surrog_bid_flag, 'N'), 'Y',
701: decode(NVL(paha.FULL_QUANTITY_BID_CODE, 'FULL_QTY_BIDS_REQD'), 'FULL_QTY_BIDS_REQD',1,
702: Decode( Decode(paip.order_type_lookup_code,'QUANTITY','Y','N'),'N',1,
703: Decode( Decode(paha.contract_type,'STANDARD','Y','N'),'N',1,
704: 0))), 0), 0), 0))) s_bidded_lines
705:
706: ----------------------------------------------------------------------------
707: FROM pon_bid_item_prices bl,
3277: -- added by Allen Yang for Surrogate Bid 2008/09/03
3278: ---------------------------------------------------
3279: p_two_part_tech_surrogate_flag = 'N' AND
3280: ---------------------------------------------------
3281: progress_payment_type = 'FINANCE' AND contract_type='STANDARD'
3282: AND s_group_type NOT IN ('GROUP','LOT_LINE') AND s_clm_info_flag <> 'Y' AND progress_pymt_rate_percent IS NULL THEN
3283: INTO pon_interface_errors
3284: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
3285: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
6336: -- maximum quantity of all the price tiers.
6337:
6338: WHEN
6339: (
6340: p_contract_type = 'STANDARD'
6341: and s_max_ship_qty = s_max_quantity
6342: and s_max_ship_qty <> s_bid_quantity
6343: )
6344: THEN
6400:
6401:
6402: -- in case of an SPO the price entered at the line level must be equal to the price
6403: -- corresponding to the maximum quantity of all the price tiers.
6404: WHEN (p_contract_type = 'STANDARD'
6405: and s_max_ship_qty = s_bid_quantity
6406: and s_max_ship_qty = s_max_quantity
6407: and s_bid_price <> s_shipments_price) THEN
6408: INTO pon_interface_errors
7592: bh.rate,
7593: bh.number_price_decimals,
7594: fc.precision,
7595: decode(ah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING', 'Y', 'N'),
7596: decode(ah.contract_type, 'STANDARD',
7597: decode(ah.supplier_view_type, 'TRANSFORMED', 'Y', 'N'), 'N'),
7598: decode(ah.contract_type, 'BLANKET', 'Y', 'CONTRACT', 'Y', 'N'),
7599: nvl(ah.global_agreement_flag, 'N'),
7600: decode(ah.supplier_view_type, 'TRANSFORMED', 'Y', 'N'),
7917: --added by Allen Yang for Surrogate Bid 2009/09/03
7918: --------------------------------------------------
7919: l_two_part_tech_surrogate_flag = 'N' AND
7920: --------------------------------------------------
7921: l_progress_payment_type <> 'NONE' AND l_contract_type = 'STANDARD' AND NVL(p_spreadsheet,g_online_mode) = g_online_mode
7922: THEN
7923: validate_payments
7924: (
7925: p_auc_header_id => p_auc_header_id,