1 PACKAGE POS_CLM_UTIL_PKG AUTHID CURRENT_USER as
2 /* $Header: POSCLMUTILS.pls 120.2 2010/05/17 07:06:00 vchiranj noship $ */
3
4 g_package_name VARCHAR2(35) := 'pos_clm_util_pkg';
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 to check whether single distrbution enabled*/
14 FUNCTION IsEnforceSingleDistEnabled RETURN VARCHAR2;
15
16 /* Function to check whether DoD case enabled*/
17 FUNCTION IsFundedInfoSLINAllowed RETURN VARCHAR2;
18
19 /* Function to check whether Complex Pricing enabled*/
20 FUNCTION IsComplexPricingAllowed RETURN VARCHAR2;
21
22 /* Function to validate the CLIN/SLIN move*/
23 FUNCTION isValidToMove(
24 p_product IN VARCHAR2
25 ,P_ACTION IN VARCHAR2
26 ,p_document_id IN NUMBER DEFAULT null
27 ,p_from_line_id IN NUMBER
28 ,p_from_GROUP_LINE_ID IN NUMBER
29 ,p_from_CLM_INFO_FLAG IN VARCHAR2
30 ,p_from_CLM_OPTION_INDICATOR IN VARCHAR2
31 ,p_from_CLM_BASE_LINE_NUM IN NUMBER
32 ,p_from_CLM_OPTION_NUM IN NUMBER
33 ,p_from_CLM_OPTION_FROM_DATE IN DATE
34 ,p_from_CLM_OPTION_TO_DATE IN DATE
35 ,p_from_CLM_FUNDED_FLAG IN VARCHAR2
36 ,p_to_line_id IN NUMBER
37 ,p_to_GROUP_LINE_ID IN NUMBER
38 ,p_to_CLM_INFO_FLAG IN VARCHAR2
39 ,p_to_CLM_OPTION_INDICATOR IN VARCHAR2
40 ,p_to_CLM_BASE_LINE_NUM IN NUMBER
41 ,p_to_CLM_OPTION_NUM IN NUMBER
42 ,p_to_CLM_OPTION_FROM_DATE IN date
43 ,p_to_CLM_OPTION_TO_DATE IN date
44 ,p_to_CLM_FUNDED_FLAG IN VARCHAR2
45 ) RETURN VARCHAR2;
46
47 PROCEDURE Check_Uda_Enabled
48 (
49 p_functional_area_code IN VARCHAR2
50 ,p_document_type_code IN VARCHAR2
51 ,p_document_style_id IN NUMBER
52 ,x_enabled_flag OUT NOCOPY VARCHAR2
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_errorcode OUT NOCOPY NUMBER
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE GET_MODIF_LINE_INFO
60 (
61 p_draftId IN NUMBER,
62 p_header_id IN NUMBER,
63 p_line_type_id IN NUMBER,
64 p_item_id IN NUMBER,
65 p_job_id IN NUMBER,
66 p_contract_type IN VARCHAR2,
67 p_matching_basis IN VARCHAR2,
68 x_line_type OUT NOCOPY VARCHAR2,
69 x_item_number OUT NOCOPY VARCHAR2,
70 x_job_title OUT NOCOPY VARCHAR2,
71 x_contract_type OUT NOCOPY VARCHAR2,
72 x_funded_amount OUT NOCOPY NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_errorcode OUT NOCOPY NUMBER,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE GET_MODIF_LINE_UDA_INFO
80 (
81 p_draftId IN NUMBER,
82 p_header_id IN NUMBER,
83 p_line_type_id IN NUMBER,
84 p_org_id IN NUMBER,
85 p_idc_type IN VARCHAR2,
86 p_contract_type IN VARCHAR2,
87 p_item_id IN NUMBER,
88 p_matching_basis IN VARCHAR2,
89 x_line_type OUT NOCOPY VARCHAR2,
90 x_org_name OUT NOCOPY VARCHAR2,
91 x_contract_type OUT NOCOPY VARCHAR2,
92 x_item_name OUT NOCOPY VARCHAR2,
93 x_currency_code OUT NOCOPY VARCHAR2,
94 x_idc_type OUT NOCOPY VARCHAR2,
95 x_ext_price_label OUT NOCOPY VARCHAR2,
96 x_document_type OUT NOCOPY VARCHAR2,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_errorcode OUT NOCOPY NUMBER,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 PROCEDURE GET_MODIF_HEADER_INFO
104 (
105 p_draftId IN NUMBER,
106 p_header_id IN NUMBER,
107 p_vendor_id IN NUMBER,
108 p_vendor_site_id IN NUMBER,
109 p_user_id IN NUMBER,
110 p_orgId IN NUMBER,
111 p_term_id IN NUMBER,
112 p_ship_to_loc_id IN NUMBER,
113 p_bill_to_loc_id IN NUMBER,
114 p_document_level IN VARCHAR2,
115 p_freight_lookup_code IN VARCHAR2,
116 p_ship_cntrl_lookup_code IN VARCHAR2,
117 p_fob_lookup_code IN VARCHAR2,
118 x_chg_amt OUT NOCOPY NUMBER,
119 x_chg_amt_wo_opt OUT NOCOPY NUMBER,
120 x_vendor_name OUT NOCOPY VARCHAR2,
121 x_vendor_site_code OUT NOCOPY VARCHAR2,
122 x_addr_line1 OUT NOCOPY VARCHAR2,
123 x_addr_line2 OUT NOCOPY VARCHAR2,
124 x_addr_line3 OUT NOCOPY VARCHAR2,
125 x_city_state OUT NOCOPY VARCHAR2,
126 x_country OUT NOCOPY VARCHAR2,
127 x_employee_id OUT NOCOPY NUMBER,
128 x_employee_full_name OUT NOCOPY VARCHAR2,
129 x_emp_location_id OUT NOCOPY NUMBER,
130 x_agent_id OUT NOCOPY NUMBER,
131 x_org_name OUT NOCOPY VARCHAR2,
132 x_pay_term_name OUT NOCOPY VARCHAR2,
133 x_freight_meaning OUT NOCOPY VARCHAR2,
134 x_ship_cntrl_meaning OUT NOCOPY VARCHAR2,
135 x_fob_meaning OUT NOCOPY VARCHAR2,
136 x_ship_addr1 OUT NOCOPY VARCHAR2,
137 x_ship_addr2 OUT NOCOPY VARCHAR2,
138 x_ship_addr3 OUT NOCOPY VARCHAR2,
139 x_ship_city_state OUT NOCOPY VARCHAR2,
140 x_bill_addr1 OUT NOCOPY VARCHAR2,
141 x_bill_addr2 OUT NOCOPY VARCHAR2,
142 x_bill_addr3 OUT NOCOPY VARCHAR2,
143 x_bill_city_state OUT NOCOPY VARCHAR2,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_errorcode OUT NOCOPY NUMBER,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150 END POS_CLM_UTIL_PKG;