DBA Data[Home] [Help]

APPS.OKL_GTT_PVT_W dependencies on OKL_GTT_PVT

Line 1: package body okl_gtt_pvt_w as

1: package body okl_gtt_pvt_w as
2: /* $Header: OKLIGTTB.pls 120.1 2005/10/30 04:00:52 appldev 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_gtt_pvt.gtt_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_gtt_pvt.gtt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE

Line 97: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_gtt_pvt.gtt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , a4 out nocopy JTF_DATE_TABLE

Line 261: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE

257: end if;
258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_gtt_pvt.gttv_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_VARCHAR2_TABLE_100
265: , a4 JTF_DATE_TABLE

Line 336: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

332: end loop;
333: end if;
334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_gtt_pvt.gttv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_NUMBER_TABLE
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_VARCHAR2_TABLE_100
340: , a4 out nocopy JTF_DATE_TABLE

Line 566: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;

562: , p5_a28 NUMBER := 0-1962.0724
563: )
564:
565: as
566: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;
567: ddx_gttv_rec okl_gtt_pvt.gttv_rec_type;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:

Line 567: ddx_gttv_rec okl_gtt_pvt.gttv_rec_type;

563: )
564:
565: as
566: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;
567: ddx_gttv_rec okl_gtt_pvt.gttv_rec_type;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any

Line 609: okl_gtt_pvt.insert_row(p_api_version,

605: ddp_gttv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
606:
607:
608: -- here's the delegated call to the old PL/SQL routine
609: okl_gtt_pvt.insert_row(p_api_version,
610: p_init_msg_list,
611: x_return_status,
612: x_msg_count,
613: x_msg_data,

Line 721: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;

717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )
719:
720: as
721: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
722: ddx_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
723: ddindx binary_integer; indx binary_integer;
724: begin
725:

Line 722: ddx_gttv_tbl okl_gtt_pvt.gttv_tbl_type;

718: )
719:
720: as
721: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
722: ddx_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
723: ddindx binary_integer; indx binary_integer;
724: begin
725:
726: -- copy data to the local IN or IN-OUT args, if any

Line 732: okl_gtt_pvt_w.rosetta_table_copy_in_p5(ddp_gttv_tbl, p5_a0

728:
729:
730:
731:
732: okl_gtt_pvt_w.rosetta_table_copy_in_p5(ddp_gttv_tbl, p5_a0
733: , p5_a1
734: , p5_a2
735: , p5_a3
736: , p5_a4

Line 765: okl_gtt_pvt.insert_row(p_api_version,

761: );
762:
763:
764: -- here's the delegated call to the old PL/SQL routine
765: okl_gtt_pvt.insert_row(p_api_version,
766: p_init_msg_list,
767: x_return_status,
768: x_msg_count,
769: x_msg_data,

Line 780: okl_gtt_pvt_w.rosetta_table_copy_out_p5(ddx_gttv_tbl, p6_a0

776:
777:
778:
779:
780: okl_gtt_pvt_w.rosetta_table_copy_out_p5(ddx_gttv_tbl, p6_a0
781: , p6_a1
782: , p6_a2
783: , p6_a3
784: , p6_a4

Line 878: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;

874: , p5_a28 NUMBER := 0-1962.0724
875: )
876:
877: as
878: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;
879: ddx_gttv_rec okl_gtt_pvt.gttv_rec_type;
880: ddindx binary_integer; indx binary_integer;
881: begin
882:

Line 879: ddx_gttv_rec okl_gtt_pvt.gttv_rec_type;

875: )
876:
877: as
878: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;
879: ddx_gttv_rec okl_gtt_pvt.gttv_rec_type;
880: ddindx binary_integer; indx binary_integer;
881: begin
882:
883: -- copy data to the local IN or IN-OUT args, if any

Line 921: okl_gtt_pvt.update_row(p_api_version,

917: ddp_gttv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
918:
919:
920: -- here's the delegated call to the old PL/SQL routine
921: okl_gtt_pvt.update_row(p_api_version,
922: p_init_msg_list,
923: x_return_status,
924: x_msg_count,
925: x_msg_data,

Line 1033: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;

1029: , p6_a28 out nocopy JTF_NUMBER_TABLE
1030: )
1031:
1032: as
1033: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
1034: ddx_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
1035: ddindx binary_integer; indx binary_integer;
1036: begin
1037:

Line 1034: ddx_gttv_tbl okl_gtt_pvt.gttv_tbl_type;

1030: )
1031:
1032: as
1033: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
1034: ddx_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
1035: ddindx binary_integer; indx binary_integer;
1036: begin
1037:
1038: -- copy data to the local IN or IN-OUT args, if any

Line 1044: okl_gtt_pvt_w.rosetta_table_copy_in_p5(ddp_gttv_tbl, p5_a0

1040:
1041:
1042:
1043:
1044: okl_gtt_pvt_w.rosetta_table_copy_in_p5(ddp_gttv_tbl, p5_a0
1045: , p5_a1
1046: , p5_a2
1047: , p5_a3
1048: , p5_a4

Line 1077: okl_gtt_pvt.update_row(p_api_version,

1073: );
1074:
1075:
1076: -- here's the delegated call to the old PL/SQL routine
1077: okl_gtt_pvt.update_row(p_api_version,
1078: p_init_msg_list,
1079: x_return_status,
1080: x_msg_count,
1081: x_msg_data,

Line 1092: okl_gtt_pvt_w.rosetta_table_copy_out_p5(ddx_gttv_tbl, p6_a0

1088:
1089:
1090:
1091:
1092: okl_gtt_pvt_w.rosetta_table_copy_out_p5(ddx_gttv_tbl, p6_a0
1093: , p6_a1
1094: , p6_a2
1095: , p6_a3
1096: , p6_a4

Line 1161: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;

1157: , p5_a28 NUMBER := 0-1962.0724
1158: )
1159:
1160: as
1161: ddp_gttv_rec okl_gtt_pvt.gttv_rec_type;
1162: ddindx binary_integer; indx binary_integer;
1163: begin
1164:
1165: -- copy data to the local IN or IN-OUT args, if any

Line 1202: okl_gtt_pvt.delete_row(p_api_version,

1198: ddp_gttv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a27);
1199: ddp_gttv_rec.last_update_login := rosetta_g_miss_num_map(p5_a28);
1200:
1201: -- here's the delegated call to the old PL/SQL routine
1202: okl_gtt_pvt.delete_row(p_api_version,
1203: p_init_msg_list,
1204: x_return_status,
1205: x_msg_count,
1206: x_msg_data,

Line 1254: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;

1250: , p5_a28 JTF_NUMBER_TABLE
1251: )
1252:
1253: as
1254: ddp_gttv_tbl okl_gtt_pvt.gttv_tbl_type;
1255: ddindx binary_integer; indx binary_integer;
1256: begin
1257:
1258: -- copy data to the local IN or IN-OUT args, if any

Line 1264: okl_gtt_pvt_w.rosetta_table_copy_in_p5(ddp_gttv_tbl, p5_a0

1260:
1261:
1262:
1263:
1264: okl_gtt_pvt_w.rosetta_table_copy_in_p5(ddp_gttv_tbl, p5_a0
1265: , p5_a1
1266: , p5_a2
1267: , p5_a3
1268: , p5_a4

Line 1296: okl_gtt_pvt.delete_row(p_api_version,

1292: , p5_a28
1293: );
1294:
1295: -- here's the delegated call to the old PL/SQL routine
1296: okl_gtt_pvt.delete_row(p_api_version,
1297: p_init_msg_list,
1298: x_return_status,
1299: x_msg_count,
1300: x_msg_data,

Line 1311: end okl_gtt_pvt_w;

1307:
1308:
1309: end;
1310:
1311: end okl_gtt_pvt_w;