DBA Data[Home] [Help]

APPS.OKL_RCS_PVT_W dependencies on OKL_RCS_PVT

Line 1: package body okl_rcs_pvt_w as

1: package body okl_rcs_pvt_w as
2: /* $Header: OKLIRCSB.pls 120.2 2005/09/14 06:42:42 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_rcs_pvt_w as
2: /* $Header: OKLIRCSB.pls 120.2 2005/09/14 06:42:42 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 48: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE

133: end if;
134: end if;
135: end rosetta_table_copy_out_p1;
136:
137: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
138: , a1 JTF_VARCHAR2_TABLE_300
139: , a2 JTF_NUMBER_TABLE
140: , a3 JTF_NUMBER_TABLE
141: , a4 JTF_NUMBER_TABLE

Line 178: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE

174: end loop;
175: end if;
176: end if;
177: end rosetta_table_copy_in_p3;
178: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
179: , a1 out nocopy JTF_VARCHAR2_TABLE_300
180: , a2 out nocopy JTF_NUMBER_TABLE
181: , a3 out nocopy JTF_NUMBER_TABLE
182: , a4 out nocopy JTF_NUMBER_TABLE

Line 257: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE

253: end if;
254: end if;
255: end rosetta_table_copy_out_p3;
256:
257: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE
258: , a1 JTF_VARCHAR2_TABLE_100
259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE

Line 294: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE

290: end loop;
291: end if;
292: end if;
293: end rosetta_table_copy_in_p5;
294: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE
295: , a1 out nocopy JTF_VARCHAR2_TABLE_100
296: , a2 out nocopy JTF_VARCHAR2_TABLE_100
297: , a3 out nocopy JTF_VARCHAR2_TABLE_100
298: , a4 out nocopy JTF_NUMBER_TABLE

Line 399: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;

395: , p6_a13 out nocopy NUMBER
396: )
397:
398: as
399: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
400: ddx_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
401: ddindx binary_integer; indx binary_integer;
402: begin
403:

Line 400: ddx_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;

396: )
397:
398: as
399: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
400: ddx_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
401: ddindx binary_integer; indx binary_integer;
402: begin
403:
404: -- copy data to the local IN or IN-OUT args, if any

Line 427: okl_rcs_pvt.insert_row(p_api_version,

423: ddp_rcsv_rec.last_update_login := p5_a13;
424:
425:
426: -- here's the delegated call to the old PL/SQL routine
427: okl_rcs_pvt.insert_row(p_api_version,
428: p_init_msg_list,
429: x_return_status,
430: x_msg_count,
431: x_msg_data,

Line 494: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;

490: , p6_a13 out nocopy JTF_NUMBER_TABLE
491: )
492:
493: as
494: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
495: ddx_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
496: ddindx binary_integer; indx binary_integer;
497: begin
498:

Line 495: ddx_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;

491: )
492:
493: as
494: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
495: ddx_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
496: ddindx binary_integer; indx binary_integer;
497: begin
498:
499: -- copy data to the local IN or IN-OUT args, if any

Line 505: okl_rcs_pvt_w.rosetta_table_copy_in_p1(ddp_rcsv_tbl, p5_a0

501:
502:
503:
504:
505: okl_rcs_pvt_w.rosetta_table_copy_in_p1(ddp_rcsv_tbl, p5_a0
506: , p5_a1
507: , p5_a2
508: , p5_a3
509: , p5_a4

Line 523: okl_rcs_pvt.insert_row(p_api_version,

519: );
520:
521:
522: -- here's the delegated call to the old PL/SQL routine
523: okl_rcs_pvt.insert_row(p_api_version,
524: p_init_msg_list,
525: x_return_status,
526: x_msg_count,
527: x_msg_data,

Line 538: okl_rcs_pvt_w.rosetta_table_copy_out_p1(ddx_rcsv_tbl, p6_a0

534:
535:
536:
537:
538: okl_rcs_pvt_w.rosetta_table_copy_out_p1(ddx_rcsv_tbl, p6_a0
539: , p6_a1
540: , p6_a2
541: , p6_a3
542: , p6_a4

Line 591: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;

587: , p6_a13 out nocopy NUMBER
588: )
589:
590: as
591: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
592: ddx_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
593: ddindx binary_integer; indx binary_integer;
594: begin
595:

Line 592: ddx_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;

588: )
589:
590: as
591: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
592: ddx_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
593: ddindx binary_integer; indx binary_integer;
594: begin
595:
596: -- copy data to the local IN or IN-OUT args, if any

Line 619: okl_rcs_pvt.update_row(p_api_version,

615: ddp_rcsv_rec.last_update_login := p5_a13;
616:
617:
618: -- here's the delegated call to the old PL/SQL routine
619: okl_rcs_pvt.update_row(p_api_version,
620: p_init_msg_list,
621: x_return_status,
622: x_msg_count,
623: x_msg_data,

Line 686: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;

682: , p6_a13 out nocopy JTF_NUMBER_TABLE
683: )
684:
685: as
686: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
687: ddx_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
688: ddindx binary_integer; indx binary_integer;
689: begin
690:

Line 687: ddx_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;

683: )
684:
685: as
686: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
687: ddx_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
688: ddindx binary_integer; indx binary_integer;
689: begin
690:
691: -- copy data to the local IN or IN-OUT args, if any

Line 697: okl_rcs_pvt_w.rosetta_table_copy_in_p1(ddp_rcsv_tbl, p5_a0

693:
694:
695:
696:
697: okl_rcs_pvt_w.rosetta_table_copy_in_p1(ddp_rcsv_tbl, p5_a0
698: , p5_a1
699: , p5_a2
700: , p5_a3
701: , p5_a4

Line 715: okl_rcs_pvt.update_row(p_api_version,

711: );
712:
713:
714: -- here's the delegated call to the old PL/SQL routine
715: okl_rcs_pvt.update_row(p_api_version,
716: p_init_msg_list,
717: x_return_status,
718: x_msg_count,
719: x_msg_data,

Line 730: okl_rcs_pvt_w.rosetta_table_copy_out_p1(ddx_rcsv_tbl, p6_a0

726:
727:
728:
729:
730: okl_rcs_pvt_w.rosetta_table_copy_out_p1(ddx_rcsv_tbl, p6_a0
731: , p6_a1
732: , p6_a2
733: , p6_a3
734: , p6_a4

Line 769: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;

765: , p5_a13 NUMBER
766: )
767:
768: as
769: ddp_rcsv_rec okl_rcs_pvt.okl_rcsv_rec;
770: ddindx binary_integer; indx binary_integer;
771: begin
772:
773: -- copy data to the local IN or IN-OUT args, if any

Line 795: okl_rcs_pvt.delete_row(p_api_version,

791: ddp_rcsv_rec.last_update_date := p5_a12;
792: ddp_rcsv_rec.last_update_login := p5_a13;
793:
794: -- here's the delegated call to the old PL/SQL routine
795: okl_rcs_pvt.delete_row(p_api_version,
796: p_init_msg_list,
797: x_return_status,
798: x_msg_count,
799: x_msg_data,

Line 832: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;

828: , p5_a13 JTF_NUMBER_TABLE
829: )
830:
831: as
832: ddp_rcsv_tbl okl_rcs_pvt.okl_rcsv_tbl;
833: ddindx binary_integer; indx binary_integer;
834: begin
835:
836: -- copy data to the local IN or IN-OUT args, if any

Line 842: okl_rcs_pvt_w.rosetta_table_copy_in_p1(ddp_rcsv_tbl, p5_a0

838:
839:
840:
841:
842: okl_rcs_pvt_w.rosetta_table_copy_in_p1(ddp_rcsv_tbl, p5_a0
843: , p5_a1
844: , p5_a2
845: , p5_a3
846: , p5_a4

Line 859: okl_rcs_pvt.delete_row(p_api_version,

855: , p5_a13
856: );
857:
858: -- here's the delegated call to the old PL/SQL routine
859: okl_rcs_pvt.delete_row(p_api_version,
860: p_init_msg_list,
861: x_return_status,
862: x_msg_count,
863: x_msg_data,

Line 874: end okl_rcs_pvt_w;

870:
871:
872: end;
873:
874: end okl_rcs_pvt_w;