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_AWARD_PKG dependencies on PON_BID_ITEM_PRICES

Line 123: * corresponding to the award shipment number. PON_BID_ITEM_PRICES is updated accordingly

119: * 5. p_award_date -- Award Datw
120: * 6. p_auctioneer_id - Id of person who is saving award
121: * 7. p_award_shipment_number - Quantity awarded falls in the tiers range corresponding to the shipment number
122: * COMMENT : This procedure calculates the award price based on the per unit and fixed amount component and
123: * corresponding to the award shipment number. PON_BID_ITEM_PRICES is updated accordingly
124: *==========================================================================================================================*/
125: PROCEDURE upd_single_bid_item_prices_qt
126: (
127: p_bid_number IN NUMBER,

Line 310: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,

306: --
307: PROCEDURE award_bi_subline (
308: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
309: p_bid_number IN pon_bid_headers.bid_number%TYPE,
310: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
311: p_award_status IN pon_bid_item_prices.award_status%TYPE,
312: p_award_date IN pon_bid_item_prices.award_date%TYPE,
313: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE);
314: --

Line 311: p_award_status IN pon_bid_item_prices.award_status%TYPE,

307: PROCEDURE award_bi_subline (
308: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
309: p_bid_number IN pon_bid_headers.bid_number%TYPE,
310: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
311: p_award_status IN pon_bid_item_prices.award_status%TYPE,
312: p_award_date IN pon_bid_item_prices.award_date%TYPE,
313: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE);
314: --
315: --

Line 312: p_award_date IN pon_bid_item_prices.award_date%TYPE,

308: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
309: p_bid_number IN pon_bid_headers.bid_number%TYPE,
310: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
311: p_award_status IN pon_bid_item_prices.award_status%TYPE,
312: p_award_date IN pon_bid_item_prices.award_date%TYPE,
313: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE);
314: --
315: --
316: ----------------------------------------------------------------

Line 313: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE);

309: p_bid_number IN pon_bid_headers.bid_number%TYPE,
310: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,
311: p_award_status IN pon_bid_item_prices.award_status%TYPE,
312: p_award_date IN pon_bid_item_prices.award_date%TYPE,
313: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE);
314: --
315: --
316: ----------------------------------------------------------------
317: --and sets the award status of parent line by querying up the child lines

Line 323: p_award_date IN pon_bid_item_prices.award_date%TYPE,

319: PROCEDURE update_bi_group_award (
320: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
321: p_bid_number IN pon_bid_headers.bid_number%TYPE,
322: p_parent_line_number IN pon_auction_item_prices_all.parent_line_number%TYPE,
323: p_award_date IN pon_bid_item_prices.award_date%TYPE,
324: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE);
325: --
326: --
327: PROCEDURE update_ai_group_award (

Line 324: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE);

320: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
321: p_bid_number IN pon_bid_headers.bid_number%TYPE,
322: p_parent_line_number IN pon_auction_item_prices_all.parent_line_number%TYPE,
323: p_award_date IN pon_bid_item_prices.award_date%TYPE,
324: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE);
325: --
326: --
327: PROCEDURE update_ai_group_award (
328: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

Line 329: p_line_number IN pon_bid_item_prices.line_number%TYPE,

325: --
326: --
327: PROCEDURE update_ai_group_award (
328: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
329: p_line_number IN pon_bid_item_prices.line_number%TYPE,
330: p_award_date IN pon_bid_item_prices.award_date%TYPE,
331: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE);
332: --
333:

Line 330: p_award_date IN pon_bid_item_prices.award_date%TYPE,

326: --
327: PROCEDURE update_ai_group_award (
328: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
329: p_line_number IN pon_bid_item_prices.line_number%TYPE,
330: p_award_date IN pon_bid_item_prices.award_date%TYPE,
331: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE);
332: --
333:
334: PROCEDURE get_award_totals(

Line 331: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE);

327: PROCEDURE update_ai_group_award (
328: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,
329: p_line_number IN pon_bid_item_prices.line_number%TYPE,
330: p_award_date IN pon_bid_item_prices.award_date%TYPE,
331: p_auctioneer_id IN pon_bid_item_prices.last_updated_by%TYPE);
332: --
333:
334: PROCEDURE get_award_totals(
335: p_auction_header_id in number,