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_SST_PVT_W dependencies on OKL_SST_PVT

Line 1: package body okl_sst_pvt_w as

1: package body okl_sst_pvt_w as
2: /* $Header: OKLISSTB.pls 120.1 2005/08/11 11:05:30 dkagrawa 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_sst_pvt.sst_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_sst_pvt.sst_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 91: procedure rosetta_table_copy_out_p2(t okl_sst_pvt.sst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 240: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE

236: end if;
237: end if;
238: end rosetta_table_copy_out_p2;
239:
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_sst_pvt.sstv_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_NUMBER_TABLE
242: , a2 JTF_NUMBER_TABLE
243: , a3 JTF_NUMBER_TABLE
244: , a4 JTF_VARCHAR2_TABLE_100

Line 309: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

305: end loop;
306: end if;
307: end if;
308: end rosetta_table_copy_in_p5;
309: procedure rosetta_table_copy_out_p5(t okl_sst_pvt.sstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
310: , a1 out nocopy JTF_NUMBER_TABLE
311: , a2 out nocopy JTF_NUMBER_TABLE
312: , a3 out nocopy JTF_NUMBER_TABLE
313: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 518: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;

514: , p5_a25 NUMBER := 0-1962.0724
515: )
516:
517: as
518: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;
519: ddx_sstv_rec okl_sst_pvt.sstv_rec_type;
520: ddindx binary_integer; indx binary_integer;
521: begin
522:

Line 519: ddx_sstv_rec okl_sst_pvt.sstv_rec_type;

515: )
516:
517: as
518: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;
519: ddx_sstv_rec okl_sst_pvt.sstv_rec_type;
520: ddindx binary_integer; indx binary_integer;
521: begin
522:
523: -- copy data to the local IN or IN-OUT args, if any

Line 558: okl_sst_pvt.insert_row(p_api_version,

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

Line 661: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;

657: , p6_a25 out nocopy JTF_NUMBER_TABLE
658: )
659:
660: as
661: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;
662: ddx_sstv_tbl okl_sst_pvt.sstv_tbl_type;
663: ddindx binary_integer; indx binary_integer;
664: begin
665:

Line 662: ddx_sstv_tbl okl_sst_pvt.sstv_tbl_type;

658: )
659:
660: as
661: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;
662: ddx_sstv_tbl okl_sst_pvt.sstv_tbl_type;
663: ddindx binary_integer; indx binary_integer;
664: begin
665:
666: -- copy data to the local IN or IN-OUT args, if any

Line 672: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0

668:
669:
670:
671:
672: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0
673: , p5_a1
674: , p5_a2
675: , p5_a3
676: , p5_a4

Line 702: okl_sst_pvt.insert_row(p_api_version,

698: );
699:
700:
701: -- here's the delegated call to the old PL/SQL routine
702: okl_sst_pvt.insert_row(p_api_version,
703: p_init_msg_list,
704: x_return_status,
705: x_msg_count,
706: x_msg_data,

Line 717: okl_sst_pvt_w.rosetta_table_copy_out_p5(ddx_sstv_tbl, p6_a0

713:
714:
715:
716:
717: okl_sst_pvt_w.rosetta_table_copy_out_p5(ddx_sstv_tbl, p6_a0
718: , p6_a1
719: , p6_a2
720: , p6_a3
721: , p6_a4

Line 780: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;

776: , p5_a25 NUMBER := 0-1962.0724
777: )
778:
779: as
780: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;
781: ddindx binary_integer; indx binary_integer;
782: begin
783:
784: -- copy data to the local IN or IN-OUT args, if any

Line 818: okl_sst_pvt.lock_row(p_api_version,

814: ddp_sstv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a24);
815: ddp_sstv_rec.last_update_login := rosetta_g_miss_num_map(p5_a25);
816:
817: -- here's the delegated call to the old PL/SQL routine
818: okl_sst_pvt.lock_row(p_api_version,
819: p_init_msg_list,
820: x_return_status,
821: x_msg_count,
822: x_msg_data,

Line 867: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;

863: , p5_a25 JTF_NUMBER_TABLE
864: )
865:
866: as
867: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;
868: ddindx binary_integer; indx binary_integer;
869: begin
870:
871: -- copy data to the local IN or IN-OUT args, if any

Line 877: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0

873:
874:
875:
876:
877: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0
878: , p5_a1
879: , p5_a2
880: , p5_a3
881: , p5_a4

Line 906: okl_sst_pvt.lock_row(p_api_version,

902: , p5_a25
903: );
904:
905: -- here's the delegated call to the old PL/SQL routine
906: okl_sst_pvt.lock_row(p_api_version,
907: p_init_msg_list,
908: x_return_status,
909: x_msg_count,
910: x_msg_data,

Line 981: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;

977: , p5_a25 NUMBER := 0-1962.0724
978: )
979:
980: as
981: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;
982: ddx_sstv_rec okl_sst_pvt.sstv_rec_type;
983: ddindx binary_integer; indx binary_integer;
984: begin
985:

Line 982: ddx_sstv_rec okl_sst_pvt.sstv_rec_type;

978: )
979:
980: as
981: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;
982: ddx_sstv_rec okl_sst_pvt.sstv_rec_type;
983: ddindx binary_integer; indx binary_integer;
984: begin
985:
986: -- copy data to the local IN or IN-OUT args, if any

Line 1021: okl_sst_pvt.update_row(p_api_version,

1017: ddp_sstv_rec.last_update_login := rosetta_g_miss_num_map(p5_a25);
1018:
1019:
1020: -- here's the delegated call to the old PL/SQL routine
1021: okl_sst_pvt.update_row(p_api_version,
1022: p_init_msg_list,
1023: x_return_status,
1024: x_msg_count,
1025: x_msg_data,

Line 1124: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;

1120: , p6_a25 out nocopy JTF_NUMBER_TABLE
1121: )
1122:
1123: as
1124: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;
1125: ddx_sstv_tbl okl_sst_pvt.sstv_tbl_type;
1126: ddindx binary_integer; indx binary_integer;
1127: begin
1128:

Line 1125: ddx_sstv_tbl okl_sst_pvt.sstv_tbl_type;

1121: )
1122:
1123: as
1124: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;
1125: ddx_sstv_tbl okl_sst_pvt.sstv_tbl_type;
1126: ddindx binary_integer; indx binary_integer;
1127: begin
1128:
1129: -- copy data to the local IN or IN-OUT args, if any

Line 1135: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0

1131:
1132:
1133:
1134:
1135: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0
1136: , p5_a1
1137: , p5_a2
1138: , p5_a3
1139: , p5_a4

Line 1165: okl_sst_pvt.update_row(p_api_version,

1161: );
1162:
1163:
1164: -- here's the delegated call to the old PL/SQL routine
1165: okl_sst_pvt.update_row(p_api_version,
1166: p_init_msg_list,
1167: x_return_status,
1168: x_msg_count,
1169: x_msg_data,

Line 1180: okl_sst_pvt_w.rosetta_table_copy_out_p5(ddx_sstv_tbl, p6_a0

1176:
1177:
1178:
1179:
1180: okl_sst_pvt_w.rosetta_table_copy_out_p5(ddx_sstv_tbl, p6_a0
1181: , p6_a1
1182: , p6_a2
1183: , p6_a3
1184: , p6_a4

Line 1243: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;

1239: , p5_a25 NUMBER := 0-1962.0724
1240: )
1241:
1242: as
1243: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;
1244: ddindx binary_integer; indx binary_integer;
1245: begin
1246:
1247: -- copy data to the local IN or IN-OUT args, if any

Line 1281: okl_sst_pvt.delete_row(p_api_version,

1277: ddp_sstv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a24);
1278: ddp_sstv_rec.last_update_login := rosetta_g_miss_num_map(p5_a25);
1279:
1280: -- here's the delegated call to the old PL/SQL routine
1281: okl_sst_pvt.delete_row(p_api_version,
1282: p_init_msg_list,
1283: x_return_status,
1284: x_msg_count,
1285: x_msg_data,

Line 1330: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;

1326: , p5_a25 JTF_NUMBER_TABLE
1327: )
1328:
1329: as
1330: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;
1331: ddindx binary_integer; indx binary_integer;
1332: begin
1333:
1334: -- copy data to the local IN or IN-OUT args, if any

Line 1340: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0

1336:
1337:
1338:
1339:
1340: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0
1341: , p5_a1
1342: , p5_a2
1343: , p5_a3
1344: , p5_a4

Line 1369: okl_sst_pvt.delete_row(p_api_version,

1365: , p5_a25
1366: );
1367:
1368: -- here's the delegated call to the old PL/SQL routine
1369: okl_sst_pvt.delete_row(p_api_version,
1370: p_init_msg_list,
1371: x_return_status,
1372: x_msg_count,
1373: x_msg_data,

Line 1418: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;

1414: , p5_a25 NUMBER := 0-1962.0724
1415: )
1416:
1417: as
1418: ddp_sstv_rec okl_sst_pvt.sstv_rec_type;
1419: ddindx binary_integer; indx binary_integer;
1420: begin
1421:
1422: -- copy data to the local IN or IN-OUT args, if any

Line 1456: okl_sst_pvt.validate_row(p_api_version,

1452: ddp_sstv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a24);
1453: ddp_sstv_rec.last_update_login := rosetta_g_miss_num_map(p5_a25);
1454:
1455: -- here's the delegated call to the old PL/SQL routine
1456: okl_sst_pvt.validate_row(p_api_version,
1457: p_init_msg_list,
1458: x_return_status,
1459: x_msg_count,
1460: x_msg_data,

Line 1505: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;

1501: , p5_a25 JTF_NUMBER_TABLE
1502: )
1503:
1504: as
1505: ddp_sstv_tbl okl_sst_pvt.sstv_tbl_type;
1506: ddindx binary_integer; indx binary_integer;
1507: begin
1508:
1509: -- copy data to the local IN or IN-OUT args, if any

Line 1515: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0

1511:
1512:
1513:
1514:
1515: okl_sst_pvt_w.rosetta_table_copy_in_p5(ddp_sstv_tbl, p5_a0
1516: , p5_a1
1517: , p5_a2
1518: , p5_a3
1519: , p5_a4

Line 1544: okl_sst_pvt.validate_row(p_api_version,

1540: , p5_a25
1541: );
1542:
1543: -- here's the delegated call to the old PL/SQL routine
1544: okl_sst_pvt.validate_row(p_api_version,
1545: p_init_msg_list,
1546: x_return_status,
1547: x_msg_count,
1548: x_msg_data,

Line 1559: end okl_sst_pvt_w;

1555:
1556:
1557: end;
1558:
1559: end okl_sst_pvt_w;