[Home] [Help]
2620: -- added by Allen Yang for Surrogate Bid 2008/09/03
2621: ---------------------------------------------------
2622: p_two_part_tech_surrogate_flag = 'N' AND
2623: ---------------------------------------------------
2624: progress_payment_type = 'FINANCE' AND contract_type='STANDARD'
2625: AND s_group_type NOT IN ('GROUP','LOT_LINE') AND progress_pymt_rate_percent IS NULL THEN
2626: INTO pon_interface_errors
2627: (INTERFACE_TYPE, COLUMN_NAME, TABLE_NAME, --1
2628: BATCH_ID, INTERFACE_LINE_ID, ERROR_MESSAGE_NAME, --2
5598: -- maximum quantity of all the price tiers.
5599:
5600: WHEN
5601: (
5602: p_contract_type = 'STANDARD'
5603: and s_max_ship_qty = s_max_quantity
5604: and s_max_ship_qty <> s_bid_quantity
5605: )
5606: THEN
5661:
5662:
5663: -- in case of an SPO the price entered at the line level must be equal to the price
5664: -- corresponding to the maximum quantity of all the price tiers.
5665: WHEN (p_contract_type = 'STANDARD'
5666: and s_max_ship_qty = s_bid_quantity
5667: and s_max_ship_qty = s_max_quantity
5668: and s_bid_price <> s_shipments_price) THEN
5669: INTO pon_interface_errors
6725: bh.rate,
6726: bh.number_price_decimals,
6727: fc.precision,
6728: decode(ah.bid_ranking, 'MULTI_ATTRIBUTE_SCORING', 'Y', 'N'),
6729: decode(ah.contract_type, 'STANDARD',
6730: decode(ah.supplier_view_type, 'TRANSFORMED', 'Y', 'N'), 'N'),
6731: decode(ah.contract_type, 'BLANKET', 'Y', 'CONTRACT', 'Y', 'N'),
6732: nvl(ah.global_agreement_flag, 'N'),
6733: decode(ah.supplier_view_type, 'TRANSFORMED', 'Y', 'N'),
7016: --added by Allen Yang for Surrogate Bid 2009/09/03
7017: --------------------------------------------------
7018: l_two_part_tech_surrogate_flag = 'N' AND
7019: --------------------------------------------------
7020: l_progress_payment_type <> 'NONE' AND l_contract_type = 'STANDARD' AND NVL(p_spreadsheet,g_online_mode) = g_online_mode
7021: THEN
7022: validate_payments
7023: (
7024: p_auc_header_id => p_auc_header_id,