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_SEL_PVT_W dependencies on OKL_SEL_PVT

Line 1: package body okl_sel_pvt_w as

1: package body okl_sel_pvt_w as
2: /* $Header: OKLISELB.pls 120.2 2005/06/24 03:14:44 hkpatel 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_sel_pvt.sel_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_sel_pvt.sel_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 87: procedure rosetta_table_copy_out_p2(t okl_sel_pvt.sel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

83: end loop;
84: end if;
85: end if;
86: end rosetta_table_copy_in_p2;
87: procedure rosetta_table_copy_out_p2(t okl_sel_pvt.sel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
88: , a1 out nocopy JTF_NUMBER_TABLE
89: , a2 out nocopy JTF_NUMBER_TABLE
90: , a3 out nocopy JTF_DATE_TABLE
91: , a4 out nocopy JTF_NUMBER_TABLE

Line 226: procedure rosetta_table_copy_in_p5(t out nocopy okl_sel_pvt.selv_tbl_type, a0 JTF_NUMBER_TABLE

222: end if;
223: end if;
224: end rosetta_table_copy_out_p2;
225:
226: procedure rosetta_table_copy_in_p5(t out nocopy okl_sel_pvt.selv_tbl_type, a0 JTF_NUMBER_TABLE
227: , a1 JTF_NUMBER_TABLE
228: , a2 JTF_NUMBER_TABLE
229: , a3 JTF_NUMBER_TABLE
230: , a4 JTF_VARCHAR2_TABLE_2000

Line 293: procedure rosetta_table_copy_out_p5(t okl_sel_pvt.selv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t okl_sel_pvt.selv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 495: ddp_selv_rec okl_sel_pvt.selv_rec_type;

491: , p5_a24 DATE := fnd_api.g_miss_date
492: )
493:
494: as
495: ddp_selv_rec okl_sel_pvt.selv_rec_type;
496: ddx_selv_rec okl_sel_pvt.selv_rec_type;
497: ddindx binary_integer; indx binary_integer;
498: begin
499:

Line 496: ddx_selv_rec okl_sel_pvt.selv_rec_type;

492: )
493:
494: as
495: ddp_selv_rec okl_sel_pvt.selv_rec_type;
496: ddx_selv_rec okl_sel_pvt.selv_rec_type;
497: ddindx binary_integer; indx binary_integer;
498: begin
499:
500: -- copy data to the local IN or IN-OUT args, if any

Line 534: okl_sel_pvt.insert_row(p_api_version,

530: ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
531:
532:
533: -- here's the delegated call to the old PL/SQL routine
534: okl_sel_pvt.insert_row(p_api_version,
535: p_init_msg_list,
536: x_return_status,
537: x_msg_count,
538: x_msg_data,

Line 634: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;

630: , p6_a24 out nocopy JTF_DATE_TABLE
631: )
632:
633: as
634: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;
635: ddx_selv_tbl okl_sel_pvt.selv_tbl_type;
636: ddindx binary_integer; indx binary_integer;
637: begin
638:

Line 635: ddx_selv_tbl okl_sel_pvt.selv_tbl_type;

631: )
632:
633: as
634: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;
635: ddx_selv_tbl okl_sel_pvt.selv_tbl_type;
636: ddindx binary_integer; indx binary_integer;
637: begin
638:
639: -- copy data to the local IN or IN-OUT args, if any

Line 645: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0

641:
642:
643:
644:
645: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
646: , p5_a1
647: , p5_a2
648: , p5_a3
649: , p5_a4

Line 674: okl_sel_pvt.insert_row(p_api_version,

670: );
671:
672:
673: -- here's the delegated call to the old PL/SQL routine
674: okl_sel_pvt.insert_row(p_api_version,
675: p_init_msg_list,
676: x_return_status,
677: x_msg_count,
678: x_msg_data,

Line 689: okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p6_a0

685:
686:
687:
688:
689: okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p6_a0
690: , p6_a1
691: , p6_a2
692: , p6_a3
693: , p6_a4

Line 750: ddp_selv_rec okl_sel_pvt.selv_rec_type;

746: , p5_a24 DATE := fnd_api.g_miss_date
747: )
748:
749: as
750: ddp_selv_rec okl_sel_pvt.selv_rec_type;
751: ddindx binary_integer; indx binary_integer;
752: begin
753:
754: -- copy data to the local IN or IN-OUT args, if any

Line 787: okl_sel_pvt.lock_row(p_api_version,

783: ddp_selv_rec.accrual_adj_flag := p5_a23;
784: ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
785:
786: -- here's the delegated call to the old PL/SQL routine
787: okl_sel_pvt.lock_row(p_api_version,
788: p_init_msg_list,
789: x_return_status,
790: x_msg_count,
791: x_msg_data,

Line 835: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;

831: , p5_a24 JTF_DATE_TABLE
832: )
833:
834: as
835: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:
839: -- copy data to the local IN or IN-OUT args, if any

Line 845: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0

841:
842:
843:
844:
845: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
846: , p5_a1
847: , p5_a2
848: , p5_a3
849: , p5_a4

Line 873: okl_sel_pvt.lock_row(p_api_version,

869: , p5_a24
870: );
871:
872: -- here's the delegated call to the old PL/SQL routine
873: okl_sel_pvt.lock_row(p_api_version,
874: p_init_msg_list,
875: x_return_status,
876: x_msg_count,
877: x_msg_data,

Line 946: ddp_selv_rec okl_sel_pvt.selv_rec_type;

942: , p5_a24 DATE := fnd_api.g_miss_date
943: )
944:
945: as
946: ddp_selv_rec okl_sel_pvt.selv_rec_type;
947: ddx_selv_rec okl_sel_pvt.selv_rec_type;
948: ddindx binary_integer; indx binary_integer;
949: begin
950:

Line 947: ddx_selv_rec okl_sel_pvt.selv_rec_type;

943: )
944:
945: as
946: ddp_selv_rec okl_sel_pvt.selv_rec_type;
947: ddx_selv_rec okl_sel_pvt.selv_rec_type;
948: ddindx binary_integer; indx binary_integer;
949: begin
950:
951: -- copy data to the local IN or IN-OUT args, if any

Line 985: okl_sel_pvt.update_row(p_api_version,

981: ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
982:
983:
984: -- here's the delegated call to the old PL/SQL routine
985: okl_sel_pvt.update_row(p_api_version,
986: p_init_msg_list,
987: x_return_status,
988: x_msg_count,
989: x_msg_data,

Line 1085: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;

1081: , p6_a24 out nocopy JTF_DATE_TABLE
1082: )
1083:
1084: as
1085: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;
1086: ddx_selv_tbl okl_sel_pvt.selv_tbl_type;
1087: ddindx binary_integer; indx binary_integer;
1088: begin
1089:

Line 1086: ddx_selv_tbl okl_sel_pvt.selv_tbl_type;

1082: )
1083:
1084: as
1085: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;
1086: ddx_selv_tbl okl_sel_pvt.selv_tbl_type;
1087: ddindx binary_integer; indx binary_integer;
1088: begin
1089:
1090: -- copy data to the local IN or IN-OUT args, if any

Line 1096: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0

1092:
1093:
1094:
1095:
1096: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
1097: , p5_a1
1098: , p5_a2
1099: , p5_a3
1100: , p5_a4

Line 1125: okl_sel_pvt.update_row(p_api_version,

1121: );
1122:
1123:
1124: -- here's the delegated call to the old PL/SQL routine
1125: okl_sel_pvt.update_row(p_api_version,
1126: p_init_msg_list,
1127: x_return_status,
1128: x_msg_count,
1129: x_msg_data,

Line 1140: okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p6_a0

1136:
1137:
1138:
1139:
1140: okl_sel_pvt_w.rosetta_table_copy_out_p5(ddx_selv_tbl, p6_a0
1141: , p6_a1
1142: , p6_a2
1143: , p6_a3
1144: , p6_a4

Line 1201: ddp_selv_rec okl_sel_pvt.selv_rec_type;

1197: , p5_a24 DATE := fnd_api.g_miss_date
1198: )
1199:
1200: as
1201: ddp_selv_rec okl_sel_pvt.selv_rec_type;
1202: ddindx binary_integer; indx binary_integer;
1203: begin
1204:
1205: -- copy data to the local IN or IN-OUT args, if any

Line 1238: okl_sel_pvt.delete_row(p_api_version,

1234: ddp_selv_rec.accrual_adj_flag := p5_a23;
1235: ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
1236:
1237: -- here's the delegated call to the old PL/SQL routine
1238: okl_sel_pvt.delete_row(p_api_version,
1239: p_init_msg_list,
1240: x_return_status,
1241: x_msg_count,
1242: x_msg_data,

Line 1286: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;

1282: , p5_a24 JTF_DATE_TABLE
1283: )
1284:
1285: as
1286: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;
1287: ddindx binary_integer; indx binary_integer;
1288: begin
1289:
1290: -- copy data to the local IN or IN-OUT args, if any

Line 1296: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0

1292:
1293:
1294:
1295:
1296: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
1297: , p5_a1
1298: , p5_a2
1299: , p5_a3
1300: , p5_a4

Line 1324: okl_sel_pvt.delete_row(p_api_version,

1320: , p5_a24
1321: );
1322:
1323: -- here's the delegated call to the old PL/SQL routine
1324: okl_sel_pvt.delete_row(p_api_version,
1325: p_init_msg_list,
1326: x_return_status,
1327: x_msg_count,
1328: x_msg_data,

Line 1372: ddp_selv_rec okl_sel_pvt.selv_rec_type;

1368: , p5_a24 DATE := fnd_api.g_miss_date
1369: )
1370:
1371: as
1372: ddp_selv_rec okl_sel_pvt.selv_rec_type;
1373: ddindx binary_integer; indx binary_integer;
1374: begin
1375:
1376: -- copy data to the local IN or IN-OUT args, if any

Line 1409: okl_sel_pvt.validate_row(p_api_version,

1405: ddp_selv_rec.accrual_adj_flag := p5_a23;
1406: ddp_selv_rec.date_disbursed := rosetta_g_miss_date_in_map(p5_a24);
1407:
1408: -- here's the delegated call to the old PL/SQL routine
1409: okl_sel_pvt.validate_row(p_api_version,
1410: p_init_msg_list,
1411: x_return_status,
1412: x_msg_count,
1413: x_msg_data,

Line 1457: ddp_selv_tbl okl_sel_pvt.selv_tbl_type;

1453: , p5_a24 JTF_DATE_TABLE
1454: )
1455:
1456: as
1457: ddp_selv_tbl okl_sel_pvt.selv_tbl_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 1467: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0

1463:
1464:
1465:
1466:
1467: okl_sel_pvt_w.rosetta_table_copy_in_p5(ddp_selv_tbl, p5_a0
1468: , p5_a1
1469: , p5_a2
1470: , p5_a3
1471: , p5_a4

Line 1495: okl_sel_pvt.validate_row(p_api_version,

1491: , p5_a24
1492: );
1493:
1494: -- here's the delegated call to the old PL/SQL routine
1495: okl_sel_pvt.validate_row(p_api_version,
1496: p_init_msg_list,
1497: x_return_status,
1498: x_msg_count,
1499: x_msg_data,

Line 1510: end okl_sel_pvt_w;

1506:
1507:
1508: end;
1509:
1510: end okl_sel_pvt_w;