[Home] [Help]
PACKAGE: APPS.OKL_TEL_PVT
Source
1 PACKAGE OKL_TEL_PVT AS
2 /* $Header: OKLSTELS.pls 120.5 2007/12/21 13:01:41 rajnisku noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKL_TXL_EXTENSION_V Record Spec
7 TYPE telv_rec_type IS RECORD (
8 line_extension_id NUMBER
9 ,teh_id NUMBER
10 ,source_id NUMBER
11 ,source_table OKL_TXL_EXTENSION_V.SOURCE_TABLE%TYPE
12 ,object_version_number NUMBER
13 ,language OKL_TXL_EXTENSION_V.LANGUAGE%TYPE
14 ,contract_line_number OKL_TXL_EXTENSION_V.CONTRACT_LINE_NUMBER%TYPE
15 ,fee_type_code OKL_TXL_EXTENSION_V.FEE_TYPE_CODE%TYPE
16 ,asset_number OKL_TXL_EXTENSION_V.ASSET_NUMBER%TYPE
17 ,asset_category_name OKL_TXL_EXTENSION_V.ASSET_CATEGORY_NAME%TYPE
18 ,asset_vendor_name OKL_TXL_EXTENSION_V.ASSET_VENDOR_NAME%TYPE
19 ,asset_manufacturer_name OKL_TXL_EXTENSION_V.ASSET_MANUFACTURER_NAME%TYPE
20 ,asset_year_manufactured OKL_TXL_EXTENSION_V.ASSET_YEAR_MANUFACTURED%TYPE
21 ,asset_model_number OKL_TXL_EXTENSION_V.ASSET_MODEL_NUMBER%TYPE
22 ,asset_delivered_date OKL_TXL_EXTENSION_V.ASSET_DELIVERED_DATE%TYPE
23 ,installed_site_id NUMBER
24 ,fixed_asset_location_name OKL_TXL_EXTENSION_V.FIXED_ASSET_LOCATION_NAME%TYPE
25 ,contingency_code OKL_TXL_EXTENSION_V.CONTINGENCY_CODE%TYPE
26 ,subsidy_name OKL_TXL_EXTENSION_V.SUBSIDY_NAME%TYPE
27 ,subsidy_party_name OKL_TXL_EXTENSION_V.SUBSIDY_PARTY_NAME%TYPE
28 ,memo_flag OKL_TXL_EXTENSION_V.MEMO_FLAG%TYPE
29 ,recievables_trx_type_name OKL_TXL_EXTENSION_V.RECIEVABLES_TRX_TYPE_NAME%TYPE
30 ,contract_line_type OKL_TXL_EXTENSION_V.CONTRACT_LINE_TYPE%TYPE
31 ,pay_supplier_site_name OKL_TXL_EXTENSION_V.PAY_SUPPLIER_SITE_NAME%TYPE
32 ,aging_bucket_name OKL_TXL_EXTENSION_V.AGING_BUCKET_NAME%TYPE
33 ,created_by NUMBER
34 ,creation_date OKL_TXL_EXTENSION_V.CREATION_DATE%TYPE
35 ,last_updated_by NUMBER
36 ,last_update_date OKL_TXL_EXTENSION_V.LAST_UPDATE_DATE%TYPE
37 ,last_update_login NUMBER
38 ,inventory_item_name OKL_TXL_EXTENSION_V.INVENTORY_ITEM_NAME%TYPE
39 ,inventory_org_name OKL_TXL_EXTENSION_V.INVENTORY_ORG_NAME%TYPE
40 ,inventory_item_name_code OKL_TXL_EXTENSION_V.INVENTORY_ITEM_NAME_CODE%TYPE
41 ,inventory_org_code OKL_TXL_EXTENSION_V.INVENTORY_ORG_CODE%TYPE
42 ,vendor_site_id OKL_TXL_EXTENSION_V.VENDOR_SITE_ID%TYPE
43 ,subsidy_vendor_id OKL_TXL_EXTENSION_V.SUBSIDY_VENDOR_ID%TYPE
44 ,asset_vendor_id OKL_TXL_EXTENSION_V.ASSET_VENDOR_ID%TYPE);
45 G_MISS_telv_rec telv_rec_type;
46 TYPE telv_tbl_type IS TABLE OF telv_rec_type
47 INDEX BY BINARY_INTEGER;
48 -- OKL_TXL_EXTENSION_TL Record Spec
49 TYPE tell_rec_type IS RECORD (
50 line_extension_id NUMBER
51 ,language OKL_TXL_EXTENSION_TL.LANGUAGE%TYPE
52 ,source_lang OKL_TXL_EXTENSION_TL.SOURCE_LANG%TYPE
53 ,sfwt_flag OKL_TXL_EXTENSION_TL.SFWT_FLAG%TYPE
54 ,inventory_item_name OKL_TXL_EXTENSION_TL.INVENTORY_ITEM_NAME%TYPE
55 ,inventory_org_name OKL_TXL_EXTENSION_TL.INVENTORY_ORG_NAME%TYPE
56 ,created_by NUMBER
57 ,creation_date OKL_TXL_EXTENSION_TL.CREATION_DATE%TYPE
58 ,last_updated_by NUMBER
59 ,last_update_date OKL_TXL_EXTENSION_TL.LAST_UPDATE_DATE%TYPE
60 ,last_update_login NUMBER);
61 G_MISS_tell_rec tell_rec_type;
62 TYPE tell_tbl_type IS TABLE OF tell_rec_type
63 INDEX BY BINARY_INTEGER;
64 -- OKL_TXL_EXTENSION_B Record Spec
65 TYPE tel_rec_type IS RECORD (
66 line_extension_id NUMBER
67 ,source_id NUMBER
68 ,source_table OKL_TXL_EXTENSION_B.SOURCE_TABLE%TYPE
69 ,object_version_number NUMBER
70 ,contract_line_number OKL_TXL_EXTENSION_B.CONTRACT_LINE_NUMBER%TYPE
71 ,fee_type_code OKL_TXL_EXTENSION_B.FEE_TYPE_CODE%TYPE
72 ,asset_number OKL_TXL_EXTENSION_B.ASSET_NUMBER%TYPE
73 ,asset_category_name OKL_TXL_EXTENSION_B.ASSET_CATEGORY_NAME%TYPE
74 ,asset_vendor_name OKL_TXL_EXTENSION_B.ASSET_VENDOR_NAME%TYPE
75 ,asset_manufacturer_name OKL_TXL_EXTENSION_B.ASSET_MANUFACTURER_NAME%TYPE
76 ,asset_year_manufactured OKL_TXL_EXTENSION_B.ASSET_YEAR_MANUFACTURED%TYPE
77 ,asset_model_number OKL_TXL_EXTENSION_B.ASSET_MODEL_NUMBER%TYPE
78 ,asset_delivered_date OKL_TXL_EXTENSION_B.ASSET_DELIVERED_DATE%TYPE
79 ,installed_site_id NUMBER
80 ,fixed_asset_location_name OKL_TXL_EXTENSION_B.FIXED_ASSET_LOCATION_NAME%TYPE
81 ,contingency_code OKL_TXL_EXTENSION_B.CONTINGENCY_CODE%TYPE
82 ,subsidy_name OKL_TXL_EXTENSION_B.SUBSIDY_NAME%TYPE
83 ,subsidy_party_name OKL_TXL_EXTENSION_B.SUBSIDY_PARTY_NAME%TYPE
84 ,memo_flag OKL_TXL_EXTENSION_B.MEMO_FLAG%TYPE
85 ,recievables_trx_type_name OKL_TXL_EXTENSION_B.RECIEVABLES_TRX_TYPE_NAME%TYPE
86 ,aging_bucket_name OKL_TXL_EXTENSION_B.AGING_BUCKET_NAME%TYPE
87 ,contract_line_type OKL_TXL_EXTENSION_B.CONTRACT_LINE_TYPE%TYPE
88 ,pay_supplier_site_name OKL_TXL_EXTENSION_B.PAY_SUPPLIER_SITE_NAME%TYPE
89 ,created_by NUMBER
90 ,creation_date OKL_TXL_EXTENSION_B.CREATION_DATE%TYPE
91 ,last_updated_by NUMBER
92 ,last_update_date OKL_TXL_EXTENSION_B.LAST_UPDATE_DATE%TYPE
93 ,last_update_login NUMBER
94 ,teh_id NUMBER
95 ,inventory_item_name_code OKL_TXL_EXTENSION_B.INVENTORY_ITEM_NAME_CODE%TYPE
96 ,inventory_org_code OKL_TXL_EXTENSION_B.INVENTORY_ORG_CODE%TYPE
97 ,vendor_site_id OKL_TXL_EXTENSION_B.VENDOR_SITE_ID%TYPE
98 , subsidy_vendor_id OKL_TXL_EXTENSION_B.SUBSIDY_VENDOR_ID%TYPE
99 ,asset_vendor_id OKL_TXL_EXTENSION_B.ASSET_VENDOR_ID%TYPE);
100 G_MISS_tel_rec tel_rec_type;
101 TYPE tel_tbl_type IS TABLE OF tel_rec_type
102 INDEX BY BINARY_INTEGER;
103 -- Start : PRASJAIN : Bug# 6268782
104 TYPE tel_tbl_rec_type IS RECORD(
105 tel_rec okl_tel_pvt.tel_rec_type
106 ,tell_tbl okl_tel_pvt.tell_tbl_type
107 );
108 TYPE tel_tbl_tbl_type IS TABLE OF tel_tbl_rec_type
109 INDEX BY BINARY_INTEGER;
110 -- End : PRASJAIN : Bug# 6268782
111 TYPE txl_tbl_type IS TABLE OF OKL_TXL_EXTENSION_B%ROWTYPE;
112 TYPE txll_tbl_type IS TABLE OF OKL_TXL_EXTENSION_TL%ROWTYPE;
113 ---------------------------------------------------------------------------
114 -- GLOBAL MESSAGE CONSTANTS
115 ---------------------------------------------------------------------------
116 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
117 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
118 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
119 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
120 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
121 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
122 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
123 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
124 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
125 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
126 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
127 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
128 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
129
130 ---------------------------------------------------------------------------
131 -- GLOBAL EXCEPTIONS
132 ---------------------------------------------------------------------------
133 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
134
135 ---------------------------------------------------------------------------
136 -- GLOBAL VARIABLES
137 ---------------------------------------------------------------------------
138 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TEL_PVT';
139 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
140 ---------------------------------------------------------------------------
141 -- Procedures and Functions
142 ---------------------------------------------------------------------------
143
144 PROCEDURE qc;
145 PROCEDURE change_version;
146 PROCEDURE api_copy;
147 PROCEDURE add_language;
148 PROCEDURE insert_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_telv_rec IN telv_rec_type,
155 x_telv_rec OUT NOCOPY telv_rec_type);
156 PROCEDURE insert_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_telv_tbl IN telv_tbl_type,
163 x_telv_tbl OUT NOCOPY telv_tbl_type,
164 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
165 PROCEDURE insert_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_telv_tbl IN telv_tbl_type,
172 x_telv_tbl OUT NOCOPY telv_tbl_type);
173 PROCEDURE lock_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_telv_rec IN telv_rec_type);
180 PROCEDURE lock_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_telv_tbl IN telv_tbl_type,
187 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
188 PROCEDURE lock_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_telv_tbl IN telv_tbl_type);
195 PROCEDURE update_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_telv_rec IN telv_rec_type,
202 x_telv_rec OUT NOCOPY telv_rec_type);
203 PROCEDURE update_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_telv_tbl IN telv_tbl_type,
210 x_telv_tbl OUT NOCOPY telv_tbl_type,
211 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
212 PROCEDURE update_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_telv_tbl IN telv_tbl_type,
219 x_telv_tbl OUT NOCOPY telv_tbl_type);
220 PROCEDURE delete_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_telv_rec IN telv_rec_type);
227 PROCEDURE delete_row(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_telv_tbl IN telv_tbl_type,
234 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
235 PROCEDURE delete_row(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_telv_tbl IN telv_tbl_type);
242 PROCEDURE validate_row(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_telv_rec IN telv_rec_type);
249 PROCEDURE validate_row(
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 p_telv_tbl IN telv_tbl_type,
256 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
257 PROCEDURE validate_row(
258 p_api_version IN NUMBER,
259 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
260 x_return_status OUT NOCOPY VARCHAR2,
261 x_msg_count OUT NOCOPY NUMBER,
262 x_msg_data OUT NOCOPY VARCHAR2,
263 p_telv_tbl IN telv_tbl_type);
264 -- Added : PRASJAIN : Bug# 6268782
265 PROCEDURE insert_row(
266 p_api_version IN NUMBER,
267 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
268 x_return_status OUT NOCOPY VARCHAR2,
269 x_msg_count OUT NOCOPY NUMBER,
270 x_msg_data OUT NOCOPY VARCHAR2,
271 p_tel_rec IN tel_rec_type,
272 p_tell_tbl IN tell_tbl_type,
273 x_tel_rec OUT NOCOPY tel_rec_type,
274 x_tell_tbl OUT NOCOPY tell_tbl_type);
275 END OKL_TEL_PVT;