APPS.PON_AUCTION_HEADERS_PKG dependencies on FND_TABLE_OF_NUMBER

Line 18: g_bidsGenerated fnd_table_of_number;

14: g_pkg_name CONSTANT VARCHAR2(50) := 'auctionHeadersPkg';
15: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.' || g_pkg_name || '.';
16:
17: -- (Raja) global variables used to store the bid numbers generated per publish
18: g_bidsGenerated fnd_table_of_number;
19: g_bidsGeneratedCount NUMBER;
20: --
21: --private helper procedure for logging
22: PROCEDURE print_log(p_module IN VARCHAR2,

Line 3555: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))

3551: (SELECT al.line_number
3552: FROM pon_bid_headers bh,
3553: pon_bid_item_prices bl,
3554: pon_auction_item_prices_all al
3555: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3556: AND bl.bid_number = bh.bid_number
3557: AND al.auction_header_id = bh.auction_header_id
3558: AND bl.line_number = al.line_number
3559:

Line 3782: b.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))

3778: pon_auction_item_prices_all a,
3779: pon_bid_item_prices b
3780: where
3781: -- We need to consider every bid generated during this publish - the current bid + all proxy bids
3782: b.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3783: and a.auction_header_id = p_auctionHeaderId
3784: and a.line_number = b.line_number
3785:
3786: -- We extend when any bid will trigger AutoExtend

Line 5424: g_bidsGenerated := fnd_table_of_number(1);

5420: p_vendorSiteId, v_oldBidNumber);
5421: END IF;
5422:
5423: -- (Raja) initialise the global variables that track the bids generated during this publish
5424: g_bidsGenerated := fnd_table_of_number(1);
5425: g_bidsGeneratedCount := 1;
5426: g_bidsGenerated(g_bidsGeneratedCount) := p_bidNumber;
5427:
5428: -- AUTO EXTENSION AND PROXY BIDDING