[Home] [Help]
PACKAGE: APPS.OKL_LLA_UTIL_PVT
Source
1 PACKAGE Okl_Lla_Util_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRLAUS.pls 120.12.12010000.4 2009/08/05 12:52:55 rpillay ship $ */
3 /* *************************************** */
4
5 g_canonical_mask VARCHAR2(15) := FND_DATE.canonical_mask;
6 G_DISPLAY_MASK VARCHAR2(15) := fnd_profile.value('ICX_DATE_FORMAT_MASK');
7 l_temp VARCHAR2(15) := 'YYYY/MM/DD';
8
9 -- MVASUDEV, 8/26/2004
10 -- Added the following constants for Business Events Enabling
11 G_KHR_PROCESS_NEW CONSTANT VARCHAR2(3) := 'NEW';
12 G_KHR_PROCESS_MASS_REBOOK CONSTANT VARCHAR2(11) := 'MASS_REBOOK';
13 G_KHR_PROCESS_REBOOK CONSTANT VARCHAR2(6) := 'REBOOK';
14 G_KHR_PROCESS_RELEASE_CONTRACT CONSTANT VARCHAR2(16) := 'RELEASE_CONTRACT';
15 G_KHR_PROCESS_RELEASE_ASSETS CONSTANT VARCHAR2(14) := 'RELEASE_ASSETS';
16 G_KHR_PROCESS_SPLIT_CONTRACT CONSTANT VARCHAR2(14) := 'SPLIT_CONTRACT';
17
18 PROCEDURE format_round_amount(
19 p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_amount IN VARCHAR2,
25 p_currency_code IN VARCHAR2,
26 x_amount OUT NOCOPY VARCHAR2);
27
28 PROCEDURE format_round_amount(
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2,
34 p_amount IN VARCHAR2,
35 p_currency_code IN VARCHAR2,
36 p_org_id IN VARCHAR2,
37 x_amount OUT NOCOPY VARCHAR2);
38
39
40 PROCEDURE round_amount(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_amount IN VARCHAR2,
47 p_currency_code IN VARCHAR2,
48 x_amount OUT NOCOPY VARCHAR2);
49
50
51 PROCEDURE round_amount(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_amount IN VARCHAR2,
58 p_currency_code IN VARCHAR2,
59 p_org_id IN VARCHAR2,
60 x_amount OUT NOCOPY VARCHAR2);
61
62 FUNCTION get_number
63 (p_amount_in IN VARCHAR2)
64 RETURN VARCHAR2;
65
66 FUNCTION get_canonical_date(
67 p_date_char IN VARCHAR2)
68 RETURN VARCHAR2;
69
70 FUNCTION get_canonical_date(
71 p_date_char IN VARCHAR2,
72 p_date_mask IN VARCHAR2)
73 RETURN VARCHAR2;
74
75 FUNCTION validate_get_canonical_date(
76 p_date_char IN VARCHAR2)
77 RETURN VARCHAR2;
78
79
80 FUNCTION get_display_date(
81 p_date_char IN VARCHAR2)
82 RETURN VARCHAR2;
83
84 FUNCTION get_display_date(
85 p_date_char IN VARCHAR2,
86 p_date_mask IN VARCHAR2)
87 RETURN VARCHAR2;
88
89 FUNCTION convert_date(
90 p_date_in_char IN VARCHAR2,
91 p_date_in_mask IN VARCHAR2,
92 p_date_out_mask IN VARCHAR2)
93 RETURN VARCHAR2;
94
95 /*
96 -- mvasudev, 08/17/2004
97 Added the following functions for Business Events Enabling
98 */
99
100 FUNCTION check_mass_rebook_contract(
101 p_chr_id IN NUMBER)
102 RETURN VARCHAR2;
103
104 FUNCTION check_rebook_contract(
105 p_chr_id IN NUMBER)
106 RETURN VARCHAR2;
107
108 FUNCTION check_release_contract(
109 p_chr_id IN NUMBER)
110 RETURN VARCHAR2;
111
112 FUNCTION check_release_assets(
113 p_chr_id IN NUMBER)
114 RETURN VARCHAR2;
115
116 FUNCTION check_new_contract(
117 p_chr_id IN NUMBER)
118 RETURN VARCHAR2;
119
120 FUNCTION check_split_contract(
121 p_chr_id IN NUMBER)
122 RETURN VARCHAR2;
123
124 FUNCTION get_contract_process(
125 p_chr_id IN NUMBER)
126 RETURN VARCHAR2;
127
128 FUNCTION is_lease_contract(
129 p_chr_id okc_k_headers_b.id%TYPE)
130 RETURN VARCHAR2;
131 /* -- end, mvasudev, 08/17/2004 */
132
133 -- start: cklee/mvasudev -- Fixed 11.5.9 Bug#4392051/okl.h 4437938
134 FUNCTION calculate_end_date(
135 p_start_date IN DATE,
136 p_months IN NUMBER,
137 p_start_day IN NUMBER DEFAULT NULL,
138 p_contract_end_date IN DATE DEFAULT NULL --Bug#5441811
139 )
140 RETURN DATE;
141 -- end: cklee/mvasudev -- Fixed 11.5.9 Bug#4392051/okl.h 4437938
142
143 FUNCTION get_lookup_meaning(
144 p_lookup_type FND_LOOKUPS.LOOKUP_TYPE%TYPE,
145 p_lookup_code FND_LOOKUPS.LOOKUP_CODE%TYPE)
146 RETURN VARCHAR2;
147
148 --Bug# 4903011
149 PROCEDURE check_line_update_allowed(p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_cle_id IN NUMBER);
155
156 --asawanka added
157 FUNCTION get_asset_location(
158 p_kle_id IN NUMBER,
159 p_khr_id IN NUMBER)
160 RETURN VARCHAR2;
161 FUNCTION get_ast_install_loc_id(
162 p_kle_id IN NUMBER,
163 p_khr_id IN NUMBER) RETURN NUMBER;
164 FUNCTION get_booked_asset_number(
165 p_kle_id IN NUMBER,
166 p_khr_id IN NUMBER)
167 RETURN VARCHAR2;
168
169 -- Added procedure as part of Bug#6651871 to create Pay Site for Supplier start
170 PROCEDURE create_pay_site(
171 party_id IN NUMBER,
172 party_site_id IN NUMBER := NULL, -- added to create pay site
173 p_org_id IN NUMBER, -- added to create pay site
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2
179 );
180 -- Added procedure as part of Bug#6651871 to create Pay Site for Supplier end
181
182 -- Added procedure as part of Bug#6636587 to Create Vendor for a Party in TCA start
183
184 PROCEDURE create_related_vendor(
185 party_id IN NUMBER,
186 party_site_id IN NUMBER := NULL,
187 p_org_id IN NUMBER ,
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2
193 ) ;
194 -- Added procedure as part of Bug#6636587 to Create Vendor for a Party in TCA end
195
196 --Bug# 8370699
197 FUNCTION get_last_activation_date(
198 p_chr_id IN NUMBER)
199 RETURN DATE;
200
201
202 PROCEDURE update_external_id (p_chr_id in number,
203 x_return_status OUT NOCOPY VARCHAR2);
204
205 --Bug# 8756653
206 PROCEDURE check_rebook_upgrade(p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_chr_id IN NUMBER,
212 p_rbk_chr_id IN NUMBER DEFAULT NULL);
213
214 END Okl_Lla_Util_Pvt;