APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_BID_PRICE_DIFFERENTIALS

Line 284: FROM pon_bid_price_differentials bpd

280: AND EXISTS
281:
282: -- Check price differentials, including shipment price differentials
283: (SELECT bpd.line_number
284: FROM pon_bid_price_differentials bpd
285: WHERE bpd.bid_number = bl.bid_number
286: AND bpd.line_number = bl.line_number
287: AND NVL(bpd.multiplier, g_null_int) <> NVL(bpd.old_multiplier, g_null_int)
288: AND rownum = 1))

Line 5891: 'PON_BID_PRICE_DIFFERENTIALS',

5887: ENTITY_MESSAGE_CODE)
5888: VALUES
5889: (p_interface_type,
5890: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
5891: 'PON_BID_PRICE_DIFFERENTIALS',
5892: p_batch_id,
5893: s_interface_line_id,
5894: 'PON_AUC_PD_VALUE_REQ' || p_suffix,
5895: p_userid,

Line 5953: 'PON_BID_PRICE_DIFFERENTIALS',

5949: ENTITY_MESSAGE_CODE)
5950: VALUES
5951: (p_interface_type,
5952: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
5953: 'PON_BID_PRICE_DIFFERENTIALS',
5954: p_batch_id,
5955: s_interface_line_id ,
5956: 'PON_AUC_PD_VAL_NONENTERABLE',
5957: p_userid,

Line 6015: 'PON_BID_PRICE_DIFFERENTIALS',

6011: ENTITY_MESSAGE_CODE)
6012: VALUES
6013: (p_interface_type,
6014: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6015: 'PON_BID_PRICE_DIFFERENTIALS',
6016: p_batch_id,
6017: s_interface_line_id,
6018: 'PON_AUC_PD_INVALID_MULT' || p_suffix,
6019: p_userid,

Line 6080: 'PON_BID_PRICE_DIFFERENTIALS',

6076: ENTITY_MESSAGE_CODE)
6077: VALUES
6078: (p_interface_type,
6079: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6080: 'PON_BID_PRICE_DIFFERENTIALS',
6081: p_batch_id,
6082: s_interface_line_id,
6083: 'PON_AUC_PB_PD_VALUE_REQ' || p_suffix,
6084: p_userid,

Line 6144: 'PON_BID_PRICE_DIFFERENTIALS',

6140: ENTITY_MESSAGE_CODE)
6141: VALUES
6142: (p_interface_type,
6143: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6144: 'PON_BID_PRICE_DIFFERENTIALS',
6145: p_batch_id,
6146: s_interface_line_id,
6147: 'PON_AUC_PB_PD_VAL_NONENTERABLE',
6148: p_userid,

Line 6210: 'PON_BID_PRICE_DIFFERENTIALS',

6206: )
6207: VALUES
6208: (p_interface_type,
6209: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6210: 'PON_BID_PRICE_DIFFERENTIALS',
6211: p_batch_id,
6212: s_interface_line_id,
6213: 'PON_AUC_PB_PD_INVALID_MULT' || p_suffix,
6214: p_userid,

Line 6257: FROM pon_bid_price_differentials bpd

6253: decode(p_spreadsheet, g_xml_upload_mode,
6254: 'PON_PRICE_DIFFERENTIALS',
6255: null
6256: ) s_entity_name
6257: FROM pon_bid_price_differentials bpd
6258: , pon_bid_item_prices bl
6259: , pon_auction_item_prices_all al
6260: , pon_price_differentials apd
6261: , pon_auction_shipments_all apb