DBA Data[Home] [Help]

APPS.OKL_IRH_PVT_W dependencies on OKL_IRH_PVT

Line 1: package body okl_irh_pvt_w as

1: package body okl_irh_pvt_w as
2: /* $Header: OKLIIRHB.pls 120.1 2005/07/11 10:25:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irh_pvt.okl_irhv_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_irh_pvt.okl_irhv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_irh_pvt_w as
2: /* $Header: OKLIIRHB.pls 120.1 2005/07/11 10:25:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irh_pvt.okl_irhv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 60: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE

56: end loop;
57: end if;
58: end if;
59: end rosetta_table_copy_in_p1;
60: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE

Line 179: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE

175: end if;
176: end if;
177: end rosetta_table_copy_out_p1;
178:
179: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
180: , a1 JTF_NUMBER_TABLE
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_NUMBER_TABLE
183: , a4 JTF_NUMBER_TABLE

Line 236: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE

232: end loop;
233: end if;
234: end if;
235: end rosetta_table_copy_in_p3;
236: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
237: , a1 out nocopy JTF_NUMBER_TABLE
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_NUMBER_TABLE
240: , a4 out nocopy JTF_NUMBER_TABLE

Line 403: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;

399: , p6_a19 out nocopy NUMBER
400: )
401:
402: as
403: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;
404: ddx_irhv_rec okl_irh_pvt.okl_irhv_rec;
405: ddindx binary_integer; indx binary_integer;
406: begin
407:

Line 404: ddx_irhv_rec okl_irh_pvt.okl_irhv_rec;

400: )
401:
402: as
403: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;
404: ddx_irhv_rec okl_irh_pvt.okl_irhv_rec;
405: ddindx binary_integer; indx binary_integer;
406: begin
407:
408: -- copy data to the local IN or IN-OUT args, if any

Line 437: okl_irh_pvt.insert_row(p_api_version,

433: ddp_irhv_rec.last_update_login := p5_a19;
434:
435:
436: -- here's the delegated call to the old PL/SQL routine
437: okl_irh_pvt.insert_row(p_api_version,
438: p_init_msg_list,
439: x_return_status,
440: x_msg_count,
441: x_msg_data,

Line 522: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;

518: , p6_a19 out nocopy JTF_NUMBER_TABLE
519: )
520:
521: as
522: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
523: ddx_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
524: ddindx binary_integer; indx binary_integer;
525: begin
526:

Line 523: ddx_irhv_tbl okl_irh_pvt.okl_irhv_tbl;

519: )
520:
521: as
522: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
523: ddx_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
524: ddindx binary_integer; indx binary_integer;
525: begin
526:
527: -- copy data to the local IN or IN-OUT args, if any

Line 533: okl_irh_pvt_w.rosetta_table_copy_in_p1(ddp_irhv_tbl, p5_a0

529:
530:
531:
532:
533: okl_irh_pvt_w.rosetta_table_copy_in_p1(ddp_irhv_tbl, p5_a0
534: , p5_a1
535: , p5_a2
536: , p5_a3
537: , p5_a4

Line 557: okl_irh_pvt.insert_row(p_api_version,

553: );
554:
555:
556: -- here's the delegated call to the old PL/SQL routine
557: okl_irh_pvt.insert_row(p_api_version,
558: p_init_msg_list,
559: x_return_status,
560: x_msg_count,
561: x_msg_data,

Line 572: okl_irh_pvt_w.rosetta_table_copy_out_p1(ddx_irhv_tbl, p6_a0

568:
569:
570:
571:
572: okl_irh_pvt_w.rosetta_table_copy_out_p1(ddx_irhv_tbl, p6_a0
573: , p6_a1
574: , p6_a2
575: , p6_a3
576: , p6_a4

Line 643: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;

639: , p6_a19 out nocopy NUMBER
640: )
641:
642: as
643: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;
644: ddx_irhv_rec okl_irh_pvt.okl_irhv_rec;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:

Line 644: ddx_irhv_rec okl_irh_pvt.okl_irhv_rec;

640: )
641:
642: as
643: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;
644: ddx_irhv_rec okl_irh_pvt.okl_irhv_rec;
645: ddindx binary_integer; indx binary_integer;
646: begin
647:
648: -- copy data to the local IN or IN-OUT args, if any

Line 677: okl_irh_pvt.update_row(p_api_version,

673: ddp_irhv_rec.last_update_login := p5_a19;
674:
675:
676: -- here's the delegated call to the old PL/SQL routine
677: okl_irh_pvt.update_row(p_api_version,
678: p_init_msg_list,
679: x_return_status,
680: x_msg_count,
681: x_msg_data,

Line 762: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;

758: , p6_a19 out nocopy JTF_NUMBER_TABLE
759: )
760:
761: as
762: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
763: ddx_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
764: ddindx binary_integer; indx binary_integer;
765: begin
766:

Line 763: ddx_irhv_tbl okl_irh_pvt.okl_irhv_tbl;

759: )
760:
761: as
762: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
763: ddx_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
764: ddindx binary_integer; indx binary_integer;
765: begin
766:
767: -- copy data to the local IN or IN-OUT args, if any

Line 773: okl_irh_pvt_w.rosetta_table_copy_in_p1(ddp_irhv_tbl, p5_a0

769:
770:
771:
772:
773: okl_irh_pvt_w.rosetta_table_copy_in_p1(ddp_irhv_tbl, p5_a0
774: , p5_a1
775: , p5_a2
776: , p5_a3
777: , p5_a4

Line 797: okl_irh_pvt.update_row(p_api_version,

793: );
794:
795:
796: -- here's the delegated call to the old PL/SQL routine
797: okl_irh_pvt.update_row(p_api_version,
798: p_init_msg_list,
799: x_return_status,
800: x_msg_count,
801: x_msg_data,

Line 812: okl_irh_pvt_w.rosetta_table_copy_out_p1(ddx_irhv_tbl, p6_a0

808:
809:
810:
811:
812: okl_irh_pvt_w.rosetta_table_copy_out_p1(ddx_irhv_tbl, p6_a0
813: , p6_a1
814: , p6_a2
815: , p6_a3
816: , p6_a4

Line 863: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;

859: , p5_a19 NUMBER
860: )
861:
862: as
863: ddp_irhv_rec okl_irh_pvt.okl_irhv_rec;
864: ddindx binary_integer; indx binary_integer;
865: begin
866:
867: -- copy data to the local IN or IN-OUT args, if any

Line 895: okl_irh_pvt.delete_row(p_api_version,

891: ddp_irhv_rec.last_update_date := p5_a18;
892: ddp_irhv_rec.last_update_login := p5_a19;
893:
894: -- here's the delegated call to the old PL/SQL routine
895: okl_irh_pvt.delete_row(p_api_version,
896: p_init_msg_list,
897: x_return_status,
898: x_msg_count,
899: x_msg_data,

Line 938: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;

934: , p5_a19 JTF_NUMBER_TABLE
935: )
936:
937: as
938: ddp_irhv_tbl okl_irh_pvt.okl_irhv_tbl;
939: ddindx binary_integer; indx binary_integer;
940: begin
941:
942: -- copy data to the local IN or IN-OUT args, if any

Line 948: okl_irh_pvt_w.rosetta_table_copy_in_p1(ddp_irhv_tbl, p5_a0

944:
945:
946:
947:
948: okl_irh_pvt_w.rosetta_table_copy_in_p1(ddp_irhv_tbl, p5_a0
949: , p5_a1
950: , p5_a2
951: , p5_a3
952: , p5_a4

Line 971: okl_irh_pvt.delete_row(p_api_version,

967: , p5_a19
968: );
969:
970: -- here's the delegated call to the old PL/SQL routine
971: okl_irh_pvt.delete_row(p_api_version,
972: p_init_msg_list,
973: x_return_status,
974: x_msg_count,
975: x_msg_data,

Line 986: end okl_irh_pvt_w;

982:
983:
984: end;
985:
986: end okl_irh_pvt_w;