APPS.PON_BID_DEFAULTING_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 385: INSERT INTO pon_bid_attribute_values

381: /************************************************************
382: ** STEP 5: Insert missing line attributes
383: *************************************************************/
384:
385: INSERT INTO pon_bid_attribute_values
386: (
387: AUCTION_HEADER_ID,
388: AUCTION_LINE_NUMBER,
389: BID_NUMBER,

Line 422: FROM pon_bid_attribute_values pbav

418: WHERE aa.auction_header_id = p_auc_header_id
419: AND aa.line_number BETWEEN p_batch_start AND p_batch_end
420: AND NOT EXISTS
421: (SELECT pbav.attribute_name
422: FROM pon_bid_attribute_values pbav
423: WHERE pbav.bid_number = p_bid_number
424: AND pbav.line_number = aa.line_number
425: AND pbav.sequence_number = aa.sequence_number));
426:

Line 734: UPDATE pon_bid_attribute_values ba

730: WHERE bl.bid_number = p_bid_number
731: AND bl.line_number BETWEEN p_batch_start AND p_batch_end;
732:
733: -- Update attribute old value columns
734: UPDATE pon_bid_attribute_values ba
735: SET ba.old_value =
736: (SELECT old_ba.value
737: FROM pon_bid_attribute_values old_ba
738: WHERE old_ba.bid_number = p_source_bid_num

Line 737: FROM pon_bid_attribute_values old_ba

733: -- Update attribute old value columns
734: UPDATE pon_bid_attribute_values ba
735: SET ba.old_value =
736: (SELECT old_ba.value
737: FROM pon_bid_attribute_values old_ba
738: WHERE old_ba.bid_number = p_source_bid_num
739: AND old_ba.line_number = ba.line_number
740: AND old_ba.attribute_name = ba.attribute_name)
741: WHERE ba.bid_number = p_bid_number

Line 1742: INSERT INTO pon_bid_attribute_values

1738: FROM pon_auction_headers_all
1739: WHERE auction_header_id = p_auc_header_id;
1740:
1741: -- Insert header attributes
1742: INSERT INTO pon_bid_attribute_values
1743: (
1744: AUCTION_HEADER_ID,
1745: AUCTION_LINE_NUMBER,
1746: BID_NUMBER,

Line 1786: pon_bid_attribute_values ba,

1782: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1783: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1784: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1785: FROM pon_auction_attributes aa,
1786: pon_bid_attribute_values ba,
1787: pon_auction_attributes old_aa
1788: WHERE aa.auction_header_id = p_auc_header_id
1789: AND aa.line_number= -1
1790: AND ba.bid_number (+) = p_source_bid_num

Line 1801: UPDATE pon_bid_attribute_values

1797: -- Begin Supplier Management: Bug 12369949
1798: -- For evaluation response, need to clear value and score for sections
1799: -- not currently assigned to the evaluator
1800: IF (p_eval_flag = 'Y') THEN
1801: UPDATE pon_bid_attribute_values
1802: SET value = NULL,
1803: score = NULL,
1804: weighted_score = NULL
1805: WHERE auction_header_id = p_auc_header_id

Line 1851: INSERT INTO pon_bid_attribute_values

1847: ) IS
1848: BEGIN
1849:
1850: -- Insert line attributes
1851: INSERT INTO pon_bid_attribute_values
1852: (
1853: AUCTION_HEADER_ID,
1854: AUCTION_LINE_NUMBER,
1855: BID_NUMBER,

Line 1894: pon_bid_attribute_values ba,

1890: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1891: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1892: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1893: FROM pon_auction_attributes aa,
1894: pon_bid_attribute_values ba,
1895: pon_bid_item_prices bl
1896: WHERE aa.auction_header_id = p_auc_header_id
1897: AND aa.line_number > 0
1898: AND bl.bid_number = p_bid_number

Line 2779: FROM pon_bid_attribute_values ba

2775: OR EXISTS
2776:
2777: -- Check attributes
2778: (SELECT ba.line_number
2779: FROM pon_bid_attribute_values ba
2780: WHERE ba.bid_number = bl.bid_number
2781: AND ba.line_number = bl.line_number
2782: AND ba.value IS NOT null
2783: AND rownum = 1)