1 PACKAGE PON_MULTIPLE_RESPONSE_PKG AUTHID CURRENT_USER AS
2 --$Header: PON_MULTIPLE_RESPONSE_PKG.pls 120.0 2011/11/28 10:54:59 hvutukur noship $
3
4 -- ======================================================================
5 -- PROCEDURE: CHECK_AND_LOAD_BID PUBLIC
6 -- PARAMETERS:
7 -- p_auc_header_id IN auction header id of negotiation
8 -- p_draft_number IN non-null if a specific draft is to be loaded
9 -- or if the action code is CREATE_NEW_AMEND_DRAFT
10 -- p_tpid IN trading partner id of supplier
11 -- p_tpcid IN trading partner contact id of supplier
12 -- p_tpname IN trading partner name of supplier
13 -- p_tpcname IN trading partner contact name of supplier
14 -- p_userid IN userid of bid creator
15 -- p_venid IN vendor id
16 -- p_vensid IN vendor site to place a bid for
17 -- p_venscode IN corresponding vendor site code
18 -- p_buyer_user IN determines if surrogate bid
19 -- p_auctpid IN trading partner id of buyer if surrogate bid
20 -- p_auctpcid IN trading partner contact id of buyer if surrogate bid
21
22 -- p_evaluator_id IN evaluator user id
23 -- p_eval_flag IN flag indicating if the response is an evaluation
24
25 -- x_bid_number OUT bid number of draft loaded or created
26 -- x_rebid_flag OUT flag determining if rebid or not
27 -- x_prev_bid_number OUT source bid number
28 -- x_amend_bid_def OUT Y if source bid is on a previous amendment
29 -- x_round_bid_def OUT Y if source bid is on a previous round
30 -- x_prev_bid_disq OUT Y if source bid was disqualified
31 -- x_prev_bid_wthd OUT Y if source bid was Withdrawn
32 -- x_withdraw_reason source bid Withdraw Reason
33 -- x_edit_draft OUT Y if we loaded an existing draft
34
35 -- p_action_code IN determine if a special action needs to be taken
36 -- x_return_status OUT 0 for success, 1 for error
37 -- x_return_code OUT returned error code, or SUCCESS
38 --
39 -- COMMENT: Main procedure which determines whether a new or defaulted bid
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,
49 p_tpcname IN pon_bid_headers.trading_partner_contact_name%TYPE,
50 p_userid IN pon_bid_headers.created_by%TYPE,
51 p_venid IN pon_bid_headers.vendor_id%TYPE,
52 p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
53 p_venscode IN pon_bid_headers.vendor_site_code%TYPE,
54 p_buyer_user IN VARCHAR2,
55 p_auctpid IN pon_bid_headers.surrog_bid_created_tp_id%TYPE,
56 p_auctpcid IN pon_bid_headers.surrog_bid_created_contact_id%TYPE,
57
58 ----------- Supplier Management: Supplier Evaluation -----------
59 p_evaluator_id IN pon_bid_headers.evaluator_id%TYPE,
60 p_eval_flag IN pon_bid_headers.evaluation_flag%TYPE,
61 ----------------------------------------------------------------
62
63 x_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
64 x_rebid_flag OUT NOCOPY VARCHAR2,
65 x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
66 x_amend_bid_def OUT NOCOPY VARCHAR2,
67 x_round_bid_def OUT NOCOPY VARCHAR2,
68 x_prev_bid_disq OUT NOCOPY VARCHAR2,
69 x_prev_bid_wthd OUT NOCOPY VARCHAR2,
70 x_withdraw_reason OUT NOCOPY VARCHAR2,
71 x_edit_draft OUT NOCOPY VARCHAR2,
72
73 p_action_code IN VARCHAR2,
74 p_rev_bid_number IN pon_bid_headers.bid_number%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
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,
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;