APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 216: FROM pon_bid_attribute_values ba

212: AND EXISTS
213:
214: -- Check attributes
215: (SELECT ba.line_number
216: FROM pon_bid_attribute_values ba
217: WHERE ba.bid_number = bl.bid_number
218: AND ba.line_number = bl.line_number
219: AND (ba.value IS NULL AND ba.old_value IS NOT NULL OR
220: ba.value IS NOT NULL AND ba.old_value IS NULL OR

Line 425: UPDATE pon_bid_attribute_values ba

421: -- NUM - we check value between from_range and to_range,
422: -- converting varchar to number first
423: -- DAT - we check value between from_range and to_range,
424: -- converting varchar to date first (timestamp for need_by_date)
425: UPDATE pon_bid_attribute_values ba
426: SET ba.score =
427: nvl((SELECT s.score
428: FROM pon_attribute_scores s
429: WHERE s.auction_header_id = ba.auction_header_id

Line 454: UPDATE pon_bid_attribute_values ba

450: AND bl.line_number = ba.line_number
451: AND bl.batch_id = p_batch_id);
452:
453:
454: UPDATE pon_bid_attribute_values ba
455: SET ba.weighted_score =
456: (SELECT decode(nvl(aa.scoring_type, 'NONE'),
457: 'NONE', null,
458: aa.weight / 100.0 * nvl(ba.score, 0))

Line 488: FROM pon_bid_attribute_values ba, pon_auction_attributes aa

484: null, decode(bl.has_bid_flag, 'Y', 100, null),
485: 0, decode(bl.has_bid_flag, 'Y', 100, null),
486: sum(decode(sign(aa.weight), 1, nvl2(ba.value, 1, 0), 0)),
487: sum(aa.weight / 100.0 * nvl(ba.score, 0)), null)
488: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
489: WHERE ba.bid_number = bl.bid_number
490: AND ba.line_number = bl.line_number
491: AND aa.auction_header_id = ba.auction_header_id
492: AND aa.line_number = ba.line_number

Line 543: FROM pon_bid_attribute_values ba

539: AND bh.old_surrog_bid_receipt_date <> bh.surrog_bid_receipt_date
540: -- Check if a header attribute was modified
541: OR EXISTS
542: (SELECT null
543: FROM pon_bid_attribute_values ba
544: WHERE ba.bid_number = p_bid_number
545: AND ba.line_number = -1
546: AND (ba.old_value <> ba.value
547: OR ba.old_value IS null AND ba.value IS NOT null

Line 3864: 'PON_BID_ATTRIBUTE_VALUES',

3860: ENTITY_MESSAGE_CODE)
3861: VALUES
3862: (p_interface_type,
3863: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3864: 'PON_BID_ATTRIBUTE_VALUES',
3865: p_batch_id,
3866: s_interface_line_id,
3867: 'PON_AUC_HDR_ATTR_REQ' || p_suffix,
3868: p_userid,

Line 3921: 'PON_BID_ATTRIBUTE_VALUES',

3917: ENTITY_MESSAGE_CODE)
3918: VALUES
3919: (p_interface_type,
3920: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
3921: 'PON_BID_ATTRIBUTE_VALUES',
3922: p_batch_id,
3923: s_interface_line_id,
3924: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,
3925: p_userid,

Line 3964: FROM pon_bid_attribute_values ba, pon_auction_attributes aa

3960: ---------------------------------------------------
3961: ---- Supplier Management: Supplier Evaluation -----
3962: , nvl(pbh.evaluation_flag, 'N') s_evaluation_flag
3963: ---------------------------------------------------
3964: FROM pon_bid_attribute_values ba, pon_auction_attributes aa
3965: --added by Allen Yang for Surrogate Bid 2008/09/03
3966: ---------------------------------------------------
3967: , pon_auction_sections pas
3968: ---------------------------------------------------

Line 4039: 'PON_BID_ATTRIBUTE_VALUES',

4035: ENTITY_MESSAGE_CODE)
4036: VALUES
4037: (p_interface_type,
4038: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
4039: 'PON_BID_ATTRIBUTE_VALUES',
4040: p_batch_id,
4041: s_interface_line_id,
4042: 'PON_AUC_ATTR_VALUE_REQ' || p_suffix,
4043: p_userid,

Line 4100: 'PON_BID_ATTRIBUTE_VALUES',

4096: ENTITY_MESSAGE_CODE)
4097: VALUES
4098: (p_interface_type,
4099: fnd_message.get_string('PON', 'PON_AUCTS_BID_VALUE' || p_suffix),
4100: 'PON_BID_ATTRIBUTE_VALUES',
4101: p_batch_id,
4102: s_interface_line_id,
4103: 'PON_AUC_INVALID_ATTR_VALUE' || p_suffix,
4104: p_userid,

Line 4136: FROM pon_bid_attribute_values ba

4132: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, null) s_worksheet_name,
4133: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, null) s_worksheet_sequence_number,
4134: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ATTRIBUTES', null) s_entity_message_code,
4135: al.line_num_display s_clm_line_num_display
4136: FROM pon_bid_attribute_values ba
4137: , pon_auction_attributes aa
4138: , pon_auction_item_prices_all al
4139: , pon_bid_item_prices bl
4140: , pon_bid_headers pbh