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_CAH_PVT_W dependencies on OKL_CAH_PVT

Line 1: package body okl_cah_pvt_w as

1: package body okl_cah_pvt_w as
2: /* $Header: OKLICAHB.pls 120.3 2005/09/20 13:41:15 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_cah_pvt.cah_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_cah_pvt.cah_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 95: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t okl_cah_pvt.cah_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_200
97: , a2 out nocopy JTF_NUMBER_TABLE
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_NUMBER_TABLE

Line 254: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE

250: end if;
251: end if;
252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p5(t out nocopy okl_cah_pvt.cahv_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_VARCHAR2_TABLE_200
257: , a3 JTF_VARCHAR2_TABLE_2000
258: , a4 JTF_NUMBER_TABLE

Line 327: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

323: end loop;
324: end if;
325: end if;
326: end rosetta_table_copy_in_p5;
327: procedure rosetta_table_copy_out_p5(t okl_cah_pvt.cahv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
328: , a1 out nocopy JTF_NUMBER_TABLE
329: , a2 out nocopy JTF_VARCHAR2_TABLE_200
330: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
331: , a4 out nocopy JTF_NUMBER_TABLE

Line 550: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;

546: , p5_a27 NUMBER := 0-1962.0724
547: )
548:
549: as
550: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;
551: ddx_cahv_rec okl_cah_pvt.cahv_rec_type;
552: ddindx binary_integer; indx binary_integer;
553: begin
554:

Line 551: ddx_cahv_rec okl_cah_pvt.cahv_rec_type;

547: )
548:
549: as
550: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;
551: ddx_cahv_rec okl_cah_pvt.cahv_rec_type;
552: ddindx binary_integer; indx binary_integer;
553: begin
554:
555: -- copy data to the local IN or IN-OUT args, if any

Line 592: okl_cah_pvt.insert_row(p_api_version,

588: ddp_cahv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
589:
590:
591: -- here's the delegated call to the old PL/SQL routine
592: okl_cah_pvt.insert_row(p_api_version,
593: p_init_msg_list,
594: x_return_status,
595: x_msg_count,
596: x_msg_data,

Line 701: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;

697: , p6_a27 out nocopy JTF_NUMBER_TABLE
698: )
699:
700: as
701: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;
702: ddx_cahv_tbl okl_cah_pvt.cahv_tbl_type;
703: ddindx binary_integer; indx binary_integer;
704: begin
705:

Line 702: ddx_cahv_tbl okl_cah_pvt.cahv_tbl_type;

698: )
699:
700: as
701: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;
702: ddx_cahv_tbl okl_cah_pvt.cahv_tbl_type;
703: ddindx binary_integer; indx binary_integer;
704: begin
705:
706: -- copy data to the local IN or IN-OUT args, if any

Line 712: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0

708:
709:
710:
711:
712: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0
713: , p5_a1
714: , p5_a2
715: , p5_a3
716: , p5_a4

Line 744: okl_cah_pvt.insert_row(p_api_version,

740: );
741:
742:
743: -- here's the delegated call to the old PL/SQL routine
744: okl_cah_pvt.insert_row(p_api_version,
745: p_init_msg_list,
746: x_return_status,
747: x_msg_count,
748: x_msg_data,

Line 759: okl_cah_pvt_w.rosetta_table_copy_out_p5(ddx_cahv_tbl, p6_a0

755:
756:
757:
758:
759: okl_cah_pvt_w.rosetta_table_copy_out_p5(ddx_cahv_tbl, p6_a0
760: , p6_a1
761: , p6_a2
762: , p6_a3
763: , p6_a4

Line 826: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;

822: , p5_a27 NUMBER := 0-1962.0724
823: )
824:
825: as
826: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;
827: ddindx binary_integer; indx binary_integer;
828: begin
829:
830: -- copy data to the local IN or IN-OUT args, if any

Line 866: okl_cah_pvt.lock_row(p_api_version,

862: ddp_cahv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a26);
863: ddp_cahv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
864:
865: -- here's the delegated call to the old PL/SQL routine
866: okl_cah_pvt.lock_row(p_api_version,
867: p_init_msg_list,
868: x_return_status,
869: x_msg_count,
870: x_msg_data,

Line 917: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;

913: , p5_a27 JTF_NUMBER_TABLE
914: )
915:
916: as
917: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;
918: ddindx binary_integer; indx binary_integer;
919: begin
920:
921: -- copy data to the local IN or IN-OUT args, if any

Line 927: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0

923:
924:
925:
926:
927: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0
928: , p5_a1
929: , p5_a2
930: , p5_a3
931: , p5_a4

Line 958: okl_cah_pvt.lock_row(p_api_version,

954: , p5_a27
955: );
956:
957: -- here's the delegated call to the old PL/SQL routine
958: okl_cah_pvt.lock_row(p_api_version,
959: p_init_msg_list,
960: x_return_status,
961: x_msg_count,
962: x_msg_data,

Line 1037: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;

1033: , p5_a27 NUMBER := 0-1962.0724
1034: )
1035:
1036: as
1037: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;
1038: ddx_cahv_rec okl_cah_pvt.cahv_rec_type;
1039: ddindx binary_integer; indx binary_integer;
1040: begin
1041:

Line 1038: ddx_cahv_rec okl_cah_pvt.cahv_rec_type;

1034: )
1035:
1036: as
1037: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;
1038: ddx_cahv_rec okl_cah_pvt.cahv_rec_type;
1039: ddindx binary_integer; indx binary_integer;
1040: begin
1041:
1042: -- copy data to the local IN or IN-OUT args, if any

Line 1079: okl_cah_pvt.update_row(p_api_version,

1075: ddp_cahv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1076:
1077:
1078: -- here's the delegated call to the old PL/SQL routine
1079: okl_cah_pvt.update_row(p_api_version,
1080: p_init_msg_list,
1081: x_return_status,
1082: x_msg_count,
1083: x_msg_data,

Line 1188: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;

1184: , p6_a27 out nocopy JTF_NUMBER_TABLE
1185: )
1186:
1187: as
1188: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;
1189: ddx_cahv_tbl okl_cah_pvt.cahv_tbl_type;
1190: ddindx binary_integer; indx binary_integer;
1191: begin
1192:

Line 1189: ddx_cahv_tbl okl_cah_pvt.cahv_tbl_type;

1185: )
1186:
1187: as
1188: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;
1189: ddx_cahv_tbl okl_cah_pvt.cahv_tbl_type;
1190: ddindx binary_integer; indx binary_integer;
1191: begin
1192:
1193: -- copy data to the local IN or IN-OUT args, if any

Line 1199: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0

1195:
1196:
1197:
1198:
1199: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0
1200: , p5_a1
1201: , p5_a2
1202: , p5_a3
1203: , p5_a4

Line 1231: okl_cah_pvt.update_row(p_api_version,

1227: );
1228:
1229:
1230: -- here's the delegated call to the old PL/SQL routine
1231: okl_cah_pvt.update_row(p_api_version,
1232: p_init_msg_list,
1233: x_return_status,
1234: x_msg_count,
1235: x_msg_data,

Line 1246: okl_cah_pvt_w.rosetta_table_copy_out_p5(ddx_cahv_tbl, p6_a0

1242:
1243:
1244:
1245:
1246: okl_cah_pvt_w.rosetta_table_copy_out_p5(ddx_cahv_tbl, p6_a0
1247: , p6_a1
1248: , p6_a2
1249: , p6_a3
1250: , p6_a4

Line 1313: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;

1309: , p5_a27 NUMBER := 0-1962.0724
1310: )
1311:
1312: as
1313: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;
1314: ddindx binary_integer; indx binary_integer;
1315: begin
1316:
1317: -- copy data to the local IN or IN-OUT args, if any

Line 1353: okl_cah_pvt.delete_row(p_api_version,

1349: ddp_cahv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a26);
1350: ddp_cahv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1351:
1352: -- here's the delegated call to the old PL/SQL routine
1353: okl_cah_pvt.delete_row(p_api_version,
1354: p_init_msg_list,
1355: x_return_status,
1356: x_msg_count,
1357: x_msg_data,

Line 1404: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;

1400: , p5_a27 JTF_NUMBER_TABLE
1401: )
1402:
1403: as
1404: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;
1405: ddindx binary_integer; indx binary_integer;
1406: begin
1407:
1408: -- copy data to the local IN or IN-OUT args, if any

Line 1414: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0

1410:
1411:
1412:
1413:
1414: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0
1415: , p5_a1
1416: , p5_a2
1417: , p5_a3
1418: , p5_a4

Line 1445: okl_cah_pvt.delete_row(p_api_version,

1441: , p5_a27
1442: );
1443:
1444: -- here's the delegated call to the old PL/SQL routine
1445: okl_cah_pvt.delete_row(p_api_version,
1446: p_init_msg_list,
1447: x_return_status,
1448: x_msg_count,
1449: x_msg_data,

Line 1496: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;

1492: , p5_a27 NUMBER := 0-1962.0724
1493: )
1494:
1495: as
1496: ddp_cahv_rec okl_cah_pvt.cahv_rec_type;
1497: ddindx binary_integer; indx binary_integer;
1498: begin
1499:
1500: -- copy data to the local IN or IN-OUT args, if any

Line 1536: okl_cah_pvt.validate_row(p_api_version,

1532: ddp_cahv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a26);
1533: ddp_cahv_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1534:
1535: -- here's the delegated call to the old PL/SQL routine
1536: okl_cah_pvt.validate_row(p_api_version,
1537: p_init_msg_list,
1538: x_return_status,
1539: x_msg_count,
1540: x_msg_data,

Line 1587: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;

1583: , p5_a27 JTF_NUMBER_TABLE
1584: )
1585:
1586: as
1587: ddp_cahv_tbl okl_cah_pvt.cahv_tbl_type;
1588: ddindx binary_integer; indx binary_integer;
1589: begin
1590:
1591: -- copy data to the local IN or IN-OUT args, if any

Line 1597: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0

1593:
1594:
1595:
1596:
1597: okl_cah_pvt_w.rosetta_table_copy_in_p5(ddp_cahv_tbl, p5_a0
1598: , p5_a1
1599: , p5_a2
1600: , p5_a3
1601: , p5_a4

Line 1628: okl_cah_pvt.validate_row(p_api_version,

1624: , p5_a27
1625: );
1626:
1627: -- here's the delegated call to the old PL/SQL routine
1628: okl_cah_pvt.validate_row(p_api_version,
1629: p_init_msg_list,
1630: x_return_status,
1631: x_msg_count,
1632: x_msg_data,

Line 1643: end okl_cah_pvt_w;

1639:
1640:
1641: end;
1642:
1643: end okl_cah_pvt_w;