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_STM_PVT_W dependencies on OKL_STM_PVT

Line 1: package body okl_stm_pvt_w as

1: package body okl_stm_pvt_w as
2: /* $Header: OKLISTMB.pls 120.2 2005/10/30 04:18:37 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 13: procedure rosetta_table_copy_in_p2(t out nocopy okl_stm_pvt.stm_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy okl_stm_pvt.stm_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 86: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

82: end loop;
83: end if;
84: end if;
85: end rosetta_table_copy_in_p2;
86: procedure rosetta_table_copy_out_p2(t okl_stm_pvt.stm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
87: , a1 out nocopy JTF_NUMBER_TABLE
88: , a2 out nocopy JTF_NUMBER_TABLE
89: , a3 out nocopy JTF_NUMBER_TABLE
90: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 245: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE

241: end if;
242: end if;
243: end rosetta_table_copy_out_p2;
244:
245: procedure rosetta_table_copy_in_p5(t out nocopy okl_stm_pvt.stmv_tbl_type, a0 JTF_NUMBER_TABLE
246: , a1 JTF_NUMBER_TABLE
247: , a2 JTF_NUMBER_TABLE
248: , a3 JTF_NUMBER_TABLE
249: , a4 JTF_VARCHAR2_TABLE_100

Line 318: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

314: end loop;
315: end if;
316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_stm_pvt.stmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 541: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;

537: , p6_a27 out nocopy NUMBER
538: )
539:
540: as
541: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;
542: ddx_stmv_rec okl_stm_pvt.stmv_rec_type;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:

Line 542: ddx_stmv_rec okl_stm_pvt.stmv_rec_type;

538: )
539:
540: as
541: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;
542: ddx_stmv_rec okl_stm_pvt.stmv_rec_type;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:
546: -- copy data to the local IN or IN-OUT args, if any

Line 583: okl_stm_pvt.insert_row(p_api_version,

579: ddp_stmv_rec.link_hist_stream_id := p5_a27;
580:
581:
582: -- here's the delegated call to the old PL/SQL routine
583: okl_stm_pvt.insert_row(p_api_version,
584: p_init_msg_list,
585: x_return_status,
586: x_msg_count,
587: x_msg_data,

Line 692: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;

688: , p6_a27 out nocopy JTF_NUMBER_TABLE
689: )
690:
691: as
692: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;
693: ddx_stmv_tbl okl_stm_pvt.stmv_tbl_type;
694: ddindx binary_integer; indx binary_integer;
695: begin
696:

Line 693: ddx_stmv_tbl okl_stm_pvt.stmv_tbl_type;

689: )
690:
691: as
692: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;
693: ddx_stmv_tbl okl_stm_pvt.stmv_tbl_type;
694: ddindx binary_integer; indx binary_integer;
695: begin
696:
697: -- copy data to the local IN or IN-OUT args, if any

Line 703: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0

699:
700:
701:
702:
703: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
704: , p5_a1
705: , p5_a2
706: , p5_a3
707: , p5_a4

Line 735: okl_stm_pvt.insert_row(p_api_version,

731: );
732:
733:
734: -- here's the delegated call to the old PL/SQL routine
735: okl_stm_pvt.insert_row(p_api_version,
736: p_init_msg_list,
737: x_return_status,
738: x_msg_count,
739: x_msg_data,

Line 750: okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p6_a0

746:
747:
748:
749:
750: okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p6_a0
751: , p6_a1
752: , p6_a2
753: , p6_a3
754: , p6_a4

Line 817: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;

813: , p5_a27 NUMBER
814: )
815:
816: as
817: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;
818: ddindx binary_integer; indx binary_integer;
819: begin
820:
821: -- copy data to the local IN or IN-OUT args, if any

Line 857: okl_stm_pvt.lock_row(p_api_version,

853: ddp_stmv_rec.trx_id := p5_a26;
854: ddp_stmv_rec.link_hist_stream_id := p5_a27;
855:
856: -- here's the delegated call to the old PL/SQL routine
857: okl_stm_pvt.lock_row(p_api_version,
858: p_init_msg_list,
859: x_return_status,
860: x_msg_count,
861: x_msg_data,

Line 908: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;

904: , p5_a27 JTF_NUMBER_TABLE
905: )
906:
907: as
908: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;
909: ddindx binary_integer; indx binary_integer;
910: begin
911:
912: -- copy data to the local IN or IN-OUT args, if any

Line 918: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0

914:
915:
916:
917:
918: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
919: , p5_a1
920: , p5_a2
921: , p5_a3
922: , p5_a4

Line 949: okl_stm_pvt.lock_row(p_api_version,

945: , p5_a27
946: );
947:
948: -- here's the delegated call to the old PL/SQL routine
949: okl_stm_pvt.lock_row(p_api_version,
950: p_init_msg_list,
951: x_return_status,
952: x_msg_count,
953: x_msg_data,

Line 1028: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;

1024: , p6_a27 out nocopy NUMBER
1025: )
1026:
1027: as
1028: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;
1029: ddx_stmv_rec okl_stm_pvt.stmv_rec_type;
1030: ddindx binary_integer; indx binary_integer;
1031: begin
1032:

Line 1029: ddx_stmv_rec okl_stm_pvt.stmv_rec_type;

1025: )
1026:
1027: as
1028: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;
1029: ddx_stmv_rec okl_stm_pvt.stmv_rec_type;
1030: ddindx binary_integer; indx binary_integer;
1031: begin
1032:
1033: -- copy data to the local IN or IN-OUT args, if any

Line 1070: okl_stm_pvt.update_row(p_api_version,

1066: ddp_stmv_rec.link_hist_stream_id := p5_a27;
1067:
1068:
1069: -- here's the delegated call to the old PL/SQL routine
1070: okl_stm_pvt.update_row(p_api_version,
1071: p_init_msg_list,
1072: x_return_status,
1073: x_msg_count,
1074: x_msg_data,

Line 1179: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;

1175: , p6_a27 out nocopy JTF_NUMBER_TABLE
1176: )
1177:
1178: as
1179: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;
1180: ddx_stmv_tbl okl_stm_pvt.stmv_tbl_type;
1181: ddindx binary_integer; indx binary_integer;
1182: begin
1183:

Line 1180: ddx_stmv_tbl okl_stm_pvt.stmv_tbl_type;

1176: )
1177:
1178: as
1179: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;
1180: ddx_stmv_tbl okl_stm_pvt.stmv_tbl_type;
1181: ddindx binary_integer; indx binary_integer;
1182: begin
1183:
1184: -- copy data to the local IN or IN-OUT args, if any

Line 1190: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0

1186:
1187:
1188:
1189:
1190: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
1191: , p5_a1
1192: , p5_a2
1193: , p5_a3
1194: , p5_a4

Line 1222: okl_stm_pvt.update_row(p_api_version,

1218: );
1219:
1220:
1221: -- here's the delegated call to the old PL/SQL routine
1222: okl_stm_pvt.update_row(p_api_version,
1223: p_init_msg_list,
1224: x_return_status,
1225: x_msg_count,
1226: x_msg_data,

Line 1237: okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p6_a0

1233:
1234:
1235:
1236:
1237: okl_stm_pvt_w.rosetta_table_copy_out_p5(ddx_stmv_tbl, p6_a0
1238: , p6_a1
1239: , p6_a2
1240: , p6_a3
1241: , p6_a4

Line 1304: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;

1300: , p5_a27 NUMBER
1301: )
1302:
1303: as
1304: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;
1305: ddindx binary_integer; indx binary_integer;
1306: begin
1307:
1308: -- copy data to the local IN or IN-OUT args, if any

Line 1344: okl_stm_pvt.delete_row(p_api_version,

1340: ddp_stmv_rec.trx_id := p5_a26;
1341: ddp_stmv_rec.link_hist_stream_id := p5_a27;
1342:
1343: -- here's the delegated call to the old PL/SQL routine
1344: okl_stm_pvt.delete_row(p_api_version,
1345: p_init_msg_list,
1346: x_return_status,
1347: x_msg_count,
1348: x_msg_data,

Line 1395: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;

1391: , p5_a27 JTF_NUMBER_TABLE
1392: )
1393:
1394: as
1395: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;
1396: ddindx binary_integer; indx binary_integer;
1397: begin
1398:
1399: -- copy data to the local IN or IN-OUT args, if any

Line 1405: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0

1401:
1402:
1403:
1404:
1405: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
1406: , p5_a1
1407: , p5_a2
1408: , p5_a3
1409: , p5_a4

Line 1436: okl_stm_pvt.delete_row(p_api_version,

1432: , p5_a27
1433: );
1434:
1435: -- here's the delegated call to the old PL/SQL routine
1436: okl_stm_pvt.delete_row(p_api_version,
1437: p_init_msg_list,
1438: x_return_status,
1439: x_msg_count,
1440: x_msg_data,

Line 1487: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;

1483: , p5_a27 NUMBER
1484: )
1485:
1486: as
1487: ddp_stmv_rec okl_stm_pvt.stmv_rec_type;
1488: ddindx binary_integer; indx binary_integer;
1489: begin
1490:
1491: -- copy data to the local IN or IN-OUT args, if any

Line 1527: okl_stm_pvt.validate_row(p_api_version,

1523: ddp_stmv_rec.trx_id := p5_a26;
1524: ddp_stmv_rec.link_hist_stream_id := p5_a27;
1525:
1526: -- here's the delegated call to the old PL/SQL routine
1527: okl_stm_pvt.validate_row(p_api_version,
1528: p_init_msg_list,
1529: x_return_status,
1530: x_msg_count,
1531: x_msg_data,

Line 1578: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;

1574: , p5_a27 JTF_NUMBER_TABLE
1575: )
1576:
1577: as
1578: ddp_stmv_tbl okl_stm_pvt.stmv_tbl_type;
1579: ddindx binary_integer; indx binary_integer;
1580: begin
1581:
1582: -- copy data to the local IN or IN-OUT args, if any

Line 1588: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0

1584:
1585:
1586:
1587:
1588: okl_stm_pvt_w.rosetta_table_copy_in_p5(ddp_stmv_tbl, p5_a0
1589: , p5_a1
1590: , p5_a2
1591: , p5_a3
1592: , p5_a4

Line 1619: okl_stm_pvt.validate_row(p_api_version,

1615: , p5_a27
1616: );
1617:
1618: -- here's the delegated call to the old PL/SQL routine
1619: okl_stm_pvt.validate_row(p_api_version,
1620: p_init_msg_list,
1621: x_return_status,
1622: x_msg_count,
1623: x_msg_data,

Line 1634: end okl_stm_pvt_w;

1630:
1631:
1632: end;
1633:
1634: end okl_stm_pvt_w;