APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_BID_PRICE_DIFFERENTIALS

Line 297: FROM pon_bid_price_differentials bpd

293: AND EXISTS
294:
295: -- Check price differentials, including shipment price differentials
296: (SELECT bpd.line_number
297: FROM pon_bid_price_differentials bpd
298: WHERE bpd.bid_number = bl.bid_number
299: AND bpd.line_number = bl.line_number
300: AND NVL(bpd.multiplier, g_null_int) <> NVL(bpd.old_multiplier, g_null_int)
301: AND rownum = 1))

Line 6632: 'PON_BID_PRICE_DIFFERENTIALS',

6628: ENTITY_MESSAGE_CODE)
6629: VALUES
6630: (p_interface_type,
6631: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6632: 'PON_BID_PRICE_DIFFERENTIALS',
6633: p_batch_id,
6634: s_interface_line_id,
6635: 'PON_AUC_PD_VALUE_REQ' || p_suffix,
6636: p_userid,

Line 6695: 'PON_BID_PRICE_DIFFERENTIALS',

6691: ENTITY_MESSAGE_CODE)
6692: VALUES
6693: (p_interface_type,
6694: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6695: 'PON_BID_PRICE_DIFFERENTIALS',
6696: p_batch_id,
6697: s_interface_line_id ,
6698: 'PON_AUC_PD_VAL_NONENTERABLE',
6699: p_userid,

Line 6758: 'PON_BID_PRICE_DIFFERENTIALS',

6754: ENTITY_MESSAGE_CODE)
6755: VALUES
6756: (p_interface_type,
6757: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER' || p_suffix),
6758: 'PON_BID_PRICE_DIFFERENTIALS',
6759: p_batch_id,
6760: s_interface_line_id,
6761: 'PON_AUC_PD_INVALID_MULT' || p_suffix,
6762: p_userid,

Line 6824: 'PON_BID_PRICE_DIFFERENTIALS',

6820: ENTITY_MESSAGE_CODE)
6821: VALUES
6822: (p_interface_type,
6823: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6824: 'PON_BID_PRICE_DIFFERENTIALS',
6825: p_batch_id,
6826: s_interface_line_id,
6827: 'PON_AUC_PB_PD_VALUE_REQ' || p_suffix,
6828: p_userid,

Line 6889: 'PON_BID_PRICE_DIFFERENTIALS',

6885: ENTITY_MESSAGE_CODE)
6886: VALUES
6887: (p_interface_type,
6888: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6889: 'PON_BID_PRICE_DIFFERENTIALS',
6890: p_batch_id,
6891: s_interface_line_id,
6892: 'PON_AUC_PB_PD_VAL_NONENTERABLE',
6893: p_userid,

Line 6956: 'PON_BID_PRICE_DIFFERENTIALS',

6952: )
6953: VALUES
6954: (p_interface_type,
6955: fnd_message.get_string('PON', 'PON_AUC_RESP_MULTIPLIER'||p_suffix),
6956: 'PON_BID_PRICE_DIFFERENTIALS',
6957: p_batch_id,
6958: s_interface_line_id,
6959: 'PON_AUC_PB_PD_INVALID_MULT' || p_suffix,
6960: p_userid,

Line 7005: FROM pon_bid_price_differentials bpd

7001: 'PON_PRICE_DIFFERENTIALS',
7002: null
7003: ) s_entity_name,
7004: al.line_num_display s_clm_line_num_display
7005: FROM pon_bid_price_differentials bpd
7006: , pon_bid_item_prices bl
7007: , pon_auction_item_prices_all al
7008: , pon_price_differentials apd
7009: , pon_auction_shipments_all apb