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_OPD_PVT_W dependencies on OKL_OPD_PVT

Line 1: package body okl_opd_pvt_w as

1: package body okl_opd_pvt_w as
2: /* $Header: OKLIOPDB.pls 120.1 2005/07/14 11:57:30 asawanka 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_opd_pvt.opd_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_opd_pvt.opd_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 71: procedure rosetta_table_copy_out_p2(t okl_opd_pvt.opd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

67: end loop;
68: end if;
69: end if;
70: end rosetta_table_copy_in_p2;
71: procedure rosetta_table_copy_out_p2(t okl_opd_pvt.opd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_VARCHAR2_TABLE_200
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_NUMBER_TABLE
75: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 170: procedure rosetta_table_copy_in_p5(t out nocopy okl_opd_pvt.okl_operands_tl_tbl_type, a0 JTF_NUMBER_TABLE

166: end if;
167: end if;
168: end rosetta_table_copy_out_p2;
169:
170: procedure rosetta_table_copy_in_p5(t out nocopy okl_opd_pvt.okl_operands_tl_tbl_type, a0 JTF_NUMBER_TABLE
171: , a1 JTF_VARCHAR2_TABLE_100
172: , a2 JTF_VARCHAR2_TABLE_100
173: , a3 JTF_VARCHAR2_TABLE_100
174: , a4 JTF_VARCHAR2_TABLE_2000

Line 207: procedure rosetta_table_copy_out_p5(t okl_opd_pvt.okl_operands_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

203: end loop;
204: end if;
205: end if;
206: end rosetta_table_copy_in_p5;
207: procedure rosetta_table_copy_out_p5(t okl_opd_pvt.okl_operands_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
208: , a1 out nocopy JTF_VARCHAR2_TABLE_100
209: , a2 out nocopy JTF_VARCHAR2_TABLE_100
210: , a3 out nocopy JTF_VARCHAR2_TABLE_100
211: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 276: procedure rosetta_table_copy_in_p8(t out nocopy okl_opd_pvt.opdv_tbl_type, a0 JTF_NUMBER_TABLE

272: end if;
273: end if;
274: end rosetta_table_copy_out_p5;
275:
276: procedure rosetta_table_copy_in_p8(t out nocopy okl_opd_pvt.opdv_tbl_type, a0 JTF_NUMBER_TABLE
277: , a1 JTF_NUMBER_TABLE
278: , a2 JTF_VARCHAR2_TABLE_100
279: , a3 JTF_NUMBER_TABLE
280: , a4 JTF_NUMBER_TABLE

Line 329: procedure rosetta_table_copy_out_p8(t okl_opd_pvt.opdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p8;
329: procedure rosetta_table_copy_out_p8(t okl_opd_pvt.opdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_NUMBER_TABLE
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_NUMBER_TABLE
333: , a4 out nocopy JTF_NUMBER_TABLE

Line 482: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;

478: , p5_a17 NUMBER := 0-1962.0724
479: )
480:
481: as
482: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;
483: ddx_opdv_rec okl_opd_pvt.opdv_rec_type;
484: ddindx binary_integer; indx binary_integer;
485: begin
486:

Line 483: ddx_opdv_rec okl_opd_pvt.opdv_rec_type;

479: )
480:
481: as
482: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;
483: ddx_opdv_rec okl_opd_pvt.opdv_rec_type;
484: ddindx binary_integer; indx binary_integer;
485: begin
486:
487: -- copy data to the local IN or IN-OUT args, if any

Line 514: okl_opd_pvt.insert_row(p_api_version,

510: ddp_opdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
511:
512:
513: -- here's the delegated call to the old PL/SQL routine
514: okl_opd_pvt.insert_row(p_api_version,
515: p_init_msg_list,
516: x_return_status,
517: x_msg_count,
518: x_msg_data,

Line 593: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;

589: , p6_a17 out nocopy JTF_NUMBER_TABLE
590: )
591:
592: as
593: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;
594: ddx_opdv_tbl okl_opd_pvt.opdv_tbl_type;
595: ddindx binary_integer; indx binary_integer;
596: begin
597:

Line 594: ddx_opdv_tbl okl_opd_pvt.opdv_tbl_type;

590: )
591:
592: as
593: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;
594: ddx_opdv_tbl okl_opd_pvt.opdv_tbl_type;
595: ddindx binary_integer; indx binary_integer;
596: begin
597:
598: -- copy data to the local IN or IN-OUT args, if any

Line 604: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0

600:
601:
602:
603:
604: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0
605: , p5_a1
606: , p5_a2
607: , p5_a3
608: , p5_a4

Line 626: okl_opd_pvt.insert_row(p_api_version,

622: );
623:
624:
625: -- here's the delegated call to the old PL/SQL routine
626: okl_opd_pvt.insert_row(p_api_version,
627: p_init_msg_list,
628: x_return_status,
629: x_msg_count,
630: x_msg_data,

Line 641: okl_opd_pvt_w.rosetta_table_copy_out_p8(ddx_opdv_tbl, p6_a0

637:
638:
639:
640:
641: okl_opd_pvt_w.rosetta_table_copy_out_p8(ddx_opdv_tbl, p6_a0
642: , p6_a1
643: , p6_a2
644: , p6_a3
645: , p6_a4

Line 688: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;

684: , p5_a17 NUMBER := 0-1962.0724
685: )
686:
687: as
688: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;
689: ddindx binary_integer; indx binary_integer;
690: begin
691:
692: -- copy data to the local IN or IN-OUT args, if any

Line 718: okl_opd_pvt.lock_row(p_api_version,

714: ddp_opdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
715: ddp_opdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
716:
717: -- here's the delegated call to the old PL/SQL routine
718: okl_opd_pvt.lock_row(p_api_version,
719: p_init_msg_list,
720: x_return_status,
721: x_msg_count,
722: x_msg_data,

Line 759: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;

755: , p5_a17 JTF_NUMBER_TABLE
756: )
757:
758: as
759: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;
760: ddindx binary_integer; indx binary_integer;
761: begin
762:
763: -- copy data to the local IN or IN-OUT args, if any

Line 769: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0

765:
766:
767:
768:
769: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0
770: , p5_a1
771: , p5_a2
772: , p5_a3
773: , p5_a4

Line 790: okl_opd_pvt.lock_row(p_api_version,

786: , p5_a17
787: );
788:
789: -- here's the delegated call to the old PL/SQL routine
790: okl_opd_pvt.lock_row(p_api_version,
791: p_init_msg_list,
792: x_return_status,
793: x_msg_count,
794: x_msg_data,

Line 849: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;

845: , p5_a17 NUMBER := 0-1962.0724
846: )
847:
848: as
849: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;
850: ddx_opdv_rec okl_opd_pvt.opdv_rec_type;
851: ddindx binary_integer; indx binary_integer;
852: begin
853:

Line 850: ddx_opdv_rec okl_opd_pvt.opdv_rec_type;

846: )
847:
848: as
849: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;
850: ddx_opdv_rec okl_opd_pvt.opdv_rec_type;
851: ddindx binary_integer; indx binary_integer;
852: begin
853:
854: -- copy data to the local IN or IN-OUT args, if any

Line 881: okl_opd_pvt.update_row(p_api_version,

877: ddp_opdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
878:
879:
880: -- here's the delegated call to the old PL/SQL routine
881: okl_opd_pvt.update_row(p_api_version,
882: p_init_msg_list,
883: x_return_status,
884: x_msg_count,
885: x_msg_data,

Line 960: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;

956: , p6_a17 out nocopy JTF_NUMBER_TABLE
957: )
958:
959: as
960: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;
961: ddx_opdv_tbl okl_opd_pvt.opdv_tbl_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:

Line 961: ddx_opdv_tbl okl_opd_pvt.opdv_tbl_type;

957: )
958:
959: as
960: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;
961: ddx_opdv_tbl okl_opd_pvt.opdv_tbl_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:
965: -- copy data to the local IN or IN-OUT args, if any

Line 971: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0

967:
968:
969:
970:
971: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0
972: , p5_a1
973: , p5_a2
974: , p5_a3
975: , p5_a4

Line 993: okl_opd_pvt.update_row(p_api_version,

989: );
990:
991:
992: -- here's the delegated call to the old PL/SQL routine
993: okl_opd_pvt.update_row(p_api_version,
994: p_init_msg_list,
995: x_return_status,
996: x_msg_count,
997: x_msg_data,

Line 1008: okl_opd_pvt_w.rosetta_table_copy_out_p8(ddx_opdv_tbl, p6_a0

1004:
1005:
1006:
1007:
1008: okl_opd_pvt_w.rosetta_table_copy_out_p8(ddx_opdv_tbl, p6_a0
1009: , p6_a1
1010: , p6_a2
1011: , p6_a3
1012: , p6_a4

Line 1055: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;

1051: , p5_a17 NUMBER := 0-1962.0724
1052: )
1053:
1054: as
1055: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;
1056: ddindx binary_integer; indx binary_integer;
1057: begin
1058:
1059: -- copy data to the local IN or IN-OUT args, if any

Line 1085: okl_opd_pvt.delete_row(p_api_version,

1081: ddp_opdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
1082: ddp_opdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
1083:
1084: -- here's the delegated call to the old PL/SQL routine
1085: okl_opd_pvt.delete_row(p_api_version,
1086: p_init_msg_list,
1087: x_return_status,
1088: x_msg_count,
1089: x_msg_data,

Line 1126: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;

1122: , p5_a17 JTF_NUMBER_TABLE
1123: )
1124:
1125: as
1126: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;
1127: ddindx binary_integer; indx binary_integer;
1128: begin
1129:
1130: -- copy data to the local IN or IN-OUT args, if any

Line 1136: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0

1132:
1133:
1134:
1135:
1136: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0
1137: , p5_a1
1138: , p5_a2
1139: , p5_a3
1140: , p5_a4

Line 1157: okl_opd_pvt.delete_row(p_api_version,

1153: , p5_a17
1154: );
1155:
1156: -- here's the delegated call to the old PL/SQL routine
1157: okl_opd_pvt.delete_row(p_api_version,
1158: p_init_msg_list,
1159: x_return_status,
1160: x_msg_count,
1161: x_msg_data,

Line 1198: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;

1194: , p5_a17 NUMBER := 0-1962.0724
1195: )
1196:
1197: as
1198: ddp_opdv_rec okl_opd_pvt.opdv_rec_type;
1199: ddindx binary_integer; indx binary_integer;
1200: begin
1201:
1202: -- copy data to the local IN or IN-OUT args, if any

Line 1228: okl_opd_pvt.validate_row(p_api_version,

1224: ddp_opdv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
1225: ddp_opdv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
1226:
1227: -- here's the delegated call to the old PL/SQL routine
1228: okl_opd_pvt.validate_row(p_api_version,
1229: p_init_msg_list,
1230: x_return_status,
1231: x_msg_count,
1232: x_msg_data,

Line 1269: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;

1265: , p5_a17 JTF_NUMBER_TABLE
1266: )
1267:
1268: as
1269: ddp_opdv_tbl okl_opd_pvt.opdv_tbl_type;
1270: ddindx binary_integer; indx binary_integer;
1271: begin
1272:
1273: -- copy data to the local IN or IN-OUT args, if any

Line 1279: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0

1275:
1276:
1277:
1278:
1279: okl_opd_pvt_w.rosetta_table_copy_in_p8(ddp_opdv_tbl, p5_a0
1280: , p5_a1
1281: , p5_a2
1282: , p5_a3
1283: , p5_a4

Line 1300: okl_opd_pvt.validate_row(p_api_version,

1296: , p5_a17
1297: );
1298:
1299: -- here's the delegated call to the old PL/SQL routine
1300: okl_opd_pvt.validate_row(p_api_version,
1301: p_init_msg_list,
1302: x_return_status,
1303: x_msg_count,
1304: x_msg_data,

Line 1315: end okl_opd_pvt_w;

1311:
1312:
1313: end;
1314:
1315: end okl_opd_pvt_w;