eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TMPT_SET_PVT dependencies on OKC_API

Line 7: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3:
4:
5: PROCEDURE create_tmpt_set(
6: p_api_version IN NUMBER
7: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
8: ,x_return_status OUT NOCOPY VARCHAR2
9: ,x_msg_count OUT NOCOPY NUMBER
10: ,x_msg_data OUT NOCOPY VARCHAR2
11: ,p_aesv_rec IN aesv_rec_type

Line 21: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

17: )
18:
19: AS
20:
21: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
22: l_aesv_rec aesv_rec_type;
23: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
24: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;
25: i NUMBER;

Line 42: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

38: x_aesv_rec);
39:
40: -- Proceed Further only if no Error is Encountered.
41:
42: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
43:
44: -- Populate the foreign key for the line
45: IF (l_avlv_tbl.COUNT > 0) THEN
46: i := l_avlv_tbl.FIRST;

Line 66: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

62: x_avlv_tbl);
63:
64: -- Proceed with the lines only if Template Creation is Successful.
65:
66: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
67:
68: -- Populate the foreign key for the detail
69: IF (l_avlv_tbl.COUNT > 0) THEN
70: i := l_avlv_tbl.FIRST;

Line 101: Okc_Api.set_message(p_app_name => g_app_name,

97:
98: EXCEPTION
99:
100: WHEN OTHERS THEN
101: Okc_Api.set_message(p_app_name => g_app_name,
102: p_msg_name => g_unexpected_error,
103: p_token1 => g_sqlcode_token,
104: p_token1_value => SQLCODE,
105: p_token2 => g_sqlerrm_token,

Line 107: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

103: p_token1 => g_sqlcode_token,
104: p_token1_value => SQLCODE,
105: p_token2 => g_sqlerrm_token,
106: p_token2_value => SQLERRM);
107: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
108:
109: END;
110:
111:

Line 114: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

110:
111:
112: PROCEDURE update_tmpt_set(
113: p_api_version IN NUMBER
114: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
117: ,x_msg_data OUT NOCOPY VARCHAR2
118: ,p_aesv_rec IN aesv_rec_type

Line 126: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

122: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type
123: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type
124: )
125: AS
126: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
127:
128: BEGIN
129:
130: --Update the Template Set Table

Line 140: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

136: x_msg_data,
137: p_aesv_rec,
138: x_aesv_rec);
139:
140: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
141:
142: --Update the Template Table
143: update_template(p_api_version,
144: p_init_msg_list,

Line 151: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

147: x_msg_data,
148: p_avlv_tbl,
149: x_avlv_tbl);
150:
151: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
152:
153: --Update the Template Line Table
154: update_tmpt_lines(p_api_version,
155: p_init_msg_list,

Line 171: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

167:
168:
169: PROCEDURE validate_tmpt_set(
170: p_api_version IN NUMBER
171: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
172: ,x_return_status OUT NOCOPY VARCHAR2
173: ,x_msg_count OUT NOCOPY NUMBER
174: ,x_msg_data OUT NOCOPY VARCHAR2
175: ,p_aesv_rec IN aesv_rec_type

Line 181: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

177: ,p_atlv_tbl IN atlv_tbl_type
178: )
179:
180: AS
181: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
182:
183: BEGIN
184:
185: -- Validate the Template Set Table

Line 194: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

190: x_msg_count,
191: x_msg_data,
192: p_aesv_rec);
193:
194: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
195: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
196: l_overall_status := x_return_status;
197: END IF;
198: END IF;

Line 195: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

191: x_msg_data,
192: p_aesv_rec);
193:
194: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
195: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
196: l_overall_status := x_return_status;
197: END IF;
198: END IF;
199:

Line 208: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

204: x_msg_count,
205: x_msg_data,
206: p_avlv_tbl);
207:
208: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
209: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
210: l_overall_status := x_return_status;
211: END IF;
212: END IF;

Line 209: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

205: x_msg_data,
206: p_avlv_tbl);
207:
208: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
209: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
210: l_overall_status := x_return_status;
211: END IF;
212: END IF;
213:

Line 222: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

218: x_msg_count,
219: x_msg_data,
220: p_atlv_tbl);
221:
222: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
223: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
224: l_overall_status := x_return_status;
225: END IF;
226: END IF;

Line 223: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

219: x_msg_data,
220: p_atlv_tbl);
221:
222: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
223: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
224: l_overall_status := x_return_status;
225: END IF;
226: END IF;
227:

Line 234: Okc_Api.set_message(p_app_name => g_app_name,

230:
231: EXCEPTION
232:
233: WHEN OTHERS THEN
234: Okc_Api.set_message(p_app_name => g_app_name,
235: p_msg_name => g_unexpected_error,
236: p_token1 => g_sqlcode_token,
237: p_token1_value => SQLCODE,
238: p_token2 => g_sqlerrm_token,

Line 240: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

236: p_token1 => g_sqlcode_token,
237: p_token1_value => SQLCODE,
238: p_token2 => g_sqlerrm_token,
239: p_token2_value => SQLERRM);
240: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
241:
242: END;
243:
244:

Line 247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

243:
244:
245: PROCEDURE create_tmpt_set(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_aesv_rec IN aesv_rec_type,

Line 268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

264: END create_tmpt_set;
265:
266: PROCEDURE create_tmpt_set(
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_aesv_tbl IN aesv_tbl_type,

Line 275: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_aesv_tbl IN aesv_tbl_type,
273: x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
274:
275: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
276: i NUMBER := 0;
277: BEGIN
278:
279: Okc_Api.init_msg_list(p_init_msg_list);

Line 279: Okc_Api.init_msg_list(p_init_msg_list);

275: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
276: i NUMBER := 0;
277: BEGIN
278:
279: Okc_Api.init_msg_list(p_init_msg_list);
280: -- Make sure PL/SQL table has records in it before passing
281: IF (p_aesv_tbl.COUNT > 0) THEN
282: i := p_aesv_tbl.FIRST;
283: LOOP

Line 286: p_init_msg_list => Okc_Api.G_FALSE,

282: i := p_aesv_tbl.FIRST;
283: LOOP
284: create_tmpt_set(
285: p_api_version => p_api_version,
286: p_init_msg_list => Okc_Api.G_FALSE,
287: x_return_status => x_return_status,
288: x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data,
290: p_aesv_rec => p_aesv_tbl(i),

Line 293: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

289: x_msg_data => x_msg_data,
290: p_aesv_rec => p_aesv_tbl(i),
291: x_aesv_rec => x_aesv_tbl(i));
292:
293: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
294: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
295: l_overall_status := x_return_status;
296: END IF;
297: END IF;

Line 294: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

290: p_aesv_rec => p_aesv_tbl(i),
291: x_aesv_rec => x_aesv_tbl(i));
292:
293: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
294: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
295: l_overall_status := x_return_status;
296: END IF;
297: END IF;
298: EXIT WHEN (i = p_aesv_tbl.LAST);

Line 311: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

307:
308:
309: PROCEDURE lock_tmpt_set(
310: p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2,
315: p_aesv_rec IN aesv_rec_type) IS

Line 327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

323: END lock_tmpt_set;
324:
325: PROCEDURE lock_tmpt_set(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,
331: p_aesv_tbl IN aesv_tbl_type) IS

Line 333: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,
331: p_aesv_tbl IN aesv_tbl_type) IS
332:
333: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
334: i NUMBER := 0;
335:
336: BEGIN
337:

Line 338: OKC_API.init_msg_list(p_init_msg_list);

334: i NUMBER := 0;
335:
336: BEGIN
337:
338: OKC_API.init_msg_list(p_init_msg_list);
339: IF (p_aesv_tbl.COUNT > 0) THEN
340: i := p_aesv_tbl.FIRST;
341: LOOP
342: lock_tmpt_set(p_api_version => p_api_version,

Line 349: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data,
347: p_aesv_rec => p_aesv_tbl(i));
348:
349: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
350: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
351: l_overall_status := x_return_status;
352: END IF;
353: END IF;

Line 350: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

346: x_msg_data => x_msg_data,
347: p_aesv_rec => p_aesv_tbl(i));
348:
349: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
350: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
351: l_overall_status := x_return_status;
352: END IF;
353: END IF;
354:

Line 366: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

362: END lock_tmpt_set;
363:
364: PROCEDURE update_tmpt_set(
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
367: x_return_status OUT NOCOPY VARCHAR2,
368: x_msg_count OUT NOCOPY NUMBER,
369: x_msg_data OUT NOCOPY VARCHAR2,
370: p_aesv_rec IN aesv_rec_type,

Line 385: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

381: END update_tmpt_set;
382:
383: PROCEDURE update_tmpt_set(
384: p_api_version IN NUMBER,
385: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_aesv_tbl IN aesv_tbl_type,

Line 392: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_aesv_tbl IN aesv_tbl_type,
390: x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
391:
392: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
393: i NUMBER := 0;
394:
395: BEGIN
396:

Line 397: Okc_Api.init_msg_list(p_init_msg_list);

393: i NUMBER := 0;
394:
395: BEGIN
396:
397: Okc_Api.init_msg_list(p_init_msg_list);
398: -- Make sure PL/SQL table has records in it before passing
399: IF (p_aesv_tbl.COUNT > 0) THEN
400: i := p_aesv_tbl.FIRST;
401: LOOP

Line 404: p_init_msg_list => Okc_Api.G_FALSE,

400: i := p_aesv_tbl.FIRST;
401: LOOP
402: update_tmpt_set(
403: p_api_version => p_api_version,
404: p_init_msg_list => Okc_Api.G_FALSE,
405: x_return_status => x_return_status,
406: x_msg_count => x_msg_count,
407: x_msg_data => x_msg_data,
408: p_aesv_rec => p_aesv_tbl(i),

Line 411: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

407: x_msg_data => x_msg_data,
408: p_aesv_rec => p_aesv_tbl(i),
409: x_aesv_rec => x_aesv_tbl(i));
410:
411: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
412: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
413: l_overall_status := x_return_status;
414: END IF;
415: END IF;

Line 412: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

408: p_aesv_rec => p_aesv_tbl(i),
409: x_aesv_rec => x_aesv_tbl(i));
410:
411: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
412: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
413: l_overall_status := x_return_status;
414: END IF;
415: END IF;
416:

Line 429: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

425:
426:
427: PROCEDURE delete_tmpt_set(
428: p_api_version IN NUMBER,
429: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,
432: x_msg_data OUT NOCOPY VARCHAR2,
433: p_aesv_rec IN aesv_rec_type) IS

Line 436: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

432: x_msg_data OUT NOCOPY VARCHAR2,
433: p_aesv_rec IN aesv_rec_type) IS
434:
435: i NUMBER :=0;
436: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
437:
438:
439: CURSOR tmpl_csr(p_aes_id NUMBER)
440: IS

Line 469: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

465: ,x_msg_count
466: ,x_msg_data
467: ,l_ae_template_tbl);
468:
469: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
470:
471: delete_tmpt_set(p_api_version,
472: p_init_msg_list,
473: x_return_status,

Line 483: OKC_API.set_message(p_app_name => g_app_name,

479:
480: EXCEPTION
481:
482: WHEN OTHERS THEN
483: OKC_API.set_message(p_app_name => g_app_name,
484: p_msg_name => g_unexpected_error,
485: p_token1 => g_sqlcode_token,
486: p_token1_value => SQLCODE,
487: p_token2 => g_sqlerrm_token,

Line 489: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

485: p_token1 => g_sqlcode_token,
486: p_token1_value => SQLCODE,
487: p_token2 => g_sqlerrm_token,
488: p_token2_value => SQLERRM);
489: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
490: END delete_tmpt_set;
491:
492:
493: PROCEDURE delete_tmpt_set(

Line 495: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

491:
492:
493: PROCEDURE delete_tmpt_set(
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
496: x_return_status OUT NOCOPY VARCHAR2,
497: x_msg_count OUT NOCOPY NUMBER,
498: x_msg_data OUT NOCOPY VARCHAR2,
499: p_aesv_tbl IN aesv_tbl_type) IS

Line 501: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

497: x_msg_count OUT NOCOPY NUMBER,
498: x_msg_data OUT NOCOPY VARCHAR2,
499: p_aesv_tbl IN aesv_tbl_type) IS
500: i NUMBER :=0;
501: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
502: BEGIN
503: --Initialize the return status
504: x_return_status := OKC_API.G_RET_STS_SUCCESS;
505:

Line 504: x_return_status := OKC_API.G_RET_STS_SUCCESS;

500: i NUMBER :=0;
501: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
502: BEGIN
503: --Initialize the return status
504: x_return_status := OKC_API.G_RET_STS_SUCCESS;
505:
506: IF (p_aesv_tbl.COUNT > 0) THEN
507: i := p_aesv_tbl.FIRST;
508: LOOP

Line 517: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

513: ,x_msg_count
514: ,x_msg_data
515: ,p_aesv_tbl(i));
516:
517: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
518: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: l_overall_status := x_return_status;
520: END IF;
521: END IF;

Line 518: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

514: ,x_msg_data
515: ,p_aesv_tbl(i));
516:
517: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
518: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: l_overall_status := x_return_status;
520: END IF;
521: END IF;
522:

Line 536: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

532:
533:
534: PROCEDURE validate_tmpt_set(
535: p_api_version IN NUMBER,
536: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
537: x_return_status OUT NOCOPY VARCHAR2,
538: x_msg_count OUT NOCOPY NUMBER,
539: x_msg_data OUT NOCOPY VARCHAR2,
540: p_aesv_rec IN aesv_rec_type) IS

Line 553: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

549: END validate_tmpt_set;
550:
551: PROCEDURE validate_tmpt_set(
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,
556: x_msg_data OUT NOCOPY VARCHAR2,
557: p_aesv_tbl IN aesv_tbl_type) IS

Line 559: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

555: x_msg_count OUT NOCOPY NUMBER,
556: x_msg_data OUT NOCOPY VARCHAR2,
557: p_aesv_tbl IN aesv_tbl_type) IS
558:
559: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
560: i NUMBER := 0;
561:
562: BEGIN
563: Okc_Api.init_msg_list(p_init_msg_list);

Line 563: Okc_Api.init_msg_list(p_init_msg_list);

559: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
560: i NUMBER := 0;
561:
562: BEGIN
563: Okc_Api.init_msg_list(p_init_msg_list);
564: -- Make sure PL/SQL table has records in it before passing
565:
566: IF (p_aesv_tbl.COUNT > 0) THEN
567:

Line 578: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

574: x_msg_count,
575: x_msg_data,
576: p_aesv_tbl(i));
577:
578: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
579: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
580: l_overall_status := x_return_status;
581: END IF;
582: END IF;

Line 579: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

575: x_msg_data,
576: p_aesv_tbl(i));
577:
578: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
579: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
580: l_overall_status := x_return_status;
581: END IF;
582: END IF;
583:

Line 597: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

593: END validate_tmpt_set;
594:
595: PROCEDURE create_template(
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
598: x_return_status OUT NOCOPY VARCHAR2,
599: x_msg_count OUT NOCOPY NUMBER,
600: x_msg_data OUT NOCOPY VARCHAR2,
601: p_avlv_rec IN avlv_rec_type,

Line 613: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

609: x_msg_data,
610: p_avlv_rec,
611: x_avlv_rec);
612:
613: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
614: NULL;
615: -- Custom code by developer Update_Minor_Version(p_avlv_rec.dnz_chr_id);
616: END IF;
617:

Line 623: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

619:
620:
621: PROCEDURE create_template(
622: p_api_version IN NUMBER,
623: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
624: x_return_status OUT NOCOPY VARCHAR2,
625: x_msg_count OUT NOCOPY NUMBER,
626: x_msg_data OUT NOCOPY VARCHAR2,
627: p_avlv_tbl IN avlv_tbl_type,

Line 631: l_overall_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

627: p_avlv_tbl IN avlv_tbl_type,
628: x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
629:
630: i NUMBER := 0;
631: l_overall_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
632:
633: BEGIN
634:
635: Okc_Api.init_msg_list(p_init_msg_list);

Line 635: Okc_Api.init_msg_list(p_init_msg_list);

631: l_overall_Status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
632:
633: BEGIN
634:
635: Okc_Api.init_msg_list(p_init_msg_list);
636: -- Make sure PL/SQL table has records in it before passing
637: IF (p_avlv_tbl.COUNT > 0) THEN
638: i := p_avlv_tbl.FIRST;
639: LOOP

Line 642: p_init_msg_list => Okc_Api.G_FALSE,

638: i := p_avlv_tbl.FIRST;
639: LOOP
640: create_template(
641: p_api_version => p_api_version,
642: p_init_msg_list => Okc_Api.G_FALSE,
643: x_return_status => x_return_status,
644: x_msg_count => x_msg_count,
645: x_msg_data => x_msg_data,
646: p_avlv_rec => p_avlv_tbl(i),

Line 649: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

645: x_msg_data => x_msg_data,
646: p_avlv_rec => p_avlv_tbl(i),
647: x_avlv_rec => x_avlv_tbl(i));
648:
649: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
650: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
651: l_overall_status := x_return_status;
652: END IF;
653: END IF;

Line 650: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

646: p_avlv_rec => p_avlv_tbl(i),
647: x_avlv_rec => x_avlv_tbl(i));
648:
649: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
650: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
651: l_overall_status := x_return_status;
652: END IF;
653: END IF;
654: EXIT WHEN (i = p_avlv_tbl.LAST);

Line 665: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

661:
662:
663: PROCEDURE lock_template(
664: p_api_version IN NUMBER,
665: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
666: x_return_status OUT NOCOPY VARCHAR2,
667: x_msg_count OUT NOCOPY NUMBER,
668: x_msg_data OUT NOCOPY VARCHAR2,
669: p_avlv_rec IN avlv_rec_type) IS

Line 682: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

678: END lock_template;
679:
680: PROCEDURE lock_template(
681: p_api_version IN NUMBER,
682: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
683: x_return_status OUT NOCOPY VARCHAR2,
684: x_msg_count OUT NOCOPY NUMBER,
685: x_msg_data OUT NOCOPY VARCHAR2,
686: p_avlv_tbl IN avlv_tbl_type) IS

Line 688: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

684: x_msg_count OUT NOCOPY NUMBER,
685: x_msg_data OUT NOCOPY VARCHAR2,
686: p_avlv_tbl IN avlv_tbl_type) IS
687:
688: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
689: i NUMBER := 0;
690:
691: BEGIN
692:

Line 693: Okc_Api.init_msg_list(p_init_msg_list);

689: i NUMBER := 0;
690:
691: BEGIN
692:
693: Okc_Api.init_msg_list(p_init_msg_list);
694: -- Make sure PL/SQL table has records in it before passing
695: IF (p_avlv_tbl.COUNT > 0) THEN
696: i := p_avlv_tbl.FIRST;
697: LOOP

Line 700: p_init_msg_list => Okc_Api.G_FALSE,

696: i := p_avlv_tbl.FIRST;
697: LOOP
698: lock_template(
699: p_api_version => p_api_version,
700: p_init_msg_list => Okc_Api.G_FALSE,
701: x_return_status => x_return_status,
702: x_msg_count => x_msg_count,
703: x_msg_data => x_msg_data,
704: p_avlv_rec => p_avlv_tbl(i));

Line 706: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

702: x_msg_count => x_msg_count,
703: x_msg_data => x_msg_data,
704: p_avlv_rec => p_avlv_tbl(i));
705:
706: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
707: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
708: l_overall_status := x_return_status;
709: END IF;
710: END IF;

Line 707: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

703: x_msg_data => x_msg_data,
704: p_avlv_rec => p_avlv_tbl(i));
705:
706: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
707: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
708: l_overall_status := x_return_status;
709: END IF;
710: END IF;
711: EXIT WHEN (i = p_avlv_tbl.LAST);

Line 722: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

718: END lock_template;
719:
720: PROCEDURE update_template(
721: p_api_version IN NUMBER,
722: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
723: x_return_status OUT NOCOPY VARCHAR2,
724: x_msg_count OUT NOCOPY NUMBER,
725: x_msg_data OUT NOCOPY VARCHAR2,
726: p_avlv_rec IN avlv_rec_type,

Line 739: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

735: x_msg_data,
736: p_avlv_rec,
737: x_avlv_rec);
738:
739: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
740: NULL;
741: -- Custom code by developer Update_Minor_Version(p_avlv_rec.dnz_chr_id);
742: END IF;
743: END update_template;

Line 747: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

743: END update_template;
744:
745: PROCEDURE update_template(
746: p_api_version IN NUMBER,
747: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
748: x_return_status OUT NOCOPY VARCHAR2,
749: x_msg_count OUT NOCOPY NUMBER,
750: x_msg_data OUT NOCOPY VARCHAR2,
751: p_avlv_tbl IN avlv_tbl_type,

Line 753: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

749: x_msg_count OUT NOCOPY NUMBER,
750: x_msg_data OUT NOCOPY VARCHAR2,
751: p_avlv_tbl IN avlv_tbl_type,
752: x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
753: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
754: i NUMBER := 0;
755: BEGIN
756:
757: Okc_Api.init_msg_list(p_init_msg_list);

Line 757: Okc_Api.init_msg_list(p_init_msg_list);

753: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
754: i NUMBER := 0;
755: BEGIN
756:
757: Okc_Api.init_msg_list(p_init_msg_list);
758: -- Make sure PL/SQL table has records in it before passing
759: IF (p_avlv_tbl.COUNT > 0) THEN
760: i := p_avlv_tbl.FIRST;
761: LOOP

Line 764: p_init_msg_list => Okc_Api.G_FALSE,

760: i := p_avlv_tbl.FIRST;
761: LOOP
762: update_template(
763: p_api_version => p_api_version,
764: p_init_msg_list => Okc_Api.G_FALSE,
765: x_return_status => x_return_status,
766: x_msg_count => x_msg_count,
767: x_msg_data => x_msg_data,
768: p_avlv_rec => p_avlv_tbl(i),

Line 771: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

767: x_msg_data => x_msg_data,
768: p_avlv_rec => p_avlv_tbl(i),
769: x_avlv_rec => x_avlv_tbl(i));
770:
771: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
772: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
773: l_overall_status := x_return_status;
774: END IF;
775: END IF;

Line 772: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

768: p_avlv_rec => p_avlv_tbl(i),
769: x_avlv_rec => x_avlv_tbl(i));
770:
771: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
772: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
773: l_overall_status := x_return_status;
774: END IF;
775: END IF;
776:

Line 789: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

785:
786:
787: PROCEDURE delete_template(
788: p_api_version IN NUMBER,
789: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
790: x_return_status OUT NOCOPY VARCHAR2,
791: x_msg_count OUT NOCOPY NUMBER,
792: x_msg_data OUT NOCOPY VARCHAR2,
793: p_avlv_rec IN avlv_rec_type) IS

Line 796: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

792: x_msg_data OUT NOCOPY VARCHAR2,
793: p_avlv_rec IN avlv_rec_type) IS
794:
795: i NUMBER :=0;
796: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
797: l_atlv_tbl OKL_ATL_PVT.ATLV_TBL_TYPE;
798:
799: CURSOR atl_csr(v_avl_id NUMBER) IS
800: SELECT ID

Line 823: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

819: x_msg_count,
820: x_msg_data,
821: l_atlv_tbl);
822:
823: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
824:
825: okl_avl_pvt.delete_row(
826: p_api_version,
827: p_init_msg_list,

Line 840: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

836:
837:
838: PROCEDURE delete_template(
839: p_api_version IN NUMBER,
840: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
841: x_return_status OUT NOCOPY VARCHAR2,
842: x_msg_count OUT NOCOPY NUMBER,
843: x_msg_data OUT NOCOPY VARCHAR2,
844: p_avlv_tbl IN avlv_tbl_type) IS

Line 846: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

842: x_msg_count OUT NOCOPY NUMBER,
843: x_msg_data OUT NOCOPY VARCHAR2,
844: p_avlv_tbl IN avlv_tbl_type) IS
845: i NUMBER :=0;
846: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
847:
848: BEGIN
849: --Initialize the return status
850: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 850: x_return_status := OKC_API.G_RET_STS_SUCCESS;

846: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
847:
848: BEGIN
849: --Initialize the return status
850: x_return_status := OKC_API.G_RET_STS_SUCCESS;
851:
852: IF (p_avlv_tbl.COUNT > 0) THEN
853: i := p_avlv_tbl.FIRST;
854: LOOP

Line 863: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

859: x_msg_count,
860: x_msg_data,
861: p_avlv_tbl(i));
862:
863: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
864: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
865: l_overall_status := x_return_status;
866: END IF;
867: END IF;

Line 864: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

860: x_msg_data,
861: p_avlv_tbl(i));
862:
863: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
864: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
865: l_overall_status := x_return_status;
866: END IF;
867: END IF;
868:

Line 880: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

876: END delete_template;
877:
878: PROCEDURE validate_template(
879: p_api_version IN NUMBER,
880: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
881: x_return_status OUT NOCOPY VARCHAR2,
882: x_msg_count OUT NOCOPY NUMBER,
883: x_msg_data OUT NOCOPY VARCHAR2,
884: p_avlv_rec IN avlv_rec_type) IS

Line 897: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

893: END validate_template;
894:
895: PROCEDURE validate_template(
896: p_api_version IN NUMBER,
897: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
898: x_return_status OUT NOCOPY VARCHAR2,
899: x_msg_count OUT NOCOPY NUMBER,
900: x_msg_data OUT NOCOPY VARCHAR2,
901: p_avlv_tbl IN avlv_tbl_type) IS

Line 903: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

899: x_msg_count OUT NOCOPY NUMBER,
900: x_msg_data OUT NOCOPY VARCHAR2,
901: p_avlv_tbl IN avlv_tbl_type) IS
902:
903: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
904: i NUMBER := 0;
905:
906: BEGIN
907:

Line 908: Okc_Api.init_msg_list(p_init_msg_list);

904: i NUMBER := 0;
905:
906: BEGIN
907:
908: Okc_Api.init_msg_list(p_init_msg_list);
909: -- Make sure PL/SQL table has records in it before passing
910: IF (p_avlv_tbl.COUNT > 0) THEN
911: i := p_avlv_tbl.FIRST;
912: LOOP

Line 915: p_init_msg_list => Okc_Api.G_FALSE,

911: i := p_avlv_tbl.FIRST;
912: LOOP
913: validate_template(
914: p_api_version => p_api_version,
915: p_init_msg_list => Okc_Api.G_FALSE,
916: x_return_status => x_return_status,
917: x_msg_count => x_msg_count,
918: x_msg_data => x_msg_data,
919: p_avlv_rec => p_avlv_tbl(i));

Line 921: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

917: x_msg_count => x_msg_count,
918: x_msg_data => x_msg_data,
919: p_avlv_rec => p_avlv_tbl(i));
920:
921: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
922: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
923: l_overall_status := x_return_status;
924: END IF;
925: END IF;

Line 922: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

918: x_msg_data => x_msg_data,
919: p_avlv_rec => p_avlv_tbl(i));
920:
921: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
922: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
923: l_overall_status := x_return_status;
924: END IF;
925: END IF;
926:

Line 937: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

933: END validate_template;
934:
935: PROCEDURE create_tmpt_lines(
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
938: x_return_status OUT NOCOPY VARCHAR2,
939: x_msg_count OUT NOCOPY NUMBER,
940: x_msg_data OUT NOCOPY VARCHAR2,
941: p_atlv_rec IN atlv_rec_type,

Line 953: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

949: x_msg_data,
950: p_atlv_rec,
951: x_atlv_rec);
952:
953: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
954: NULL;
955: -- Custom code by developer Update_Minor_Version(p_atlv_rec.dnz_chr_id);
956: END IF;
957:

Line 962: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

958: END create_tmpt_lines;
959:
960: PROCEDURE create_tmpt_lines(
961: p_api_version IN NUMBER,
962: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
963: x_return_status OUT NOCOPY VARCHAR2,
964: x_msg_count OUT NOCOPY NUMBER,
965: x_msg_data OUT NOCOPY VARCHAR2,
966: p_atlv_tbl IN atlv_tbl_type,

Line 969: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

965: x_msg_data OUT NOCOPY VARCHAR2,
966: p_atlv_tbl IN atlv_tbl_type,
967: x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
968:
969: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
970: i NUMBER := 0;
971: BEGIN
972:
973: Okc_Api.init_msg_list(p_init_msg_list);

Line 973: Okc_Api.init_msg_list(p_init_msg_list);

969: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
970: i NUMBER := 0;
971: BEGIN
972:
973: Okc_Api.init_msg_list(p_init_msg_list);
974: -- Make sure PL/SQL table has records in it before passing
975: IF (p_atlv_tbl.COUNT > 0) THEN
976: i := p_atlv_tbl.FIRST;
977: LOOP

Line 980: p_init_msg_list => Okc_Api.G_FALSE,

976: i := p_atlv_tbl.FIRST;
977: LOOP
978: create_tmpt_lines (
979: p_api_version => p_api_version,
980: p_init_msg_list => Okc_Api.G_FALSE,
981: x_return_status => x_return_status,
982: x_msg_count => x_msg_count,
983: x_msg_data => x_msg_data,
984: p_atlv_rec => p_atlv_tbl(i),

Line 987: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

983: x_msg_data => x_msg_data,
984: p_atlv_rec => p_atlv_tbl(i),
985: x_atlv_rec => x_atlv_tbl(i));
986:
987: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
988: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
989: l_overall_status := x_return_status;
990: END IF;
991: END IF;

Line 988: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

984: p_atlv_rec => p_atlv_tbl(i),
985: x_atlv_rec => x_atlv_tbl(i));
986:
987: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
988: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
989: l_overall_status := x_return_status;
990: END IF;
991: END IF;
992: EXIT WHEN (i = p_atlv_tbl.LAST);

Line 1002: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

998: END create_tmpt_lines;
999:
1000: PROCEDURE lock_tmpt_lines(
1001: p_api_version IN NUMBER,
1002: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1003: x_return_status OUT NOCOPY VARCHAR2,
1004: x_msg_count OUT NOCOPY NUMBER,
1005: x_msg_data OUT NOCOPY VARCHAR2,
1006: p_atlv_rec IN atlv_rec_type) IS

Line 1019: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1015: END lock_tmpt_lines;
1016:
1017: PROCEDURE lock_tmpt_lines(
1018: p_api_version IN NUMBER,
1019: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1020: x_return_status OUT NOCOPY VARCHAR2,
1021: x_msg_count OUT NOCOPY NUMBER,
1022: x_msg_data OUT NOCOPY VARCHAR2,
1023: p_atlv_tbl IN atlv_tbl_type) IS

Line 1024: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1020: x_return_status OUT NOCOPY VARCHAR2,
1021: x_msg_count OUT NOCOPY NUMBER,
1022: x_msg_data OUT NOCOPY VARCHAR2,
1023: p_atlv_tbl IN atlv_tbl_type) IS
1024: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1025: i NUMBER := 0;
1026: BEGIN
1027:
1028: Okc_Api.init_msg_list(p_init_msg_list);

Line 1028: Okc_Api.init_msg_list(p_init_msg_list);

1024: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1025: i NUMBER := 0;
1026: BEGIN
1027:
1028: Okc_Api.init_msg_list(p_init_msg_list);
1029: -- Make sure PL/SQL table has records in it before passing
1030: IF (p_atlv_tbl.COUNT > 0) THEN
1031: i := p_atlv_tbl.FIRST;
1032: LOOP

Line 1035: p_init_msg_list => Okc_Api.G_FALSE,

1031: i := p_atlv_tbl.FIRST;
1032: LOOP
1033: lock_tmpt_lines (
1034: p_api_version => p_api_version,
1035: p_init_msg_list => Okc_Api.G_FALSE,
1036: x_return_status => x_return_status,
1037: x_msg_count => x_msg_count,
1038: x_msg_data => x_msg_data,
1039: p_atlv_rec => p_atlv_tbl(i));

Line 1041: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1037: x_msg_count => x_msg_count,
1038: x_msg_data => x_msg_data,
1039: p_atlv_rec => p_atlv_tbl(i));
1040:
1041: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1042: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1043: l_overall_status := x_return_status;
1044: END IF;
1045: END IF;

Line 1042: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1038: x_msg_data => x_msg_data,
1039: p_atlv_rec => p_atlv_tbl(i));
1040:
1041: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1042: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1043: l_overall_status := x_return_status;
1044: END IF;
1045: END IF;
1046: EXIT WHEN (i = p_atlv_tbl.LAST);

Line 1056: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1052: END lock_tmpt_lines;
1053:
1054: PROCEDURE update_tmpt_lines(
1055: p_api_version IN NUMBER,
1056: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1057: x_return_status OUT NOCOPY VARCHAR2,
1058: x_msg_count OUT NOCOPY NUMBER,
1059: x_msg_data OUT NOCOPY VARCHAR2,
1060: p_atlv_rec IN atlv_rec_type,

Line 1072: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1068: x_msg_data,
1069: p_atlv_rec,
1070: x_atlv_rec);
1071:
1072: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1073: NULL;
1074: -- Custom code by developer Update_Minor_Version(p_atlv_rec.dnz_chr_id);
1075: END IF;
1076: END update_tmpt_lines;

Line 1080: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1076: END update_tmpt_lines;
1077:
1078: PROCEDURE update_tmpt_lines(
1079: p_api_version IN NUMBER,
1080: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1081: x_return_status OUT NOCOPY VARCHAR2,
1082: x_msg_count OUT NOCOPY NUMBER,
1083: x_msg_data OUT NOCOPY VARCHAR2,
1084: p_atlv_tbl IN atlv_tbl_type,

Line 1086: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1082: x_msg_count OUT NOCOPY NUMBER,
1083: x_msg_data OUT NOCOPY VARCHAR2,
1084: p_atlv_tbl IN atlv_tbl_type,
1085: x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
1086: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1087: i NUMBER := 0;
1088: BEGIN
1089:
1090: Okc_Api.init_msg_list(p_init_msg_list);

Line 1090: Okc_Api.init_msg_list(p_init_msg_list);

1086: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1087: i NUMBER := 0;
1088: BEGIN
1089:
1090: Okc_Api.init_msg_list(p_init_msg_list);
1091: -- Make sure PL/SQL table has records in it before passing
1092: IF (p_atlv_tbl.COUNT > 0) THEN
1093: i := p_atlv_tbl.FIRST;
1094: LOOP

Line 1097: p_init_msg_list => Okc_Api.G_FALSE,

1093: i := p_atlv_tbl.FIRST;
1094: LOOP
1095: update_tmpt_lines(
1096: p_api_version => p_api_version,
1097: p_init_msg_list => Okc_Api.G_FALSE,
1098: x_return_status => x_return_status,
1099: x_msg_count => x_msg_count,
1100: x_msg_data => x_msg_data,
1101: p_atlv_rec => p_atlv_tbl(i),

Line 1104: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1100: x_msg_data => x_msg_data,
1101: p_atlv_rec => p_atlv_tbl(i),
1102: x_atlv_rec => x_atlv_tbl(i));
1103:
1104: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1105: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1106: l_overall_status := x_return_status;
1107: END IF;
1108: END IF;

Line 1105: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1101: p_atlv_rec => p_atlv_tbl(i),
1102: x_atlv_rec => x_atlv_tbl(i));
1103:
1104: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1105: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1106: l_overall_status := x_return_status;
1107: END IF;
1108: END IF;
1109:

Line 1124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1120:
1121: --Put custom code for cascade delete by developer
1122: PROCEDURE delete_tmpt_lines(
1123: p_api_version IN NUMBER,
1124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1125: x_return_status OUT NOCOPY VARCHAR2,
1126: x_msg_count OUT NOCOPY NUMBER,
1127: x_msg_data OUT NOCOPY VARCHAR2,
1128: p_atlv_rec IN atlv_rec_type) IS

Line 1130: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1126: x_msg_count OUT NOCOPY NUMBER,
1127: x_msg_data OUT NOCOPY VARCHAR2,
1128: p_atlv_rec IN atlv_rec_type) IS
1129: i NUMBER :=0;
1130: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1131: BEGIN
1132: --Delete the Master
1133: okl_atl_pvt.delete_row(
1134: p_api_version,

Line 1145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1141: END delete_tmpt_lines;
1142:
1143: PROCEDURE delete_tmpt_lines(
1144: p_api_version IN NUMBER,
1145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1146: x_return_status OUT NOCOPY VARCHAR2,
1147: x_msg_count OUT NOCOPY NUMBER,
1148: x_msg_data OUT NOCOPY VARCHAR2,
1149: p_atlv_tbl IN atlv_tbl_type) IS

Line 1151: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1147: x_msg_count OUT NOCOPY NUMBER,
1148: x_msg_data OUT NOCOPY VARCHAR2,
1149: p_atlv_tbl IN atlv_tbl_type) IS
1150: i NUMBER :=0;
1151: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1152: BEGIN
1153: --Initialize the return status
1154:
1155: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1155: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1151: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1152: BEGIN
1153: --Initialize the return status
1154:
1155: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1156:
1157: IF (p_atlv_tbl.COUNT > 0) THEN
1158: i := p_atlv_tbl.FIRST;
1159: LOOP

Line 1168: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1164: x_msg_count,
1165: x_msg_data,
1166: p_atlv_tbl(i));
1167:
1168: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1169: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1170: l_overall_status := x_return_status;
1171: END IF;
1172: END IF;

Line 1169: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1165: x_msg_data,
1166: p_atlv_tbl(i));
1167:
1168: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1169: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1170: l_overall_status := x_return_status;
1171: END IF;
1172: END IF;
1173:

Line 1185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1181: END delete_tmpt_lines;
1182:
1183: PROCEDURE validate_tmpt_lines(
1184: p_api_version IN NUMBER,
1185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1186: x_return_status OUT NOCOPY VARCHAR2,
1187: x_msg_count OUT NOCOPY NUMBER,
1188: x_msg_data OUT NOCOPY VARCHAR2,
1189: p_atlv_rec IN atlv_rec_type) IS

Line 1202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1198: END validate_tmpt_lines;
1199:
1200: PROCEDURE validate_tmpt_lines(
1201: p_api_version IN NUMBER,
1202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1203: x_return_status OUT NOCOPY VARCHAR2,
1204: x_msg_count OUT NOCOPY NUMBER,
1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: p_atlv_tbl IN atlv_tbl_type) IS

Line 1208: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1204: x_msg_count OUT NOCOPY NUMBER,
1205: x_msg_data OUT NOCOPY VARCHAR2,
1206: p_atlv_tbl IN atlv_tbl_type) IS
1207:
1208: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1209: i NUMBER := 0;
1210:
1211: BEGIN
1212:

Line 1213: Okc_Api.init_msg_list(p_init_msg_list);

1209: i NUMBER := 0;
1210:
1211: BEGIN
1212:
1213: Okc_Api.init_msg_list(p_init_msg_list);
1214: -- Make sure PL/SQL table has records in it before passing
1215: IF (p_atlv_tbl.COUNT > 0) THEN
1216: i := p_atlv_tbl.FIRST;
1217: LOOP

Line 1220: p_init_msg_list => Okc_Api.G_FALSE,

1216: i := p_atlv_tbl.FIRST;
1217: LOOP
1218: validate_tmpt_lines(
1219: p_api_version => p_api_version,
1220: p_init_msg_list => Okc_Api.G_FALSE,
1221: x_return_status => x_return_status,
1222: x_msg_count => x_msg_count,
1223: x_msg_data => x_msg_data,
1224: p_atlv_rec => p_atlv_tbl(i));

Line 1226: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1222: x_msg_count => x_msg_count,
1223: x_msg_data => x_msg_data,
1224: p_atlv_rec => p_atlv_tbl(i));
1225:
1226: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1227: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1228: l_overall_status := x_return_status;
1229: END IF;
1230: END IF;

Line 1227: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1223: x_msg_data => x_msg_data,
1224: p_atlv_rec => p_atlv_tbl(i));
1225:
1226: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1227: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1228: l_overall_status := x_return_status;
1229: END IF;
1230: END IF;
1231: