APPS.PON_RESPONSE_IMPORT_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 579: FROM pon_bid_attribute_values ba

575: -- instead of attribute_name since attribute_name is a string.
576: UPDATE pon_bid_attr_values_interface bai
577: SET bai.line_number =
578: nvl((SELECT ba.line_number
579: FROM pon_bid_attribute_values ba
580: WHERE ba.bid_number = bai.bid_number
581: AND ba.line_number = bai.line_number
582: AND ba.attribute_name = bai.attribute_name), g_error_int),
583: bai.datatype =

Line 585: FROM pon_bid_attribute_values ba

581: AND ba.line_number = bai.line_number
582: AND ba.attribute_name = bai.attribute_name), g_error_int),
583: bai.datatype =
584: nvl((SELECT ba.datatype
585: FROM pon_bid_attribute_values ba
586: WHERE ba.bid_number = bai.bid_number
587: AND ba.line_number = bai.line_number
588: AND ba.attribute_name = bai.attribute_name), 'N/A'),
589: bai.sequence_number =

Line 591: FROM pon_bid_attribute_values ba

587: AND ba.line_number = bai.line_number
588: AND ba.attribute_name = bai.attribute_name), 'N/A'),
589: bai.sequence_number =
590: nvl((SELECT ba.sequence_number
591: FROM pon_bid_attribute_values ba
592: WHERE ba.bid_number = bai.bid_number
593: AND ba.line_number = bai.line_number
594: AND ba.attribute_name = bai.attribute_name), g_error_int)
595:

Line 1042: MERGE INTO pon_bid_attribute_values ba

1038: AND al2.parent_line_number = bl.line_number
1039: AND bl2.batch_id = p_batch_id);
1040:
1041: -- Update requirements/attributes table from interface
1042: MERGE INTO pon_bid_attribute_values ba
1043: USING
1044: (SELECT
1045: auction_header_id,
1046: bid_number,

Line 1076: UPDATE pon_bid_attribute_values ba

1072: -- For MAS, quantity or promised date are scored, they need to
1073: -- be updated in the bid attributes transaction table
1074: IF (p_mas = 'Y' and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN
1075: -- Update promised_date
1076: UPDATE pon_bid_attribute_values ba
1077: SET value =
1078: nvl((SELECT to_char(bl.promised_date, 'dd-mm-yyyy hh24:mi:ss')
1079: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1080: WHERE bl.bid_number = ba.bid_number

Line 1089: UPDATE pon_bid_attribute_values ba

1085: WHERE ba.bid_number = p_bid_number
1086: AND ba.sequence_number = -10;
1087:
1088: -- Update quantity
1089: UPDATE pon_bid_attribute_values ba
1090: SET value =
1091: nvl((SELECT to_char(bl.quantity)
1092: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
1093: WHERE bl.bid_number = ba.bid_number