1 PACKAGE PON_UNSOL_UTIL_PKG AUTHID CURRENT_USER AS
2 --$Header: PON_UNSOL_UTIL_PKG.pls 120.4.12020000.3 2013/02/09 10:36:11 hvutukur ship $
3
4 PROCEDURE DELETE_SINGLE_LINE(p_auction_header_id IN NUMBER,
5 p_bid_number IN NUMBER,
6 p_line_number IN NUMBER,
7 x_result OUT NOCOPY VARCHAR2,
8 x_error_code OUT NOCOPY VARCHAR2,
9 x_error_message OUT NOCOPY VARCHAR2);
10
11
12 PROCEDURE DELETE_ALL_LINES(p_auction_header_id IN NUMBER,
13 p_bid_number IN NUMBER,
14 x_result OUT NOCOPY VARCHAR2,
15 x_error_code OUT NOCOPY VARCHAR2,
16 x_error_message OUT NOCOPY VARCHAR2);
17
18 FUNCTION HAS_SOL_LINE_REFERENCES(p_bid_number IN NUMBER,
19 p_line_number IN NUMBER) RETURN VARCHAR2;
20
21 FUNCTION HAS_UNSOL_LINES(p_auc_header_id IN NUMBER) RETURN VARCHAR2;
22
23 FUNCTION HAS_RESPONSE_UNSOL_LINES(p_bid_number IN NUMBER) RETURN VARCHAR2;
24
25 FUNCTION ARE_UNSOL_LINES_ALLOWED(p_auc_header_id IN NUMBER) RETURN VARCHAR2;
26
27 PROCEDURE COPY_UNSOL_OFFER_LINES(p_auction_id IN NUMBER,
28 p_source_bid_num IN NUMBER,
29 p_bid_number IN NUMBER,
30 p_uda_template_id IN NUMBER,
31 p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
32 p_tpcid IN pon_bid_headers.trading_partner_contact_id%TYPE,
33 p_userid IN pon_bid_headers.created_by%TYPE,
34 p_vensid IN pon_bid_headers.vendor_site_id%TYPE);
35
36 PROCEDURE DUPLICATE_UNSOL_AWARDED_LINES(p_auction_id IN NUMBER);
37
38 FUNCTION HAS_PRICED_UNSOL_RESP_LINES(p_bid_number IN NUMBER) RETURN VARCHAR2;
39
40 FUNCTION CAN_PUT_REQ_IN_POOL(p_auction_header_id IN NUMBER,
41 p_line_number IN NUMBER,
42 p_is_line_type_enabled IN VARCHAR2) RETURN VARCHAR2;
43
44 END PON_UNSOL_UTIL_PKG;