APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 203: FROM pon_bid_attribute_values ba

199: AND EXISTS
200:
201: -- Check attributes
202: (SELECT ba.line_number
203: FROM pon_bid_attribute_values ba
204: WHERE ba.bid_number = bl.bid_number
205: AND ba.line_number = bl.line_number
206: AND (ba.value IS NULL AND ba.old_value IS NOT NULL OR
207: ba.value IS NOT NULL AND ba.old_value IS NULL OR

Line 412: UPDATE pon_bid_attribute_values ba

408: -- NUM - we check value between from_range and to_range,
409: -- converting varchar to number first
410: -- DAT - we check value between from_range and to_range,
411: -- converting varchar to date first (timestamp for need_by_date)
412: UPDATE pon_bid_attribute_values ba
413: SET ba.score =
414: nvl((SELECT s.score
415: FROM pon_attribute_scores s
416: WHERE s.auction_header_id = ba.auction_header_id

Line 441: UPDATE pon_bid_attribute_values ba

437: AND bl.line_number = ba.line_number
438: AND bl.batch_id = p_batch_id);
439:
440:
441: UPDATE pon_bid_attribute_values ba
442: SET ba.weighted_score =
443: (SELECT decode(nvl(aa.scoring_type, 'NONE'),
444: 'NONE', null,
445: aa.weight / 100.0 * nvl(ba.score, 0))

Line 475: FROM pon_bid_attribute_values ba, pon_auction_attributes aa

471: null, decode(bl.has_bid_flag, 'Y', 100, null),
472: 0, decode(bl.has_bid_flag, 'Y', 100, null),
473: sum(decode(sign(aa.weight), 1, nvl2(ba.value, 1, 0), 0)),
474: sum(aa.weight / 100.0 * nvl(ba.score, 0)), null)
475: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
476: WHERE ba.bid_number = bl.bid_number
477: AND ba.line_number = bl.line_number
478: AND aa.auction_header_id = ba.auction_header_id
479: AND aa.line_number = ba.line_number

Line 525: FROM pon_bid_attribute_values ba

521: AND bh.old_surrog_bid_receipt_date <> bh.surrog_bid_receipt_date
522: -- Check if a header attribute was modified
523: OR EXISTS
524: (SELECT null
525: FROM pon_bid_attribute_values ba
526: WHERE ba.bid_number = p_bid_number
527: AND ba.line_number = -1
528: AND (ba.old_value <> ba.value
529: OR ba.old_value IS null AND ba.value IS NOT null

Line 3176: 'PON_BID_ATTRIBUTE_VALUES',

3172: ENTITY_MESSAGE_CODE)
3173: VALUES
3174: (p_interface_type,
3175: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3176: 'PON_BID_ATTRIBUTE_VALUES',
3177: p_batch_id,
3178: s_interface_line_id,
3179: 'PON_AUC_HDR_ATTR_REQ' || p_suffix,
3180: p_userid,

Line 3233: 'PON_BID_ATTRIBUTE_VALUES',

3229: ENTITY_MESSAGE_CODE)
3230: VALUES
3231: (p_interface_type,
3232: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3233: 'PON_BID_ATTRIBUTE_VALUES',
3234: p_batch_id,
3235: s_interface_line_id,
3236: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,
3237: p_userid,

Line 3271: FROM pon_bid_attribute_values ba, pon_auction_attributes aa

3267: --added by Allen Yang for Surrogate Bid 2008/09/03
3268: ---------------------------------------------------
3269: , pas.two_part_section_type s_two_part_section_type
3270: ---------------------------------------------------
3271: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
3272: --added by Allen Yang for Surrogate Bid 2008/09/03
3273: ---------------------------------------------------
3274: , pon_auction_sections pas
3275: ---------------------------------------------------

Line 3339: 'PON_BID_ATTRIBUTE_VALUES',

3335: ENTITY_MESSAGE_CODE)
3336: VALUES
3337: (p_interface_type,
3338: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3339: 'PON_BID_ATTRIBUTE_VALUES',
3340: p_batch_id,
3341: s_interface_line_id,
3342: 'PON_AUC_ATTR_VALUE_REQ' || p_suffix,
3343: p_userid,

Line 3399: 'PON_BID_ATTRIBUTE_VALUES',

3395: ENTITY_MESSAGE_CODE)
3396: VALUES
3397: (p_interface_type,
3398: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3399: 'PON_BID_ATTRIBUTE_VALUES',
3400: p_batch_id,
3401: s_interface_line_id,
3402: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,
3403: p_userid,

Line 3434: FROM pon_bid_attribute_values ba

3430: decode(p_spreadsheet, g_xml_upload_mode, ba.interface_line_id, g_txt_upload_mode, bl.interface_line_id, null) s_interface_line_id,
3431: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, null) s_worksheet_name,
3432: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, null) s_worksheet_sequence_number,
3433: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ATTRIBUTES', null) s_entity_message_code
3434: FROM pon_bid_attribute_values ba
3435: , pon_auction_attributes aa
3436: , pon_auction_item_prices_all al
3437: , pon_bid_item_prices bl
3438: , pon_bid_headers pbh