DBA Data[Home] [Help]

APPS.OKC_SECTIONS_PVT dependencies on OKC_SCC_PVT

Line 340: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type,

336: p_init_msg_list IN VARCHAR2 ,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,
339: x_msg_data OUT NOCOPY VARCHAR2,
340: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type,
341: x_sccv_rec OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS
342:
343: l_sccv_rec OKC_SCC_PVT.sccv_rec_type := p_sccv_rec;
344: l_chr_id NUMBER;

Line 341: x_sccv_rec OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS

337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,
339: x_msg_data OUT NOCOPY VARCHAR2,
340: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type,
341: x_sccv_rec OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS
342:
343: l_sccv_rec OKC_SCC_PVT.sccv_rec_type := p_sccv_rec;
344: l_chr_id NUMBER;
345: BEGIN

Line 343: l_sccv_rec OKC_SCC_PVT.sccv_rec_type := p_sccv_rec;

339: x_msg_data OUT NOCOPY VARCHAR2,
340: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type,
341: x_sccv_rec OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS
342:
343: l_sccv_rec OKC_SCC_PVT.sccv_rec_type := p_sccv_rec;
344: l_chr_id NUMBER;
345: BEGIN
346: -- initialize return status
347: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 349: OKC_SCC_PVT.Insert_Row(

345: BEGIN
346: -- initialize return status
347: x_return_status := OKC_API.G_RET_STS_SUCCESS;
348:
349: OKC_SCC_PVT.Insert_Row(
350: p_api_version => p_api_version,
351: p_init_msg_list => p_init_msg_list,
352: x_return_status => x_return_status,
353: x_msg_count => x_msg_count,

Line 374: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,

370: p_init_msg_list IN VARCHAR2 ,
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,
374: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,
375: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS
376:
377: BEGIN
378: OKC_SCC_PVT.Insert_Row(

Line 375: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS

371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,
374: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,
375: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS
376:
377: BEGIN
378: OKC_SCC_PVT.Insert_Row(
379: p_api_version => p_api_version,

Line 378: OKC_SCC_PVT.Insert_Row(

374: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,
375: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS
376:
377: BEGIN
378: OKC_SCC_PVT.Insert_Row(
379: p_api_version => p_api_version,
380: p_init_msg_list => p_init_msg_list,
381: x_return_status => x_return_status,
382: x_msg_count => x_msg_count,

Line 394: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type,

390: p_init_msg_list IN VARCHAR2 ,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type,
395: x_sccv_rec OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS
396:
397: l_chr_id NUMBER := -1;
398: BEGIN

Line 395: x_sccv_rec OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS

391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type,
395: x_sccv_rec OUT NOCOPY OKC_SCC_PVT.sccv_rec_type) IS
396:
397: l_chr_id NUMBER := -1;
398: BEGIN
399:

Line 400: OKC_SCC_PVT.Update_Row(

396:
397: l_chr_id NUMBER := -1;
398: BEGIN
399:
400: OKC_SCC_PVT.Update_Row(
401: p_api_version => p_api_version,
402: p_init_msg_list => p_init_msg_list,
403: x_return_status => x_return_status,
404: x_msg_count => x_msg_count,

Line 436: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,

432: p_init_msg_list IN VARCHAR2 ,
433: x_return_status OUT NOCOPY VARCHAR2,
434: x_msg_count OUT NOCOPY NUMBER,
435: x_msg_data OUT NOCOPY VARCHAR2,
436: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,
437: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS
438:
439: BEGIN
440: OKC_SCC_PVT.Update_Row(

Line 437: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS

433: x_return_status OUT NOCOPY VARCHAR2,
434: x_msg_count OUT NOCOPY NUMBER,
435: x_msg_data OUT NOCOPY VARCHAR2,
436: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,
437: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS
438:
439: BEGIN
440: OKC_SCC_PVT.Update_Row(
441: p_api_version => p_api_version,

Line 440: OKC_SCC_PVT.Update_Row(

436: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type,
437: x_sccv_tbl OUT NOCOPY OKC_SCC_PVT.sccv_tbl_type) IS
438:
439: BEGIN
440: OKC_SCC_PVT.Update_Row(
441: p_api_version => p_api_version,
442: p_init_msg_list => p_init_msg_list,
443: x_return_status => x_return_status,
444: x_msg_count => x_msg_count,

Line 456: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS

452: p_init_msg_list IN VARCHAR2 ,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS
457:
458: l_chr_id NUMBER;
459: BEGIN
460:

Line 461: OKC_SCC_PVT.Delete_Row(

457:
458: l_chr_id NUMBER;
459: BEGIN
460:
461: OKC_SCC_PVT.Delete_Row(
462: p_api_version => p_api_version,
463: p_init_msg_list => p_init_msg_list,
464: x_return_status => x_return_status,
465: x_msg_count => x_msg_count,

Line 496: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS

492: p_init_msg_list IN VARCHAR2 ,
493: x_return_status OUT NOCOPY VARCHAR2,
494: x_msg_count OUT NOCOPY NUMBER,
495: x_msg_data OUT NOCOPY VARCHAR2,
496: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS
497:
498: BEGIN
499: OKC_SCC_PVT.Delete_Row(
500: p_api_version => p_api_version,

Line 499: OKC_SCC_PVT.Delete_Row(

495: x_msg_data OUT NOCOPY VARCHAR2,
496: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS
497:
498: BEGIN
499: OKC_SCC_PVT.Delete_Row(
500: p_api_version => p_api_version,
501: p_init_msg_list => p_init_msg_list,
502: x_return_status => x_return_status,
503: x_msg_count => x_msg_count,

Line 514: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS

510: p_init_msg_list IN VARCHAR2 ,
511: x_return_status OUT NOCOPY VARCHAR2,
512: x_msg_count OUT NOCOPY NUMBER,
513: x_msg_data OUT NOCOPY VARCHAR2,
514: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS
515:
516: BEGIN
517: OKC_SCC_PVT.Lock_Row(
518: p_api_version => p_api_version,

Line 517: OKC_SCC_PVT.Lock_Row(

513: x_msg_data OUT NOCOPY VARCHAR2,
514: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS
515:
516: BEGIN
517: OKC_SCC_PVT.Lock_Row(
518: p_api_version => p_api_version,
519: p_init_msg_list => p_init_msg_list,
520: x_return_status => x_return_status,
521: x_msg_count => x_msg_count,

Line 532: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS

528: p_init_msg_list IN VARCHAR2 ,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,
531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS
533:
534: BEGIN
535: OKC_SCC_PVT.Lock_Row(
536: p_api_version => p_api_version,

Line 535: OKC_SCC_PVT.Lock_Row(

531: x_msg_data OUT NOCOPY VARCHAR2,
532: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS
533:
534: BEGIN
535: OKC_SCC_PVT.Lock_Row(
536: p_api_version => p_api_version,
537: p_init_msg_list => p_init_msg_list,
538: x_return_status => x_return_status,
539: x_msg_count => x_msg_count,

Line 550: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS

546: p_init_msg_list IN VARCHAR2 ,
547: x_return_status OUT NOCOPY VARCHAR2,
548: x_msg_count OUT NOCOPY NUMBER,
549: x_msg_data OUT NOCOPY VARCHAR2,
550: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS
551:
552: BEGIN
553: OKC_SCC_PVT.Validate_Row(
554: p_api_version => p_api_version,

Line 553: OKC_SCC_PVT.Validate_Row(

549: x_msg_data OUT NOCOPY VARCHAR2,
550: p_sccv_rec IN OKC_SCC_PVT.sccv_rec_type) IS
551:
552: BEGIN
553: OKC_SCC_PVT.Validate_Row(
554: p_api_version => p_api_version,
555: p_init_msg_list => p_init_msg_list,
556: x_return_status => x_return_status,
557: x_msg_count => x_msg_count,

Line 568: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS

564: p_init_msg_list IN VARCHAR2 ,
565: x_return_status OUT NOCOPY VARCHAR2,
566: x_msg_count OUT NOCOPY NUMBER,
567: x_msg_data OUT NOCOPY VARCHAR2,
568: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS
569:
570: BEGIN
571: OKC_SCC_PVT.Validate_Row(
572: p_api_version => p_api_version,

Line 571: OKC_SCC_PVT.Validate_Row(

567: x_msg_data OUT NOCOPY VARCHAR2,
568: p_sccv_tbl IN OKC_SCC_PVT.sccv_tbl_type) IS
569:
570: BEGIN
571: OKC_SCC_PVT.Validate_Row(
572: p_api_version => p_api_version,
573: p_init_msg_list => p_init_msg_list,
574: x_return_status => x_return_status,
575: x_msg_count => x_msg_count,