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_SIF_RETS_PUB_W dependencies on OKL_SIF_RETS_PUB

Line 1: package body okl_sif_rets_pub_w as

1: package body okl_sif_rets_pub_w as
2: /* $Header: OKLUSIRB.pls 120.1 2005/07/19 09:44:40 viselvar 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 102: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;

98: , p5_a35 DATE := fnd_api.g_miss_date
99: )
100:
101: as
102: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
103: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
104: ddindx binary_integer; indx binary_integer;
105: begin
106:

Line 103: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;

99: )
100:
101: as
102: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
103: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
104: ddindx binary_integer; indx binary_integer;
105: begin
106:
107: -- copy data to the local IN or IN-OUT args, if any

Line 152: okl_sif_rets_pub.insert_sif_rets(p_api_version,

148: ddp_sirv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a35);
149:
150:
151: -- here's the delegated call to the old PL/SQL routine
152: okl_sif_rets_pub.insert_sif_rets(p_api_version,
153: p_init_msg_list,
154: x_return_status,
155: x_msg_count,
156: x_msg_data,

Line 285: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

281: , p6_a35 out nocopy JTF_DATE_TABLE
282: )
283:
284: as
285: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
286: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
287: ddindx binary_integer; indx binary_integer;
288: begin
289:

Line 286: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

282: )
283:
284: as
285: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
286: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
287: ddindx binary_integer; indx binary_integer;
288: begin
289:
290: -- copy data to the local IN or IN-OUT args, if any

Line 336: okl_sif_rets_pub.insert_sif_rets(p_api_version,

332: );
333:
334:
335: -- here's the delegated call to the old PL/SQL routine
336: okl_sif_rets_pub.insert_sif_rets(p_api_version,
337: p_init_msg_list,
338: x_return_status,
339: x_msg_count,
340: x_msg_data,

Line 434: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;

430: , p5_a35 DATE := fnd_api.g_miss_date
431: )
432:
433: as
434: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
435: ddindx binary_integer; indx binary_integer;
436: begin
437:
438: -- copy data to the local IN or IN-OUT args, if any

Line 482: okl_sif_rets_pub.lock_sif_rets(p_api_version,

478: ddp_sirv_rec.program_id := rosetta_g_miss_num_map(p5_a34);
479: ddp_sirv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a35);
480:
481: -- here's the delegated call to the old PL/SQL routine
482: okl_sif_rets_pub.lock_sif_rets(p_api_version,
483: p_init_msg_list,
484: x_return_status,
485: x_msg_count,
486: x_msg_data,

Line 541: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

537: , p5_a35 JTF_DATE_TABLE
538: )
539:
540: as
541: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
542: ddindx binary_integer; indx binary_integer;
543: begin
544:
545: -- copy data to the local IN or IN-OUT args, if any

Line 590: okl_sif_rets_pub.lock_sif_rets(p_api_version,

586: , p5_a35
587: );
588:
589: -- here's the delegated call to the old PL/SQL routine
590: okl_sif_rets_pub.lock_sif_rets(p_api_version,
591: p_init_msg_list,
592: x_return_status,
593: x_msg_count,
594: x_msg_data,

Line 685: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;

681: , p5_a35 DATE := fnd_api.g_miss_date
682: )
683:
684: as
685: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
686: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
687: ddindx binary_integer; indx binary_integer;
688: begin
689:

Line 686: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;

682: )
683:
684: as
685: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
686: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
687: ddindx binary_integer; indx binary_integer;
688: begin
689:
690: -- copy data to the local IN or IN-OUT args, if any

Line 735: okl_sif_rets_pub.update_sif_rets(p_api_version,

731: ddp_sirv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a35);
732:
733:
734: -- here's the delegated call to the old PL/SQL routine
735: okl_sif_rets_pub.update_sif_rets(p_api_version,
736: p_init_msg_list,
737: x_return_status,
738: x_msg_count,
739: x_msg_data,

Line 868: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

864: , p6_a35 out nocopy JTF_DATE_TABLE
865: )
866:
867: as
868: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
869: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
870: ddindx binary_integer; indx binary_integer;
871: begin
872:

Line 869: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

865: )
866:
867: as
868: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
869: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
870: ddindx binary_integer; indx binary_integer;
871: begin
872:
873: -- copy data to the local IN or IN-OUT args, if any

Line 919: okl_sif_rets_pub.update_sif_rets(p_api_version,

915: );
916:
917:
918: -- here's the delegated call to the old PL/SQL routine
919: okl_sif_rets_pub.update_sif_rets(p_api_version,
920: p_init_msg_list,
921: x_return_status,
922: x_msg_count,
923: x_msg_data,

Line 1053: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;

1049: , p5_a35 DATE := fnd_api.g_miss_date
1050: )
1051:
1052: as
1053: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1054: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1055: ddindx binary_integer; indx binary_integer;
1056: begin
1057:

Line 1054: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;

1050: )
1051:
1052: as
1053: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1054: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1055: ddindx binary_integer; indx binary_integer;
1056: begin
1057:
1058: -- copy data to the local IN or IN-OUT args, if any

Line 1103: okl_sif_rets_pub.delete_sif_rets(p_api_version,

1099: ddp_sirv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a35);
1100:
1101:
1102: -- here's the delegated call to the old PL/SQL routine
1103: okl_sif_rets_pub.delete_sif_rets(p_api_version,
1104: p_init_msg_list,
1105: x_return_status,
1106: x_msg_count,
1107: x_msg_data,

Line 1236: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

1232: , p6_a35 out nocopy JTF_DATE_TABLE
1233: )
1234:
1235: as
1236: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1237: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1238: ddindx binary_integer; indx binary_integer;
1239: begin
1240:

Line 1237: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

1233: )
1234:
1235: as
1236: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1237: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1238: ddindx binary_integer; indx binary_integer;
1239: begin
1240:
1241: -- copy data to the local IN or IN-OUT args, if any

Line 1287: okl_sif_rets_pub.delete_sif_rets(p_api_version,

1283: );
1284:
1285:
1286: -- here's the delegated call to the old PL/SQL routine
1287: okl_sif_rets_pub.delete_sif_rets(p_api_version,
1288: p_init_msg_list,
1289: x_return_status,
1290: x_msg_count,
1291: x_msg_data,

Line 1421: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;

1417: , p5_a35 DATE := fnd_api.g_miss_date
1418: )
1419:
1420: as
1421: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1422: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1423: ddindx binary_integer; indx binary_integer;
1424: begin
1425:

Line 1422: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;

1418: )
1419:
1420: as
1421: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1422: ddx_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1423: ddindx binary_integer; indx binary_integer;
1424: begin
1425:
1426: -- copy data to the local IN or IN-OUT args, if any

Line 1471: okl_sif_rets_pub.validate_sif_rets(p_api_version,

1467: ddp_sirv_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a35);
1468:
1469:
1470: -- here's the delegated call to the old PL/SQL routine
1471: okl_sif_rets_pub.validate_sif_rets(p_api_version,
1472: p_init_msg_list,
1473: x_return_status,
1474: x_msg_count,
1475: x_msg_data,

Line 1604: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

1600: , p6_a35 out nocopy JTF_DATE_TABLE
1601: )
1602:
1603: as
1604: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1605: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1606: ddindx binary_integer; indx binary_integer;
1607: begin
1608:

Line 1605: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;

1601: )
1602:
1603: as
1604: ddp_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1605: ddx_sirv_tbl okl_sif_rets_pub.sirv_tbl_type;
1606: ddindx binary_integer; indx binary_integer;
1607: begin
1608:
1609: -- copy data to the local IN or IN-OUT args, if any

Line 1655: okl_sif_rets_pub.validate_sif_rets(p_api_version,

1651: );
1652:
1653:
1654: -- here's the delegated call to the old PL/SQL routine
1655: okl_sif_rets_pub.validate_sif_rets(p_api_version,
1656: p_init_msg_list,
1657: x_return_status,
1658: x_msg_count,
1659: x_msg_data,

Line 1709: end okl_sif_rets_pub_w;

1705: , p6_a35
1706: );
1707: end;
1708:
1709: end okl_sif_rets_pub_w;