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_CURE_REPORTS_PUB_W dependencies on OKL_CURE_REPORTS_PUB

Line 1: package body okl_cure_reports_pub_w as

1: package body okl_cure_reports_pub_w as
2: /* $Header: OKLUCRTB.pls 115.2 2003/10/07 18:00:48 pdevaraj 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_cure_reports_pub.crtv_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_cure_reports_pub.crtv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 115: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_VARCHAR2_TABLE_200
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE

Line 408: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;

404: , p6_a37 out nocopy JTF_NUMBER_TABLE
405: )
406:
407: as
408: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
409: ddx_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
410: ddindx binary_integer; indx binary_integer;
411: begin
412:

Line 409: ddx_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;

405: )
406:
407: as
408: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
409: ddx_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
410: ddindx binary_integer; indx binary_integer;
411: begin
412:
413: -- copy data to the local IN or IN-OUT args, if any

Line 419: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

415:
416:
417:
418:
419: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
420: , p5_a1
421: , p5_a2
422: , p5_a3
423: , p5_a4

Line 461: okl_cure_reports_pub.insert_cure_reports(p_api_version,

457: );
458:
459:
460: -- here's the delegated call to the old PL/SQL routine
461: okl_cure_reports_pub.insert_cure_reports(p_api_version,
462: p_init_msg_list,
463: x_return_status,
464: x_msg_count,
465: x_msg_data,

Line 476: okl_cure_reports_pub_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0

472:
473:
474:
475:
476: okl_cure_reports_pub_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0
477: , p6_a1
478: , p6_a2
479: , p6_a3
480: , p6_a4

Line 601: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;

597: , p5_a37 NUMBER := 0-1962.0724
598: )
599:
600: as
601: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
602: ddx_crtv_rec okl_cure_reports_pub.crtv_rec_type;
603: ddindx binary_integer; indx binary_integer;
604: begin
605:

Line 602: ddx_crtv_rec okl_cure_reports_pub.crtv_rec_type;

598: )
599:
600: as
601: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
602: ddx_crtv_rec okl_cure_reports_pub.crtv_rec_type;
603: ddindx binary_integer; indx binary_integer;
604: begin
605:
606: -- copy data to the local IN or IN-OUT args, if any

Line 653: okl_cure_reports_pub.insert_cure_reports(p_api_version,

649: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
650:
651:
652: -- here's the delegated call to the old PL/SQL routine
653: okl_cure_reports_pub.insert_cure_reports(p_api_version,
654: p_init_msg_list,
655: x_return_status,
656: x_msg_count,
657: x_msg_data,

Line 754: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;

750: , p5_a37 JTF_NUMBER_TABLE
751: )
752:
753: as
754: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
755: ddindx binary_integer; indx binary_integer;
756: begin
757:
758: -- copy data to the local IN or IN-OUT args, if any

Line 764: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

760:
761:
762:
763:
764: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
765: , p5_a1
766: , p5_a2
767: , p5_a3
768: , p5_a4

Line 805: okl_cure_reports_pub.lock_cure_reports(p_api_version,

801: , p5_a37
802: );
803:
804: -- here's the delegated call to the old PL/SQL routine
805: okl_cure_reports_pub.lock_cure_reports(p_api_version,
806: p_init_msg_list,
807: x_return_status,
808: x_msg_count,
809: x_msg_data,

Line 866: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;

862: , p5_a37 NUMBER := 0-1962.0724
863: )
864:
865: as
866: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
867: ddindx binary_integer; indx binary_integer;
868: begin
869:
870: -- copy data to the local IN or IN-OUT args, if any

Line 916: okl_cure_reports_pub.lock_cure_reports(p_api_version,

912: ddp_crtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
913: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
914:
915: -- here's the delegated call to the old PL/SQL routine
916: okl_cure_reports_pub.lock_cure_reports(p_api_version,
917: p_init_msg_list,
918: x_return_status,
919: x_msg_count,
920: x_msg_data,

Line 1015: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;

1011: , p6_a37 out nocopy JTF_NUMBER_TABLE
1012: )
1013:
1014: as
1015: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
1016: ddx_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
1017: ddindx binary_integer; indx binary_integer;
1018: begin
1019:

Line 1016: ddx_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;

1012: )
1013:
1014: as
1015: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
1016: ddx_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
1017: ddindx binary_integer; indx binary_integer;
1018: begin
1019:
1020: -- copy data to the local IN or IN-OUT args, if any

Line 1026: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

1022:
1023:
1024:
1025:
1026: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
1027: , p5_a1
1028: , p5_a2
1029: , p5_a3
1030: , p5_a4

Line 1068: okl_cure_reports_pub.update_cure_reports(p_api_version,

1064: );
1065:
1066:
1067: -- here's the delegated call to the old PL/SQL routine
1068: okl_cure_reports_pub.update_cure_reports(p_api_version,
1069: p_init_msg_list,
1070: x_return_status,
1071: x_msg_count,
1072: x_msg_data,

Line 1083: okl_cure_reports_pub_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0

1079:
1080:
1081:
1082:
1083: okl_cure_reports_pub_w.rosetta_table_copy_out_p2(ddx_crtv_tbl, p6_a0
1084: , p6_a1
1085: , p6_a2
1086: , p6_a3
1087: , p6_a4

Line 1208: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;

1204: , p5_a37 NUMBER := 0-1962.0724
1205: )
1206:
1207: as
1208: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
1209: ddx_crtv_rec okl_cure_reports_pub.crtv_rec_type;
1210: ddindx binary_integer; indx binary_integer;
1211: begin
1212:

Line 1209: ddx_crtv_rec okl_cure_reports_pub.crtv_rec_type;

1205: )
1206:
1207: as
1208: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
1209: ddx_crtv_rec okl_cure_reports_pub.crtv_rec_type;
1210: ddindx binary_integer; indx binary_integer;
1211: begin
1212:
1213: -- copy data to the local IN or IN-OUT args, if any

Line 1260: okl_cure_reports_pub.update_cure_reports(p_api_version,

1256: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1257:
1258:
1259: -- here's the delegated call to the old PL/SQL routine
1260: okl_cure_reports_pub.update_cure_reports(p_api_version,
1261: p_init_msg_list,
1262: x_return_status,
1263: x_msg_count,
1264: x_msg_data,

Line 1361: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;

1357: , p5_a37 JTF_NUMBER_TABLE
1358: )
1359:
1360: as
1361: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
1362: ddindx binary_integer; indx binary_integer;
1363: begin
1364:
1365: -- copy data to the local IN or IN-OUT args, if any

Line 1371: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

1367:
1368:
1369:
1370:
1371: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
1372: , p5_a1
1373: , p5_a2
1374: , p5_a3
1375: , p5_a4

Line 1412: okl_cure_reports_pub.delete_cure_reports(p_api_version,

1408: , p5_a37
1409: );
1410:
1411: -- here's the delegated call to the old PL/SQL routine
1412: okl_cure_reports_pub.delete_cure_reports(p_api_version,
1413: p_init_msg_list,
1414: x_return_status,
1415: x_msg_count,
1416: x_msg_data,

Line 1473: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;

1469: , p5_a37 NUMBER := 0-1962.0724
1470: )
1471:
1472: as
1473: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
1474: ddindx binary_integer; indx binary_integer;
1475: begin
1476:
1477: -- copy data to the local IN or IN-OUT args, if any

Line 1523: okl_cure_reports_pub.delete_cure_reports(p_api_version,

1519: ddp_crtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1520: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1521:
1522: -- here's the delegated call to the old PL/SQL routine
1523: okl_cure_reports_pub.delete_cure_reports(p_api_version,
1524: p_init_msg_list,
1525: x_return_status,
1526: x_msg_count,
1527: x_msg_data,

Line 1584: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;

1580: , p5_a37 JTF_NUMBER_TABLE
1581: )
1582:
1583: as
1584: ddp_crtv_tbl okl_cure_reports_pub.crtv_tbl_type;
1585: ddindx binary_integer; indx binary_integer;
1586: begin
1587:
1588: -- copy data to the local IN or IN-OUT args, if any

Line 1594: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0

1590:
1591:
1592:
1593:
1594: okl_cure_reports_pub_w.rosetta_table_copy_in_p2(ddp_crtv_tbl, p5_a0
1595: , p5_a1
1596: , p5_a2
1597: , p5_a3
1598: , p5_a4

Line 1635: okl_cure_reports_pub.validate_cure_reports(p_api_version,

1631: , p5_a37
1632: );
1633:
1634: -- here's the delegated call to the old PL/SQL routine
1635: okl_cure_reports_pub.validate_cure_reports(p_api_version,
1636: p_init_msg_list,
1637: x_return_status,
1638: x_msg_count,
1639: x_msg_data,

Line 1696: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;

1692: , p5_a37 NUMBER := 0-1962.0724
1693: )
1694:
1695: as
1696: ddp_crtv_rec okl_cure_reports_pub.crtv_rec_type;
1697: ddindx binary_integer; indx binary_integer;
1698: begin
1699:
1700: -- copy data to the local IN or IN-OUT args, if any

Line 1746: okl_cure_reports_pub.validate_cure_reports(p_api_version,

1742: ddp_crtv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1743: ddp_crtv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1744:
1745: -- here's the delegated call to the old PL/SQL routine
1746: okl_cure_reports_pub.validate_cure_reports(p_api_version,
1747: p_init_msg_list,
1748: x_return_status,
1749: x_msg_count,
1750: x_msg_data,

Line 1761: end okl_cure_reports_pub_w;

1757:
1758:
1759: end;
1760:
1761: end okl_cure_reports_pub_w;