DBA Data[Home] [Help]

APPS.OKL_DRV_PVT_W dependencies on OKL_DRV_PVT

Line 1: package body okl_drv_pvt_w as

1: package body okl_drv_pvt_w as
2: /* $Header: OKLIDRVB.pls 120.0 2007/04/27 09:18:48 gkhuntet 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: 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_drv_pvt.drv_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_drv_pvt.drv_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE

Line 104: procedure rosetta_table_copy_out_p2(t okl_drv_pvt.drv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

100: end loop;
101: end if;
102: end if;
103: end rosetta_table_copy_in_p2;
104: procedure rosetta_table_copy_out_p2(t okl_drv_pvt.drv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
105: , a1 out nocopy JTF_NUMBER_TABLE
106: , a2 out nocopy JTF_NUMBER_TABLE
107: , a3 out nocopy JTF_NUMBER_TABLE
108: , a4 out nocopy JTF_NUMBER_TABLE

Line 348: ddp_drv_rec okl_drv_pvt.drv_rec_type;

344: , p5_a30 NUMBER := 0-1962.0724
345: )
346:
347: as
348: ddp_drv_rec okl_drv_pvt.drv_rec_type;
349: ddx_drv_rec okl_drv_pvt.drv_rec_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:

Line 349: ddx_drv_rec okl_drv_pvt.drv_rec_type;

345: )
346:
347: as
348: ddp_drv_rec okl_drv_pvt.drv_rec_type;
349: ddx_drv_rec okl_drv_pvt.drv_rec_type;
350: ddindx binary_integer; indx binary_integer;
351: begin
352:
353: -- copy data to the local IN or IN-OUT args, if any

Line 393: okl_drv_pvt.insert_row(p_api_version,

389: ddp_drv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
390:
391:
392: -- here's the delegated call to the old PL/SQL routine
393: okl_drv_pvt.insert_row(p_api_version,
394: p_init_msg_list,
395: x_return_status,
396: x_msg_count,
397: x_msg_data,

Line 511: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;

507: , p6_a30 out nocopy JTF_NUMBER_TABLE
508: )
509:
510: as
511: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;
512: ddx_drv_tbl okl_drv_pvt.drv_tbl_type;
513: ddindx binary_integer; indx binary_integer;
514: begin
515:

Line 512: ddx_drv_tbl okl_drv_pvt.drv_tbl_type;

508: )
509:
510: as
511: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;
512: ddx_drv_tbl okl_drv_pvt.drv_tbl_type;
513: ddindx binary_integer; indx binary_integer;
514: begin
515:
516: -- copy data to the local IN or IN-OUT args, if any

Line 522: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0

518:
519:
520:
521:
522: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0
523: , p5_a1
524: , p5_a2
525: , p5_a3
526: , p5_a4

Line 557: okl_drv_pvt.insert_row(p_api_version,

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

Line 572: okl_drv_pvt_w.rosetta_table_copy_out_p2(ddx_drv_tbl, p6_a0

568:
569:
570:
571:
572: okl_drv_pvt_w.rosetta_table_copy_out_p2(ddx_drv_tbl, p6_a0
573: , p6_a1
574: , p6_a2
575: , p6_a3
576: , p6_a4

Line 645: ddp_drv_rec okl_drv_pvt.drv_rec_type;

641: , p5_a30 NUMBER := 0-1962.0724
642: )
643:
644: as
645: ddp_drv_rec okl_drv_pvt.drv_rec_type;
646: ddindx binary_integer; indx binary_integer;
647: begin
648:
649: -- copy data to the local IN or IN-OUT args, if any

Line 688: okl_drv_pvt.lock_row(p_api_version,

684: ddp_drv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
685: ddp_drv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
686:
687: -- here's the delegated call to the old PL/SQL routine
688: okl_drv_pvt.lock_row(p_api_version,
689: p_init_msg_list,
690: x_return_status,
691: x_msg_count,
692: x_msg_data,

Line 742: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;

738: , p5_a30 JTF_NUMBER_TABLE
739: )
740:
741: as
742: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;
743: ddindx binary_integer; indx binary_integer;
744: begin
745:
746: -- copy data to the local IN or IN-OUT args, if any

Line 752: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0

748:
749:
750:
751:
752: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0
753: , p5_a1
754: , p5_a2
755: , p5_a3
756: , p5_a4

Line 786: okl_drv_pvt.lock_row(p_api_version,

782: , p5_a30
783: );
784:
785: -- here's the delegated call to the old PL/SQL routine
786: okl_drv_pvt.lock_row(p_api_version,
787: p_init_msg_list,
788: x_return_status,
789: x_msg_count,
790: x_msg_data,

Line 871: ddp_drv_rec okl_drv_pvt.drv_rec_type;

867: , p5_a30 NUMBER := 0-1962.0724
868: )
869:
870: as
871: ddp_drv_rec okl_drv_pvt.drv_rec_type;
872: ddx_drv_rec okl_drv_pvt.drv_rec_type;
873: ddindx binary_integer; indx binary_integer;
874: begin
875:

Line 872: ddx_drv_rec okl_drv_pvt.drv_rec_type;

868: )
869:
870: as
871: ddp_drv_rec okl_drv_pvt.drv_rec_type;
872: ddx_drv_rec okl_drv_pvt.drv_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 916: okl_drv_pvt.update_row(p_api_version,

912: ddp_drv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
913:
914:
915: -- here's the delegated call to the old PL/SQL routine
916: okl_drv_pvt.update_row(p_api_version,
917: p_init_msg_list,
918: x_return_status,
919: x_msg_count,
920: x_msg_data,

Line 1034: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;

1030: , p6_a30 out nocopy JTF_NUMBER_TABLE
1031: )
1032:
1033: as
1034: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;
1035: ddx_drv_tbl okl_drv_pvt.drv_tbl_type;
1036: ddindx binary_integer; indx binary_integer;
1037: begin
1038:

Line 1035: ddx_drv_tbl okl_drv_pvt.drv_tbl_type;

1031: )
1032:
1033: as
1034: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;
1035: ddx_drv_tbl okl_drv_pvt.drv_tbl_type;
1036: ddindx binary_integer; indx binary_integer;
1037: begin
1038:
1039: -- copy data to the local IN or IN-OUT args, if any

Line 1045: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0

1041:
1042:
1043:
1044:
1045: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0
1046: , p5_a1
1047: , p5_a2
1048: , p5_a3
1049: , p5_a4

Line 1080: okl_drv_pvt.update_row(p_api_version,

1076: );
1077:
1078:
1079: -- here's the delegated call to the old PL/SQL routine
1080: okl_drv_pvt.update_row(p_api_version,
1081: p_init_msg_list,
1082: x_return_status,
1083: x_msg_count,
1084: x_msg_data,

Line 1095: okl_drv_pvt_w.rosetta_table_copy_out_p2(ddx_drv_tbl, p6_a0

1091:
1092:
1093:
1094:
1095: okl_drv_pvt_w.rosetta_table_copy_out_p2(ddx_drv_tbl, p6_a0
1096: , p6_a1
1097: , p6_a2
1098: , p6_a3
1099: , p6_a4

Line 1168: ddp_drv_rec okl_drv_pvt.drv_rec_type;

1164: , p5_a30 NUMBER := 0-1962.0724
1165: )
1166:
1167: as
1168: ddp_drv_rec okl_drv_pvt.drv_rec_type;
1169: ddindx binary_integer; indx binary_integer;
1170: begin
1171:
1172: -- copy data to the local IN or IN-OUT args, if any

Line 1211: okl_drv_pvt.delete_row(p_api_version,

1207: ddp_drv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1208: ddp_drv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1209:
1210: -- here's the delegated call to the old PL/SQL routine
1211: okl_drv_pvt.delete_row(p_api_version,
1212: p_init_msg_list,
1213: x_return_status,
1214: x_msg_count,
1215: x_msg_data,

Line 1265: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;

1261: , p5_a30 JTF_NUMBER_TABLE
1262: )
1263:
1264: as
1265: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;
1266: ddindx binary_integer; indx binary_integer;
1267: begin
1268:
1269: -- copy data to the local IN or IN-OUT args, if any

Line 1275: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0

1271:
1272:
1273:
1274:
1275: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0
1276: , p5_a1
1277: , p5_a2
1278: , p5_a3
1279: , p5_a4

Line 1309: okl_drv_pvt.delete_row(p_api_version,

1305: , p5_a30
1306: );
1307:
1308: -- here's the delegated call to the old PL/SQL routine
1309: okl_drv_pvt.delete_row(p_api_version,
1310: p_init_msg_list,
1311: x_return_status,
1312: x_msg_count,
1313: x_msg_data,

Line 1363: ddp_drv_rec okl_drv_pvt.drv_rec_type;

1359: , p5_a30 NUMBER := 0-1962.0724
1360: )
1361:
1362: as
1363: ddp_drv_rec okl_drv_pvt.drv_rec_type;
1364: ddindx binary_integer; indx binary_integer;
1365: begin
1366:
1367: -- copy data to the local IN or IN-OUT args, if any

Line 1406: okl_drv_pvt.validate_row(p_api_version,

1402: ddp_drv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1403: ddp_drv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1404:
1405: -- here's the delegated call to the old PL/SQL routine
1406: okl_drv_pvt.validate_row(p_api_version,
1407: p_init_msg_list,
1408: x_return_status,
1409: x_msg_count,
1410: x_msg_data,

Line 1460: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;

1456: , p5_a30 JTF_NUMBER_TABLE
1457: )
1458:
1459: as
1460: ddp_drv_tbl okl_drv_pvt.drv_tbl_type;
1461: ddindx binary_integer; indx binary_integer;
1462: begin
1463:
1464: -- copy data to the local IN or IN-OUT args, if any

Line 1470: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0

1466:
1467:
1468:
1469:
1470: okl_drv_pvt_w.rosetta_table_copy_in_p2(ddp_drv_tbl, p5_a0
1471: , p5_a1
1472: , p5_a2
1473: , p5_a3
1474: , p5_a4

Line 1504: okl_drv_pvt.validate_row(p_api_version,

1500: , p5_a30
1501: );
1502:
1503: -- here's the delegated call to the old PL/SQL routine
1504: okl_drv_pvt.validate_row(p_api_version,
1505: p_init_msg_list,
1506: x_return_status,
1507: x_msg_count,
1508: x_msg_data,

Line 1519: end okl_drv_pvt_w;

1515:
1516:
1517: end;
1518:
1519: end okl_drv_pvt_w;