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_OPT_PVT_W dependencies on OKL_OPT_PVT

Line 1: package body okl_opt_pvt_w as

1: package body okl_opt_pvt_w as
2: /* $Header: OKLIOPTB.pls 115.4 2002/12/24 04:05:49 sgorantl 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_opt_pvt.opt_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_opt_pvt.opt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_DATE_TABLE

Line 93: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

89: end loop;
90: end if;
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_200
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a4 out nocopy JTF_DATE_TABLE

Line 247: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE

243: end if;
244: end if;
245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_VARCHAR2_TABLE_200
250: , a3 JTF_VARCHAR2_TABLE_2000
251: , a4 JTF_DATE_TABLE

Line 318: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_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_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_VARCHAR2_TABLE_200
321: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
322: , a4 out nocopy JTF_DATE_TABLE

Line 534: ddp_optv_rec okl_opt_pvt.optv_rec_type;

530: , p5_a26 NUMBER := 0-1962.0724
531: )
532:
533: as
534: ddp_optv_rec okl_opt_pvt.optv_rec_type;
535: ddx_optv_rec okl_opt_pvt.optv_rec_type;
536: ddindx binary_integer; indx binary_integer;
537: begin
538:

Line 535: ddx_optv_rec okl_opt_pvt.optv_rec_type;

531: )
532:
533: as
534: ddp_optv_rec okl_opt_pvt.optv_rec_type;
535: ddx_optv_rec okl_opt_pvt.optv_rec_type;
536: ddindx binary_integer; indx binary_integer;
537: begin
538:
539: -- copy data to the local IN or IN-OUT args, if any

Line 575: okl_opt_pvt.insert_row(p_api_version,

571: ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
572:
573:
574: -- here's the delegated call to the old PL/SQL routine
575: okl_opt_pvt.insert_row(p_api_version,
576: p_init_msg_list,
577: x_return_status,
578: x_msg_count,
579: x_msg_data,

Line 681: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;

677: , p6_a26 out nocopy JTF_NUMBER_TABLE
678: )
679:
680: as
681: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;
682: ddx_optv_tbl okl_opt_pvt.optv_tbl_type;
683: ddindx binary_integer; indx binary_integer;
684: begin
685:

Line 682: ddx_optv_tbl okl_opt_pvt.optv_tbl_type;

678: )
679:
680: as
681: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;
682: ddx_optv_tbl okl_opt_pvt.optv_tbl_type;
683: ddindx binary_integer; indx binary_integer;
684: begin
685:
686: -- copy data to the local IN or IN-OUT args, if any

Line 692: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0

688:
689:
690:
691:
692: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
693: , p5_a1
694: , p5_a2
695: , p5_a3
696: , p5_a4

Line 723: okl_opt_pvt.insert_row(p_api_version,

719: );
720:
721:
722: -- here's the delegated call to the old PL/SQL routine
723: okl_opt_pvt.insert_row(p_api_version,
724: p_init_msg_list,
725: x_return_status,
726: x_msg_count,
727: x_msg_data,

Line 738: okl_opt_pvt_w.rosetta_table_copy_out_p5(ddx_optv_tbl, p6_a0

734:
735:
736:
737:
738: okl_opt_pvt_w.rosetta_table_copy_out_p5(ddx_optv_tbl, p6_a0
739: , p6_a1
740: , p6_a2
741: , p6_a3
742: , p6_a4

Line 803: ddp_optv_rec okl_opt_pvt.optv_rec_type;

799: , p5_a26 NUMBER := 0-1962.0724
800: )
801:
802: as
803: ddp_optv_rec okl_opt_pvt.optv_rec_type;
804: ddindx binary_integer; indx binary_integer;
805: begin
806:
807: -- copy data to the local IN or IN-OUT args, if any

Line 842: okl_opt_pvt.lock_row(p_api_version,

838: ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
839: ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
840:
841: -- here's the delegated call to the old PL/SQL routine
842: okl_opt_pvt.lock_row(p_api_version,
843: p_init_msg_list,
844: x_return_status,
845: x_msg_count,
846: x_msg_data,

Line 892: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;

888: , p5_a26 JTF_NUMBER_TABLE
889: )
890:
891: as
892: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;
893: ddindx binary_integer; indx binary_integer;
894: begin
895:
896: -- copy data to the local IN or IN-OUT args, if any

Line 902: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0

898:
899:
900:
901:
902: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
903: , p5_a1
904: , p5_a2
905: , p5_a3
906: , p5_a4

Line 932: okl_opt_pvt.lock_row(p_api_version,

928: , p5_a26
929: );
930:
931: -- here's the delegated call to the old PL/SQL routine
932: okl_opt_pvt.lock_row(p_api_version,
933: p_init_msg_list,
934: x_return_status,
935: x_msg_count,
936: x_msg_data,

Line 1009: ddp_optv_rec okl_opt_pvt.optv_rec_type;

1005: , p5_a26 NUMBER := 0-1962.0724
1006: )
1007:
1008: as
1009: ddp_optv_rec okl_opt_pvt.optv_rec_type;
1010: ddx_optv_rec okl_opt_pvt.optv_rec_type;
1011: ddindx binary_integer; indx binary_integer;
1012: begin
1013:

Line 1010: ddx_optv_rec okl_opt_pvt.optv_rec_type;

1006: )
1007:
1008: as
1009: ddp_optv_rec okl_opt_pvt.optv_rec_type;
1010: ddx_optv_rec okl_opt_pvt.optv_rec_type;
1011: ddindx binary_integer; indx binary_integer;
1012: begin
1013:
1014: -- copy data to the local IN or IN-OUT args, if any

Line 1050: okl_opt_pvt.update_row(p_api_version,

1046: ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1047:
1048:
1049: -- here's the delegated call to the old PL/SQL routine
1050: okl_opt_pvt.update_row(p_api_version,
1051: p_init_msg_list,
1052: x_return_status,
1053: x_msg_count,
1054: x_msg_data,

Line 1156: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;

1152: , p6_a26 out nocopy JTF_NUMBER_TABLE
1153: )
1154:
1155: as
1156: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;
1157: ddx_optv_tbl okl_opt_pvt.optv_tbl_type;
1158: ddindx binary_integer; indx binary_integer;
1159: begin
1160:

Line 1157: ddx_optv_tbl okl_opt_pvt.optv_tbl_type;

1153: )
1154:
1155: as
1156: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;
1157: ddx_optv_tbl okl_opt_pvt.optv_tbl_type;
1158: ddindx binary_integer; indx binary_integer;
1159: begin
1160:
1161: -- copy data to the local IN or IN-OUT args, if any

Line 1167: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0

1163:
1164:
1165:
1166:
1167: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
1168: , p5_a1
1169: , p5_a2
1170: , p5_a3
1171: , p5_a4

Line 1198: okl_opt_pvt.update_row(p_api_version,

1194: );
1195:
1196:
1197: -- here's the delegated call to the old PL/SQL routine
1198: okl_opt_pvt.update_row(p_api_version,
1199: p_init_msg_list,
1200: x_return_status,
1201: x_msg_count,
1202: x_msg_data,

Line 1213: okl_opt_pvt_w.rosetta_table_copy_out_p5(ddx_optv_tbl, p6_a0

1209:
1210:
1211:
1212:
1213: okl_opt_pvt_w.rosetta_table_copy_out_p5(ddx_optv_tbl, p6_a0
1214: , p6_a1
1215: , p6_a2
1216: , p6_a3
1217: , p6_a4

Line 1278: ddp_optv_rec okl_opt_pvt.optv_rec_type;

1274: , p5_a26 NUMBER := 0-1962.0724
1275: )
1276:
1277: as
1278: ddp_optv_rec okl_opt_pvt.optv_rec_type;
1279: ddindx binary_integer; indx binary_integer;
1280: begin
1281:
1282: -- copy data to the local IN or IN-OUT args, if any

Line 1317: okl_opt_pvt.delete_row(p_api_version,

1313: ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
1314: ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1315:
1316: -- here's the delegated call to the old PL/SQL routine
1317: okl_opt_pvt.delete_row(p_api_version,
1318: p_init_msg_list,
1319: x_return_status,
1320: x_msg_count,
1321: x_msg_data,

Line 1367: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;

1363: , p5_a26 JTF_NUMBER_TABLE
1364: )
1365:
1366: as
1367: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;
1368: ddindx binary_integer; indx binary_integer;
1369: begin
1370:
1371: -- copy data to the local IN or IN-OUT args, if any

Line 1377: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0

1373:
1374:
1375:
1376:
1377: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
1378: , p5_a1
1379: , p5_a2
1380: , p5_a3
1381: , p5_a4

Line 1407: okl_opt_pvt.delete_row(p_api_version,

1403: , p5_a26
1404: );
1405:
1406: -- here's the delegated call to the old PL/SQL routine
1407: okl_opt_pvt.delete_row(p_api_version,
1408: p_init_msg_list,
1409: x_return_status,
1410: x_msg_count,
1411: x_msg_data,

Line 1457: ddp_optv_rec okl_opt_pvt.optv_rec_type;

1453: , p5_a26 NUMBER := 0-1962.0724
1454: )
1455:
1456: as
1457: ddp_optv_rec okl_opt_pvt.optv_rec_type;
1458: ddindx binary_integer; indx binary_integer;
1459: begin
1460:
1461: -- copy data to the local IN or IN-OUT args, if any

Line 1496: okl_opt_pvt.validate_row(p_api_version,

1492: ddp_optv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
1493: ddp_optv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1494:
1495: -- here's the delegated call to the old PL/SQL routine
1496: okl_opt_pvt.validate_row(p_api_version,
1497: p_init_msg_list,
1498: x_return_status,
1499: x_msg_count,
1500: x_msg_data,

Line 1546: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;

1542: , p5_a26 JTF_NUMBER_TABLE
1543: )
1544:
1545: as
1546: ddp_optv_tbl okl_opt_pvt.optv_tbl_type;
1547: ddindx binary_integer; indx binary_integer;
1548: begin
1549:
1550: -- copy data to the local IN or IN-OUT args, if any

Line 1556: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0

1552:
1553:
1554:
1555:
1556: okl_opt_pvt_w.rosetta_table_copy_in_p5(ddp_optv_tbl, p5_a0
1557: , p5_a1
1558: , p5_a2
1559: , p5_a3
1560: , p5_a4

Line 1586: okl_opt_pvt.validate_row(p_api_version,

1582: , p5_a26
1583: );
1584:
1585: -- here's the delegated call to the old PL/SQL routine
1586: okl_opt_pvt.validate_row(p_api_version,
1587: p_init_msg_list,
1588: x_return_status,
1589: x_msg_count,
1590: x_msg_data,

Line 1601: end okl_opt_pvt_w;

1597:
1598:
1599: end;
1600:
1601: end okl_opt_pvt_w;