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 122: * corresponding to the award shipment number. PON_BID_ITEM_PRICES is updated accordingly

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

Line 309: p_parent_line_number IN pon_bid_item_prices.line_number%TYPE,

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

Line 310: p_award_status IN pon_bid_item_prices.award_status%TYPE,

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

Line 311: p_award_date IN pon_bid_item_prices.award_date%TYPE,

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

Line 312: p_auctioneer_id pon_bid_item_prices.LAST_UPDATED_BY%TYPE);

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

Line 322: p_award_date IN pon_bid_item_prices.award_date%TYPE,

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

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

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

Line 328: p_line_number IN pon_bid_item_prices.line_number%TYPE,

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

Line 329: p_award_date IN pon_bid_item_prices.award_date%TYPE,

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

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

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