[Home] [Help]
PACKAGE: APPS.OKL_XLS_PVT
Source
1 Package Okl_Xls_Pvt AS
2 /* $Header: OKLSXLSS.pls 120.3 2005/10/30 03:47:33 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE xls_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 ill_id NUMBER := Okl_Api.G_MISS_NUM,
9 tld_id NUMBER := Okl_Api.G_MISS_NUM,
10 lsm_id NUMBER := Okl_Api.G_MISS_NUM,
11 til_id NUMBER := Okl_Api.G_MISS_NUM,
12 xsi_id_details NUMBER := Okl_Api.G_MISS_NUM,
13 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
14 line_type OKL_XTL_SELL_INVS_B.LINE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
15 amount NUMBER := Okl_Api.G_MISS_NUM,
16 quantity NUMBER := Okl_Api.G_MISS_NUM,
17 xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
18 xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,
19 request_id NUMBER := Okl_Api.G_MISS_NUM,
20 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
21 program_id NUMBER := Okl_Api.G_MISS_NUM,
22 program_update_date OKL_XTL_SELL_INVS_B.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
23 org_id NUMBER := Okl_Api.G_MISS_NUM,
24 inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
25 isl_id NUMBER := Okl_Api.G_MISS_NUM,
26 sel_id NUMBER := Okl_Api.G_MISS_NUM,
27 -- Start changes on remarketing by fmiao on 10/18/04 --
28 inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
29 -- End changes on remarketing by fmiao on 10/18/04 --
30 attribute_category OKL_XTL_SELL_INVS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
31 attribute1 OKL_XTL_SELL_INVS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
32 attribute2 OKL_XTL_SELL_INVS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
33 attribute3 OKL_XTL_SELL_INVS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
34 attribute4 OKL_XTL_SELL_INVS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
35 attribute5 OKL_XTL_SELL_INVS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
36 attribute6 OKL_XTL_SELL_INVS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
37 attribute7 OKL_XTL_SELL_INVS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
38 attribute8 OKL_XTL_SELL_INVS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
39 attribute9 OKL_XTL_SELL_INVS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
40 attribute10 OKL_XTL_SELL_INVS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
41 attribute11 OKL_XTL_SELL_INVS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
42 attribute12 OKL_XTL_SELL_INVS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
43 attribute13 OKL_XTL_SELL_INVS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
44 attribute14 OKL_XTL_SELL_INVS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
45 attribute15 OKL_XTL_SELL_INVS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
46 created_by NUMBER := Okl_Api.G_MISS_NUM,
47 creation_date OKL_XTL_SELL_INVS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
48 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
49 last_update_date OKL_XTL_SELL_INVS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
50 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
51 g_miss_xls_rec xls_rec_type;
52 TYPE xls_tbl_type IS TABLE OF xls_rec_type
53 INDEX BY BINARY_INTEGER;
54 TYPE okl_xtl_sell_invs_tl_rec_type IS RECORD (
55 id NUMBER := Okl_Api.G_MISS_NUM,
56 LANGUAGE OKL_XTL_SELL_INVS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
57 source_lang OKL_XTL_SELL_INVS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
58 sfwt_flag OKL_XTL_SELL_INVS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59 description OKL_XTL_SELL_INVS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
60 xtrx_contract OKL_XTL_SELL_INVS_TL.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,
61 xtrx_asset OKL_XTL_SELL_INVS_TL.XTRX_ASSET%TYPE := Okl_Api.G_MISS_CHAR,
62 xtrx_stream_group OKL_XTL_SELL_INVS_TL.XTRX_STREAM_GROUP%TYPE := Okl_Api.G_MISS_CHAR,
63 xtrx_stream_type OKL_XTL_SELL_INVS_TL.XTRX_STREAM_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
64 created_by NUMBER := Okl_Api.G_MISS_NUM,
65 creation_date OKL_XTL_SELL_INVS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
66 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
67 last_update_date OKL_XTL_SELL_INVS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
68 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
69 GMissOklXtlSellInvsTlRec okl_xtl_sell_invs_tl_rec_type;
70 TYPE okl_xtl_sell_invs_tl_tbl_type IS TABLE OF okl_xtl_sell_invs_tl_rec_type
71 INDEX BY BINARY_INTEGER;
72 TYPE xlsv_rec_type IS RECORD (
73 id NUMBER := Okl_Api.G_MISS_NUM,
74 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
75 sfwt_flag OKL_XTL_SELL_INVS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
76 tld_id NUMBER := Okl_Api.G_MISS_NUM,
77 lsm_id NUMBER := Okl_Api.G_MISS_NUM,
78 til_id NUMBER := Okl_Api.G_MISS_NUM,
79 ill_id NUMBER := Okl_Api.G_MISS_NUM,
80 xsi_id_details NUMBER := Okl_Api.G_MISS_NUM,
81 line_type OKL_XTL_SELL_INVS_V.LINE_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
82 description OKL_XTL_SELL_INVS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
83 amount NUMBER := Okl_Api.G_MISS_NUM,
84 quantity NUMBER := Okl_Api.G_MISS_NUM,
85 xtrx_cons_line_number NUMBER := Okl_Api.G_MISS_NUM,
86 xtrx_contract OKL_XTL_SELL_INVS_V.XTRX_CONTRACT%TYPE := Okl_Api.G_MISS_CHAR,
87 xtrx_asset OKL_XTL_SELL_INVS_V.XTRX_ASSET%TYPE := Okl_Api.G_MISS_CHAR,
88 xtrx_stream_group OKL_XTL_SELL_INVS_V.XTRX_STREAM_GROUP%TYPE := Okl_Api.G_MISS_CHAR,
89 xtrx_stream_type OKL_XTL_SELL_INVS_V.XTRX_STREAM_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
90 xtrx_cons_stream_id NUMBER := Okl_Api.G_MISS_NUM,
91 isl_id NUMBER := Okl_Api.G_MISS_NUM,
92 sel_id NUMBER := Okl_Api.G_MISS_NUM,
93 -- Start changes on remarketing by fmiao on 10/18/04 --
94 inventory_item_id NUMBER := Okl_Api.G_MISS_NUM,
95 -- End changes on remarketing by fmiao on 10/18/04 --
96 attribute_category OKL_XTL_SELL_INVS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
97 attribute1 OKL_XTL_SELL_INVS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
98 attribute2 OKL_XTL_SELL_INVS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
99 attribute3 OKL_XTL_SELL_INVS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
100 attribute4 OKL_XTL_SELL_INVS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
101 attribute5 OKL_XTL_SELL_INVS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
102 attribute6 OKL_XTL_SELL_INVS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
103 attribute7 OKL_XTL_SELL_INVS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
104 attribute8 OKL_XTL_SELL_INVS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
105 attribute9 OKL_XTL_SELL_INVS_V.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
106 attribute10 OKL_XTL_SELL_INVS_V.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
107 attribute11 OKL_XTL_SELL_INVS_V.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
108 attribute12 OKL_XTL_SELL_INVS_V.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
109 attribute13 OKL_XTL_SELL_INVS_V.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
110 attribute14 OKL_XTL_SELL_INVS_V.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
111 attribute15 OKL_XTL_SELL_INVS_V.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
112 request_id NUMBER := Okl_Api.G_MISS_NUM,
113 program_application_id NUMBER := Okl_Api.G_MISS_NUM,
114 program_id NUMBER := Okl_Api.G_MISS_NUM,
115 program_update_date OKL_XTL_SELL_INVS_V.PROGRAM_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
116 org_id NUMBER := Okl_Api.G_MISS_NUM,
117 inventory_org_id NUMBER := Okl_Api.G_MISS_NUM,
118 created_by NUMBER := Okl_Api.G_MISS_NUM,
119 creation_date OKL_XTL_SELL_INVS_V.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
120 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
121 last_update_date OKL_XTL_SELL_INVS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
122 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
123 g_miss_xlsv_rec xlsv_rec_type;
124 TYPE xlsv_tbl_type IS TABLE OF xlsv_rec_type
125 INDEX BY BINARY_INTEGER;
126 ---------------------------------------------------------------------------
127 -- GLOBAL MESSAGE CONSTANTS
128 ---------------------------------------------------------------------------
129 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
130 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
131 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
132 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
133 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
134 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
135 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
136 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
137 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
138 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
139 ---------------------------------------------------------------------------
140 -- GLOBAL VARIABLES
141 ---------------------------------------------------------------------------
142 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_XLS_PVT';
143 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
144
145 /******************ADDED AFTER TAPI, Sunil T. Mathew (04/18/2001) ****************/
146 --GLOBAL MESSAGES
147 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
148 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
149 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
150 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
151 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
152
153
154 --GLOBAL VARIABLES
155 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTL_SELL_INVS_V';
156 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
157
158 ---------------------------------------------------------------------------
159 -- validation Procedures and Functions
160 ---------------------------------------------------------------------------
161 --PROCEDURE validate_unique(p_saiv_rec IN saiv_rec_type,
162 -- x_return_status OUT NOCOPY VARCHAR2);
163
164 /****************END ADDED AFTER TAPI, Sunil T. Mathew (04/18/2001)**************/
165
166 ---------------------------------------------------------------------------
167 -- Procedures and Functions
168 ---------------------------------------------------------------------------
169
170 PROCEDURE qc;
171 PROCEDURE change_version;
172 PROCEDURE api_copy;
173 PROCEDURE add_language;
174 PROCEDURE insert_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_xlsv_rec IN xlsv_rec_type,
181 x_xlsv_rec OUT NOCOPY xlsv_rec_type);
182
183 PROCEDURE insert_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_xlsv_tbl IN xlsv_tbl_type,
190 x_xlsv_tbl OUT NOCOPY xlsv_tbl_type);
191
192 PROCEDURE lock_row(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_xlsv_rec IN xlsv_rec_type);
199
200 PROCEDURE lock_row(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_xlsv_tbl IN xlsv_tbl_type);
207
208 PROCEDURE update_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_xlsv_rec IN xlsv_rec_type,
215 x_xlsv_rec OUT NOCOPY xlsv_rec_type);
216
217 PROCEDURE update_row(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_xlsv_tbl IN xlsv_tbl_type,
224 x_xlsv_tbl OUT NOCOPY xlsv_tbl_type);
225
226 PROCEDURE delete_row(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_xlsv_rec IN xlsv_rec_type);
233
234 PROCEDURE delete_row(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_xlsv_tbl IN xlsv_tbl_type);
241
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_xlsv_rec IN xlsv_rec_type);
249
250 PROCEDURE validate_row(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_xlsv_tbl IN xlsv_tbl_type);
257
258 END Okl_Xls_Pvt;