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_SGT_PVT_W dependencies on OKL_SGT_PVT

Line 1: package body okl_sgt_pvt_w as

1: package body okl_sgt_pvt_w as
2: /* $Header: OKLISGTB.pls 120.1 2005/07/14 11:59:35 asawanka 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_sgt_pvt.sgnv_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_sgt_pvt.sgnv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_400
26: , a4 JTF_VARCHAR2_TABLE_100

Line 101: procedure rosetta_table_copy_out_p2(t okl_sgt_pvt.sgnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_sgt_pvt.sgnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_400
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sgt_pvt.sgt_tbl_type, a0 JTF_NUMBER_TABLE

271: end if;
272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_sgt_pvt.sgt_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_VARCHAR2_TABLE_100
277: , a2 JTF_VARCHAR2_TABLE_100
278: , a3 JTF_VARCHAR2_TABLE_400
279: , a4 JTF_VARCHAR2_TABLE_100

Line 354: procedure rosetta_table_copy_out_p5(t okl_sgt_pvt.sgt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

350: end loop;
351: end if;
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_sgt_pvt.sgt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_VARCHAR2_TABLE_100
356: , a2 out nocopy JTF_VARCHAR2_TABLE_100
357: , a3 out nocopy JTF_VARCHAR2_TABLE_400
358: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 598: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;

594: , p5_a30 NUMBER := 0-1962.0724
595: )
596:
597: as
598: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
599: ddx_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
600: ddindx binary_integer; indx binary_integer;
601: begin
602:

Line 599: ddx_sgnv_rec okl_sgt_pvt.sgnv_rec_type;

595: )
596:
597: as
598: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
599: ddx_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
600: ddindx binary_integer; indx binary_integer;
601: begin
602:
603: -- copy data to the local IN or IN-OUT args, if any

Line 643: okl_sgt_pvt.insert_row(p_api_version,

639: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
640:
641:
642: -- here's the delegated call to the old PL/SQL routine
643: okl_sgt_pvt.insert_row(p_api_version,
644: p_init_msg_list,
645: x_return_status,
646: x_msg_count,
647: x_msg_data,

Line 761: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;

757: , p6_a30 out nocopy JTF_NUMBER_TABLE
758: )
759:
760: as
761: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
762: ddx_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
763: ddindx binary_integer; indx binary_integer;
764: begin
765:

Line 762: ddx_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;

758: )
759:
760: as
761: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
762: ddx_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
763: ddindx binary_integer; indx binary_integer;
764: begin
765:
766: -- copy data to the local IN or IN-OUT args, if any

Line 772: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0

768:
769:
770:
771:
772: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0
773: , p5_a1
774: , p5_a2
775: , p5_a3
776: , p5_a4

Line 807: okl_sgt_pvt.insert_row(p_api_version,

803: );
804:
805:
806: -- here's the delegated call to the old PL/SQL routine
807: okl_sgt_pvt.insert_row(p_api_version,
808: p_init_msg_list,
809: x_return_status,
810: x_msg_count,
811: x_msg_data,

Line 822: okl_sgt_pvt_w.rosetta_table_copy_out_p2(ddx_sgnv_tbl, p6_a0

818:
819:
820:
821:
822: okl_sgt_pvt_w.rosetta_table_copy_out_p2(ddx_sgnv_tbl, p6_a0
823: , p6_a1
824: , p6_a2
825: , p6_a3
826: , p6_a4

Line 895: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;

891: , p5_a30 NUMBER := 0-1962.0724
892: )
893:
894: as
895: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
896: ddindx binary_integer; indx binary_integer;
897: begin
898:
899: -- copy data to the local IN or IN-OUT args, if any

Line 938: okl_sgt_pvt.lock_row(p_api_version,

934: ddp_sgnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
935: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
936:
937: -- here's the delegated call to the old PL/SQL routine
938: okl_sgt_pvt.lock_row(p_api_version,
939: p_init_msg_list,
940: x_return_status,
941: x_msg_count,
942: x_msg_data,

Line 992: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;

988: , p5_a30 JTF_NUMBER_TABLE
989: )
990:
991: as
992: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
993: ddindx binary_integer; indx binary_integer;
994: begin
995:
996: -- copy data to the local IN or IN-OUT args, if any

Line 1002: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0

998:
999:
1000:
1001:
1002: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0
1003: , p5_a1
1004: , p5_a2
1005: , p5_a3
1006: , p5_a4

Line 1036: okl_sgt_pvt.lock_row(p_api_version,

1032: , p5_a30
1033: );
1034:
1035: -- here's the delegated call to the old PL/SQL routine
1036: okl_sgt_pvt.lock_row(p_api_version,
1037: p_init_msg_list,
1038: x_return_status,
1039: x_msg_count,
1040: x_msg_data,

Line 1121: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;

1117: , p5_a30 NUMBER := 0-1962.0724
1118: )
1119:
1120: as
1121: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
1122: ddx_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125:

Line 1122: ddx_sgnv_rec okl_sgt_pvt.sgnv_rec_type;

1118: )
1119:
1120: as
1121: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
1122: ddx_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125:
1126: -- copy data to the local IN or IN-OUT args, if any

Line 1166: okl_sgt_pvt.update_row(p_api_version,

1162: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1163:
1164:
1165: -- here's the delegated call to the old PL/SQL routine
1166: okl_sgt_pvt.update_row(p_api_version,
1167: p_init_msg_list,
1168: x_return_status,
1169: x_msg_count,
1170: x_msg_data,

Line 1284: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;

1280: , p6_a30 out nocopy JTF_NUMBER_TABLE
1281: )
1282:
1283: as
1284: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
1285: ddx_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
1286: ddindx binary_integer; indx binary_integer;
1287: begin
1288:

Line 1285: ddx_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;

1281: )
1282:
1283: as
1284: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
1285: ddx_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
1286: ddindx binary_integer; indx binary_integer;
1287: begin
1288:
1289: -- copy data to the local IN or IN-OUT args, if any

Line 1295: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0

1291:
1292:
1293:
1294:
1295: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0
1296: , p5_a1
1297: , p5_a2
1298: , p5_a3
1299: , p5_a4

Line 1330: okl_sgt_pvt.update_row(p_api_version,

1326: );
1327:
1328:
1329: -- here's the delegated call to the old PL/SQL routine
1330: okl_sgt_pvt.update_row(p_api_version,
1331: p_init_msg_list,
1332: x_return_status,
1333: x_msg_count,
1334: x_msg_data,

Line 1345: okl_sgt_pvt_w.rosetta_table_copy_out_p2(ddx_sgnv_tbl, p6_a0

1341:
1342:
1343:
1344:
1345: okl_sgt_pvt_w.rosetta_table_copy_out_p2(ddx_sgnv_tbl, p6_a0
1346: , p6_a1
1347: , p6_a2
1348: , p6_a3
1349: , p6_a4

Line 1418: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;

1414: , p5_a30 NUMBER := 0-1962.0724
1415: )
1416:
1417: as
1418: ddp_sgnv_rec okl_sgt_pvt.sgnv_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 1461: okl_sgt_pvt.delete_row(p_api_version,

1457: ddp_sgnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1458: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1459:
1460: -- here's the delegated call to the old PL/SQL routine
1461: okl_sgt_pvt.delete_row(p_api_version,
1462: p_init_msg_list,
1463: x_return_status,
1464: x_msg_count,
1465: x_msg_data,

Line 1515: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;

1511: , p5_a30 JTF_NUMBER_TABLE
1512: )
1513:
1514: as
1515: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
1516: ddindx binary_integer; indx binary_integer;
1517: begin
1518:
1519: -- copy data to the local IN or IN-OUT args, if any

Line 1525: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0

1521:
1522:
1523:
1524:
1525: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0
1526: , p5_a1
1527: , p5_a2
1528: , p5_a3
1529: , p5_a4

Line 1559: okl_sgt_pvt.delete_row(p_api_version,

1555: , p5_a30
1556: );
1557:
1558: -- here's the delegated call to the old PL/SQL routine
1559: okl_sgt_pvt.delete_row(p_api_version,
1560: p_init_msg_list,
1561: x_return_status,
1562: x_msg_count,
1563: x_msg_data,

Line 1613: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;

1609: , p5_a30 NUMBER := 0-1962.0724
1610: )
1611:
1612: as
1613: ddp_sgnv_rec okl_sgt_pvt.sgnv_rec_type;
1614: ddindx binary_integer; indx binary_integer;
1615: begin
1616:
1617: -- copy data to the local IN or IN-OUT args, if any

Line 1656: okl_sgt_pvt.validate_row(p_api_version,

1652: ddp_sgnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a29);
1653: ddp_sgnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a30);
1654:
1655: -- here's the delegated call to the old PL/SQL routine
1656: okl_sgt_pvt.validate_row(p_api_version,
1657: p_init_msg_list,
1658: x_return_status,
1659: x_msg_count,
1660: x_msg_data,

Line 1710: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;

1706: , p5_a30 JTF_NUMBER_TABLE
1707: )
1708:
1709: as
1710: ddp_sgnv_tbl okl_sgt_pvt.sgnv_tbl_type;
1711: ddindx binary_integer; indx binary_integer;
1712: begin
1713:
1714: -- copy data to the local IN or IN-OUT args, if any

Line 1720: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0

1716:
1717:
1718:
1719:
1720: okl_sgt_pvt_w.rosetta_table_copy_in_p2(ddp_sgnv_tbl, p5_a0
1721: , p5_a1
1722: , p5_a2
1723: , p5_a3
1724: , p5_a4

Line 1754: okl_sgt_pvt.validate_row(p_api_version,

1750: , p5_a30
1751: );
1752:
1753: -- here's the delegated call to the old PL/SQL routine
1754: okl_sgt_pvt.validate_row(p_api_version,
1755: p_init_msg_list,
1756: x_return_status,
1757: x_msg_count,
1758: x_msg_data,

Line 1769: end okl_sgt_pvt_w;

1765:
1766:
1767: end;
1768:
1769: end okl_sgt_pvt_w;