DBA Data[Home] [Help]

APPS.OKL_XMP_PVT_W dependencies on OKL_XMP_PVT

Line 1: package body okl_xmp_pvt_w as

1: package body okl_xmp_pvt_w as
2: /* $Header: OKLIXMPB.pls 120.0 2007/04/02 09:12:52 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_xmp_pvt.xmp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_xmp_pvt.xmp_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_xmp_pvt_w as
2: /* $Header: OKLIXMPB.pls 120.0 2007/04/02 09:12:52 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_xmp_pvt.xmp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 74: procedure rosetta_table_copy_out_p2(t okl_xmp_pvt.xmp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

70: end loop;
71: end if;
72: end if;
73: end rosetta_table_copy_in_p2;
74: procedure rosetta_table_copy_out_p2(t okl_xmp_pvt.xmp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_NUMBER_TABLE
76: , a2 out nocopy JTF_VARCHAR2_TABLE_300
77: , a3 out nocopy JTF_NUMBER_TABLE
78: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 290: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;

286: , p6_a26 out nocopy VARCHAR2
287: )
288:
289: as
290: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;
291: ddx_xmp_rec okl_xmp_pvt.xmp_rec_type;
292: ddindx binary_integer; indx binary_integer;
293: begin
294:

Line 291: ddx_xmp_rec okl_xmp_pvt.xmp_rec_type;

287: )
288:
289: as
290: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;
291: ddx_xmp_rec okl_xmp_pvt.xmp_rec_type;
292: ddindx binary_integer; indx binary_integer;
293: begin
294:
295: -- copy data to the local IN or IN-OUT args, if any

Line 331: okl_xmp_pvt.insert_row(p_api_version,

327: ddp_xmp_rec.last_update_login := p5_a26;
328:
329:
330: -- here's the delegated call to the old PL/SQL routine
331: okl_xmp_pvt.insert_row(p_api_version,
332: p_init_msg_list,
333: x_return_status,
334: x_msg_count,
335: x_msg_data,

Line 437: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

433: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
434: )
435:
436: as
437: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
438: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
439: ddindx binary_integer; indx binary_integer;
440: begin
441:

Line 438: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

434: )
435:
436: as
437: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
438: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
439: ddindx binary_integer; indx binary_integer;
440: begin
441:
442: -- copy data to the local IN or IN-OUT args, if any

Line 448: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

444:
445:
446:
447:
448: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
449: , p5_a1
450: , p5_a2
451: , p5_a3
452: , p5_a4

Line 479: okl_xmp_pvt.insert_row(p_api_version,

475: );
476:
477:
478: -- here's the delegated call to the old PL/SQL routine
479: okl_xmp_pvt.insert_row(p_api_version,
480: p_init_msg_list,
481: x_return_status,
482: x_msg_count,
483: x_msg_data,

Line 494: okl_xmp_pvt_w.rosetta_table_copy_out_p2(ddx_xmp_tbl, p6_a0

490:
491:
492:
493:
494: okl_xmp_pvt_w.rosetta_table_copy_out_p2(ddx_xmp_tbl, p6_a0
495: , p6_a1
496: , p6_a2
497: , p6_a3
498: , p6_a4

Line 559: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;

555: , p5_a26 VARCHAR2
556: )
557:
558: as
559: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;
560: ddindx binary_integer; indx binary_integer;
561: begin
562:
563: -- copy data to the local IN or IN-OUT args, if any

Line 598: okl_xmp_pvt.lock_row(p_api_version,

594: ddp_xmp_rec.last_update_date := p5_a25;
595: ddp_xmp_rec.last_update_login := p5_a26;
596:
597: -- here's the delegated call to the old PL/SQL routine
598: okl_xmp_pvt.lock_row(p_api_version,
599: p_init_msg_list,
600: x_return_status,
601: x_msg_count,
602: x_msg_data,

Line 655: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

651: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
652: )
653:
654: as
655: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
656: ddpx_error_tbl okl_api.error_tbl_type;
657: ddindx binary_integer; indx binary_integer;
658: begin
659:

Line 666: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

662:
663:
664:
665:
666: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
667: , p5_a1
668: , p5_a2
669: , p5_a3
670: , p5_a4

Line 705: okl_xmp_pvt.lock_row(p_api_version,

701: , p6_a6
702: );
703:
704: -- here's the delegated call to the old PL/SQL routine
705: okl_xmp_pvt.lock_row(p_api_version,
706: p_init_msg_list,
707: x_return_status,
708: x_msg_count,
709: x_msg_data,

Line 765: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

761: , p5_a26 JTF_VARCHAR2_TABLE_300
762: )
763:
764: as
765: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
766: ddindx binary_integer; indx binary_integer;
767: begin
768:
769: -- copy data to the local IN or IN-OUT args, if any

Line 775: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

771:
772:
773:
774:
775: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
776: , p5_a1
777: , p5_a2
778: , p5_a3
779: , p5_a4

Line 805: okl_xmp_pvt.lock_row(p_api_version,

801: , p5_a26
802: );
803:
804: -- here's the delegated call to the old PL/SQL routine
805: okl_xmp_pvt.lock_row(p_api_version,
806: p_init_msg_list,
807: x_return_status,
808: x_msg_count,
809: x_msg_data,

Line 882: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;

878: , p6_a26 out nocopy VARCHAR2
879: )
880:
881: as
882: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;
883: ddx_xmp_rec okl_xmp_pvt.xmp_rec_type;
884: ddindx binary_integer; indx binary_integer;
885: begin
886:

Line 883: ddx_xmp_rec okl_xmp_pvt.xmp_rec_type;

879: )
880:
881: as
882: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;
883: ddx_xmp_rec okl_xmp_pvt.xmp_rec_type;
884: ddindx binary_integer; indx binary_integer;
885: begin
886:
887: -- copy data to the local IN or IN-OUT args, if any

Line 923: okl_xmp_pvt.update_row(p_api_version,

919: ddp_xmp_rec.last_update_login := p5_a26;
920:
921:
922: -- here's the delegated call to the old PL/SQL routine
923: okl_xmp_pvt.update_row(p_api_version,
924: p_init_msg_list,
925: x_return_status,
926: x_msg_count,
927: x_msg_data,

Line 1036: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1032: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1033: )
1034:
1035: as
1036: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1037: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1038: ddpx_error_tbl okl_api.error_tbl_type;
1039: ddindx binary_integer; indx binary_integer;
1040: begin

Line 1037: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1033: )
1034:
1035: as
1036: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1037: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1038: ddpx_error_tbl okl_api.error_tbl_type;
1039: ddindx binary_integer; indx binary_integer;
1040: begin
1041:

Line 1048: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

1044:
1045:
1046:
1047:
1048: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
1049: , p5_a1
1050: , p5_a2
1051: , p5_a3
1052: , p5_a4

Line 1088: okl_xmp_pvt.update_row(p_api_version,

1084: , p7_a6
1085: );
1086:
1087: -- here's the delegated call to the old PL/SQL routine
1088: okl_xmp_pvt.update_row(p_api_version,
1089: p_init_msg_list,
1090: x_return_status,
1091: x_msg_count,
1092: x_msg_data,

Line 1104: okl_xmp_pvt_w.rosetta_table_copy_out_p2(ddx_xmp_tbl, p6_a0

1100:
1101:
1102:
1103:
1104: okl_xmp_pvt_w.rosetta_table_copy_out_p2(ddx_xmp_tbl, p6_a0
1105: , p6_a1
1106: , p6_a2
1107: , p6_a3
1108: , p6_a4

Line 1205: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1201: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
1202: )
1203:
1204: as
1205: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1206: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1207: ddindx binary_integer; indx binary_integer;
1208: begin
1209:

Line 1206: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1202: )
1203:
1204: as
1205: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1206: ddx_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1207: ddindx binary_integer; indx binary_integer;
1208: begin
1209:
1210: -- copy data to the local IN or IN-OUT args, if any

Line 1216: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

1212:
1213:
1214:
1215:
1216: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
1217: , p5_a1
1218: , p5_a2
1219: , p5_a3
1220: , p5_a4

Line 1247: okl_xmp_pvt.update_row(p_api_version,

1243: );
1244:
1245:
1246: -- here's the delegated call to the old PL/SQL routine
1247: okl_xmp_pvt.update_row(p_api_version,
1248: p_init_msg_list,
1249: x_return_status,
1250: x_msg_count,
1251: x_msg_data,

Line 1262: okl_xmp_pvt_w.rosetta_table_copy_out_p2(ddx_xmp_tbl, p6_a0

1258:
1259:
1260:
1261:
1262: okl_xmp_pvt_w.rosetta_table_copy_out_p2(ddx_xmp_tbl, p6_a0
1263: , p6_a1
1264: , p6_a2
1265: , p6_a3
1266: , p6_a4

Line 1327: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;

1323: , p5_a26 VARCHAR2
1324: )
1325:
1326: as
1327: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;
1328: ddindx binary_integer; indx binary_integer;
1329: begin
1330:
1331: -- copy data to the local IN or IN-OUT args, if any

Line 1366: okl_xmp_pvt.delete_row(p_api_version,

1362: ddp_xmp_rec.last_update_date := p5_a25;
1363: ddp_xmp_rec.last_update_login := p5_a26;
1364:
1365: -- here's the delegated call to the old PL/SQL routine
1366: okl_xmp_pvt.delete_row(p_api_version,
1367: p_init_msg_list,
1368: x_return_status,
1369: x_msg_count,
1370: x_msg_data,

Line 1423: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1419: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1420: )
1421:
1422: as
1423: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1424: ddpx_error_tbl okl_api.error_tbl_type;
1425: ddindx binary_integer; indx binary_integer;
1426: begin
1427:

Line 1434: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

1430:
1431:
1432:
1433:
1434: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
1435: , p5_a1
1436: , p5_a2
1437: , p5_a3
1438: , p5_a4

Line 1473: okl_xmp_pvt.delete_row(p_api_version,

1469: , p6_a6
1470: );
1471:
1472: -- here's the delegated call to the old PL/SQL routine
1473: okl_xmp_pvt.delete_row(p_api_version,
1474: p_init_msg_list,
1475: x_return_status,
1476: x_msg_count,
1477: x_msg_data,

Line 1533: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1529: , p5_a26 JTF_VARCHAR2_TABLE_300
1530: )
1531:
1532: as
1533: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1534: ddindx binary_integer; indx binary_integer;
1535: begin
1536:
1537: -- copy data to the local IN or IN-OUT args, if any

Line 1543: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

1539:
1540:
1541:
1542:
1543: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
1544: , p5_a1
1545: , p5_a2
1546: , p5_a3
1547: , p5_a4

Line 1573: okl_xmp_pvt.delete_row(p_api_version,

1569: , p5_a26
1570: );
1571:
1572: -- here's the delegated call to the old PL/SQL routine
1573: okl_xmp_pvt.delete_row(p_api_version,
1574: p_init_msg_list,
1575: x_return_status,
1576: x_msg_count,
1577: x_msg_data,

Line 1623: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;

1619: , p5_a26 VARCHAR2
1620: )
1621:
1622: as
1623: ddp_xmp_rec okl_xmp_pvt.xmp_rec_type;
1624: ddindx binary_integer; indx binary_integer;
1625: begin
1626:
1627: -- copy data to the local IN or IN-OUT args, if any

Line 1662: okl_xmp_pvt.validate_row(p_api_version,

1658: ddp_xmp_rec.last_update_date := p5_a25;
1659: ddp_xmp_rec.last_update_login := p5_a26;
1660:
1661: -- here's the delegated call to the old PL/SQL routine
1662: okl_xmp_pvt.validate_row(p_api_version,
1663: p_init_msg_list,
1664: x_return_status,
1665: x_msg_count,
1666: x_msg_data,

Line 1719: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1715: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1716: )
1717:
1718: as
1719: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1720: ddpx_error_tbl okl_api.error_tbl_type;
1721: ddindx binary_integer; indx binary_integer;
1722: begin
1723:

Line 1730: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

1726:
1727:
1728:
1729:
1730: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
1731: , p5_a1
1732: , p5_a2
1733: , p5_a3
1734: , p5_a4

Line 1769: okl_xmp_pvt.validate_row(p_api_version,

1765: , p6_a6
1766: );
1767:
1768: -- here's the delegated call to the old PL/SQL routine
1769: okl_xmp_pvt.validate_row(p_api_version,
1770: p_init_msg_list,
1771: x_return_status,
1772: x_msg_count,
1773: x_msg_data,

Line 1829: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;

1825: , p5_a26 JTF_VARCHAR2_TABLE_300
1826: )
1827:
1828: as
1829: ddp_xmp_tbl okl_xmp_pvt.xmp_tbl_type;
1830: ddindx binary_integer; indx binary_integer;
1831: begin
1832:
1833: -- copy data to the local IN or IN-OUT args, if any

Line 1839: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0

1835:
1836:
1837:
1838:
1839: okl_xmp_pvt_w.rosetta_table_copy_in_p2(ddp_xmp_tbl, p5_a0
1840: , p5_a1
1841: , p5_a2
1842: , p5_a3
1843: , p5_a4

Line 1869: okl_xmp_pvt.validate_row(p_api_version,

1865: , p5_a26
1866: );
1867:
1868: -- here's the delegated call to the old PL/SQL routine
1869: okl_xmp_pvt.validate_row(p_api_version,
1870: p_init_msg_list,
1871: x_return_status,
1872: x_msg_count,
1873: x_msg_data,

Line 1884: end okl_xmp_pvt_w;

1880:
1881:
1882: end;
1883:
1884: end okl_xmp_pvt_w;