DBA Data[Home] [Help]

APPS.OKL_PROCESS_TMPT_SET_PUB_W dependencies on OKL_PROCESS_TMPT_SET_PUB

Line 1: package body okl_process_tmpt_set_pub_w as

1: package body okl_process_tmpt_set_pub_w as
2: /* $Header: OKLUTMSB.pls 120.2 2005/10/30 03:52:18 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_process_tmpt_set_pub.aesv_rec_type;

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

Line 211: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

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

Line 212: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

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

Line 213: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;

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

Line 214: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

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

Line 215: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

211: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
212: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
213: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
214: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
215: ddx_atlv_tbl okl_process_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_process_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_process_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_process_tmpt_set_pub.aesv_rec_type;

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

Line 630: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

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

Line 631: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

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

Line 632: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;

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

Line 633: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

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

Line 634: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

630: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
631: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
632: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
633: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
634: ddx_atlv_tbl okl_process_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_process_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_process_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 896: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;

892: , p6_a13 out nocopy JTF_NUMBER_TABLE
893: )
894:
895: as
896: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
897: ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
898: ddindx binary_integer; indx binary_integer;
899: begin
900:

Line 897: ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;

893: )
894:
895: as
896: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
897: ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
898: ddindx binary_integer; indx binary_integer;
899: begin
900:
901: -- copy data to the local IN or IN-OUT args, if any

Line 925: okl_process_tmpt_set_pub.create_tmpt_set(p_api_version,

921: );
922:
923:
924: -- here's the delegated call to the old PL/SQL routine
925: okl_process_tmpt_set_pub.create_tmpt_set(p_api_version,
926: p_init_msg_list,
927: x_return_status,
928: x_msg_count,
929: x_msg_data,

Line 994: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;

990: , p5_a13 NUMBER := 0-1962.0724
991: )
992:
993: as
994: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
995: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
996: ddindx binary_integer; indx binary_integer;
997: begin
998:

Line 995: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;

991: )
992:
993: as
994: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
995: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
996: ddindx binary_integer; indx binary_integer;
997: begin
998:
999: -- copy data to the local IN or IN-OUT args, if any

Line 1023: okl_process_tmpt_set_pub.create_tmpt_set(p_api_version,

1019:
1020:
1021:
1022: -- here's the delegated call to the old PL/SQL routine
1023: okl_process_tmpt_set_pub.create_tmpt_set(p_api_version,
1024: p_init_msg_list,
1025: x_return_status,
1026: x_msg_count,
1027: x_msg_data,

Line 1092: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;

1088: , p6_a13 out nocopy JTF_NUMBER_TABLE
1089: )
1090:
1091: as
1092: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1093: ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1094: ddindx binary_integer; indx binary_integer;
1095: begin
1096:

Line 1093: ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;

1089: )
1090:
1091: as
1092: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1093: ddx_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1094: ddindx binary_integer; indx binary_integer;
1095: begin
1096:
1097: -- copy data to the local IN or IN-OUT args, if any

Line 1121: okl_process_tmpt_set_pub.update_tmpt_set(p_api_version,

1117: );
1118:
1119:
1120: -- here's the delegated call to the old PL/SQL routine
1121: okl_process_tmpt_set_pub.update_tmpt_set(p_api_version,
1122: p_init_msg_list,
1123: x_return_status,
1124: x_msg_count,
1125: x_msg_data,

Line 1189: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;

1185: , p5_a13 NUMBER := 0-1962.0724
1186: )
1187:
1188: as
1189: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1190: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1191: ddindx binary_integer; indx binary_integer;
1192: begin
1193:

Line 1190: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;

1186: )
1187:
1188: as
1189: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1190: ddx_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1191: ddindx binary_integer; indx binary_integer;
1192: begin
1193:
1194: -- copy data to the local IN or IN-OUT args, if any

Line 1217: okl_process_tmpt_set_pub.update_tmpt_set(p_api_version,

1213: ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1214:
1215:
1216: -- here's the delegated call to the old PL/SQL routine
1217: okl_process_tmpt_set_pub.update_tmpt_set(p_api_version,
1218: p_init_msg_list,
1219: x_return_status,
1220: x_msg_count,
1221: x_msg_data,

Line 1270: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;

1266: , p5_a13 JTF_NUMBER_TABLE
1267: )
1268:
1269: as
1270: ddp_aesv_tbl okl_process_tmpt_set_pub.aesv_tbl_type;
1271: ddindx binary_integer; indx binary_integer;
1272: begin
1273:
1274: -- copy data to the local IN or IN-OUT args, if any

Line 1297: okl_process_tmpt_set_pub.delete_tmpt_set(p_api_version,

1293: , p5_a13
1294: );
1295:
1296: -- here's the delegated call to the old PL/SQL routine
1297: okl_process_tmpt_set_pub.delete_tmpt_set(p_api_version,
1298: p_init_msg_list,
1299: x_return_status,
1300: x_msg_count,
1301: x_msg_data,

Line 1334: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;

1330: , p5_a13 NUMBER := 0-1962.0724
1331: )
1332:
1333: as
1334: ddp_aesv_rec okl_process_tmpt_set_pub.aesv_rec_type;
1335: ddindx binary_integer; indx binary_integer;
1336: begin
1337:
1338: -- copy data to the local IN or IN-OUT args, if any

Line 1360: okl_process_tmpt_set_pub.delete_tmpt_set(p_api_version,

1356: ddp_aesv_rec.last_update_login := rosetta_g_miss_num_map(p5_a12);
1357: ddp_aesv_rec.gts_id := rosetta_g_miss_num_map(p5_a13);
1358:
1359: -- here's the delegated call to the old PL/SQL routine
1360: okl_process_tmpt_set_pub.delete_tmpt_set(p_api_version,
1361: p_init_msg_list,
1362: x_return_status,
1363: x_msg_count,
1364: x_msg_data,

Line 1469: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

1465: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1466: )
1467:
1468: as
1469: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1470: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1471: ddindx binary_integer; indx binary_integer;
1472: begin
1473:

Line 1470: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

1466: )
1467:
1468: as
1469: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1470: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1471: ddindx binary_integer; indx binary_integer;
1472: begin
1473:
1474: -- copy data to the local IN or IN-OUT args, if any

Line 1527: okl_process_tmpt_set_pub.create_template(p_api_version,

1523: );
1524:
1525:
1526: -- here's the delegated call to the old PL/SQL routine
1527: okl_process_tmpt_set_pub.create_template(p_api_version,
1528: p_init_msg_list,
1529: x_return_status,
1530: x_msg_count,
1531: x_msg_data,

Line 1682: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;

1678: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1679: )
1680:
1681: as
1682: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
1683: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
1684: ddindx binary_integer; indx binary_integer;
1685: begin
1686:

Line 1683: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;

1679: )
1680:
1681: as
1682: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
1683: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
1684: ddindx binary_integer; indx binary_integer;
1685: begin
1686:
1687: -- copy data to the local IN or IN-OUT args, if any

Line 1739: okl_process_tmpt_set_pub.create_template(p_api_version,

1735: ddp_avlv_rec.inv_code := p5_a42;
1736:
1737:
1738: -- here's the delegated call to the old PL/SQL routine
1739: okl_process_tmpt_set_pub.create_template(p_api_version,
1740: p_init_msg_list,
1741: x_return_status,
1742: x_msg_count,
1743: x_msg_data,

Line 1893: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

1889: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
1890: )
1891:
1892: as
1893: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1894: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1895: ddindx binary_integer; indx binary_integer;
1896: begin
1897:

Line 1894: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

1890: )
1891:
1892: as
1893: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1894: ddx_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
1895: ddindx binary_integer; indx binary_integer;
1896: begin
1897:
1898: -- copy data to the local IN or IN-OUT args, if any

Line 1951: okl_process_tmpt_set_pub.update_template(p_api_version,

1947: );
1948:
1949:
1950: -- here's the delegated call to the old PL/SQL routine
1951: okl_process_tmpt_set_pub.update_template(p_api_version,
1952: p_init_msg_list,
1953: x_return_status,
1954: x_msg_count,
1955: x_msg_data,

Line 2106: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;

2102: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2103: )
2104:
2105: as
2106: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2107: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2108: ddindx binary_integer; indx binary_integer;
2109: begin
2110:

Line 2107: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;

2103: )
2104:
2105: as
2106: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2107: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2108: ddindx binary_integer; indx binary_integer;
2109: begin
2110:
2111: -- copy data to the local IN or IN-OUT args, if any

Line 2163: okl_process_tmpt_set_pub.update_template(p_api_version,

2159: ddp_avlv_rec.inv_code := p5_a42;
2160:
2161:
2162: -- here's the delegated call to the old PL/SQL routine
2163: okl_process_tmpt_set_pub.update_template(p_api_version,
2164: p_init_msg_list,
2165: x_return_status,
2166: x_msg_count,
2167: x_msg_data,

Line 2274: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;

2270: , p5_a42 JTF_VARCHAR2_TABLE_100
2271: )
2272:
2273: as
2274: ddp_avlv_tbl okl_process_tmpt_set_pub.avlv_tbl_type;
2275: ddindx binary_integer; indx binary_integer;
2276: begin
2277:
2278: -- copy data to the local IN or IN-OUT args, if any

Line 2330: okl_process_tmpt_set_pub.delete_template(p_api_version,

2326: , p5_a42
2327: );
2328:
2329: -- here's the delegated call to the old PL/SQL routine
2330: okl_process_tmpt_set_pub.delete_template(p_api_version,
2331: p_init_msg_list,
2332: x_return_status,
2333: x_msg_count,
2334: x_msg_data,

Line 2396: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;

2392: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2393: )
2394:
2395: as
2396: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
2397: ddindx binary_integer; indx binary_integer;
2398: begin
2399:
2400: -- copy data to the local IN or IN-OUT args, if any

Line 2451: okl_process_tmpt_set_pub.delete_template(p_api_version,

2447: ddp_avlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a41);
2448: ddp_avlv_rec.inv_code := p5_a42;
2449:
2450: -- here's the delegated call to the old PL/SQL routine
2451: okl_process_tmpt_set_pub.delete_template(p_api_version,
2452: p_init_msg_list,
2453: x_return_status,
2454: x_msg_count,
2455: x_msg_data,

Line 2540: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

2536: , p6_a32 out nocopy JTF_NUMBER_TABLE
2537: )
2538:
2539: as
2540: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2541: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2542: ddindx binary_integer; indx binary_integer;
2543: begin
2544:

Line 2541: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

2537: )
2538:
2539: as
2540: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2541: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2542: ddindx binary_integer; indx binary_integer;
2543: begin
2544:
2545: -- copy data to the local IN or IN-OUT args, if any

Line 2588: okl_process_tmpt_set_pub.create_tmpt_lines(p_api_version,

2584: );
2585:
2586:
2587: -- here's the delegated call to the old PL/SQL routine
2588: okl_process_tmpt_set_pub.create_tmpt_lines(p_api_version,
2589: p_init_msg_list,
2590: x_return_status,
2591: x_msg_count,
2592: x_msg_data,

Line 2713: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;

2709: , p5_a32 NUMBER := 0-1962.0724
2710: )
2711:
2712: as
2713: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
2714: ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
2715: ddindx binary_integer; indx binary_integer;
2716: begin
2717:

Line 2714: ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;

2710: )
2711:
2712: as
2713: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
2714: ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
2715: ddindx binary_integer; indx binary_integer;
2716: begin
2717:
2718: -- copy data to the local IN or IN-OUT args, if any

Line 2760: okl_process_tmpt_set_pub.create_tmpt_lines(p_api_version,

2756: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
2757:
2758:
2759: -- here's the delegated call to the old PL/SQL routine
2760: okl_process_tmpt_set_pub.create_tmpt_lines(p_api_version,
2761: p_init_msg_list,
2762: x_return_status,
2763: x_msg_count,
2764: x_msg_data,

Line 2884: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

2880: , p6_a32 out nocopy JTF_NUMBER_TABLE
2881: )
2882:
2883: as
2884: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2885: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2886: ddindx binary_integer; indx binary_integer;
2887: begin
2888:

Line 2885: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

2881: )
2882:
2883: as
2884: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2885: ddx_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
2886: ddindx binary_integer; indx binary_integer;
2887: begin
2888:
2889: -- copy data to the local IN or IN-OUT args, if any

Line 2932: okl_process_tmpt_set_pub.update_tmpt_lines(p_api_version,

2928: );
2929:
2930:
2931: -- here's the delegated call to the old PL/SQL routine
2932: okl_process_tmpt_set_pub.update_tmpt_lines(p_api_version,
2933: p_init_msg_list,
2934: x_return_status,
2935: x_msg_count,
2936: x_msg_data,

Line 3057: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;

3053: , p5_a32 NUMBER := 0-1962.0724
3054: )
3055:
3056: as
3057: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3058: ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3059: ddindx binary_integer; indx binary_integer;
3060: begin
3061:

Line 3058: ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;

3054: )
3055:
3056: as
3057: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3058: ddx_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3059: ddindx binary_integer; indx binary_integer;
3060: begin
3061:
3062: -- copy data to the local IN or IN-OUT args, if any

Line 3104: okl_process_tmpt_set_pub.update_tmpt_lines(p_api_version,

3100: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3101:
3102:
3103: -- here's the delegated call to the old PL/SQL routine
3104: okl_process_tmpt_set_pub.update_tmpt_lines(p_api_version,
3105: p_init_msg_list,
3106: x_return_status,
3107: x_msg_count,
3108: x_msg_data,

Line 3195: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;

3191: , p5_a32 JTF_NUMBER_TABLE
3192: )
3193:
3194: as
3195: ddp_atlv_tbl okl_process_tmpt_set_pub.atlv_tbl_type;
3196: ddindx binary_integer; indx binary_integer;
3197: begin
3198:
3199: -- copy data to the local IN or IN-OUT args, if any

Line 3241: okl_process_tmpt_set_pub.delete_tmpt_lines(p_api_version,

3237: , p5_a32
3238: );
3239:
3240: -- here's the delegated call to the old PL/SQL routine
3241: okl_process_tmpt_set_pub.delete_tmpt_lines(p_api_version,
3242: p_init_msg_list,
3243: x_return_status,
3244: x_msg_count,
3245: x_msg_data,

Line 3297: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;

3293: , p5_a32 NUMBER := 0-1962.0724
3294: )
3295:
3296: as
3297: ddp_atlv_rec okl_process_tmpt_set_pub.atlv_rec_type;
3298: ddindx binary_integer; indx binary_integer;
3299: begin
3300:
3301: -- copy data to the local IN or IN-OUT args, if any

Line 3342: okl_process_tmpt_set_pub.delete_tmpt_lines(p_api_version,

3338: ddp_atlv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a31);
3339: ddp_atlv_rec.last_update_login := rosetta_g_miss_num_map(p5_a32);
3340:
3341: -- here's the delegated call to the old PL/SQL routine
3342: okl_process_tmpt_set_pub.delete_tmpt_lines(p_api_version,
3343: p_init_msg_list,
3344: x_return_status,
3345: x_msg_count,
3346: x_msg_data,

Line 3452: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;

3448: , p5_a42 VARCHAR2 := fnd_api.g_miss_char
3449: )
3450:
3451: as
3452: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
3453: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
3454: ddindx binary_integer; indx binary_integer;
3455: begin
3456:

Line 3453: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;

3449: )
3450:
3451: as
3452: ddp_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
3453: ddx_avlv_rec okl_process_tmpt_set_pub.avlv_rec_type;
3454: ddindx binary_integer; indx binary_integer;
3455: begin
3456:
3457: -- copy data to the local IN or IN-OUT args, if any

Line 3510: okl_process_tmpt_set_pub.copy_template(p_api_version,

3506:
3507:
3508:
3509: -- here's the delegated call to the old PL/SQL routine
3510: okl_process_tmpt_set_pub.copy_template(p_api_version,
3511: p_init_msg_list,
3512: x_return_status,
3513: x_msg_count,
3514: x_msg_data,

Line 3572: end okl_process_tmpt_set_pub_w;

3568: p7_a41 := rosetta_g_miss_num_map(ddx_avlv_rec.last_update_login);
3569: p7_a42 := ddx_avlv_rec.inv_code;
3570: end;
3571:
3572: end okl_process_tmpt_set_pub_w;