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_DRS_PVT_W dependencies on OKL_DRS_PVT

Line 1: package body okl_drs_pvt_w as

1: package body okl_drs_pvt_w as
2: /* $Header: OKLIDRSB.pls 120.0 2007/04/27 09:18:00 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_drs_pvt.drs_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_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100

Line 92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p2;
92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 294: ddp_drs_rec okl_drs_pvt.drs_rec_type;

290: , p5_a24 NUMBER := 0-1962.0724
291: )
292:
293: as
294: ddp_drs_rec okl_drs_pvt.drs_rec_type;
295: ddx_drs_rec okl_drs_pvt.drs_rec_type;
296: ddindx binary_integer; indx binary_integer;
297: begin
298:

Line 295: ddx_drs_rec okl_drs_pvt.drs_rec_type;

291: )
292:
293: as
294: ddp_drs_rec okl_drs_pvt.drs_rec_type;
295: ddx_drs_rec okl_drs_pvt.drs_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 333: okl_drs_pvt.insert_row(p_api_version,

329: ddp_drs_rec.last_update_login := rosetta_g_miss_num_map(p5_a24);
330:
331:
332: -- here's the delegated call to the old PL/SQL routine
333: okl_drs_pvt.insert_row(p_api_version,
334: p_init_msg_list,
335: x_return_status,
336: x_msg_count,
337: x_msg_data,

Line 433: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;

429: , p6_a24 out nocopy JTF_NUMBER_TABLE
430: )
431:
432: as
433: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
434: ddx_drs_tbl okl_drs_pvt.drs_tbl_type;
435: ddindx binary_integer; indx binary_integer;
436: begin
437:

Line 434: ddx_drs_tbl okl_drs_pvt.drs_tbl_type;

430: )
431:
432: as
433: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
434: ddx_drs_tbl okl_drs_pvt.drs_tbl_type;
435: ddindx binary_integer; indx binary_integer;
436: begin
437:
438: -- copy data to the local IN or IN-OUT args, if any

Line 444: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0

440:
441:
442:
443:
444: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0
445: , p5_a1
446: , p5_a2
447: , p5_a3
448: , p5_a4

Line 473: okl_drs_pvt.insert_row(p_api_version,

469: );
470:
471:
472: -- here's the delegated call to the old PL/SQL routine
473: okl_drs_pvt.insert_row(p_api_version,
474: p_init_msg_list,
475: x_return_status,
476: x_msg_count,
477: x_msg_data,

Line 488: okl_drs_pvt_w.rosetta_table_copy_out_p2(ddx_drs_tbl, p6_a0

484:
485:
486:
487:
488: okl_drs_pvt_w.rosetta_table_copy_out_p2(ddx_drs_tbl, p6_a0
489: , p6_a1
490: , p6_a2
491: , p6_a3
492: , p6_a4

Line 549: ddp_drs_rec okl_drs_pvt.drs_rec_type;

545: , p5_a24 NUMBER := 0-1962.0724
546: )
547:
548: as
549: ddp_drs_rec okl_drs_pvt.drs_rec_type;
550: ddindx binary_integer; indx binary_integer;
551: begin
552:
553: -- copy data to the local IN or IN-OUT args, if any

Line 586: okl_drs_pvt.lock_row(p_api_version,

582: ddp_drs_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a23);
583: ddp_drs_rec.last_update_login := rosetta_g_miss_num_map(p5_a24);
584:
585: -- here's the delegated call to the old PL/SQL routine
586: okl_drs_pvt.lock_row(p_api_version,
587: p_init_msg_list,
588: x_return_status,
589: x_msg_count,
590: x_msg_data,

Line 634: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;

630: , p5_a24 JTF_NUMBER_TABLE
631: )
632:
633: as
634: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
635: ddindx binary_integer; indx binary_integer;
636: begin
637:
638: -- copy data to the local IN or IN-OUT args, if any

Line 644: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0

640:
641:
642:
643:
644: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0
645: , p5_a1
646: , p5_a2
647: , p5_a3
648: , p5_a4

Line 672: okl_drs_pvt.lock_row(p_api_version,

668: , p5_a24
669: );
670:
671: -- here's the delegated call to the old PL/SQL routine
672: okl_drs_pvt.lock_row(p_api_version,
673: p_init_msg_list,
674: x_return_status,
675: x_msg_count,
676: x_msg_data,

Line 745: ddp_drs_rec okl_drs_pvt.drs_rec_type;

741: , p5_a24 NUMBER := 0-1962.0724
742: )
743:
744: as
745: ddp_drs_rec okl_drs_pvt.drs_rec_type;
746: ddx_drs_rec okl_drs_pvt.drs_rec_type;
747: ddindx binary_integer; indx binary_integer;
748: begin
749:

Line 746: ddx_drs_rec okl_drs_pvt.drs_rec_type;

742: )
743:
744: as
745: ddp_drs_rec okl_drs_pvt.drs_rec_type;
746: ddx_drs_rec okl_drs_pvt.drs_rec_type;
747: ddindx binary_integer; indx binary_integer;
748: begin
749:
750: -- copy data to the local IN or IN-OUT args, if any

Line 784: okl_drs_pvt.update_row(p_api_version,

780: ddp_drs_rec.last_update_login := rosetta_g_miss_num_map(p5_a24);
781:
782:
783: -- here's the delegated call to the old PL/SQL routine
784: okl_drs_pvt.update_row(p_api_version,
785: p_init_msg_list,
786: x_return_status,
787: x_msg_count,
788: x_msg_data,

Line 884: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;

880: , p6_a24 out nocopy JTF_NUMBER_TABLE
881: )
882:
883: as
884: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
885: ddx_drs_tbl okl_drs_pvt.drs_tbl_type;
886: ddindx binary_integer; indx binary_integer;
887: begin
888:

Line 885: ddx_drs_tbl okl_drs_pvt.drs_tbl_type;

881: )
882:
883: as
884: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
885: ddx_drs_tbl okl_drs_pvt.drs_tbl_type;
886: ddindx binary_integer; indx binary_integer;
887: begin
888:
889: -- copy data to the local IN or IN-OUT args, if any

Line 895: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0

891:
892:
893:
894:
895: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0
896: , p5_a1
897: , p5_a2
898: , p5_a3
899: , p5_a4

Line 924: okl_drs_pvt.update_row(p_api_version,

920: );
921:
922:
923: -- here's the delegated call to the old PL/SQL routine
924: okl_drs_pvt.update_row(p_api_version,
925: p_init_msg_list,
926: x_return_status,
927: x_msg_count,
928: x_msg_data,

Line 939: okl_drs_pvt_w.rosetta_table_copy_out_p2(ddx_drs_tbl, p6_a0

935:
936:
937:
938:
939: okl_drs_pvt_w.rosetta_table_copy_out_p2(ddx_drs_tbl, p6_a0
940: , p6_a1
941: , p6_a2
942: , p6_a3
943: , p6_a4

Line 1000: ddp_drs_rec okl_drs_pvt.drs_rec_type;

996: , p5_a24 NUMBER := 0-1962.0724
997: )
998:
999: as
1000: ddp_drs_rec okl_drs_pvt.drs_rec_type;
1001: ddindx binary_integer; indx binary_integer;
1002: begin
1003:
1004: -- copy data to the local IN or IN-OUT args, if any

Line 1037: okl_drs_pvt.delete_row(p_api_version,

1033: ddp_drs_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a23);
1034: ddp_drs_rec.last_update_login := rosetta_g_miss_num_map(p5_a24);
1035:
1036: -- here's the delegated call to the old PL/SQL routine
1037: okl_drs_pvt.delete_row(p_api_version,
1038: p_init_msg_list,
1039: x_return_status,
1040: x_msg_count,
1041: x_msg_data,

Line 1085: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;

1081: , p5_a24 JTF_NUMBER_TABLE
1082: )
1083:
1084: as
1085: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
1086: ddindx binary_integer; indx binary_integer;
1087: begin
1088:
1089: -- copy data to the local IN or IN-OUT args, if any

Line 1095: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0

1091:
1092:
1093:
1094:
1095: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0
1096: , p5_a1
1097: , p5_a2
1098: , p5_a3
1099: , p5_a4

Line 1123: okl_drs_pvt.delete_row(p_api_version,

1119: , p5_a24
1120: );
1121:
1122: -- here's the delegated call to the old PL/SQL routine
1123: okl_drs_pvt.delete_row(p_api_version,
1124: p_init_msg_list,
1125: x_return_status,
1126: x_msg_count,
1127: x_msg_data,

Line 1171: ddp_drs_rec okl_drs_pvt.drs_rec_type;

1167: , p5_a24 NUMBER := 0-1962.0724
1168: )
1169:
1170: as
1171: ddp_drs_rec okl_drs_pvt.drs_rec_type;
1172: ddindx binary_integer; indx binary_integer;
1173: begin
1174:
1175: -- copy data to the local IN or IN-OUT args, if any

Line 1208: okl_drs_pvt.validate_row(p_api_version,

1204: ddp_drs_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a23);
1205: ddp_drs_rec.last_update_login := rosetta_g_miss_num_map(p5_a24);
1206:
1207: -- here's the delegated call to the old PL/SQL routine
1208: okl_drs_pvt.validate_row(p_api_version,
1209: p_init_msg_list,
1210: x_return_status,
1211: x_msg_count,
1212: x_msg_data,

Line 1256: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;

1252: , p5_a24 JTF_NUMBER_TABLE
1253: )
1254:
1255: as
1256: ddp_drs_tbl okl_drs_pvt.drs_tbl_type;
1257: ddindx binary_integer; indx binary_integer;
1258: begin
1259:
1260: -- copy data to the local IN or IN-OUT args, if any

Line 1266: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0

1262:
1263:
1264:
1265:
1266: okl_drs_pvt_w.rosetta_table_copy_in_p2(ddp_drs_tbl, p5_a0
1267: , p5_a1
1268: , p5_a2
1269: , p5_a3
1270: , p5_a4

Line 1294: okl_drs_pvt.validate_row(p_api_version,

1290: , p5_a24
1291: );
1292:
1293: -- here's the delegated call to the old PL/SQL routine
1294: okl_drs_pvt.validate_row(p_api_version,
1295: p_init_msg_list,
1296: x_return_status,
1297: x_msg_count,
1298: x_msg_data,

Line 1309: end okl_drs_pvt_w;

1305:
1306:
1307: end;
1308:
1309: end okl_drs_pvt_w;