1 PACKAGE pon_exhibits_pkg AUTHID CURRENT_USER AS
2 /* $Header: PON_EXHIBITS_PKG.pls 120.6.12020000.4 2013/03/15 07:48:27 rakearun noship $ */
3 PROCEDURE HANDLE_AUCTION_EXHIBIT_DETAILS(p_auction_header_id NUMBER);
4 PROCEDURE CREATE_EXHIBIT_DETAILS(p_auction_header_id NUMBER,p_old_exhibit_number varchar2,p_exhibit_number varchar2);
5 FUNCTION IS_EXHIBITS_ENABLED( p_organization_id IN NUMBER,l_doc_type_id IN NUMBER) RETURN VARCHAR;
6 PROCEDURE DELETE_EXHIBIT_DETAILS(p_auction_header_id NUMBER,p_exhibit_number varchar2);
7 PROCEDURE UPDATE_EXHIBIT_DETAILS(p_auction_header_id NUMBER,p_line_number NUMBER);
8 PROCEDURE LOG_MESSAGE( p_module IN VARCHAR2, p_message IN VARCHAR2);
9
10 FUNCTION HAS_ELIN_ASSOC_FOR_LINE(p_auction_header_id NUMBER, p_line_number IN NUMBER) RETURN VARCHAR2;
11
12 FUNCTION IS_LINE_ELIN (p_auction_header_id NUMBER, p_line_number IN NUMBER) RETURN VARCHAR2;
13
14 FUNCTION IS_EXHIBITS_ENABLED_FOR_AUC(p_auction_header_id NUMBER) RETURN VARCHAR2;
15
16 FUNCTION GET_NEXT_EXHIBIT(
17 auction_header_id IN NUMBER,
18 old_exhibit_number IN VARCHAR2,
19 lines IN NUMBER)
20 RETURN VARCHAR;
21
22
23 PROCEDURE COPY_EXHIBITS(
24 p_auction_header_id NUMBER,
25 p_doctype_id NUMBER,
26 p_user_id NUMBER,
27 p_exhibit_number VARCHAR2,
28 p_is_cdrl VARCHAR2);
29
30 PROCEDURE DELETE_EXHIBITS(
31 p_auction_header_id NUMBER,
32 p_doctype_id NUMBER,
33 p_user_id NUMBER,
34 p_exhibit_number VARCHAR2,
35 p_is_cdrl VARCHAR2);
36
37
38 PROCEDURE COPY_ELINS(
39 p_auction_header_id NUMBER,
40 p_doctype_id NUMBER,
41 p_user_id NUMBER,
42 p_exhibit_number VARCHAR2);
43
44 PROCEDURE DELETE_ELINS(
45 p_auction_header_id NUMBER,
46 p_doctype_id NUMBER,
47 p_user_id NUMBER,
48 p_exhibit_number VARCHAR2);
49
50
51 /* This api will check if cdrls are enabled for org or not?
52 * This will return "Y" : only if federal and cdrls are enabled.
53 */
54 FUNCTION IS_CDRLS_ENABLED( p_organization_id IN NUMBER,l_doc_type_id IN NUMBER)
55 RETURN VARCHAR;
56
57 /* This api will Insert data into Exhibit Details table for cdrls.
58 * This will be called from okc code.
59 * If cdrl record already exists : x_return_status = 'S', x_return_msg := 'CDRL_RECORD_EXISTS'
60 * If p_exhibit_number is used by elins : x_return_status = 'U', x_return_msg := 'EXHIBIT_NUM_USED_BY_ELIN'
61 */
62 PROCEDURE INSERT_CDRL_EXHIBIT_DETAILS(p_auction_header_id IN NUMBER,
63 p_exhibit_number IN VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_return_msg OUT NOCOPY VARCHAR2);
66
67 /* This api will delete cdrl exhibit record from pon_auction_exhibit_details table.
68 * This api should be called by okc code.
69 */
70 PROCEDURE DELETE_CDRL_EXHIBIT_DETAILS(p_auction_header_id IN NUMBER,
71 p_exhibit_number IN VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2);
73
74 END PON_EXHIBITS_PKG;