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_GTS_PVT_W dependencies on OKL_GTS_PVT

Line 1: package body okl_gts_pvt_w as

1: package body okl_gts_pvt_w as
2: /* $Header: OKLIGTSB.pls 120.3 2007/10/15 15:57:45 dpsingh ship $ */
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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p2(t out nocopy okl_gts_pvt.gts_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_gts_pvt.gts_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_2000
29: , a4 JTF_VARCHAR2_TABLE_100

Line 80: procedure rosetta_table_copy_out_p2(t okl_gts_pvt.gts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p2;
80: procedure rosetta_table_copy_out_p2(t okl_gts_pvt.gts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 194: procedure rosetta_table_copy_in_p5(t out nocopy okl_gts_pvt.gtsv_tbl_type, a0 JTF_NUMBER_TABLE

190: end if;
191: end if;
192: end rosetta_table_copy_out_p2;
193:
194: procedure rosetta_table_copy_in_p5(t out nocopy okl_gts_pvt.gtsv_tbl_type, a0 JTF_NUMBER_TABLE
195: , a1 JTF_NUMBER_TABLE
196: , a2 JTF_VARCHAR2_TABLE_200
197: , a3 JTF_VARCHAR2_TABLE_2000
198: , a4 JTF_VARCHAR2_TABLE_100

Line 249: procedure rosetta_table_copy_out_p5(t okl_gts_pvt.gtsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

245: end loop;
246: end if;
247: end if;
248: end rosetta_table_copy_in_p5;
249: procedure rosetta_table_copy_out_p5(t okl_gts_pvt.gtsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
250: , a1 out nocopy JTF_NUMBER_TABLE
251: , a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 409: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;

405: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
406: )
407:
408: as
409: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;
410: ddx_gtsv_rec okl_gts_pvt.gtsv_rec_type;
411: ddindx binary_integer; indx binary_integer;
412: begin
413:

Line 410: ddx_gtsv_rec okl_gts_pvt.gtsv_rec_type;

406: )
407:
408: as
409: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;
410: ddx_gtsv_rec okl_gts_pvt.gtsv_rec_type;
411: ddindx binary_integer; indx binary_integer;
412: begin
413:
414: -- copy data to the local IN or IN-OUT args, if any

Line 442: okl_gts_pvt.insert_row(p_api_version,

438: ddp_gtsv_rec.isg_arrears_pay_dates_option := p5_a18;
439:
440:
441: -- here's the delegated call to the old PL/SQL routine
442: okl_gts_pvt.insert_row(p_api_version,
443: p_init_msg_list,
444: x_return_status,
445: x_msg_count,
446: x_msg_data,

Line 524: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;

520: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
521: )
522:
523: as
524: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
525: ddx_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
526: ddindx binary_integer; indx binary_integer;
527: begin
528:

Line 525: ddx_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;

521: )
522:
523: as
524: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
525: ddx_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
526: ddindx binary_integer; indx binary_integer;
527: begin
528:
529: -- copy data to the local IN or IN-OUT args, if any

Line 535: okl_gts_pvt_w.rosetta_table_copy_in_p5(ddp_gtsv_tbl, p5_a0

531:
532:
533:
534:
535: okl_gts_pvt_w.rosetta_table_copy_in_p5(ddp_gtsv_tbl, p5_a0
536: , p5_a1
537: , p5_a2
538: , p5_a3
539: , p5_a4

Line 558: okl_gts_pvt.insert_row(p_api_version,

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

Line 573: okl_gts_pvt_w.rosetta_table_copy_out_p5(ddx_gtsv_tbl, p6_a0

569:
570:
571:
572:
573: okl_gts_pvt_w.rosetta_table_copy_out_p5(ddx_gtsv_tbl, p6_a0
574: , p6_a1
575: , p6_a2
576: , p6_a3
577: , p6_a4

Line 641: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;

637: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
638: )
639:
640: as
641: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;
642: ddx_gtsv_rec okl_gts_pvt.gtsv_rec_type;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:

Line 642: ddx_gtsv_rec okl_gts_pvt.gtsv_rec_type;

638: )
639:
640: as
641: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;
642: ddx_gtsv_rec okl_gts_pvt.gtsv_rec_type;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:
646: -- copy data to the local IN or IN-OUT args, if any

Line 674: okl_gts_pvt.update_row(p_api_version,

670: ddp_gtsv_rec.isg_arrears_pay_dates_option := p5_a18;
671:
672:
673: -- here's the delegated call to the old PL/SQL routine
674: okl_gts_pvt.update_row(p_api_version,
675: p_init_msg_list,
676: x_return_status,
677: x_msg_count,
678: x_msg_data,

Line 756: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;

752: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
753: )
754:
755: as
756: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
757: ddx_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
758: ddindx binary_integer; indx binary_integer;
759: begin
760:

Line 757: ddx_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;

753: )
754:
755: as
756: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
757: ddx_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
758: ddindx binary_integer; indx binary_integer;
759: begin
760:
761: -- copy data to the local IN or IN-OUT args, if any

Line 767: okl_gts_pvt_w.rosetta_table_copy_in_p5(ddp_gtsv_tbl, p5_a0

763:
764:
765:
766:
767: okl_gts_pvt_w.rosetta_table_copy_in_p5(ddp_gtsv_tbl, p5_a0
768: , p5_a1
769: , p5_a2
770: , p5_a3
771: , p5_a4

Line 790: okl_gts_pvt.update_row(p_api_version,

786: );
787:
788:
789: -- here's the delegated call to the old PL/SQL routine
790: okl_gts_pvt.update_row(p_api_version,
791: p_init_msg_list,
792: x_return_status,
793: x_msg_count,
794: x_msg_data,

Line 805: okl_gts_pvt_w.rosetta_table_copy_out_p5(ddx_gtsv_tbl, p6_a0

801:
802:
803:
804:
805: okl_gts_pvt_w.rosetta_table_copy_out_p5(ddx_gtsv_tbl, p6_a0
806: , p6_a1
807: , p6_a2
808: , p6_a3
809: , p6_a4

Line 854: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;

850: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
851: )
852:
853: as
854: ddp_gtsv_rec okl_gts_pvt.gtsv_rec_type;
855: ddindx binary_integer; indx binary_integer;
856: begin
857:
858: -- copy data to the local IN or IN-OUT args, if any

Line 885: okl_gts_pvt.delete_row(p_api_version,

881: ddp_gtsv_rec.days_in_yr_code := p5_a17;
882: ddp_gtsv_rec.isg_arrears_pay_dates_option := p5_a18;
883:
884: -- here's the delegated call to the old PL/SQL routine
885: okl_gts_pvt.delete_row(p_api_version,
886: p_init_msg_list,
887: x_return_status,
888: x_msg_count,
889: x_msg_data,

Line 927: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;

923: , p5_a18 JTF_VARCHAR2_TABLE_100
924: )
925:
926: as
927: ddp_gtsv_tbl okl_gts_pvt.gtsv_tbl_type;
928: ddindx binary_integer; indx binary_integer;
929: begin
930:
931: -- copy data to the local IN or IN-OUT args, if any

Line 937: okl_gts_pvt_w.rosetta_table_copy_in_p5(ddp_gtsv_tbl, p5_a0

933:
934:
935:
936:
937: okl_gts_pvt_w.rosetta_table_copy_in_p5(ddp_gtsv_tbl, p5_a0
938: , p5_a1
939: , p5_a2
940: , p5_a3
941: , p5_a4

Line 959: okl_gts_pvt.delete_row(p_api_version,

955: , p5_a18
956: );
957:
958: -- here's the delegated call to the old PL/SQL routine
959: okl_gts_pvt.delete_row(p_api_version,
960: p_init_msg_list,
961: x_return_status,
962: x_msg_count,
963: x_msg_data,

Line 974: end okl_gts_pvt_w;

970:
971:
972: end;
973:
974: end okl_gts_pvt_w;