DBA Data[Home] [Help]

APPS.PON_MULTIPLE_RESPONSE_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 44: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

40: -- is to be created. Or whether a draft already exists
41: -- ======================================================================
42: PROCEDURE check_and_load_bid
43: (
44: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
45: p_draft_number IN pon_bid_headers.bid_number%TYPE,
46: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
47: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
48: p_tpname IN pon_bid_headers.trading_partner_name%TYPE,

Line 79: FUNCTION multiple_resp_enabled(p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

75: x_return_status OUT NOCOPY NUMBER,
76: x_return_code OUT NOCOPY VARCHAR2
77: );
78:
79: FUNCTION multiple_resp_enabled(p_auction_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
80: p_buyer_user IN VARCHAR2) RETURN VARCHAR2;
81:
82:
83: /* This procedure gives auction_header_id of document in this round and on previous round

Line 87: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,

83: /* This procedure gives auction_header_id of document in this round and on previous round
84: * which has offers. Draft offers on previous round are not considered.
85: * If offers exist on multiple documents, latest submitted document with offers will be returned.
86: */
87: PROCEDURE get_latest_neg_with_resp(p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
88: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
89: p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
90: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
91: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,

Line 94: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,

90: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
91: p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
92: p_eval_flag IN VARCHAR2,
93: p_buyer_user IN VARCHAR2,
94: x_auc_id_with_resp OUT NOCOPY pon_auction_headers_all.auction_header_id%TYPE,
95: x_is_prev_amend OUT NOCOPY VARCHAR2);
96:
97: END PON_MULTIPLE_RESPONSE_PKG;