[Home] [Help]
33: p_two_part_tech_surrogate_flag IN VARCHAR2) IS
34:
35: l_price_mask VARCHAR2(80);
36: BEGIN
37: l_price_mask := PON_BID_VALIDATIONS_PKG.get_mask(p_price_precision);
38: g_exp_date := SYSDATE + g_exp_days_offset;
39: INSERT ALL
40:
41: -- Price and quantity are required fields if they are editable
865: s_entity_message_code)
866:
867: -- po_bid_min_rel_amount should not exceed currency precision
868: WHEN p_blanket = 'Y' AND
869: PON_BID_VALIDATIONS_PKG.validate_currency_precision(s_po_bid_min_rel_amount, p_amt_precision) = 'F' THEN
870: INTO pon_interface_errors
871: (INTERFACE_TYPE,
872: COLUMN_NAME,
873: TABLE_NAME,
980: -- bid_currency_unit_price only validated when header disp_pf_flag is Y
981: -- bid_currency_unit_price precision should not exceed price precision
982: -- Suppress error if spreadsheet case and no price factors
983: WHEN p_header_disp_pf = 'Y' AND
984: PON_BID_VALIDATIONS_PKG.validate_price_precision(s_bid_currency_unit_price, p_price_precision) = 'F'
985: AND (p_spreadsheet = g_online_mode OR s_display_price_factors_flag = 'Y')
986: --AND p_two_part_tech_surrogate_flag = 'N'
987: THEN
988: INTO pon_interface_errors
1137:
1138: -- bid_currency_price precision should not exceed price precision
1139: WHEN
1140: ( (s_order_type_lookup_code = 'QUANTITY') AND
1141: PON_BID_VALIDATIONS_PKG.validate_price_precision(s_bid_currency_price, p_price_precision) = 'F')
1142: THEN
1143: INTO pon_interface_errors
1144: (INTERFACE_TYPE,
1145: COLUMN_NAME,
1194:
1195: -- bid_currency_price precision should not exceed price precision
1196: WHEN
1197: ( s_order_type_lookup_code <> 'QUANTITY' AND
1198: PON_BID_VALIDATIONS_PKG.validate_price_precision(s_bid_currency_price, p_amt_precision) = 'F')
1199: THEN
1200: INTO pon_interface_errors
1201: (INTERFACE_TYPE,
1202: COLUMN_NAME,