DBA Data[Home] [Help]

APPS.PON_BID_VALIDATIONS_PKG dependencies on PON_ATTRIBUTE_SCORES

Line 415: FROM pon_attribute_scores s

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
417: AND s.line_number = ba.line_number
418: AND s.attribute_sequence_number = ba.sequence_number
419: AND (datatype = 'TXT' AND ba.value = s.value

Line 3201: FROM pon_attribute_scores bs

3197:
3198: -- value must be among buyer specified values if type is LOV
3199: 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
3200: (SELECT bs.score
3201: FROM pon_attribute_scores bs
3202: WHERE bs.auction_header_id = p_auc_header_id
3203: AND bs.line_number = s_line_number
3204: AND bs.attribute_sequence_number = s_sequence_number
3205: AND bs.value = s_value) THEN

Line 3367: FROM pon_attribute_scores bs

3363:
3364: -- value must be among buyer specified values if type is LOV
3365: 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
3366: (SELECT bs.score
3367: FROM pon_attribute_scores bs
3368: WHERE bs.auction_header_id = p_auc_header_id
3369: AND bs.line_number = s_line_number
3370: AND bs.attribute_sequence_number = s_sequence_number
3371: AND bs.value = s_value) THEN