1 PACKAGE pn_varen_util AUTHID CURRENT_USER AS
2 /* $Header: PNVARUTS.pls 120.1 2010/12/15 10:22:59 seevivek noship $ */
3 g_pn_miss_num CONSTANT NUMBER := 1.7e20;
4 g_pn_miss_date CONSTANT DATE := TO_DATE ('01/01/4712'
5 , 'DD/MM/YYYY'
6 );
7 g_pn_miss_char CONSTANT VARCHAR2 (3) := '^';
8 g_module_name CONSTANT VARCHAR2 (2) := 'PN';
9 g_debug VARCHAR2 (255) := NVL (fnd_profile.VALUE ('PN_DEBUG_MODE')
10 , 'N'
11 );
12
13 PROCEDURE validate_lease (
14 p_lease_name IN VARCHAR2
15 , p_lease_num IN VARCHAR2
16 , x_lease_id IN OUT NOCOPY VARCHAR2
17 , x_proration_days OUT NOCOPY NUMBER
18 , x_location_id IN OUT NOCOPY NUMBER
19 , p_location_code IN VARCHAR2
20 , x_lease_commencement_date OUT NOCOPY DATE
21 , x_lease_termination_date OUT NOCOPY DATE
22 , p_org_id IN NUMBER
23 , x_return_status OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE validate_rent_num (
27 x_rent_num IN OUT NOCOPY VARCHAR2
28 , x_var_rent_id OUT NOCOPY VARCHAR2
29 , p_lease_id IN NUMBER
30 , p_org_id IN NUMBER
31 , x_return_status OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE validate_location (
35 p_lease_id IN NUMBER
36 , x_location_id IN OUT NOCOPY NUMBER
37 , x_location_code IN OUT NOCOPY VARCHAR2
38 , x_return_status OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE validate_lookups (
42 p_lookup_type IN VARCHAR2
43 , x_lookup_meaning IN OUT NOCOPY VARCHAR2
44 , x_lookup_code IN OUT NOCOPY VARCHAR2
45 , x_return_status OUT NOCOPY VARCHAR2
46 );
47
48 PROCEDURE validate_term_template (
49 p_org_id IN NUMBER
50 , x_term_template_id IN OUT NOCOPY NUMBER
51 , x_term_template_name IN OUT NOCOPY VARCHAR2
52 , x_return_status OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE validate_abst_user (
56 x_user_name IN OUT NOCOPY VARCHAR2
57 , x_user_id IN OUT NOCOPY NUMBER
58 , x_return_status OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE validate_currency (
62 p_currency_code IN VARCHAR2
63 , x_return_status OUT NOCOPY VARCHAR2
64 );
65
66 PROCEDURE validate_periods (
67 p_lookup_type IN VARCHAR2
68 , x_lookup_meaning IN OUT NOCOPY VARCHAR2
69 , x_lookup_code IN OUT NOCOPY VARCHAR2
70 , x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE validate_calendar_date (
74 p_commencement_date IN DATE
75 , p_use_gl_calendar IN VARCHAR2
76 , p_year_start_date IN OUT NOCOPY DATE
77 , p_gl_period_set_name IN OUT NOCOPY VARCHAR2
78 , p_period_type IN OUT NOCOPY VARCHAR2
79 , x_return_status OUT NOCOPY VARCHAR2
80 );
81
82 PROCEDURE check_prora_cum_comb (
83 p_proration_rule_code IN VARCHAR2
84 , p_cumulative_vol_code IN VARCHAR2
85 , x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 PROCEDURE check_prora_invon_comb (
89 p_proration_rule_code IN VARCHAR2
90 , p_invoice_on_code IN VARCHAR2
91 , x_return_status OUT NOCOPY VARCHAR2
92 );
93
94 PROCEDURE check_calc_rept_freq_comb (
95 p_vrg_reptg_freq_code IN VARCHAR2
96 , p_reptg_freq_code IN VARCHAR2
97 , x_return_status OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE check_calc_inv_freq_comb (
101 p_reptg_freq_code IN VARCHAR2
102 , p_invg_freq_code IN VARCHAR2
103 , x_return_status OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE validate_agreement_temp (
107 x_agreement_template_id IN OUT NOCOPY NUMBER
108 , x_agreement_template IN OUT NOCOPY VARCHAR2
109 , x_purpose_code OUT NOCOPY VARCHAR2
110 , x_type_code OUT NOCOPY VARCHAR2
111 , x_cumulative_vol OUT NOCOPY VARCHAR2
112 , x_invoice_on OUT NOCOPY VARCHAR2
113 , x_negative_rent OUT NOCOPY VARCHAR2
114 , x_term_template_id OUT NOCOPY NUMBER
115 , x_abatement_amount OUT NOCOPY NUMBER
116 , x_proration_rule OUT NOCOPY VARCHAR2
117 , x_vrg_reptg_freq_code OUT NOCOPY VARCHAR2
118 , x_period_freq_code OUT NOCOPY VARCHAR2
119 , x_use_gl_calendar OUT NOCOPY VARCHAR2
120 , x_year_start_date OUT NOCOPY DATE
121 , x_gl_period_set_name OUT NOCOPY VARCHAR2
122 , x_period_type OUT NOCOPY VARCHAR2
123 , x_reptg_freq_code OUT NOCOPY VARCHAR2
124 , x_reptg_day_of_month OUT NOCOPY NUMBER
125 , x_reptg_days_after OUT NOCOPY NUMBER
126 , x_invg_freq_code OUT NOCOPY VARCHAR2
127 , x_invg_spread_code OUT NOCOPY VARCHAR2
128 , x_invg_day_of_month OUT NOCOPY VARCHAR2
129 , x_invg_days_after OUT NOCOPY VARCHAR2
130 , x_comments OUT NOCOPY VARCHAR2
131 , p_org_id IN NUMBER
132 , x_return_status OUT NOCOPY VARCHAR2
133 );
134
135 PROCEDURE pvt_debug (
136 p_log_message IN VARCHAR2
137 , p_log_level IN NUMBER
138 );
139
140 PROCEDURE var_rent_details (
141 p_var_rent_id IN NUMBER
142 , p_org_id IN NUMBER
143 , x_commencement_date OUT NOCOPY DATE
144 , x_termination_date OUT NOCOPY DATE
145 , x_return_status OUT NOCOPY VARCHAR2
146 );
147
148 PROCEDURE validate_flex_fields (
149 p_desc_flex_name IN VARCHAR2
150 , p_attribute_category IN VARCHAR2
151 , p_attribute1 IN VARCHAR2
152 , p_attribute2 IN VARCHAR2
153 , p_attribute3 IN VARCHAR2
154 , p_attribute4 IN VARCHAR2
155 , p_attribute5 IN VARCHAR2
156 , p_attribute6 IN VARCHAR2
157 , p_attribute7 IN VARCHAR2
158 , p_attribute8 IN VARCHAR2
159 , p_attribute9 IN VARCHAR2
160 , p_attribute10 IN VARCHAR2
161 , p_attribute11 IN VARCHAR2
162 , p_attribute12 IN VARCHAR2
163 , p_attribute13 IN VARCHAR2
164 , p_attribute14 IN VARCHAR2
165 , p_attribute15 IN VARCHAR2
166 , x_return_msg OUT NOCOPY VARCHAR2
167 , x_return_status OUT NOCOPY VARCHAR2
168 );
169 -- The below procedure specification has been commented by Vivek on 08-Dec-2010
170 /*
171 PROCEDURE val_rent_details (
172 p_rent_num IN VARCHAR2
176 , x_return_status OUT NOCOPY VARCHAR2
173 , x_var_rent_id OUT NOCOPY NUMBER
174 , x_lease_id OUT NOCOPY NUMBER
175 , x_location_id OUT NOCOPY NUMBER
177 );
178 */
179 -- The below procedure specification has been added by Vivek on 08-Dec-2010
180 PROCEDURE val_rent_details (
181 p_rent_num IN OUT NOCOPY NUMBER
182 , x_var_rent_id IN OUT NOCOPY NUMBER
183 -- , x_lease_id OUT NOCOPY NUMBER
184 -- , x_location_id OUT NOCOPY NUMBER
185 , x_return_status OUT NOCOPY VARCHAR2
186 );
187
188 PROCEDURE validate_period_set_type (
189 p_gl_period_set_name IN OUT NOCOPY VARCHAR2
190 , p_period_type IN OUT NOCOPY VARCHAR2
191 , x_return_status OUT NOCOPY VARCHAR2
192 );
193
194 PROCEDURE breakpoint_ext (
195 p_var_rent_id IN NUMBER
196 , x_bkpt_exist OUT NOCOPY NUMBER
197 , x_return_status OUT NOCOPY VARCHAR2
198 );
199
200 PROCEDURE constr_ext (
201 p_var_rent_id IN NUMBER
202 , x_constr_count OUT NOCOPY NUMBER
203 , x_return_status OUT NOCOPY VARCHAR2
204 );
205
206 -- Below Procedure has been added by Vivek on 08-Dec-2010 to validate lease during update flow
207 PROCEDURE validate_lease_id (
208 p_lease_id IN OUT NOCOPY NUMBER
209 , x_lease_commencement_date OUT NOCOPY DATE
210 , x_lease_termination_date OUT NOCOPY DATE
211 , x_return_status OUT NOCOPY VARCHAR2
212 );
213
214 END pn_varen_util;