DBA Data[Home] [Help]

APPS.PON_AWARD_PKG dependencies on PON_BID_HEADERS

Line 58: award_status PON_BID_HEADERS.AWARD_STATUS%TYPE,

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

Line 308: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

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

Line 309: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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

Line 320: p_auction_header_id IN pon_bid_headers.auction_header_id%TYPE,

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

Line 321: p_bid_number IN pon_bid_headers.bid_number%TYPE,

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

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

Line 346: p_bid_number IN PON_BID_HEADERS.BID_NUMBER%TYPE

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