DBA Data[Home] [Help]

APPS.OKL_TEL_PVT dependencies on OKL_API

Line 116: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

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;

Line 117: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 118: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

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;

Line 119: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

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;

Line 120: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 121: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

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;

Line 122: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

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';

Line 123: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

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';

Line 124: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

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';

Line 125: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

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:

Line 139: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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:

Line 150: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 164: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

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,

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 175: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 187: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

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,

Line 190: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 205: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 211: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

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,

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 222: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 229: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 234: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

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,

Line 237: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 244: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 251: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,

Line 256: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);

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,

Line 259: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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);

Line 267: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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,