DBA Data[Home] [Help]

APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_BID_PRICE_ELEMENTS

Line 228: FROM pon_bid_price_elements bpf

224: OR EXISTS
225:
226: -- Check price factors
227: (SELECT bpf.line_number
228: FROM pon_bid_price_elements bpf
229: WHERE bpf.bid_number = bl.bid_number
230: AND bpf.line_number = bl.line_number
231: AND bpf.pf_type = 'SUPPLIER'
232: AND NVL(bpf.bid_currency_value, g_null_int) <> NVL(old_bid_currency_value, g_null_int)

Line 4207: 'PON_BID_PRICE_ELEMENTS',

4203: ENTITY_MESSAGE_CODE)
4204: VALUES
4205: (p_interface_type,
4206: s_column_name,
4207: 'PON_BID_PRICE_ELEMENTS',
4208: p_batch_id,
4209: s_interface_line_id,
4210: 'PON_AUC_PE_VALUE_REQ' || p_suffix,
4211: p_userid,

Line 4266: 'PON_BID_PRICE_ELEMENTS',

4262: entity_message_code)
4263: VALUES
4264: (p_interface_type,
4265: s_column_name,
4266: 'PON_BID_PRICE_ELEMENTS',
4267: p_batch_id,
4268: s_interface_line_id,
4269: 'PON_AUC_PE_MUST_BE_POS' || p_suffix,
4270: p_userid,

Line 4326: 'PON_BID_PRICE_ELEMENTS',

4322: ENTITY_MESSAGE_CODE)
4323: VALUES
4324: (p_interface_type,
4325: s_column_name,
4326: 'PON_BID_PRICE_ELEMENTS',
4327: p_batch_id,
4328: s_interface_line_id,
4329: 'PON_AUC_PE_MUST_BE_POS_ZERO' || p_suffix,
4330: p_userid,

Line 4388: 'PON_BID_PRICE_ELEMENTS',

4384: ENTITY_MESSAGE_CODE)
4385: VALUES
4386: (p_interface_type,
4387: s_column_name,
4388: 'PON_BID_PRICE_ELEMENTS',
4389: p_batch_id,
4390: s_interface_line_id,
4391: 'PON_AUC_PE_INVALID_BID_PREC' || p_suffix,
4392: p_userid,

Line 4450: 'PON_BID_PRICE_ELEMENTS',

4446: entity_message_code)
4447: VALUES
4448: (p_interface_type,
4449: s_column_name,
4450: 'PON_BID_PRICE_ELEMENTS',
4451: p_batch_id,
4452: s_interface_line_id,
4453: 'PON_AUC_PE_INVALID_CURR_PREC' || p_suffix,
4454: p_userid,

Line 4494: FROM pon_bid_price_elements bpf

4490: decode(p_spreadsheet, g_xml_upload_mode,
4491: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
4492: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name,
4493: al.line_num_display s_clm_line_num_display
4494: FROM pon_bid_price_elements bpf
4495: , pon_auction_item_prices_all al
4496: , pon_bid_item_prices bl
4497: , pon_price_element_types_tl pft
4498: , pon_bid_headers pbh