eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PQV_PVT_W dependencies on OKL_PQV_PVT

Line 1: package body okl_pqv_pvt_w as

1: package body okl_pqv_pvt_w as
2: /* $Header: OKLIPQVB.pls 115.10 2002/12/24 04:08:56 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_pqv_pvt.pqv_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_pqv_pvt.pqv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 63: procedure rosetta_table_copy_out_p2(t okl_pqv_pvt.pqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

59: end loop;
60: end if;
61: end if;
62: end rosetta_table_copy_in_p2;
63: procedure rosetta_table_copy_out_p2(t okl_pqv_pvt.pqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE

Line 142: procedure rosetta_table_copy_in_p5(t out nocopy okl_pqv_pvt.pqvv_tbl_type, a0 JTF_NUMBER_TABLE

138: end if;
139: end if;
140: end rosetta_table_copy_out_p2;
141:
142: procedure rosetta_table_copy_in_p5(t out nocopy okl_pqv_pvt.pqvv_tbl_type, a0 JTF_NUMBER_TABLE
143: , a1 JTF_NUMBER_TABLE
144: , a2 JTF_NUMBER_TABLE
145: , a3 JTF_NUMBER_TABLE
146: , a4 JTF_NUMBER_TABLE

Line 183: procedure rosetta_table_copy_out_p5(t okl_pqv_pvt.pqvv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

179: end loop;
180: end if;
181: end if;
182: end rosetta_table_copy_in_p5;
183: procedure rosetta_table_copy_out_p5(t okl_pqv_pvt.pqvv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_NUMBER_TABLE
185: , a2 out nocopy JTF_NUMBER_TABLE
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_NUMBER_TABLE

Line 294: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;

290: , p5_a11 NUMBER := 0-1962.0724
291: )
292:
293: as
294: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
295: ddx_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
296: ddindx binary_integer; indx binary_integer;
297: begin
298:

Line 295: ddx_pqvv_rec okl_pqv_pvt.pqvv_rec_type;

291: )
292:
293: as
294: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
295: ddx_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
296: ddindx binary_integer; indx binary_integer;
297: begin
298:
299: -- copy data to the local IN or IN-OUT args, if any

Line 320: okl_pqv_pvt.insert_row(p_api_version,

316: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
317:
318:
319: -- here's the delegated call to the old PL/SQL routine
320: okl_pqv_pvt.insert_row(p_api_version,
321: p_init_msg_list,
322: x_return_status,
323: x_msg_count,
324: x_msg_data,

Line 381: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;

377: , p6_a11 out nocopy JTF_NUMBER_TABLE
378: )
379:
380: as
381: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
382: ddx_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
383: ddindx binary_integer; indx binary_integer;
384: begin
385:

Line 382: ddx_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;

378: )
379:
380: as
381: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
382: ddx_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
383: ddindx binary_integer; indx binary_integer;
384: begin
385:
386: -- copy data to the local IN or IN-OUT args, if any

Line 392: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0

388:
389:
390:
391:
392: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0
393: , p5_a1
394: , p5_a2
395: , p5_a3
396: , p5_a4

Line 408: okl_pqv_pvt.insert_row(p_api_version,

404: );
405:
406:
407: -- here's the delegated call to the old PL/SQL routine
408: okl_pqv_pvt.insert_row(p_api_version,
409: p_init_msg_list,
410: x_return_status,
411: x_msg_count,
412: x_msg_data,

Line 423: okl_pqv_pvt_w.rosetta_table_copy_out_p5(ddx_pqvv_tbl, p6_a0

419:
420:
421:
422:
423: okl_pqv_pvt_w.rosetta_table_copy_out_p5(ddx_pqvv_tbl, p6_a0
424: , p6_a1
425: , p6_a2
426: , p6_a3
427: , p6_a4

Line 458: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;

454: , p5_a11 NUMBER := 0-1962.0724
455: )
456:
457: as
458: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
459: ddindx binary_integer; indx binary_integer;
460: begin
461:
462: -- copy data to the local IN or IN-OUT args, if any

Line 482: okl_pqv_pvt.lock_row(p_api_version,

478: ddp_pqvv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
479: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
480:
481: -- here's the delegated call to the old PL/SQL routine
482: okl_pqv_pvt.lock_row(p_api_version,
483: p_init_msg_list,
484: x_return_status,
485: x_msg_count,
486: x_msg_data,

Line 517: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;

513: , p5_a11 JTF_NUMBER_TABLE
514: )
515:
516: as
517: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
518: ddindx binary_integer; indx binary_integer;
519: begin
520:
521: -- copy data to the local IN or IN-OUT args, if any

Line 527: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0

523:
524:
525:
526:
527: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0
528: , p5_a1
529: , p5_a2
530: , p5_a3
531: , p5_a4

Line 542: okl_pqv_pvt.lock_row(p_api_version,

538: , p5_a11
539: );
540:
541: -- here's the delegated call to the old PL/SQL routine
542: okl_pqv_pvt.lock_row(p_api_version,
543: p_init_msg_list,
544: x_return_status,
545: x_msg_count,
546: x_msg_data,

Line 589: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;

585: , p5_a11 NUMBER := 0-1962.0724
586: )
587:
588: as
589: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
590: ddx_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
591: ddindx binary_integer; indx binary_integer;
592: begin
593:

Line 590: ddx_pqvv_rec okl_pqv_pvt.pqvv_rec_type;

586: )
587:
588: as
589: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
590: ddx_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
591: ddindx binary_integer; indx binary_integer;
592: begin
593:
594: -- copy data to the local IN or IN-OUT args, if any

Line 615: okl_pqv_pvt.update_row(p_api_version,

611: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
612:
613:
614: -- here's the delegated call to the old PL/SQL routine
615: okl_pqv_pvt.update_row(p_api_version,
616: p_init_msg_list,
617: x_return_status,
618: x_msg_count,
619: x_msg_data,

Line 676: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;

672: , p6_a11 out nocopy JTF_NUMBER_TABLE
673: )
674:
675: as
676: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
677: ddx_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
678: ddindx binary_integer; indx binary_integer;
679: begin
680:

Line 677: ddx_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;

673: )
674:
675: as
676: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
677: ddx_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
678: ddindx binary_integer; indx binary_integer;
679: begin
680:
681: -- copy data to the local IN or IN-OUT args, if any

Line 687: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0

683:
684:
685:
686:
687: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0
688: , p5_a1
689: , p5_a2
690: , p5_a3
691: , p5_a4

Line 703: okl_pqv_pvt.update_row(p_api_version,

699: );
700:
701:
702: -- here's the delegated call to the old PL/SQL routine
703: okl_pqv_pvt.update_row(p_api_version,
704: p_init_msg_list,
705: x_return_status,
706: x_msg_count,
707: x_msg_data,

Line 718: okl_pqv_pvt_w.rosetta_table_copy_out_p5(ddx_pqvv_tbl, p6_a0

714:
715:
716:
717:
718: okl_pqv_pvt_w.rosetta_table_copy_out_p5(ddx_pqvv_tbl, p6_a0
719: , p6_a1
720: , p6_a2
721: , p6_a3
722: , p6_a4

Line 753: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;

749: , p5_a11 NUMBER := 0-1962.0724
750: )
751:
752: as
753: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
754: ddindx binary_integer; indx binary_integer;
755: begin
756:
757: -- copy data to the local IN or IN-OUT args, if any

Line 777: okl_pqv_pvt.delete_row(p_api_version,

773: ddp_pqvv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
774: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
775:
776: -- here's the delegated call to the old PL/SQL routine
777: okl_pqv_pvt.delete_row(p_api_version,
778: p_init_msg_list,
779: x_return_status,
780: x_msg_count,
781: x_msg_data,

Line 812: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;

808: , p5_a11 JTF_NUMBER_TABLE
809: )
810:
811: as
812: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
813: ddindx binary_integer; indx binary_integer;
814: begin
815:
816: -- copy data to the local IN or IN-OUT args, if any

Line 822: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0

818:
819:
820:
821:
822: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0
823: , p5_a1
824: , p5_a2
825: , p5_a3
826: , p5_a4

Line 837: okl_pqv_pvt.delete_row(p_api_version,

833: , p5_a11
834: );
835:
836: -- here's the delegated call to the old PL/SQL routine
837: okl_pqv_pvt.delete_row(p_api_version,
838: p_init_msg_list,
839: x_return_status,
840: x_msg_count,
841: x_msg_data,

Line 872: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;

868: , p5_a11 NUMBER := 0-1962.0724
869: )
870:
871: as
872: ddp_pqvv_rec okl_pqv_pvt.pqvv_rec_type;
873: ddindx binary_integer; indx binary_integer;
874: begin
875:
876: -- copy data to the local IN or IN-OUT args, if any

Line 896: okl_pqv_pvt.validate_row(p_api_version,

892: ddp_pqvv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
893: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
894:
895: -- here's the delegated call to the old PL/SQL routine
896: okl_pqv_pvt.validate_row(p_api_version,
897: p_init_msg_list,
898: x_return_status,
899: x_msg_count,
900: x_msg_data,

Line 931: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;

927: , p5_a11 JTF_NUMBER_TABLE
928: )
929:
930: as
931: ddp_pqvv_tbl okl_pqv_pvt.pqvv_tbl_type;
932: ddindx binary_integer; indx binary_integer;
933: begin
934:
935: -- copy data to the local IN or IN-OUT args, if any

Line 941: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0

937:
938:
939:
940:
941: okl_pqv_pvt_w.rosetta_table_copy_in_p5(ddp_pqvv_tbl, p5_a0
942: , p5_a1
943: , p5_a2
944: , p5_a3
945: , p5_a4

Line 956: okl_pqv_pvt.validate_row(p_api_version,

952: , p5_a11
953: );
954:
955: -- here's the delegated call to the old PL/SQL routine
956: okl_pqv_pvt.validate_row(p_api_version,
957: p_init_msg_list,
958: x_return_status,
959: x_msg_count,
960: x_msg_data,

Line 971: end okl_pqv_pvt_w;

967:
968:
969: end;
970:
971: end okl_pqv_pvt_w;