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 3722: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))

3718: (SELECT al.line_number
3719: FROM pon_bid_headers bh,
3720: pon_bid_item_prices bl,
3721: pon_auction_item_prices_all al
3722: WHERE bh.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3723: AND bl.bid_number = bh.bid_number
3724: AND al.auction_header_id = bh.auction_header_id
3725: AND bl.line_number = al.line_number
3726:

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

3945: pon_auction_item_prices_all a,
3946: pon_bid_item_prices b
3947: where
3948: -- We need to consider every bid generated during this publish - the current bid + all proxy bids
3949: b.bid_number IN (SELECT * FROM TABLE(CAST (g_bidsGenerated AS fnd_table_of_number)))
3950: and a.auction_header_id = p_auctionHeaderId
3951: and a.line_number = b.line_number
3952:
3953: -- We extend when any bid will trigger AutoExtend

Line 5591: g_bidsGenerated := fnd_table_of_number(1);

5587: p_vendorSiteId, v_oldBidNumber);
5588: END IF;
5589:
5590: -- (Raja) initialise the global variables that track the bids generated during this publish
5591: g_bidsGenerated := fnd_table_of_number(1);
5592: g_bidsGeneratedCount := 1;
5593: g_bidsGenerated(g_bidsGeneratedCount) := p_bidNumber;
5594:
5595: -- AUTO EXTENSION AND PROXY BIDDING