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_TMPT_SET_PUB_W dependencies on OKL_TMPT_SET_PUB

Line 1: package body okl_tmpt_set_pub_w as

1: package body okl_tmpt_set_pub_w as
2: /* $Header: OKLUAESB.pls 120.2 2005/10/30 03:47:59 appldev 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 210: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

206: , p5_a13 NUMBER := 0-1962.0724
207: )
208:
209: as
210: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
211: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
212: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
213: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
214: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

Line 211: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

207: )
208:
209: as
210: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
211: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
212: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
213: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
214: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
215: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

Line 212: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

208:
209: as
210: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
211: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
212: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
213: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
214: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
215: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
216: ddindx binary_integer; indx binary_integer;

Line 213: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

209: as
210: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
211: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
212: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
213: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
214: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
215: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
216: ddindx binary_integer; indx binary_integer;
217: begin

Line 214: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

210: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
211: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
212: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
213: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
214: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
215: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
216: ddindx binary_integer; indx binary_integer;
217: begin
218:

Line 215: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

211: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
212: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
213: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
214: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
215: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
216: ddindx binary_integer; indx binary_integer;
217: begin
218:
219: -- copy data to the local IN or IN-OUT args, if any

Line 324: okl_tmpt_set_pub.create_tmpt_set(p_api_version,

320:
321:
322:
323: -- here's the delegated call to the old PL/SQL routine
324: okl_tmpt_set_pub.create_tmpt_set(p_api_version,
325: p_init_msg_list,
326: x_return_status,
327: x_msg_count,
328: x_msg_data,

Line 629: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

625: , p5_a13 NUMBER := 0-1962.0724
626: )
627:
628: as
629: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
630: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
631: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
632: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
633: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

Line 630: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

626: )
627:
628: as
629: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
630: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
631: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
632: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
633: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
634: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

Line 631: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

627:
628: as
629: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
630: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
631: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
632: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
633: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
634: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
635: ddindx binary_integer; indx binary_integer;

Line 632: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

628: as
629: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
630: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
631: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
632: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
633: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
634: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
635: ddindx binary_integer; indx binary_integer;
636: begin

Line 633: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

629: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
630: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
631: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
632: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
633: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
634: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
635: ddindx binary_integer; indx binary_integer;
636: begin
637:

Line 634: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

630: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
631: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
632: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
633: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
634: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
635: ddindx binary_integer; indx binary_integer;
636: begin
637:
638: -- copy data to the local IN or IN-OUT args, if any

Line 743: okl_tmpt_set_pub.update_tmpt_set(p_api_version,

739:
740:
741:
742: -- here's the delegated call to the old PL/SQL routine
743: okl_tmpt_set_pub.update_tmpt_set(p_api_version,
744: p_init_msg_list,
745: x_return_status,
746: x_msg_count,
747: x_msg_data,

Line 958: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

954: , p5_a13 NUMBER := 0-1962.0724
955: )
956:
957: as
958: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
959: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
960: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
961: ddindx binary_integer; indx binary_integer;
962: begin

Line 959: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

955: )
956:
957: as
958: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
959: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
960: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
961: ddindx binary_integer; indx binary_integer;
962: begin
963:

Line 960: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

956:
957: as
958: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
959: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
960: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
961: ddindx binary_integer; indx binary_integer;
962: begin
963:
964: -- copy data to the local IN or IN-OUT args, if any

Line 1066: okl_tmpt_set_pub.validate_tmpt_set(p_api_version,

1062: , p7_a32
1063: );
1064:
1065: -- here's the delegated call to the old PL/SQL routine
1066: okl_tmpt_set_pub.validate_tmpt_set(p_api_version,
1067: p_init_msg_list,
1068: x_return_status,
1069: x_msg_count,
1070: x_msg_data,

Line 1121: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;

1117: , p6_a13 out nocopy JTF_NUMBER_TABLE
1118: )
1119:
1120: as
1121: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1122: ddx_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125:

Line 1122: ddx_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;

1118: )
1119:
1120: as
1121: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1122: ddx_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1123: ddindx binary_integer; indx binary_integer;
1124: begin
1125:
1126: -- copy data to the local IN or IN-OUT args, if any

Line 1150: okl_tmpt_set_pub.create_tmpt_set(p_api_version,

1146: );
1147:
1148:
1149: -- here's the delegated call to the old PL/SQL routine
1150: okl_tmpt_set_pub.create_tmpt_set(p_api_version,
1151: p_init_msg_list,
1152: x_return_status,
1153: x_msg_count,
1154: x_msg_data,

Line 1218: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

1214: , p5_a13 NUMBER := 0-1962.0724
1215: )
1216:
1217: as
1218: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1219: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1220: ddindx binary_integer; indx binary_integer;
1221: begin
1222:

Line 1219: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

1215: )
1216:
1217: as
1218: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1219: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1220: ddindx binary_integer; indx binary_integer;
1221: begin
1222:
1223: -- copy data to the local IN or IN-OUT args, if any

Line 1246: okl_tmpt_set_pub.create_tmpt_set(p_api_version,

1242: ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1243:
1244:
1245: -- here's the delegated call to the old PL/SQL routine
1246: okl_tmpt_set_pub.create_tmpt_set(p_api_version,
1247: p_init_msg_list,
1248: x_return_status,
1249: x_msg_count,
1250: x_msg_data,

Line 1299: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;

1295: , p5_a13 JTF_NUMBER_TABLE
1296: )
1297:
1298: as
1299: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1300: ddindx binary_integer; indx binary_integer;
1301: begin
1302:
1303: -- copy data to the local IN or IN-OUT args, if any

Line 1326: okl_tmpt_set_pub.lock_tmpt_set(p_api_version,

1322: , p5_a13
1323: );
1324:
1325: -- here's the delegated call to the old PL/SQL routine
1326: okl_tmpt_set_pub.lock_tmpt_set(p_api_version,
1327: p_init_msg_list,
1328: x_return_status,
1329: x_msg_count,
1330: x_msg_data,

Line 1363: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

1359: , p5_a13 NUMBER := 0-1962.0724
1360: )
1361:
1362: as
1363: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1364: ddindx binary_integer; indx binary_integer;
1365: begin
1366:
1367: -- copy data to the local IN or IN-OUT args, if any

Line 1389: okl_tmpt_set_pub.lock_tmpt_set(p_api_version,

1385: ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1386: ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1387:
1388: -- here's the delegated call to the old PL/SQL routine
1389: okl_tmpt_set_pub.lock_tmpt_set(p_api_version,
1390: p_init_msg_list,
1391: x_return_status,
1392: x_msg_count,
1393: x_msg_data,

Line 1440: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;

1436: , p6_a13 out nocopy JTF_NUMBER_TABLE
1437: )
1438:
1439: as
1440: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1441: ddx_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1442: ddindx binary_integer; indx binary_integer;
1443: begin
1444:

Line 1441: ddx_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;

1437: )
1438:
1439: as
1440: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1441: ddx_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1442: ddindx binary_integer; indx binary_integer;
1443: begin
1444:
1445: -- copy data to the local IN or IN-OUT args, if any

Line 1469: okl_tmpt_set_pub.update_tmpt_set(p_api_version,

1465: );
1466:
1467:
1468: -- here's the delegated call to the old PL/SQL routine
1469: okl_tmpt_set_pub.update_tmpt_set(p_api_version,
1470: p_init_msg_list,
1471: x_return_status,
1472: x_msg_count,
1473: x_msg_data,

Line 1537: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

1533: , p5_a13 NUMBER := 0-1962.0724
1534: )
1535:
1536: as
1537: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1538: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1539: ddindx binary_integer; indx binary_integer;
1540: begin
1541:

Line 1538: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

1534: )
1535:
1536: as
1537: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1538: ddx_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1539: ddindx binary_integer; indx binary_integer;
1540: begin
1541:
1542: -- copy data to the local IN or IN-OUT args, if any

Line 1565: okl_tmpt_set_pub.update_tmpt_set(p_api_version,

1561: ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1562:
1563:
1564: -- here's the delegated call to the old PL/SQL routine
1565: okl_tmpt_set_pub.update_tmpt_set(p_api_version,
1566: p_init_msg_list,
1567: x_return_status,
1568: x_msg_count,
1569: x_msg_data,

Line 1618: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;

1614: , p5_a13 JTF_NUMBER_TABLE
1615: )
1616:
1617: as
1618: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1619: ddindx binary_integer; indx binary_integer;
1620: begin
1621:
1622: -- copy data to the local IN or IN-OUT args, if any

Line 1645: okl_tmpt_set_pub.delete_tmpt_set(p_api_version,

1641: , p5_a13
1642: );
1643:
1644: -- here's the delegated call to the old PL/SQL routine
1645: okl_tmpt_set_pub.delete_tmpt_set(p_api_version,
1646: p_init_msg_list,
1647: x_return_status,
1648: x_msg_count,
1649: x_msg_data,

Line 1682: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

1678: , p5_a13 NUMBER := 0-1962.0724
1679: )
1680:
1681: as
1682: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1683: ddindx binary_integer; indx binary_integer;
1684: begin
1685:
1686: -- copy data to the local IN or IN-OUT args, if any

Line 1708: okl_tmpt_set_pub.delete_tmpt_set(p_api_version,

1704: ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1705: ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1706:
1707: -- here's the delegated call to the old PL/SQL routine
1708: okl_tmpt_set_pub.delete_tmpt_set(p_api_version,
1709: p_init_msg_list,
1710: x_return_status,
1711: x_msg_count,
1712: x_msg_data,

Line 1745: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;

1741: , p5_a13 JTF_NUMBER_TABLE
1742: )
1743:
1744: as
1745: ddp_aesv_tbl okl_tmpt_set_pub.aesv_tbl_type;
1746: ddindx binary_integer; indx binary_integer;
1747: begin
1748:
1749: -- copy data to the local IN or IN-OUT args, if any

Line 1772: okl_tmpt_set_pub.validate_tmpt_set(p_api_version,

1768: , p5_a13
1769: );
1770:
1771: -- here's the delegated call to the old PL/SQL routine
1772: okl_tmpt_set_pub.validate_tmpt_set(p_api_version,
1773: p_init_msg_list,
1774: x_return_status,
1775: x_msg_count,
1776: x_msg_data,

Line 1809: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;

1805: , p5_a13 NUMBER := 0-1962.0724
1806: )
1807:
1808: as
1809: ddp_aesv_rec okl_tmpt_set_pub.aesv_rec_type;
1810: ddindx binary_integer; indx binary_integer;
1811: begin
1812:
1813: -- copy data to the local IN or IN-OUT args, if any

Line 1835: okl_tmpt_set_pub.validate_tmpt_set(p_api_version,

1831: ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1832: ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1833:
1834: -- here's the delegated call to the old PL/SQL routine
1835: okl_tmpt_set_pub.validate_tmpt_set(p_api_version,
1836: p_init_msg_list,
1837: x_return_status,
1838: x_msg_count,
1839: x_msg_data,

Line 1944: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

1940: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1941: )
1942:
1943: as
1944: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
1945: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
1946: ddindx binary_integer; indx binary_integer;
1947: begin
1948:

Line 1945: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

1941: )
1942:
1943: as
1944: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
1945: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
1946: ddindx binary_integer; indx binary_integer;
1947: begin
1948:
1949: -- copy data to the local IN or IN-OUT args, if any

Line 2002: okl_tmpt_set_pub.create_template(p_api_version,

1998: );
1999:
2000:
2001: -- here's the delegated call to the old PL/SQL routine
2002: okl_tmpt_set_pub.create_template(p_api_version,
2003: p_init_msg_list,
2004: x_return_status,
2005: x_msg_count,
2006: x_msg_data,

Line 2157: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;

2153: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2154: )
2155:
2156: as
2157: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2158: ddx_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2159: ddindx binary_integer; indx binary_integer;
2160: begin
2161:

Line 2158: ddx_avlv_rec okl_tmpt_set_pub.avlv_rec_type;

2154: )
2155:
2156: as
2157: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2158: ddx_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2159: ddindx binary_integer; indx binary_integer;
2160: begin
2161:
2162: -- copy data to the local IN or IN-OUT args, if any

Line 2214: okl_tmpt_set_pub.create_template(p_api_version,

2210: ddp_avlv_rec.inv_code := p5_a42;
2211:
2212:
2213: -- here's the delegated call to the old PL/SQL routine
2214: okl_tmpt_set_pub.create_template(p_api_version,
2215: p_init_msg_list,
2216: x_return_status,
2217: x_msg_count,
2218: x_msg_data,

Line 2325: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

2321: , p5_a42 JTF_VARCHAR2_TABLE_100
2322: )
2323:
2324: as
2325: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
2326: ddindx binary_integer; indx binary_integer;
2327: begin
2328:
2329: -- copy data to the local IN or IN-OUT args, if any

Line 2381: okl_tmpt_set_pub.lock_template(p_api_version,

2377: , p5_a42
2378: );
2379:
2380: -- here's the delegated call to the old PL/SQL routine
2381: okl_tmpt_set_pub.lock_template(p_api_version,
2382: p_init_msg_list,
2383: x_return_status,
2384: x_msg_count,
2385: x_msg_data,

Line 2447: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;

2443: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2444: )
2445:
2446: as
2447: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2448: ddindx binary_integer; indx binary_integer;
2449: begin
2450:
2451: -- copy data to the local IN or IN-OUT args, if any

Line 2502: okl_tmpt_set_pub.lock_template(p_api_version,

2498: ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2499: ddp_avlv_rec.inv_code := p5_a42;
2500:
2501: -- here's the delegated call to the old PL/SQL routine
2502: okl_tmpt_set_pub.lock_template(p_api_version,
2503: p_init_msg_list,
2504: x_return_status,
2505: x_msg_count,
2506: x_msg_data,

Line 2611: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

2607: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
2608: )
2609:
2610: as
2611: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
2612: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
2613: ddindx binary_integer; indx binary_integer;
2614: begin
2615:

Line 2612: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

2608: )
2609:
2610: as
2611: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
2612: ddx_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
2613: ddindx binary_integer; indx binary_integer;
2614: begin
2615:
2616: -- copy data to the local IN or IN-OUT args, if any

Line 2669: okl_tmpt_set_pub.update_template(p_api_version,

2665: );
2666:
2667:
2668: -- here's the delegated call to the old PL/SQL routine
2669: okl_tmpt_set_pub.update_template(p_api_version,
2670: p_init_msg_list,
2671: x_return_status,
2672: x_msg_count,
2673: x_msg_data,

Line 2824: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;

2820: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2821: )
2822:
2823: as
2824: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2825: ddx_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2826: ddindx binary_integer; indx binary_integer;
2827: begin
2828:

Line 2825: ddx_avlv_rec okl_tmpt_set_pub.avlv_rec_type;

2821: )
2822:
2823: as
2824: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2825: ddx_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
2826: ddindx binary_integer; indx binary_integer;
2827: begin
2828:
2829: -- copy data to the local IN or IN-OUT args, if any

Line 2881: okl_tmpt_set_pub.update_template(p_api_version,

2877: ddp_avlv_rec.inv_code := p5_a42;
2878:
2879:
2880: -- here's the delegated call to the old PL/SQL routine
2881: okl_tmpt_set_pub.update_template(p_api_version,
2882: p_init_msg_list,
2883: x_return_status,
2884: x_msg_count,
2885: x_msg_data,

Line 2992: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

2988: , p5_a42 JTF_VARCHAR2_TABLE_100
2989: )
2990:
2991: as
2992: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
2993: ddindx binary_integer; indx binary_integer;
2994: begin
2995:
2996: -- copy data to the local IN or IN-OUT args, if any

Line 3048: okl_tmpt_set_pub.delete_template(p_api_version,

3044: , p5_a42
3045: );
3046:
3047: -- here's the delegated call to the old PL/SQL routine
3048: okl_tmpt_set_pub.delete_template(p_api_version,
3049: p_init_msg_list,
3050: x_return_status,
3051: x_msg_count,
3052: x_msg_data,

Line 3114: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;

3110: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3111: )
3112:
3113: as
3114: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
3115: ddindx binary_integer; indx binary_integer;
3116: begin
3117:
3118: -- copy data to the local IN or IN-OUT args, if any

Line 3169: okl_tmpt_set_pub.delete_template(p_api_version,

3165: ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
3166: ddp_avlv_rec.inv_code := p5_a42;
3167:
3168: -- here's the delegated call to the old PL/SQL routine
3169: okl_tmpt_set_pub.delete_template(p_api_version,
3170: p_init_msg_list,
3171: x_return_status,
3172: x_msg_count,
3173: x_msg_data,

Line 3235: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;

3231: , p5_a42 JTF_VARCHAR2_TABLE_100
3232: )
3233:
3234: as
3235: ddp_avlv_tbl okl_tmpt_set_pub.avlv_tbl_type;
3236: ddindx binary_integer; indx binary_integer;
3237: begin
3238:
3239: -- copy data to the local IN or IN-OUT args, if any

Line 3291: okl_tmpt_set_pub.validate_template(p_api_version,

3287: , p5_a42
3288: );
3289:
3290: -- here's the delegated call to the old PL/SQL routine
3291: okl_tmpt_set_pub.validate_template(p_api_version,
3292: p_init_msg_list,
3293: x_return_status,
3294: x_msg_count,
3295: x_msg_data,

Line 3357: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;

3353: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3354: )
3355:
3356: as
3357: ddp_avlv_rec okl_tmpt_set_pub.avlv_rec_type;
3358: ddindx binary_integer; indx binary_integer;
3359: begin
3360:
3361: -- copy data to the local IN or IN-OUT args, if any

Line 3412: okl_tmpt_set_pub.validate_template(p_api_version,

3408: ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
3409: ddp_avlv_rec.inv_code := p5_a42;
3410:
3411: -- here's the delegated call to the old PL/SQL routine
3412: okl_tmpt_set_pub.validate_template(p_api_version,
3413: p_init_msg_list,
3414: x_return_status,
3415: x_msg_count,
3416: x_msg_data,

Line 3501: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

3497: , p6_a32 out nocopy JTF_NUMBER_TABLE
3498: )
3499:
3500: as
3501: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
3502: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
3503: ddindx binary_integer; indx binary_integer;
3504: begin
3505:

Line 3502: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

3498: )
3499:
3500: as
3501: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
3502: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
3503: ddindx binary_integer; indx binary_integer;
3504: begin
3505:
3506: -- copy data to the local IN or IN-OUT args, if any

Line 3549: okl_tmpt_set_pub.create_tmpt_lines(p_api_version,

3545: );
3546:
3547:
3548: -- here's the delegated call to the old PL/SQL routine
3549: okl_tmpt_set_pub.create_tmpt_lines(p_api_version,
3550: p_init_msg_list,
3551: x_return_status,
3552: x_msg_count,
3553: x_msg_data,

Line 3674: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;

3670: , p5_a32 NUMBER := 0-1962.0724
3671: )
3672:
3673: as
3674: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
3675: ddx_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
3676: ddindx binary_integer; indx binary_integer;
3677: begin
3678:

Line 3675: ddx_atlv_rec okl_tmpt_set_pub.atlv_rec_type;

3671: )
3672:
3673: as
3674: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
3675: ddx_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
3676: ddindx binary_integer; indx binary_integer;
3677: begin
3678:
3679: -- copy data to the local IN or IN-OUT args, if any

Line 3721: okl_tmpt_set_pub.create_tmpt_lines(p_api_version,

3717: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3718:
3719:
3720: -- here's the delegated call to the old PL/SQL routine
3721: okl_tmpt_set_pub.create_tmpt_lines(p_api_version,
3722: p_init_msg_list,
3723: x_return_status,
3724: x_msg_count,
3725: x_msg_data,

Line 3812: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

3808: , p5_a32 JTF_NUMBER_TABLE
3809: )
3810:
3811: as
3812: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
3813: ddindx binary_integer; indx binary_integer;
3814: begin
3815:
3816: -- copy data to the local IN or IN-OUT args, if any

Line 3858: okl_tmpt_set_pub.lock_tmpt_lines(p_api_version,

3854: , p5_a32
3855: );
3856:
3857: -- here's the delegated call to the old PL/SQL routine
3858: okl_tmpt_set_pub.lock_tmpt_lines(p_api_version,
3859: p_init_msg_list,
3860: x_return_status,
3861: x_msg_count,
3862: x_msg_data,

Line 3914: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;

3910: , p5_a32 NUMBER := 0-1962.0724
3911: )
3912:
3913: as
3914: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
3915: ddindx binary_integer; indx binary_integer;
3916: begin
3917:
3918: -- copy data to the local IN or IN-OUT args, if any

Line 3959: okl_tmpt_set_pub.lock_tmpt_lines(p_api_version,

3955: ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
3956: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3957:
3958: -- here's the delegated call to the old PL/SQL routine
3959: okl_tmpt_set_pub.lock_tmpt_lines(p_api_version,
3960: p_init_msg_list,
3961: x_return_status,
3962: x_msg_count,
3963: x_msg_data,

Line 4048: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

4044: , p6_a32 out nocopy JTF_NUMBER_TABLE
4045: )
4046:
4047: as
4048: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
4049: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
4050: ddindx binary_integer; indx binary_integer;
4051: begin
4052:

Line 4049: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

4045: )
4046:
4047: as
4048: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
4049: ddx_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
4050: ddindx binary_integer; indx binary_integer;
4051: begin
4052:
4053: -- copy data to the local IN or IN-OUT args, if any

Line 4096: okl_tmpt_set_pub.update_tmpt_lines(p_api_version,

4092: );
4093:
4094:
4095: -- here's the delegated call to the old PL/SQL routine
4096: okl_tmpt_set_pub.update_tmpt_lines(p_api_version,
4097: p_init_msg_list,
4098: x_return_status,
4099: x_msg_count,
4100: x_msg_data,

Line 4221: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;

4217: , p5_a32 NUMBER := 0-1962.0724
4218: )
4219:
4220: as
4221: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
4222: ddx_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
4223: ddindx binary_integer; indx binary_integer;
4224: begin
4225:

Line 4222: ddx_atlv_rec okl_tmpt_set_pub.atlv_rec_type;

4218: )
4219:
4220: as
4221: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
4222: ddx_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
4223: ddindx binary_integer; indx binary_integer;
4224: begin
4225:
4226: -- copy data to the local IN or IN-OUT args, if any

Line 4268: okl_tmpt_set_pub.update_tmpt_lines(p_api_version,

4264: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
4265:
4266:
4267: -- here's the delegated call to the old PL/SQL routine
4268: okl_tmpt_set_pub.update_tmpt_lines(p_api_version,
4269: p_init_msg_list,
4270: x_return_status,
4271: x_msg_count,
4272: x_msg_data,

Line 4359: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

4355: , p5_a32 JTF_NUMBER_TABLE
4356: )
4357:
4358: as
4359: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
4360: ddindx binary_integer; indx binary_integer;
4361: begin
4362:
4363: -- copy data to the local IN or IN-OUT args, if any

Line 4405: okl_tmpt_set_pub.delete_tmpt_lines(p_api_version,

4401: , p5_a32
4402: );
4403:
4404: -- here's the delegated call to the old PL/SQL routine
4405: okl_tmpt_set_pub.delete_tmpt_lines(p_api_version,
4406: p_init_msg_list,
4407: x_return_status,
4408: x_msg_count,
4409: x_msg_data,

Line 4461: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;

4457: , p5_a32 NUMBER := 0-1962.0724
4458: )
4459:
4460: as
4461: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
4462: ddindx binary_integer; indx binary_integer;
4463: begin
4464:
4465: -- copy data to the local IN or IN-OUT args, if any

Line 4506: okl_tmpt_set_pub.delete_tmpt_lines(p_api_version,

4502: ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
4503: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
4504:
4505: -- here's the delegated call to the old PL/SQL routine
4506: okl_tmpt_set_pub.delete_tmpt_lines(p_api_version,
4507: p_init_msg_list,
4508: x_return_status,
4509: x_msg_count,
4510: x_msg_data,

Line 4562: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;

4558: , p5_a32 JTF_NUMBER_TABLE
4559: )
4560:
4561: as
4562: ddp_atlv_tbl okl_tmpt_set_pub.atlv_tbl_type;
4563: ddindx binary_integer; indx binary_integer;
4564: begin
4565:
4566: -- copy data to the local IN or IN-OUT args, if any

Line 4608: okl_tmpt_set_pub.validate_tmpt_lines(p_api_version,

4604: , p5_a32
4605: );
4606:
4607: -- here's the delegated call to the old PL/SQL routine
4608: okl_tmpt_set_pub.validate_tmpt_lines(p_api_version,
4609: p_init_msg_list,
4610: x_return_status,
4611: x_msg_count,
4612: x_msg_data,

Line 4664: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;

4660: , p5_a32 NUMBER := 0-1962.0724
4661: )
4662:
4663: as
4664: ddp_atlv_rec okl_tmpt_set_pub.atlv_rec_type;
4665: ddindx binary_integer; indx binary_integer;
4666: begin
4667:
4668: -- copy data to the local IN or IN-OUT args, if any

Line 4709: okl_tmpt_set_pub.validate_tmpt_lines(p_api_version,

4705: ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
4706: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
4707:
4708: -- here's the delegated call to the old PL/SQL routine
4709: okl_tmpt_set_pub.validate_tmpt_lines(p_api_version,
4710: p_init_msg_list,
4711: x_return_status,
4712: x_msg_count,
4713: x_msg_data,

Line 4724: end okl_tmpt_set_pub_w;

4720:
4721:
4722: end;
4723:
4724: end okl_tmpt_set_pub_w;