DBA Data[Home] [Help]

APPS.OKL_POV_PVT_W dependencies on OKL_POV_PVT

Line 1: package body okl_pov_pvt_w as

1: package body okl_pov_pvt_w as
2: /* $Header: OKLIPOVB.pls 115.7 2002/12/24 04:08:38 sgorantl noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_pov_pvt.pov_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_pov_pvt.pov_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE

Line 61: procedure rosetta_table_copy_out_p2(t okl_pov_pvt.pov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_pov_pvt.pov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_NUMBER_TABLE
63: , a2 out nocopy JTF_NUMBER_TABLE
64: , a3 out nocopy JTF_DATE_TABLE
65: , a4 out nocopy JTF_DATE_TABLE

Line 135: procedure rosetta_table_copy_in_p5(t out nocopy okl_pov_pvt.povv_tbl_type, a0 JTF_NUMBER_TABLE

131: end if;
132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_pov_pvt.povv_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_DATE_TABLE

Line 174: procedure rosetta_table_copy_out_p5(t okl_pov_pvt.povv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

170: end loop;
171: end if;
172: end if;
173: end rosetta_table_copy_in_p5;
174: procedure rosetta_table_copy_out_p5(t okl_pov_pvt.povv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
175: , a1 out nocopy JTF_NUMBER_TABLE
176: , a2 out nocopy JTF_NUMBER_TABLE
177: , a3 out nocopy JTF_NUMBER_TABLE
178: , a4 out nocopy JTF_DATE_TABLE

Line 278: ddp_povv_rec okl_pov_pvt.povv_rec_type;

274: , p5_a10 NUMBER := 0-1962.0724
275: )
276:
277: as
278: ddp_povv_rec okl_pov_pvt.povv_rec_type;
279: ddx_povv_rec okl_pov_pvt.povv_rec_type;
280: ddindx binary_integer; indx binary_integer;
281: begin
282:

Line 279: ddx_povv_rec okl_pov_pvt.povv_rec_type;

275: )
276:
277: as
278: ddp_povv_rec okl_pov_pvt.povv_rec_type;
279: ddx_povv_rec okl_pov_pvt.povv_rec_type;
280: ddindx binary_integer; indx binary_integer;
281: begin
282:
283: -- copy data to the local IN or IN-OUT args, if any

Line 303: okl_pov_pvt.insert_row(p_api_version,

299: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
300:
301:
302: -- here's the delegated call to the old PL/SQL routine
303: okl_pov_pvt.insert_row(p_api_version,
304: p_init_msg_list,
305: x_return_status,
306: x_msg_count,
307: x_msg_data,

Line 361: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;

357: , p6_a10 out nocopy JTF_NUMBER_TABLE
358: )
359:
360: as
361: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;
362: ddx_povv_tbl okl_pov_pvt.povv_tbl_type;
363: ddindx binary_integer; indx binary_integer;
364: begin
365:

Line 362: ddx_povv_tbl okl_pov_pvt.povv_tbl_type;

358: )
359:
360: as
361: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;
362: ddx_povv_tbl okl_pov_pvt.povv_tbl_type;
363: ddindx binary_integer; indx binary_integer;
364: begin
365:
366: -- copy data to the local IN or IN-OUT args, if any

Line 372: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0

368:
369:
370:
371:
372: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0
373: , p5_a1
374: , p5_a2
375: , p5_a3
376: , p5_a4

Line 387: okl_pov_pvt.insert_row(p_api_version,

383: );
384:
385:
386: -- here's the delegated call to the old PL/SQL routine
387: okl_pov_pvt.insert_row(p_api_version,
388: p_init_msg_list,
389: x_return_status,
390: x_msg_count,
391: x_msg_data,

Line 402: okl_pov_pvt_w.rosetta_table_copy_out_p5(ddx_povv_tbl, p6_a0

398:
399:
400:
401:
402: okl_pov_pvt_w.rosetta_table_copy_out_p5(ddx_povv_tbl, p6_a0
403: , p6_a1
404: , p6_a2
405: , p6_a3
406: , p6_a4

Line 435: ddp_povv_rec okl_pov_pvt.povv_rec_type;

431: , p5_a10 NUMBER := 0-1962.0724
432: )
433:
434: as
435: ddp_povv_rec okl_pov_pvt.povv_rec_type;
436: ddindx binary_integer; indx binary_integer;
437: begin
438:
439: -- copy data to the local IN or IN-OUT args, if any

Line 458: okl_pov_pvt.lock_row(p_api_version,

454: ddp_povv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
455: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
456:
457: -- here's the delegated call to the old PL/SQL routine
458: okl_pov_pvt.lock_row(p_api_version,
459: p_init_msg_list,
460: x_return_status,
461: x_msg_count,
462: x_msg_data,

Line 492: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;

488: , p5_a10 JTF_NUMBER_TABLE
489: )
490:
491: as
492: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;
493: ddindx binary_integer; indx binary_integer;
494: begin
495:
496: -- copy data to the local IN or IN-OUT args, if any

Line 502: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0

498:
499:
500:
501:
502: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0
503: , p5_a1
504: , p5_a2
505: , p5_a3
506: , p5_a4

Line 516: okl_pov_pvt.lock_row(p_api_version,

512: , p5_a10
513: );
514:
515: -- here's the delegated call to the old PL/SQL routine
516: okl_pov_pvt.lock_row(p_api_version,
517: p_init_msg_list,
518: x_return_status,
519: x_msg_count,
520: x_msg_data,

Line 561: ddp_povv_rec okl_pov_pvt.povv_rec_type;

557: , p5_a10 NUMBER := 0-1962.0724
558: )
559:
560: as
561: ddp_povv_rec okl_pov_pvt.povv_rec_type;
562: ddx_povv_rec okl_pov_pvt.povv_rec_type;
563: ddindx binary_integer; indx binary_integer;
564: begin
565:

Line 562: ddx_povv_rec okl_pov_pvt.povv_rec_type;

558: )
559:
560: as
561: ddp_povv_rec okl_pov_pvt.povv_rec_type;
562: ddx_povv_rec okl_pov_pvt.povv_rec_type;
563: ddindx binary_integer; indx binary_integer;
564: begin
565:
566: -- copy data to the local IN or IN-OUT args, if any

Line 586: okl_pov_pvt.update_row(p_api_version,

582: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
583:
584:
585: -- here's the delegated call to the old PL/SQL routine
586: okl_pov_pvt.update_row(p_api_version,
587: p_init_msg_list,
588: x_return_status,
589: x_msg_count,
590: x_msg_data,

Line 644: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;

640: , p6_a10 out nocopy JTF_NUMBER_TABLE
641: )
642:
643: as
644: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;
645: ddx_povv_tbl okl_pov_pvt.povv_tbl_type;
646: ddindx binary_integer; indx binary_integer;
647: begin
648:

Line 645: ddx_povv_tbl okl_pov_pvt.povv_tbl_type;

641: )
642:
643: as
644: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;
645: ddx_povv_tbl okl_pov_pvt.povv_tbl_type;
646: ddindx binary_integer; indx binary_integer;
647: begin
648:
649: -- copy data to the local IN or IN-OUT args, if any

Line 655: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0

651:
652:
653:
654:
655: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0
656: , p5_a1
657: , p5_a2
658: , p5_a3
659: , p5_a4

Line 670: okl_pov_pvt.update_row(p_api_version,

666: );
667:
668:
669: -- here's the delegated call to the old PL/SQL routine
670: okl_pov_pvt.update_row(p_api_version,
671: p_init_msg_list,
672: x_return_status,
673: x_msg_count,
674: x_msg_data,

Line 685: okl_pov_pvt_w.rosetta_table_copy_out_p5(ddx_povv_tbl, p6_a0

681:
682:
683:
684:
685: okl_pov_pvt_w.rosetta_table_copy_out_p5(ddx_povv_tbl, p6_a0
686: , p6_a1
687: , p6_a2
688: , p6_a3
689: , p6_a4

Line 718: ddp_povv_rec okl_pov_pvt.povv_rec_type;

714: , p5_a10 NUMBER := 0-1962.0724
715: )
716:
717: as
718: ddp_povv_rec okl_pov_pvt.povv_rec_type;
719: ddindx binary_integer; indx binary_integer;
720: begin
721:
722: -- copy data to the local IN or IN-OUT args, if any

Line 741: okl_pov_pvt.delete_row(p_api_version,

737: ddp_povv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
738: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
739:
740: -- here's the delegated call to the old PL/SQL routine
741: okl_pov_pvt.delete_row(p_api_version,
742: p_init_msg_list,
743: x_return_status,
744: x_msg_count,
745: x_msg_data,

Line 775: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;

771: , p5_a10 JTF_NUMBER_TABLE
772: )
773:
774: as
775: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;
776: ddindx binary_integer; indx binary_integer;
777: begin
778:
779: -- copy data to the local IN or IN-OUT args, if any

Line 785: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0

781:
782:
783:
784:
785: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0
786: , p5_a1
787: , p5_a2
788: , p5_a3
789: , p5_a4

Line 799: okl_pov_pvt.delete_row(p_api_version,

795: , p5_a10
796: );
797:
798: -- here's the delegated call to the old PL/SQL routine
799: okl_pov_pvt.delete_row(p_api_version,
800: p_init_msg_list,
801: x_return_status,
802: x_msg_count,
803: x_msg_data,

Line 833: ddp_povv_rec okl_pov_pvt.povv_rec_type;

829: , p5_a10 NUMBER := 0-1962.0724
830: )
831:
832: as
833: ddp_povv_rec okl_pov_pvt.povv_rec_type;
834: ddindx binary_integer; indx binary_integer;
835: begin
836:
837: -- copy data to the local IN or IN-OUT args, if any

Line 856: okl_pov_pvt.validate_row(p_api_version,

852: ddp_povv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a9);
853: ddp_povv_rec.last_update_login := rosetta_g_miss_num_map(p5_a10);
854:
855: -- here's the delegated call to the old PL/SQL routine
856: okl_pov_pvt.validate_row(p_api_version,
857: p_init_msg_list,
858: x_return_status,
859: x_msg_count,
860: x_msg_data,

Line 890: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;

886: , p5_a10 JTF_NUMBER_TABLE
887: )
888:
889: as
890: ddp_povv_tbl okl_pov_pvt.povv_tbl_type;
891: ddindx binary_integer; indx binary_integer;
892: begin
893:
894: -- copy data to the local IN or IN-OUT args, if any

Line 900: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0

896:
897:
898:
899:
900: okl_pov_pvt_w.rosetta_table_copy_in_p5(ddp_povv_tbl, p5_a0
901: , p5_a1
902: , p5_a2
903: , p5_a3
904: , p5_a4

Line 914: okl_pov_pvt.validate_row(p_api_version,

910: , p5_a10
911: );
912:
913: -- here's the delegated call to the old PL/SQL routine
914: okl_pov_pvt.validate_row(p_api_version,
915: p_init_msg_list,
916: x_return_status,
917: x_msg_count,
918: x_msg_data,

Line 929: end okl_pov_pvt_w;

925:
926:
927: end;
928:
929: end okl_pov_pvt_w;