eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 730: UPDATE pon_bid_attribute_values ba

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

Line 733: FROM pon_bid_attribute_values old_ba

729: -- Update attribute old value columns
730: UPDATE pon_bid_attribute_values ba
731: SET ba.old_value =
732: (SELECT old_ba.value
733: FROM pon_bid_attribute_values old_ba
734: WHERE old_ba.bid_number = p_source_bid_num
735: AND old_ba.line_number = ba.line_number
736: AND old_ba.attribute_name = ba.attribute_name)
737: WHERE ba.bid_number = p_bid_number

Line 1538: INSERT INTO pon_bid_attribute_values

1534: FROM pon_auction_headers_all
1535: WHERE auction_header_id = p_auc_header_id;
1536:
1537: -- Insert header attributes
1538: INSERT INTO pon_bid_attribute_values
1539: (
1540: AUCTION_HEADER_ID,
1541: AUCTION_LINE_NUMBER,
1542: BID_NUMBER,

Line 1582: pon_bid_attribute_values ba,

1578: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1579: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1580: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1581: FROM pon_auction_attributes aa,
1582: pon_bid_attribute_values ba,
1583: pon_auction_attributes old_aa
1584: WHERE aa.auction_header_id = p_auc_header_id
1585: AND aa.line_number= -1
1586: AND ba.bid_number (+) = p_source_bid_num

Line 1619: INSERT INTO pon_bid_attribute_values

1615: ) IS
1616: BEGIN
1617:
1618: -- Insert line attributes
1619: INSERT INTO pon_bid_attribute_values
1620: (
1621: AUCTION_HEADER_ID,
1622: AUCTION_LINE_NUMBER,
1623: BID_NUMBER,

Line 1662: pon_bid_attribute_values ba,

1658: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1659: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1660: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1661: FROM pon_auction_attributes aa,
1662: pon_bid_attribute_values ba,
1663: pon_bid_item_prices bl
1664: WHERE aa.auction_header_id = p_auc_header_id
1665: AND aa.line_number > 0
1666: AND bl.bid_number = p_bid_number

Line 2543: FROM pon_bid_attribute_values ba

2539: OR EXISTS
2540:
2541: -- Check attributes
2542: (SELECT ba.line_number
2543: FROM pon_bid_attribute_values ba
2544: WHERE ba.bid_number = bl.bid_number
2545: AND ba.line_number = bl.line_number
2546: AND ba.value IS NOT null
2547: AND rownum = 1)