APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 656: FROM pon_bid_attribute_values ba

652: -- instead of attribute_name since attribute_name is a string.
653: UPDATE pon_bid_attr_values_interface bai
654: SET bai.line_number =
655: nvl((SELECT ba.line_number
656: FROM pon_bid_attribute_values ba
657: WHERE ba.bid_number = bai.bid_number
658: AND ba.line_number = bai.line_number
659: AND ba.attribute_name = bai.attribute_name), g_error_int),
660: bai.datatype =

Line 662: FROM pon_bid_attribute_values ba

658: AND ba.line_number = bai.line_number
659: AND ba.attribute_name = bai.attribute_name), g_error_int),
660: bai.datatype =
661: nvl((SELECT ba.datatype
662: FROM pon_bid_attribute_values ba
663: WHERE ba.bid_number = bai.bid_number
664: AND ba.line_number = bai.line_number
665: AND ba.attribute_name = bai.attribute_name), 'N/A'),
666: bai.sequence_number =

Line 668: FROM pon_bid_attribute_values ba

664: AND ba.line_number = bai.line_number
665: AND ba.attribute_name = bai.attribute_name), 'N/A'),
666: bai.sequence_number =
667: nvl((SELECT ba.sequence_number
668: FROM pon_bid_attribute_values ba
669: WHERE ba.bid_number = bai.bid_number
670: AND ba.line_number = bai.line_number
671: AND ba.attribute_name = bai.attribute_name), g_error_int)
672:

Line 1241: MERGE INTO pon_bid_attribute_values ba

1237: AND al2.parent_line_number = bl.line_number
1238: AND bl2.batch_id = p_batch_id);
1239:
1240: -- Update requirements/attributes table from interface
1241: MERGE INTO pon_bid_attribute_values ba
1242: USING
1243: (SELECT
1244: auction_header_id,
1245: bid_number,

Line 1275: UPDATE pon_bid_attribute_values ba

1271: -- For MAS, quantity or promised date are scored, they need to
1272: -- be updated in the bid attributes transaction table
1273: IF (p_mas = 'Y' and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN
1274: -- Update promised_date
1275: UPDATE pon_bid_attribute_values ba
1276: SET value =
1277: nvl((SELECT to_char(bl.promised_date, 'dd-mm-yyyy hh24:mi:ss')
1278: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1279: WHERE bl.bid_number = ba.bid_number

Line 1288: UPDATE pon_bid_attribute_values ba

1284: WHERE ba.bid_number = p_bid_number
1285: AND ba.sequence_number = -10;
1286:
1287: -- Update quantity
1288: UPDATE pon_bid_attribute_values ba
1289: SET value =
1290: nvl((SELECT to_char(bl.quantity)
1291: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1292: WHERE bl.bid_number = ba.bid_number