DBA Data[Home] [Help]

APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_ATTRIBUTE_SCORES

Line 428: FROM pon_attribute_scores s

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
430: AND s.line_number = ba.line_number
431: AND s.attribute_sequence_number = ba.sequence_number
432: AND (datatype = 'TXT' AND ba.value = s.value

Line 3889: FROM pon_attribute_scores bs

3885:
3886: -- value must be among buyer specified values if type is LOV
3887: WHEN p_spreadsheet in (g_txt_upload_mode, g_xml_upload_mode) AND s_scoring_type = 'LOV' AND s_value is not NULL AND NOT EXISTS
3888: (SELECT bs.score
3889: FROM pon_attribute_scores bs
3890: WHERE bs.auction_header_id = p_auc_header_id
3891: AND bs.line_number = s_line_number
3892: AND bs.attribute_sequence_number = s_sequence_number
3893: AND bs.value = s_value) THEN

Line 4068: FROM pon_attribute_scores bs

4064:
4065: -- value must be among buyer specified values if type is LOV
4066: WHEN p_spreadsheet in (g_txt_upload_mode, g_xml_upload_mode) AND s_scoring_type = 'LOV' AND s_value is not NULL AND NOT EXISTS
4067: (SELECT bs.score
4068: FROM pon_attribute_scores bs
4069: WHERE bs.auction_header_id = p_auc_header_id
4070: AND bs.line_number = s_line_number
4071: AND bs.attribute_sequence_number = s_sequence_number
4072: AND bs.value = s_value) THEN