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_CGM_PVT_W dependencies on OKL_CGM_PVT

Line 1: package body okl_cgm_pvt_w as

1: package body okl_cgm_pvt_w as
2: /* $Header: OKLICGMB.pls 120.1 2005/07/08 10:18:41 asawanka 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_cgm_pvt.cgm_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_cgm_pvt.cgm_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 57: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p2;
57: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_NUMBER_TABLE
61: , a4 out nocopy JTF_NUMBER_TABLE

Line 121: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE

117: end if;
118: end if;
119: end rosetta_table_copy_out_p2;
120:
121: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE
122: , a1 JTF_NUMBER_TABLE
123: , a2 JTF_NUMBER_TABLE
124: , a3 JTF_NUMBER_TABLE
125: , a4 JTF_NUMBER_TABLE

Line 156: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

152: end loop;
153: end if;
154: end if;
155: end rosetta_table_copy_in_p5;
156: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
157: , a1 out nocopy JTF_NUMBER_TABLE
158: , a2 out nocopy JTF_NUMBER_TABLE
159: , a3 out nocopy JTF_NUMBER_TABLE
160: , a4 out nocopy JTF_NUMBER_TABLE

Line 246: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;

242: , p5_a8 NUMBER := 0-1962.0724
243: )
244:
245: as
246: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
247: ddx_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
248: ddindx binary_integer; indx binary_integer;
249: begin
250:

Line 247: ddx_cgmv_rec okl_cgm_pvt.cgmv_rec_type;

243: )
244:
245: as
246: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
247: ddx_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
248: ddindx binary_integer; indx binary_integer;
249: begin
250:
251: -- copy data to the local IN or IN-OUT args, if any

Line 269: okl_cgm_pvt.insert_row(p_api_version,

265: ddp_cgmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a8);
266:
267:
268: -- here's the delegated call to the old PL/SQL routine
269: okl_cgm_pvt.insert_row(p_api_version,
270: p_init_msg_list,
271: x_return_status,
272: x_msg_count,
273: x_msg_data,

Line 321: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;

317: , p6_a8 out nocopy JTF_NUMBER_TABLE
318: )
319:
320: as
321: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
322: ddx_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
323: ddindx binary_integer; indx binary_integer;
324: begin
325:

Line 322: ddx_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;

318: )
319:
320: as
321: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
322: ddx_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
323: ddindx binary_integer; indx binary_integer;
324: begin
325:
326: -- copy data to the local IN or IN-OUT args, if any

Line 332: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0

328:
329:
330:
331:
332: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0
333: , p5_a1
334: , p5_a2
335: , p5_a3
336: , p5_a4

Line 345: okl_cgm_pvt.insert_row(p_api_version,

341: );
342:
343:
344: -- here's the delegated call to the old PL/SQL routine
345: okl_cgm_pvt.insert_row(p_api_version,
346: p_init_msg_list,
347: x_return_status,
348: x_msg_count,
349: x_msg_data,

Line 360: okl_cgm_pvt_w.rosetta_table_copy_out_p5(ddx_cgmv_tbl, p6_a0

356:
357:
358:
359:
360: okl_cgm_pvt_w.rosetta_table_copy_out_p5(ddx_cgmv_tbl, p6_a0
361: , p6_a1
362: , p6_a2
363: , p6_a3
364: , p6_a4

Line 389: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;

385: , p5_a8 NUMBER := 0-1962.0724
386: )
387:
388: as
389: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
390: ddindx binary_integer; indx binary_integer;
391: begin
392:
393: -- copy data to the local IN or IN-OUT args, if any

Line 410: okl_cgm_pvt.lock_row(p_api_version,

406: ddp_cgmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a7);
407: ddp_cgmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a8);
408:
409: -- here's the delegated call to the old PL/SQL routine
410: okl_cgm_pvt.lock_row(p_api_version,
411: p_init_msg_list,
412: x_return_status,
413: x_msg_count,
414: x_msg_data,

Line 442: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;

438: , p5_a8 JTF_NUMBER_TABLE
439: )
440:
441: as
442: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
443: ddindx binary_integer; indx binary_integer;
444: begin
445:
446: -- copy data to the local IN or IN-OUT args, if any

Line 452: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0

448:
449:
450:
451:
452: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0
453: , p5_a1
454: , p5_a2
455: , p5_a3
456: , p5_a4

Line 464: okl_cgm_pvt.lock_row(p_api_version,

460: , p5_a8
461: );
462:
463: -- here's the delegated call to the old PL/SQL routine
464: okl_cgm_pvt.lock_row(p_api_version,
465: p_init_msg_list,
466: x_return_status,
467: x_msg_count,
468: x_msg_data,

Line 505: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;

501: , p5_a8 NUMBER := 0-1962.0724
502: )
503:
504: as
505: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
506: ddx_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
507: ddindx binary_integer; indx binary_integer;
508: begin
509:

Line 506: ddx_cgmv_rec okl_cgm_pvt.cgmv_rec_type;

502: )
503:
504: as
505: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
506: ddx_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
507: ddindx binary_integer; indx binary_integer;
508: begin
509:
510: -- copy data to the local IN or IN-OUT args, if any

Line 528: okl_cgm_pvt.update_row(p_api_version,

524: ddp_cgmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a8);
525:
526:
527: -- here's the delegated call to the old PL/SQL routine
528: okl_cgm_pvt.update_row(p_api_version,
529: p_init_msg_list,
530: x_return_status,
531: x_msg_count,
532: x_msg_data,

Line 580: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;

576: , p6_a8 out nocopy JTF_NUMBER_TABLE
577: )
578:
579: as
580: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
581: ddx_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
582: ddindx binary_integer; indx binary_integer;
583: begin
584:

Line 581: ddx_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;

577: )
578:
579: as
580: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
581: ddx_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
582: ddindx binary_integer; indx binary_integer;
583: begin
584:
585: -- copy data to the local IN or IN-OUT args, if any

Line 591: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0

587:
588:
589:
590:
591: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0
592: , p5_a1
593: , p5_a2
594: , p5_a3
595: , p5_a4

Line 604: okl_cgm_pvt.update_row(p_api_version,

600: );
601:
602:
603: -- here's the delegated call to the old PL/SQL routine
604: okl_cgm_pvt.update_row(p_api_version,
605: p_init_msg_list,
606: x_return_status,
607: x_msg_count,
608: x_msg_data,

Line 619: okl_cgm_pvt_w.rosetta_table_copy_out_p5(ddx_cgmv_tbl, p6_a0

615:
616:
617:
618:
619: okl_cgm_pvt_w.rosetta_table_copy_out_p5(ddx_cgmv_tbl, p6_a0
620: , p6_a1
621: , p6_a2
622: , p6_a3
623: , p6_a4

Line 648: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;

644: , p5_a8 NUMBER := 0-1962.0724
645: )
646:
647: as
648: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
649: ddindx binary_integer; indx binary_integer;
650: begin
651:
652: -- copy data to the local IN or IN-OUT args, if any

Line 669: okl_cgm_pvt.delete_row(p_api_version,

665: ddp_cgmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a7);
666: ddp_cgmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a8);
667:
668: -- here's the delegated call to the old PL/SQL routine
669: okl_cgm_pvt.delete_row(p_api_version,
670: p_init_msg_list,
671: x_return_status,
672: x_msg_count,
673: x_msg_data,

Line 701: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;

697: , p5_a8 JTF_NUMBER_TABLE
698: )
699:
700: as
701: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
702: ddindx binary_integer; indx binary_integer;
703: begin
704:
705: -- copy data to the local IN or IN-OUT args, if any

Line 711: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0

707:
708:
709:
710:
711: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0
712: , p5_a1
713: , p5_a2
714: , p5_a3
715: , p5_a4

Line 723: okl_cgm_pvt.delete_row(p_api_version,

719: , p5_a8
720: );
721:
722: -- here's the delegated call to the old PL/SQL routine
723: okl_cgm_pvt.delete_row(p_api_version,
724: p_init_msg_list,
725: x_return_status,
726: x_msg_count,
727: x_msg_data,

Line 755: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;

751: , p5_a8 NUMBER := 0-1962.0724
752: )
753:
754: as
755: ddp_cgmv_rec okl_cgm_pvt.cgmv_rec_type;
756: ddindx binary_integer; indx binary_integer;
757: begin
758:
759: -- copy data to the local IN or IN-OUT args, if any

Line 776: okl_cgm_pvt.validate_row(p_api_version,

772: ddp_cgmv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a7);
773: ddp_cgmv_rec.last_update_login := rosetta_g_miss_num_map(p5_a8);
774:
775: -- here's the delegated call to the old PL/SQL routine
776: okl_cgm_pvt.validate_row(p_api_version,
777: p_init_msg_list,
778: x_return_status,
779: x_msg_count,
780: x_msg_data,

Line 808: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;

804: , p5_a8 JTF_NUMBER_TABLE
805: )
806:
807: as
808: ddp_cgmv_tbl okl_cgm_pvt.cgmv_tbl_type;
809: ddindx binary_integer; indx binary_integer;
810: begin
811:
812: -- copy data to the local IN or IN-OUT args, if any

Line 818: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0

814:
815:
816:
817:
818: okl_cgm_pvt_w.rosetta_table_copy_in_p5(ddp_cgmv_tbl, p5_a0
819: , p5_a1
820: , p5_a2
821: , p5_a3
822: , p5_a4

Line 830: okl_cgm_pvt.validate_row(p_api_version,

826: , p5_a8
827: );
828:
829: -- here's the delegated call to the old PL/SQL routine
830: okl_cgm_pvt.validate_row(p_api_version,
831: p_init_msg_list,
832: x_return_status,
833: x_msg_count,
834: x_msg_data,

Line 845: end okl_cgm_pvt_w;

841:
842:
843: end;
844:
845: end okl_cgm_pvt_w;