PACKAGE: APPS.PON_CLM_UTIL_PKG

Source

1 PACKAGE PON_CLM_UTIL_PKG AUTHID CURRENT_USER as
2 /* $Header: PONCLMUTILS.pls 120.11.12020000.2 2013/02/09 11:48:50 hvutukur ship $ */
3 --g_module_prefix         CONSTANT VARCHAR2(50) := 'pon.plsql.PON_AUCTION_APPROVAL_PKG.';
4 
5 FUNCTION IS_DOCUMENT_FEDERAL(p_doc_type_id  IN  NUMBER) RETURN NUMBER;
6 
7 FUNCTION IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id IN NUMBER) RETURN NUMBER;
8 
9 FUNCTION GET_COPY_ERR_MSGS(p_msg_count  IN NUMBER, p_is_unexp_error OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
10 
11 FUNCTION IS_AMENDMENT(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
12 
13 FUNCTION IS_UDA_ENABLED(p_doc_type_id  IN  NUMBER) RETURN NUMBER;
14 
15 PROCEDURE UPDATE_HEADER_STYLE_ID(p_auction_header_id IN NUMBER,
16                                  p_style_id          IN NUMBER);
17 
18 FUNCTION isCLMInstalled RETURN boolean;
19 
20 
21 FUNCTION ISCLMRESP RETURN VARCHAR2;
22 
23 FUNCTION getCLMStatus ( user_id NUMBER, resp_id NUMBER, appl_id NUMBER ) RETURN VARCHAR2;
24 
25 FUNCTION clm_pon_auc_hdr_vpd_fun (object_schema in varchar2, object_name varchar2) return VARCHAR2;
26 
27 
28 FUNCTION IS_LINE_CLIN(p_auction_header_id IN Number, p_line_number IN Number) return boolean;
29 
30 FUNCTION IS_LINE_PRICED(p_auction_header_id IN Number, p_line_number IN Number) return boolean;
31 
32 Function DOES_CLIN_HAVE_CHILD(p_auction_header_id IN Number, p_line_number IN Number) return boolean;
33 
34 Function DOES_LINE_HAVE_OPTION(p_auction_header_id IN Number, p_line_number IN Number) return boolean;
35 
36 /* Bug 10056890 - Added the following function to return document number in CLM Format. */
37 
38 FUNCTION GET_DOCUMENT_NUMBER(p_auction_header_id IN Number) RETURN VARCHAR2;
39 
40 PROCEDURE UPDATE_UMBRELLA_PROG(p_auction_header_id IN NUMBER,
41 		               p_program_id        IN NUMBER );
42 
43 -- Bug:9954903-added following function
44 
45 function get_clm_pdf_name(p_docNumber in varchar2,
46 		p_revisionNum in Number,
47 		p_language in varchar2,
48 		p_userViewType in varchar2) return varchar2;
49 
50 /* Offer Enhancements Changes */
51 
52 FUNCTION GET_CLM_COMMERCIAL_DOC_NUMBER(P_AUCTION_HEADER_ID IN NUMBER) RETURN VARCHAR2;
53 
54 /*Function to check if Line Structure changes should be enabled in Sourcing*/
55 FUNCTION get_line_structure_enabled(p_auction_header_id IN NUMBER) RETURN VARCHAR2;
56 
57 end PON_CLM_UTIL_PKG;