DBA Data[Home] [Help]

APPS.PON_AWARD_PKG dependencies on PON_BID_HEADERS

Line 57: award_status PON_BID_HEADERS.AWARD_STATUS%TYPE,

53:
54: -- FPK: CPA
55: TYPE PON_AWARD_HEADER_REC IS RECORD (
56: bid_number NUMBER,
57: award_status PON_BID_HEADERS.AWARD_STATUS%TYPE,
58: award_date DATE
59: );
60:
61: TYPE t_awarded_bid_headers IS TABLE OF PON_AWARD_HEADER_REC

Line 307: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

303: --
304: FUNCTION get_award_amount(p_auction_header_id IN NUMBER) RETURN NUMBER;
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,

Line 308: p_bid_number IN pon_bid_headers.bid_number%TYPE,

304: FUNCTION get_award_amount(p_auction_header_id IN NUMBER) RETURN NUMBER;
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);

Line 319: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

315: ----------------------------------------------------------------
316: --and sets the award status of parent line by querying up the child lines
317: ----------------------------------------------------------------
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);

Line 320: p_bid_number IN pon_bid_headers.bid_number%TYPE,

316: --and sets the award status of parent line by querying up the child lines
317: ----------------------------------------------------------------
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: --

Line 327: p_auction_header_id IN pon_bid_headers.auction_header_id%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,
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: --

Line 345: p_bid_number IN PON_BID_HEADERS.BID_NUMBER%TYPE

341: FUNCTION does_bid_exist
342: (
343: p_scenario_id IN PON_OPTIMIZE_CONSTRAINTS.SCENARIO_ID%TYPE,
344: p_sequence_number IN PON_OPTIMIZE_CONSTRAINTS.SEQUENCE_NUMBER%TYPE,
345: p_bid_number IN PON_BID_HEADERS.BID_NUMBER%TYPE
346: ) RETURN VARCHAR2;
347:
348:
349: FUNCTION has_scored_attribute