1 PACKAGE PO_CLM_CLO_UTIL AUTHID CURRENT_USER AS
2 /* $Header: PO_CLM_CLO_UTIL.pls 120.8 2011/12/09 13:09:42 snelloru ship $ */
3
4 g_package_name VARCHAR2(35) := 'PO_CLM_CLO_UTIL';
5
6
7
8 /*Function to check whether CLM is installed */
9 FUNCTION isCLMInstalled RETURN boolean;
10
11 FUNCTION getCLMStatus RETURN VARCHAR2;
12
13 FUNCTION checkCLMResp ( user_id NUMBER, resp_id NUMBER, appl_id NUMBER ) RETURN VARCHAR2;
14
15 FUNCTION PO_HEADERS_ALL_DATA_SEC (object_schema in varchar2, object_name varchar2) return VARCHAR2;
16
17 FUNCTION OKC_BUS_DOC_TYPES_DATA_SEC (object_schema in varchar2, object_name varchar2) return VARCHAR2;
18
19 FUNCTION OKC_DELIVERABLES_DATA_SEC (object_schema in varchar2, object_name varchar2) return VARCHAR2;
20
21 /* Function to check whether single distrbution enabled*/
22 FUNCTION IsEnforceSingleDistEnabled RETURN VARCHAR2;
23
24 /* Function to check whether DoD case enabled*/
25 FUNCTION IsFundedInfoSLINAllowed RETURN VARCHAR2;
26
27 /* Function to check whether Complex Pricing enabled*/
28 FUNCTION IsComplexPricingAllowed RETURN VARCHAR2;
29
30 /* Function to validate the CLIN/SLIN move*/
31 FUNCTION isValidToMove(
32 p_product IN VARCHAR2
33 ,P_ACTION IN VARCHAR2
34 ,p_document_id IN NUMBER DEFAULT null
35 ,p_from_line_id IN NUMBER
36 ,p_from_GROUP_LINE_ID IN NUMBER
37 ,p_from_CLM_INFO_FLAG IN VARCHAR2
38 ,p_from_CLM_OPTION_INDICATOR IN VARCHAR2
39 ,p_from_CLM_BASE_LINE_NUM IN NUMBER
40 ,p_from_CLM_OPTION_NUM IN NUMBER
41 ,p_from_CLM_OPTION_FROM_DATE IN DATE
42 ,p_from_CLM_OPTION_TO_DATE IN DATE
43 ,p_from_CLM_FUNDED_FLAG IN VARCHAR2
44 ,p_to_line_id IN NUMBER
45 ,p_to_GROUP_LINE_ID IN NUMBER
46 ,p_to_CLM_INFO_FLAG IN VARCHAR2
47 ,p_to_CLM_OPTION_INDICATOR IN VARCHAR2
48 ,p_to_CLM_BASE_LINE_NUM IN NUMBER
49 ,p_to_CLM_OPTION_NUM IN NUMBER
50 ,p_to_CLM_OPTION_FROM_DATE IN date
51 ,p_to_CLM_OPTION_TO_DATE IN date
52 ,p_to_CLM_FUNDED_FLAG IN VARCHAR2
53 ) RETURN VARCHAR2;
54
55 PROCEDURE Check_Uda_Enabled
56 (
57 p_functional_area_code IN VARCHAR2
58 ,p_document_type_code IN VARCHAR2
59 ,p_document_style_id IN NUMBER
60 ,x_enabled_flag OUT NOCOPY VARCHAR2
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_errorcode OUT NOCOPY NUMBER
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67
68 /*Procedure to check if uda is enabled in PO.*/
69 PROCEDURE check_po_uda_enabled
70 (
71 p_document_type_code IN VARCHAR2,
72 p_document_style_id IN VARCHAR2,
73 x_enabled_flag OUT NOCOPY VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2
75 );
76
77 /*
78 FUNCTION isValidChange
79 ( p_module IN VARCHAR2
80 ,p_line_id IN NUMBER
81 ,p_old_info_flag IN NUMBER
82 ,p_new_flag IN NUMBER
83 )
84 RETURN BOOLEAN; */
85
86 FUNCTION IS_FROM_TO_VALID (p_from_line_id IN NUMBER,
87 p_to_line_id IN NUMBER,
88 p_action IN VARCHAR,
89 p_document_id IN NUMBER) RETURN VARCHAR2;
90
91
92 /* Unsolicited Lines Project */
93 FUNCTION IS_UNSOL_FROM_TO_VALID (p_from_line_id IN NUMBER,
94 p_to_line_id IN NUMBER,
95 p_action IN VARCHAR,
96 p_document_id IN NUMBER) RETURN VARCHAR2;
97
98 END;