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.IEX_SCORE_PUB_W dependencies on IEX_SCORE_PUB

Line 1: package body iex_score_pub_w as

1: package body iex_score_pub_w as
2: /* $Header: iexwscrb.pls 120.6 2004/11/08 19:20:08 clchang ship $ */
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 13: procedure rosetta_table_copy_in_p1(t out nocopy iex_score_pub.score_eng_comp_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iex_score_pub.score_eng_comp_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_VARCHAR2_TABLE_2000
17: ) as

Line 38: procedure rosetta_table_copy_out_p1(t iex_score_pub.score_eng_comp_tbl, a0 out nocopy JTF_NUMBER_TABLE

34: end loop;
35: end if;
36: end if;
37: end rosetta_table_copy_in_p1;
38: procedure rosetta_table_copy_out_p1(t iex_score_pub.score_eng_comp_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
42: ) as

Line 77: procedure rosetta_table_copy_in_p3(t out nocopy iex_score_pub.score_tbl_type, a0 JTF_NUMBER_TABLE

73: end if;
74: end if;
75: end rosetta_table_copy_out_p1;
76:
77: procedure rosetta_table_copy_in_p3(t out nocopy iex_score_pub.score_tbl_type, a0 JTF_NUMBER_TABLE
78: , a1 JTF_VARCHAR2_TABLE_300
79: , a2 JTF_DATE_TABLE
80: , a3 JTF_NUMBER_TABLE
81: , a4 JTF_DATE_TABLE

Line 144: procedure rosetta_table_copy_out_p3(t iex_score_pub.score_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

140: end loop;
141: end if;
142: end if;
143: end rosetta_table_copy_in_p3;
144: procedure rosetta_table_copy_out_p3(t iex_score_pub.score_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
145: , a1 out nocopy JTF_VARCHAR2_TABLE_300
146: , a2 out nocopy JTF_DATE_TABLE
147: , a3 out nocopy JTF_NUMBER_TABLE
148: , a4 out nocopy JTF_DATE_TABLE

Line 288: procedure rosetta_table_copy_in_p7(t out nocopy iex_score_pub.score_comp_tbl_type, a0 JTF_NUMBER_TABLE

284: end if;
285: end if;
286: end rosetta_table_copy_out_p3;
287:
288: procedure rosetta_table_copy_in_p7(t out nocopy iex_score_pub.score_comp_tbl_type, a0 JTF_NUMBER_TABLE
289: , a1 JTF_NUMBER_TABLE
290: , a2 JTF_NUMBER_TABLE
291: , a3 JTF_VARCHAR2_TABLE_100
292: , a4 JTF_NUMBER_TABLE

Line 325: procedure rosetta_table_copy_out_p7(t iex_score_pub.score_comp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

321: end loop;
322: end if;
323: end if;
324: end rosetta_table_copy_in_p7;
325: procedure rosetta_table_copy_out_p7(t iex_score_pub.score_comp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
326: , a1 out nocopy JTF_NUMBER_TABLE
327: , a2 out nocopy JTF_NUMBER_TABLE
328: , a3 out nocopy JTF_VARCHAR2_TABLE_100
329: , a4 out nocopy JTF_NUMBER_TABLE

Line 394: procedure rosetta_table_copy_in_p11(t out nocopy iex_score_pub.score_comp_det_tbl_type, a0 JTF_NUMBER_TABLE

390: end if;
391: end if;
392: end rosetta_table_copy_out_p7;
393:
394: procedure rosetta_table_copy_in_p11(t out nocopy iex_score_pub.score_comp_det_tbl_type, a0 JTF_NUMBER_TABLE
395: , a1 JTF_NUMBER_TABLE
396: , a2 JTF_NUMBER_TABLE
397: , a3 JTF_NUMBER_TABLE
398: , a4 JTF_VARCHAR2_TABLE_2000

Line 437: procedure rosetta_table_copy_out_p11(t iex_score_pub.score_comp_det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

433: end loop;
434: end if;
435: end if;
436: end rosetta_table_copy_in_p11;
437: procedure rosetta_table_copy_out_p11(t iex_score_pub.score_comp_det_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
438: , a1 out nocopy JTF_NUMBER_TABLE
439: , a2 out nocopy JTF_NUMBER_TABLE
440: , a3 out nocopy JTF_NUMBER_TABLE
441: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 521: procedure rosetta_table_copy_in_p15(t out nocopy iex_score_pub.score_comp_type_tbl_type, a0 JTF_NUMBER_TABLE

517: end if;
518: end if;
519: end rosetta_table_copy_out_p11;
520:
521: procedure rosetta_table_copy_in_p15(t out nocopy iex_score_pub.score_comp_type_tbl_type, a0 JTF_NUMBER_TABLE
522: , a1 JTF_NUMBER_TABLE
523: , a2 JTF_NUMBER_TABLE
524: , a3 JTF_NUMBER_TABLE
525: , a4 JTF_DATE_TABLE

Line 574: procedure rosetta_table_copy_out_p15(t iex_score_pub.score_comp_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

570: end loop;
571: end if;
572: end if;
573: end rosetta_table_copy_in_p15;
574: procedure rosetta_table_copy_out_p15(t iex_score_pub.score_comp_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
575: , a1 out nocopy JTF_NUMBER_TABLE
576: , a2 out nocopy JTF_NUMBER_TABLE
577: , a3 out nocopy JTF_NUMBER_TABLE
578: , a4 out nocopy JTF_DATE_TABLE

Line 683: procedure rosetta_table_copy_in_p18(t out nocopy iex_score_pub.score_id_tbl, a0 JTF_NUMBER_TABLE) as

679: end if;
680: end if;
681: end rosetta_table_copy_out_p15;
682:
683: procedure rosetta_table_copy_in_p18(t out nocopy iex_score_pub.score_id_tbl, a0 JTF_NUMBER_TABLE) as
684: ddindx binary_integer; indx binary_integer;
685: begin
686: if a0 is not null and a0.count > 0 then
687: if a0.count > 0 then

Line 701: procedure rosetta_table_copy_out_p18(t iex_score_pub.score_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

697: end loop;
698: end if;
699: end if;
700: end rosetta_table_copy_in_p18;
701: procedure rosetta_table_copy_out_p18(t iex_score_pub.score_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
702: ddindx binary_integer; indx binary_integer;
703: begin
704: if t is null or t.count = 0 then
705: a0 := JTF_NUMBER_TABLE();

Line 724: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE) as

720: end if;
721: end if;
722: end rosetta_table_copy_out_p18;
723:
724: procedure rosetta_table_copy_in_p19(t out nocopy iex_score_pub.score_comp_id_tbl, a0 JTF_NUMBER_TABLE) as
725: ddindx binary_integer; indx binary_integer;
726: begin
727: if a0 is not null and a0.count > 0 then
728: if a0.count > 0 then

Line 742: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

738: end loop;
739: end if;
740: end if;
741: end rosetta_table_copy_in_p19;
742: procedure rosetta_table_copy_out_p19(t iex_score_pub.score_comp_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
743: ddindx binary_integer; indx binary_integer;
744: begin
745: if t is null or t.count = 0 then
746: a0 := JTF_NUMBER_TABLE();

Line 765: procedure rosetta_table_copy_in_p20(t out nocopy iex_score_pub.score_comp_det_id_tbl, a0 JTF_NUMBER_TABLE) as

761: end if;
762: end if;
763: end rosetta_table_copy_out_p19;
764:
765: procedure rosetta_table_copy_in_p20(t out nocopy iex_score_pub.score_comp_det_id_tbl, a0 JTF_NUMBER_TABLE) as
766: ddindx binary_integer; indx binary_integer;
767: begin
768: if a0 is not null and a0.count > 0 then
769: if a0.count > 0 then

Line 783: procedure rosetta_table_copy_out_p20(t iex_score_pub.score_comp_det_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

779: end loop;
780: end if;
781: end if;
782: end rosetta_table_copy_in_p20;
783: procedure rosetta_table_copy_out_p20(t iex_score_pub.score_comp_det_id_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
784: ddindx binary_integer; indx binary_integer;
785: begin
786: if t is null or t.count = 0 then
787: a0 := JTF_NUMBER_TABLE();

Line 842: ddp_score_rec iex_score_pub.score_rec_type;

838: , x_score_id out nocopy NUMBER
839: )
840:
841: as
842: ddp_score_rec iex_score_pub.score_rec_type;
843: ddindx binary_integer; indx binary_integer;
844: begin
845:
846: -- copy data to the local IN or IN-OUT args, if any

Line 882: iex_score_pub.create_score(p_api_version,

878:
879:
880:
881: -- here's the delegated call to the old PL/SQL routine
882: iex_score_pub.create_score(p_api_version,
883: p_init_msg_list,
884: p_commit,
885: ddp_score_rec,
886: x_dup_status,

Line 938: ddp_score_tbl iex_score_pub.score_tbl_type;

934: , x_msg_data out nocopy VARCHAR2
935: )
936:
937: as
938: ddp_score_tbl iex_score_pub.score_tbl_type;
939: ddindx binary_integer; indx binary_integer;
940: begin
941:
942: -- copy data to the local IN or IN-OUT args, if any

Line 946: iex_score_pub_w.rosetta_table_copy_in_p3(ddp_score_tbl, p3_a0

942: -- copy data to the local IN or IN-OUT args, if any
943:
944:
945:
946: iex_score_pub_w.rosetta_table_copy_in_p3(ddp_score_tbl, p3_a0
947: , p3_a1
948: , p3_a2
949: , p3_a3
950: , p3_a4

Line 978: iex_score_pub.update_score(p_api_version,

974:
975:
976:
977: -- here's the delegated call to the old PL/SQL routine
978: iex_score_pub.update_score(p_api_version,
979: p_init_msg_list,
980: p_commit,
981: ddp_score_tbl,
982: x_dup_status,

Line 1007: ddp_score_id_tbl iex_score_pub.score_id_tbl;

1003: , x_msg_data out nocopy VARCHAR2
1004: )
1005:
1006: as
1007: ddp_score_id_tbl iex_score_pub.score_id_tbl;
1008: ddindx binary_integer; indx binary_integer;
1009: begin
1010:
1011: -- copy data to the local IN or IN-OUT args, if any

Line 1015: iex_score_pub_w.rosetta_table_copy_in_p18(ddp_score_id_tbl, p_score_id_tbl);

1011: -- copy data to the local IN or IN-OUT args, if any
1012:
1013:
1014:
1015: iex_score_pub_w.rosetta_table_copy_in_p18(ddp_score_id_tbl, p_score_id_tbl);
1016:
1017:
1018:
1019:

Line 1021: iex_score_pub.delete_score(p_api_version,

1017:
1018:
1019:
1020: -- here's the delegated call to the old PL/SQL routine
1021: iex_score_pub.delete_score(p_api_version,
1022: p_init_msg_list,
1023: p_commit,
1024: ddp_score_id_tbl,
1025: x_return_status,

Line 1058: ddp_score_comp_rec iex_score_pub.score_comp_rec_type;

1054: , x_score_comp_id out nocopy NUMBER
1055: )
1056:
1057: as
1058: ddp_score_comp_rec iex_score_pub.score_comp_rec_type;
1059: ddindx binary_integer; indx binary_integer;
1060: begin
1061:
1062: -- copy data to the local IN or IN-OUT args, if any

Line 1082: iex_score_pub.create_score_comp(p_api_version,

1078:
1079:
1080:
1081: -- here's the delegated call to the old PL/SQL routine
1082: iex_score_pub.create_score_comp(p_api_version,
1083: p_init_msg_list,
1084: p_commit,
1085: ddp_score_comp_rec,
1086: x_return_status,

Line 1120: ddp_score_comp_tbl iex_score_pub.score_comp_tbl_type;

1116: , x_msg_data out nocopy VARCHAR2
1117: )
1118:
1119: as
1120: ddp_score_comp_tbl iex_score_pub.score_comp_tbl_type;
1121: ddindx binary_integer; indx binary_integer;
1122: begin
1123:
1124: -- copy data to the local IN or IN-OUT args, if any

Line 1128: iex_score_pub_w.rosetta_table_copy_in_p7(ddp_score_comp_tbl, p3_a0

1124: -- copy data to the local IN or IN-OUT args, if any
1125:
1126:
1127:
1128: iex_score_pub_w.rosetta_table_copy_in_p7(ddp_score_comp_tbl, p3_a0
1129: , p3_a1
1130: , p3_a2
1131: , p3_a3
1132: , p3_a4

Line 1144: iex_score_pub.update_score_comp(p_api_version,

1140:
1141:
1142:
1143: -- here's the delegated call to the old PL/SQL routine
1144: iex_score_pub.update_score_comp(p_api_version,
1145: p_init_msg_list,
1146: p_commit,
1147: ddp_score_comp_tbl,
1148: x_return_status,

Line 1172: ddp_score_comp_id_tbl iex_score_pub.score_comp_id_tbl;

1168: , x_msg_data out nocopy VARCHAR2
1169: )
1170:
1171: as
1172: ddp_score_comp_id_tbl iex_score_pub.score_comp_id_tbl;
1173: ddindx binary_integer; indx binary_integer;
1174: begin
1175:
1176: -- copy data to the local IN or IN-OUT args, if any

Line 1181: iex_score_pub_w.rosetta_table_copy_in_p19(ddp_score_comp_id_tbl, p_score_comp_id_tbl);

1177:
1178:
1179:
1180:
1181: iex_score_pub_w.rosetta_table_copy_in_p19(ddp_score_comp_id_tbl, p_score_comp_id_tbl);
1182:
1183:
1184:
1185:

Line 1187: iex_score_pub.delete_score_comp(p_api_version,

1183:
1184:
1185:
1186: -- here's the delegated call to the old PL/SQL routine
1187: iex_score_pub.delete_score_comp(p_api_version,
1188: p_init_msg_list,
1189: p_commit,
1190: p_score_id,
1191: ddp_score_comp_id_tbl,

Line 1235: ddp_score_comp_type_rec iex_score_pub.score_comp_type_rec_type;

1231: , x_score_comp_type_id out nocopy NUMBER
1232: )
1233:
1234: as
1235: ddp_score_comp_type_rec iex_score_pub.score_comp_type_rec_type;
1236: ddindx binary_integer; indx binary_integer;
1237: begin
1238:
1239: -- copy data to the local IN or IN-OUT args, if any

Line 1268: iex_score_pub.create_score_comp_type(p_api_version,

1264:
1265:
1266:
1267: -- here's the delegated call to the old PL/SQL routine
1268: iex_score_pub.create_score_comp_type(p_api_version,
1269: p_init_msg_list,
1270: p_commit,
1271: ddp_score_comp_type_rec,
1272: x_dup_status,

Line 1317: ddp_score_comp_type_tbl iex_score_pub.score_comp_type_tbl_type;

1313: , x_msg_data out nocopy VARCHAR2
1314: )
1315:
1316: as
1317: ddp_score_comp_type_tbl iex_score_pub.score_comp_type_tbl_type;
1318: ddindx binary_integer; indx binary_integer;
1319: begin
1320:
1321: -- copy data to the local IN or IN-OUT args, if any

Line 1325: iex_score_pub_w.rosetta_table_copy_in_p15(ddp_score_comp_type_tbl, p3_a0

1321: -- copy data to the local IN or IN-OUT args, if any
1322:
1323:
1324:
1325: iex_score_pub_w.rosetta_table_copy_in_p15(ddp_score_comp_type_tbl, p3_a0
1326: , p3_a1
1327: , p3_a2
1328: , p3_a3
1329: , p3_a4

Line 1350: iex_score_pub.update_score_comp_type(p_api_version,

1346:
1347:
1348:
1349: -- here's the delegated call to the old PL/SQL routine
1350: iex_score_pub.update_score_comp_type(p_api_version,
1351: p_init_msg_list,
1352: p_commit,
1353: ddp_score_comp_type_tbl,
1354: x_dup_status,

Line 1396: ddp_score_comp_type_tbl iex_score_pub.score_comp_type_tbl_type;

1392: , x_msg_data out nocopy VARCHAR2
1393: )
1394:
1395: as
1396: ddp_score_comp_type_tbl iex_score_pub.score_comp_type_tbl_type;
1397: ddindx binary_integer; indx binary_integer;
1398: begin
1399:
1400: -- copy data to the local IN or IN-OUT args, if any

Line 1404: iex_score_pub_w.rosetta_table_copy_in_p15(ddp_score_comp_type_tbl, p3_a0

1400: -- copy data to the local IN or IN-OUT args, if any
1401:
1402:
1403:
1404: iex_score_pub_w.rosetta_table_copy_in_p15(ddp_score_comp_type_tbl, p3_a0
1405: , p3_a1
1406: , p3_a2
1407: , p3_a3
1408: , p3_a4

Line 1428: iex_score_pub.delete_score_comp_type(p_api_version,

1424:
1425:
1426:
1427: -- here's the delegated call to the old PL/SQL routine
1428: iex_score_pub.delete_score_comp_type(p_api_version,
1429: p_init_msg_list,
1430: p_commit,
1431: ddp_score_comp_type_tbl,
1432: x_return_status,

Line 1467: ddpx_score_comp_det_tbl iex_score_pub.score_comp_det_tbl_type;

1463: , x_msg_data out nocopy VARCHAR2
1464: )
1465:
1466: as
1467: ddpx_score_comp_det_tbl iex_score_pub.score_comp_det_tbl_type;
1468: ddindx binary_integer; indx binary_integer;
1469: begin
1470:
1471: -- copy data to the local IN or IN-OUT args, if any

Line 1475: iex_score_pub_w.rosetta_table_copy_in_p11(ddpx_score_comp_det_tbl, p3_a0

1471: -- copy data to the local IN or IN-OUT args, if any
1472:
1473:
1474:
1475: iex_score_pub_w.rosetta_table_copy_in_p11(ddpx_score_comp_det_tbl, p3_a0
1476: , p3_a1
1477: , p3_a2
1478: , p3_a3
1479: , p3_a4

Line 1494: iex_score_pub.create_score_comp_det(p_api_version,

1490:
1491:
1492:
1493: -- here's the delegated call to the old PL/SQL routine
1494: iex_score_pub.create_score_comp_det(p_api_version,
1495: p_init_msg_list,
1496: p_commit,
1497: ddpx_score_comp_det_tbl,
1498: x_return_status,

Line 1506: iex_score_pub_w.rosetta_table_copy_out_p11(ddpx_score_comp_det_tbl, p3_a0

1502: -- copy data back from the local variables to OUT or IN-OUT args, if any
1503:
1504:
1505:
1506: iex_score_pub_w.rosetta_table_copy_out_p11(ddpx_score_comp_det_tbl, p3_a0
1507: , p3_a1
1508: , p3_a2
1509: , p3_a3
1510: , p3_a4

Line 1547: ddp_score_comp_det_tbl iex_score_pub.score_comp_det_tbl_type;

1543: , x_msg_data out nocopy VARCHAR2
1544: )
1545:
1546: as
1547: ddp_score_comp_det_tbl iex_score_pub.score_comp_det_tbl_type;
1548: ddindx binary_integer; indx binary_integer;
1549: begin
1550:
1551: -- copy data to the local IN or IN-OUT args, if any

Line 1555: iex_score_pub_w.rosetta_table_copy_in_p11(ddp_score_comp_det_tbl, p3_a0

1551: -- copy data to the local IN or IN-OUT args, if any
1552:
1553:
1554:
1555: iex_score_pub_w.rosetta_table_copy_in_p11(ddp_score_comp_det_tbl, p3_a0
1556: , p3_a1
1557: , p3_a2
1558: , p3_a3
1559: , p3_a4

Line 1574: iex_score_pub.update_score_comp_det(p_api_version,

1570:
1571:
1572:
1573: -- here's the delegated call to the old PL/SQL routine
1574: iex_score_pub.update_score_comp_det(p_api_version,
1575: p_init_msg_list,
1576: p_commit,
1577: ddp_score_comp_det_tbl,
1578: x_return_status,

Line 1602: ddp_score_comp_det_id_tbl iex_score_pub.score_comp_det_id_tbl;

1598: , x_msg_data out nocopy VARCHAR2
1599: )
1600:
1601: as
1602: ddp_score_comp_det_id_tbl iex_score_pub.score_comp_det_id_tbl;
1603: ddindx binary_integer; indx binary_integer;
1604: begin
1605:
1606: -- copy data to the local IN or IN-OUT args, if any

Line 1611: iex_score_pub_w.rosetta_table_copy_in_p20(ddp_score_comp_det_id_tbl, p_score_comp_det_id_tbl);

1607:
1608:
1609:
1610:
1611: iex_score_pub_w.rosetta_table_copy_in_p20(ddp_score_comp_det_id_tbl, p_score_comp_det_id_tbl);
1612:
1613:
1614:
1615:

Line 1617: iex_score_pub.delete_score_comp_det(p_api_version,

1613:
1614:
1615:
1616: -- here's the delegated call to the old PL/SQL routine
1617: iex_score_pub.delete_score_comp_det(p_api_version,
1618: p_init_msg_list,
1619: p_commit,
1620: p_score_comp_id,
1621: ddp_score_comp_det_id_tbl,

Line 1636: end iex_score_pub_w;

1632:
1633:
1634: end;
1635:
1636: end iex_score_pub_w;