DBA Data[Home] [Help]

APPS.OKL_TBO_PVT_W dependencies on OKL_TBO_PVT

Line 1: package body okl_tbo_pvt_w as

1: package body okl_tbo_pvt_w as
2: /* $Header: OKLITBOB.pls 120.0 2005/08/24 14:33:09 asawanka 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_tbo_pvt.tbov_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_tbo_pvt.tbov_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 97: procedure rosetta_table_copy_out_p2(t okl_tbo_pvt.tbov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

93: end loop;
94: end if;
95: end if;
96: end rosetta_table_copy_in_p2;
97: procedure rosetta_table_copy_out_p2(t okl_tbo_pvt.tbov_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
98: , a1 out nocopy JTF_NUMBER_TABLE
99: , a2 out nocopy JTF_NUMBER_TABLE
100: , a3 out nocopy JTF_NUMBER_TABLE
101: , a4 out nocopy JTF_NUMBER_TABLE

Line 261: procedure rosetta_table_copy_in_p5(t out nocopy okl_tbo_pvt.tbo_tbl_type, a0 JTF_NUMBER_TABLE

257: end if;
258: end if;
259: end rosetta_table_copy_out_p2;
260:
261: procedure rosetta_table_copy_in_p5(t out nocopy okl_tbo_pvt.tbo_tbl_type, a0 JTF_NUMBER_TABLE
262: , a1 JTF_NUMBER_TABLE
263: , a2 JTF_NUMBER_TABLE
264: , a3 JTF_NUMBER_TABLE
265: , a4 JTF_NUMBER_TABLE

Line 336: procedure rosetta_table_copy_out_p5(t okl_tbo_pvt.tbo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

332: end loop;
333: end if;
334: end if;
335: end rosetta_table_copy_in_p5;
336: procedure rosetta_table_copy_out_p5(t okl_tbo_pvt.tbo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
337: , a1 out nocopy JTF_NUMBER_TABLE
338: , a2 out nocopy JTF_NUMBER_TABLE
339: , a3 out nocopy JTF_NUMBER_TABLE
340: , a4 out nocopy JTF_NUMBER_TABLE

Line 566: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;

562: , p5_a28 NUMBER := 0-1962.0724
563: )
564:
565: as
566: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;
567: ddx_tbov_rec okl_tbo_pvt.tbov_rec_type;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:

Line 567: ddx_tbov_rec okl_tbo_pvt.tbov_rec_type;

563: )
564:
565: as
566: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;
567: ddx_tbov_rec okl_tbo_pvt.tbov_rec_type;
568: ddindx binary_integer; indx binary_integer;
569: begin
570:
571: -- copy data to the local IN or IN-OUT args, if any

Line 609: okl_tbo_pvt.insert_row(p_api_version,

605: ddp_tbov_rec.object_version_number := rosetta_g_miss_num_map(p5_a28);
606:
607:
608: -- here's the delegated call to the old PL/SQL routine
609: okl_tbo_pvt.insert_row(p_api_version,
610: p_init_msg_list,
611: x_return_status,
612: x_msg_count,
613: x_msg_data,

Line 721: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;

717: , p6_a28 out nocopy JTF_NUMBER_TABLE
718: )
719:
720: as
721: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
722: ddx_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
723: ddindx binary_integer; indx binary_integer;
724: begin
725:

Line 722: ddx_tbov_tbl okl_tbo_pvt.tbov_tbl_type;

718: )
719:
720: as
721: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
722: ddx_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
723: ddindx binary_integer; indx binary_integer;
724: begin
725:
726: -- copy data to the local IN or IN-OUT args, if any

Line 732: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0

728:
729:
730:
731:
732: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0
733: , p5_a1
734: , p5_a2
735: , p5_a3
736: , p5_a4

Line 765: okl_tbo_pvt.insert_row(p_api_version,

761: );
762:
763:
764: -- here's the delegated call to the old PL/SQL routine
765: okl_tbo_pvt.insert_row(p_api_version,
766: p_init_msg_list,
767: x_return_status,
768: x_msg_count,
769: x_msg_data,

Line 780: okl_tbo_pvt_w.rosetta_table_copy_out_p2(ddx_tbov_tbl, p6_a0

776:
777:
778:
779:
780: okl_tbo_pvt_w.rosetta_table_copy_out_p2(ddx_tbov_tbl, p6_a0
781: , p6_a1
782: , p6_a2
783: , p6_a3
784: , p6_a4

Line 849: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;

845: , p5_a28 NUMBER := 0-1962.0724
846: )
847:
848: as
849: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;
850: ddindx binary_integer; indx binary_integer;
851: begin
852:
853: -- copy data to the local IN or IN-OUT args, if any

Line 890: okl_tbo_pvt.lock_row(p_api_version,

886: ddp_tbov_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
887: ddp_tbov_rec.object_version_number := rosetta_g_miss_num_map(p5_a28);
888:
889: -- here's the delegated call to the old PL/SQL routine
890: okl_tbo_pvt.lock_row(p_api_version,
891: p_init_msg_list,
892: x_return_status,
893: x_msg_count,
894: x_msg_data,

Line 942: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;

938: , p5_a28 JTF_NUMBER_TABLE
939: )
940:
941: as
942: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
943: ddindx binary_integer; indx binary_integer;
944: begin
945:
946: -- copy data to the local IN or IN-OUT args, if any

Line 952: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0

948:
949:
950:
951:
952: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0
953: , p5_a1
954: , p5_a2
955: , p5_a3
956: , p5_a4

Line 984: okl_tbo_pvt.lock_row(p_api_version,

980: , p5_a28
981: );
982:
983: -- here's the delegated call to the old PL/SQL routine
984: okl_tbo_pvt.lock_row(p_api_version,
985: p_init_msg_list,
986: x_return_status,
987: x_msg_count,
988: x_msg_data,

Line 1065: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;

1061: , p5_a28 NUMBER := 0-1962.0724
1062: )
1063:
1064: as
1065: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;
1066: ddx_tbov_rec okl_tbo_pvt.tbov_rec_type;
1067: ddindx binary_integer; indx binary_integer;
1068: begin
1069:

Line 1066: ddx_tbov_rec okl_tbo_pvt.tbov_rec_type;

1062: )
1063:
1064: as
1065: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;
1066: ddx_tbov_rec okl_tbo_pvt.tbov_rec_type;
1067: ddindx binary_integer; indx binary_integer;
1068: begin
1069:
1070: -- copy data to the local IN or IN-OUT args, if any

Line 1108: okl_tbo_pvt.update_row(p_api_version,

1104: ddp_tbov_rec.object_version_number := rosetta_g_miss_num_map(p5_a28);
1105:
1106:
1107: -- here's the delegated call to the old PL/SQL routine
1108: okl_tbo_pvt.update_row(p_api_version,
1109: p_init_msg_list,
1110: x_return_status,
1111: x_msg_count,
1112: x_msg_data,

Line 1220: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;

1216: , p6_a28 out nocopy JTF_NUMBER_TABLE
1217: )
1218:
1219: as
1220: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
1221: ddx_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
1222: ddindx binary_integer; indx binary_integer;
1223: begin
1224:

Line 1221: ddx_tbov_tbl okl_tbo_pvt.tbov_tbl_type;

1217: )
1218:
1219: as
1220: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
1221: ddx_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
1222: ddindx binary_integer; indx binary_integer;
1223: begin
1224:
1225: -- copy data to the local IN or IN-OUT args, if any

Line 1231: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0

1227:
1228:
1229:
1230:
1231: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0
1232: , p5_a1
1233: , p5_a2
1234: , p5_a3
1235: , p5_a4

Line 1264: okl_tbo_pvt.update_row(p_api_version,

1260: );
1261:
1262:
1263: -- here's the delegated call to the old PL/SQL routine
1264: okl_tbo_pvt.update_row(p_api_version,
1265: p_init_msg_list,
1266: x_return_status,
1267: x_msg_count,
1268: x_msg_data,

Line 1279: okl_tbo_pvt_w.rosetta_table_copy_out_p2(ddx_tbov_tbl, p6_a0

1275:
1276:
1277:
1278:
1279: okl_tbo_pvt_w.rosetta_table_copy_out_p2(ddx_tbov_tbl, p6_a0
1280: , p6_a1
1281: , p6_a2
1282: , p6_a3
1283: , p6_a4

Line 1348: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;

1344: , p5_a28 NUMBER := 0-1962.0724
1345: )
1346:
1347: as
1348: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;
1349: ddindx binary_integer; indx binary_integer;
1350: begin
1351:
1352: -- copy data to the local IN or IN-OUT args, if any

Line 1389: okl_tbo_pvt.delete_row(p_api_version,

1385: ddp_tbov_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1386: ddp_tbov_rec.object_version_number := rosetta_g_miss_num_map(p5_a28);
1387:
1388: -- here's the delegated call to the old PL/SQL routine
1389: okl_tbo_pvt.delete_row(p_api_version,
1390: p_init_msg_list,
1391: x_return_status,
1392: x_msg_count,
1393: x_msg_data,

Line 1441: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;

1437: , p5_a28 JTF_NUMBER_TABLE
1438: )
1439:
1440: as
1441: ddp_tbov_tbl okl_tbo_pvt.tbov_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 1451: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0

1447:
1448:
1449:
1450:
1451: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0
1452: , p5_a1
1453: , p5_a2
1454: , p5_a3
1455: , p5_a4

Line 1483: okl_tbo_pvt.delete_row(p_api_version,

1479: , p5_a28
1480: );
1481:
1482: -- here's the delegated call to the old PL/SQL routine
1483: okl_tbo_pvt.delete_row(p_api_version,
1484: p_init_msg_list,
1485: x_return_status,
1486: x_msg_count,
1487: x_msg_data,

Line 1535: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;

1531: , p5_a28 NUMBER := 0-1962.0724
1532: )
1533:
1534: as
1535: ddp_tbov_rec okl_tbo_pvt.tbov_rec_type;
1536: ddindx binary_integer; indx binary_integer;
1537: begin
1538:
1539: -- copy data to the local IN or IN-OUT args, if any

Line 1576: okl_tbo_pvt.validate_row(p_api_version,

1572: ddp_tbov_rec.last_update_login := rosetta_g_miss_num_map(p5_a27);
1573: ddp_tbov_rec.object_version_number := rosetta_g_miss_num_map(p5_a28);
1574:
1575: -- here's the delegated call to the old PL/SQL routine
1576: okl_tbo_pvt.validate_row(p_api_version,
1577: p_init_msg_list,
1578: x_return_status,
1579: x_msg_count,
1580: x_msg_data,

Line 1628: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;

1624: , p5_a28 JTF_NUMBER_TABLE
1625: )
1626:
1627: as
1628: ddp_tbov_tbl okl_tbo_pvt.tbov_tbl_type;
1629: ddindx binary_integer; indx binary_integer;
1630: begin
1631:
1632: -- copy data to the local IN or IN-OUT args, if any

Line 1638: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0

1634:
1635:
1636:
1637:
1638: okl_tbo_pvt_w.rosetta_table_copy_in_p2(ddp_tbov_tbl, p5_a0
1639: , p5_a1
1640: , p5_a2
1641: , p5_a3
1642: , p5_a4

Line 1670: okl_tbo_pvt.validate_row(p_api_version,

1666: , p5_a28
1667: );
1668:
1669: -- here's the delegated call to the old PL/SQL routine
1670: okl_tbo_pvt.validate_row(p_api_version,
1671: p_init_msg_list,
1672: x_return_status,
1673: x_msg_count,
1674: x_msg_data,

Line 1685: end okl_tbo_pvt_w;

1681:
1682:
1683: end;
1684:
1685: end okl_tbo_pvt_w;