DBA Data[Home] [Help]

APPS.OKL_VLS_PVT_W dependencies on OKL_VLS_PVT

Line 1: package body okl_vls_pvt_w as

1: package body okl_vls_pvt_w as
2: /* $Header: OKLIVLSB.pls 120.0 2005/09/20 12:37:56 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vls_pvt.vlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vls_pvt.vlsv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_vls_pvt_w as
2: /* $Header: OKLIVLSB.pls 120.0 2005/09/20 12:37:56 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_vls_pvt.vlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500

Line 70: procedure rosetta_table_copy_out_p23(t okl_vls_pvt.vlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

66: end loop;
67: end if;
68: end if;
69: end rosetta_table_copy_in_p23;
70: procedure rosetta_table_copy_out_p23(t okl_vls_pvt.vlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_NUMBER_TABLE
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_VARCHAR2_TABLE_500
74: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 272: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;

268: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_2000
269: )
270:
271: as
272: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
273: ddx_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
274: ddindx binary_integer; indx binary_integer;
275: begin
276:

Line 273: ddx_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;

269: )
270:
271: as
272: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
273: ddx_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
274: ddindx binary_integer; indx binary_integer;
275: begin
276:
277: -- copy data to the local IN or IN-OUT args, if any

Line 283: okl_vls_pvt_w.rosetta_table_copy_in_p23(ddp_vlsv_tbl, p5_a0

279:
280:
281:
282:
283: okl_vls_pvt_w.rosetta_table_copy_in_p23(ddp_vlsv_tbl, p5_a0
284: , p5_a1
285: , p5_a2
286: , p5_a3
287: , p5_a4

Line 312: okl_vls_pvt.insert_row(p_api_version,

308: );
309:
310:
311: -- here's the delegated call to the old PL/SQL routine
312: okl_vls_pvt.insert_row(p_api_version,
313: p_init_msg_list,
314: x_return_status,
315: x_msg_count,
316: x_msg_data,

Line 327: okl_vls_pvt_w.rosetta_table_copy_out_p23(ddx_vlsv_tbl, p6_a0

323:
324:
325:
326:
327: okl_vls_pvt_w.rosetta_table_copy_out_p23(ddx_vlsv_tbl, p6_a0
328: , p6_a1
329: , p6_a2
330: , p6_a3
331: , p6_a4

Line 413: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;

409: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_2000
410: )
411:
412: as
413: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
414: ddx_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
415: ddindx binary_integer; indx binary_integer;
416: begin
417:

Line 414: ddx_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;

410: )
411:
412: as
413: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
414: ddx_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
415: ddindx binary_integer; indx binary_integer;
416: begin
417:
418: -- copy data to the local IN or IN-OUT args, if any

Line 424: okl_vls_pvt_w.rosetta_table_copy_in_p23(ddp_vlsv_tbl, p5_a0

420:
421:
422:
423:
424: okl_vls_pvt_w.rosetta_table_copy_in_p23(ddp_vlsv_tbl, p5_a0
425: , p5_a1
426: , p5_a2
427: , p5_a3
428: , p5_a4

Line 453: okl_vls_pvt.update_row(p_api_version,

449: );
450:
451:
452: -- here's the delegated call to the old PL/SQL routine
453: okl_vls_pvt.update_row(p_api_version,
454: p_init_msg_list,
455: x_return_status,
456: x_msg_count,
457: x_msg_data,

Line 468: okl_vls_pvt_w.rosetta_table_copy_out_p23(ddx_vlsv_tbl, p6_a0

464:
465:
466:
467:
468: okl_vls_pvt_w.rosetta_table_copy_out_p23(ddx_vlsv_tbl, p6_a0
469: , p6_a1
470: , p6_a2
471: , p6_a3
472: , p6_a4

Line 529: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;

525: , p5_a24 JTF_VARCHAR2_TABLE_2000
526: )
527:
528: as
529: ddp_vlsv_tbl okl_vls_pvt.vlsv_tbl_type;
530: ddindx binary_integer; indx binary_integer;
531: begin
532:
533: -- copy data to the local IN or IN-OUT args, if any

Line 539: okl_vls_pvt_w.rosetta_table_copy_in_p23(ddp_vlsv_tbl, p5_a0

535:
536:
537:
538:
539: okl_vls_pvt_w.rosetta_table_copy_in_p23(ddp_vlsv_tbl, p5_a0
540: , p5_a1
541: , p5_a2
542: , p5_a3
543: , p5_a4

Line 567: okl_vls_pvt.delete_row(p_api_version,

563: , p5_a24
564: );
565:
566: -- here's the delegated call to the old PL/SQL routine
567: okl_vls_pvt.delete_row(p_api_version,
568: p_init_msg_list,
569: x_return_status,
570: x_msg_count,
571: x_msg_data,

Line 640: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;

636: , p6_a24 out nocopy VARCHAR2
637: )
638:
639: as
640: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;
641: ddx_vlsv_rec okl_vls_pvt.vlsv_rec_type;
642: ddindx binary_integer; indx binary_integer;
643: begin
644:

Line 641: ddx_vlsv_rec okl_vls_pvt.vlsv_rec_type;

637: )
638:
639: as
640: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;
641: ddx_vlsv_rec okl_vls_pvt.vlsv_rec_type;
642: ddindx binary_integer; indx binary_integer;
643: begin
644:
645: -- copy data to the local IN or IN-OUT args, if any

Line 679: okl_vls_pvt.insert_row(p_api_version,

675: ddp_vlsv_rec.comments := p5_a24;
676:
677:
678: -- here's the delegated call to the old PL/SQL routine
679: okl_vls_pvt.insert_row(p_api_version,
680: p_init_msg_list,
681: x_return_status,
682: x_msg_count,
683: x_msg_data,

Line 779: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;

775: , p6_a24 out nocopy VARCHAR2
776: )
777:
778: as
779: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;
780: ddx_vlsv_rec okl_vls_pvt.vlsv_rec_type;
781: ddindx binary_integer; indx binary_integer;
782: begin
783:

Line 780: ddx_vlsv_rec okl_vls_pvt.vlsv_rec_type;

776: )
777:
778: as
779: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;
780: ddx_vlsv_rec okl_vls_pvt.vlsv_rec_type;
781: ddindx binary_integer; indx binary_integer;
782: begin
783:
784: -- copy data to the local IN or IN-OUT args, if any

Line 818: okl_vls_pvt.update_row(p_api_version,

814: ddp_vlsv_rec.comments := p5_a24;
815:
816:
817: -- here's the delegated call to the old PL/SQL routine
818: okl_vls_pvt.update_row(p_api_version,
819: p_init_msg_list,
820: x_return_status,
821: x_msg_count,
822: x_msg_data,

Line 893: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;

889: , p5_a24 VARCHAR2
890: )
891:
892: as
893: ddp_vlsv_rec okl_vls_pvt.vlsv_rec_type;
894: ddindx binary_integer; indx binary_integer;
895: begin
896:
897: -- copy data to the local IN or IN-OUT args, if any

Line 930: okl_vls_pvt.delete_row(p_api_version,

926: ddp_vlsv_rec.description := p5_a23;
927: ddp_vlsv_rec.comments := p5_a24;
928:
929: -- here's the delegated call to the old PL/SQL routine
930: okl_vls_pvt.delete_row(p_api_version,
931: p_init_msg_list,
932: x_return_status,
933: x_msg_count,
934: x_msg_data,

Line 945: end okl_vls_pvt_w;

941:
942:
943: end;
944:
945: end okl_vls_pvt_w;