DBA Data[Home] [Help]

APPS.OKL_SRT_PVT_W dependencies on OKL_SRT_PVT

Line 1: package body okl_srt_pvt_w as

1: package body okl_srt_pvt_w as
2: /* $Header: OKLISRTB.pls 120.0 2005/07/07 10:40:32 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srt_pvt.okl_srtv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_2000

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srt_pvt.okl_srtv_tbl, a0 JTF_NUMBER_TABLE

1: package body okl_srt_pvt_w as
2: /* $Header: OKLISRTB.pls 120.0 2005/07/07 10:40:32 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srt_pvt.okl_srtv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 96: procedure rosetta_table_copy_out_p1(t okl_srt_pvt.okl_srtv_tbl, a0 out nocopy JTF_NUMBER_TABLE

92: end loop;
93: end if;
94: end if;
95: end rosetta_table_copy_in_p1;
96: procedure rosetta_table_copy_out_p1(t okl_srt_pvt.okl_srtv_tbl, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_300
98: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a3 out nocopy JTF_NUMBER_TABLE
100: , a4 out nocopy JTF_NUMBER_TABLE

Line 305: procedure rosetta_table_copy_in_p3(t out nocopy okl_srt_pvt.okl_srtb_tbl, a0 JTF_NUMBER_TABLE

301: end if;
302: end if;
303: end rosetta_table_copy_out_p1;
304:
305: procedure rosetta_table_copy_in_p3(t out nocopy okl_srt_pvt.okl_srtb_tbl, a0 JTF_NUMBER_TABLE
306: , a1 JTF_VARCHAR2_TABLE_300
307: , a2 JTF_NUMBER_TABLE
308: , a3 JTF_NUMBER_TABLE
309: , a4 JTF_VARCHAR2_TABLE_100

Line 396: procedure rosetta_table_copy_out_p3(t okl_srt_pvt.okl_srtb_tbl, a0 out nocopy JTF_NUMBER_TABLE

392: end loop;
393: end if;
394: end if;
395: end rosetta_table_copy_in_p3;
396: procedure rosetta_table_copy_out_p3(t okl_srt_pvt.okl_srtb_tbl, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_VARCHAR2_TABLE_300
398: , a2 out nocopy JTF_NUMBER_TABLE
399: , a3 out nocopy JTF_NUMBER_TABLE
400: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 600: procedure rosetta_table_copy_in_p5(t out nocopy okl_srt_pvt.okl_srttl_tbl, a0 JTF_NUMBER_TABLE

596: end if;
597: end if;
598: end rosetta_table_copy_out_p3;
599:
600: procedure rosetta_table_copy_in_p5(t out nocopy okl_srt_pvt.okl_srttl_tbl, a0 JTF_NUMBER_TABLE
601: , a1 JTF_VARCHAR2_TABLE_2000
602: , a2 JTF_VARCHAR2_TABLE_100
603: , a3 JTF_VARCHAR2_TABLE_100
604: , a4 JTF_VARCHAR2_TABLE_100

Line 637: procedure rosetta_table_copy_out_p5(t okl_srt_pvt.okl_srttl_tbl, a0 out nocopy JTF_NUMBER_TABLE

633: end loop;
634: end if;
635: end if;
636: end rosetta_table_copy_in_p5;
637: procedure rosetta_table_copy_out_p5(t okl_srt_pvt.okl_srttl_tbl, a0 out nocopy JTF_NUMBER_TABLE
638: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
639: , a2 out nocopy JTF_VARCHAR2_TABLE_100
640: , a3 out nocopy JTF_VARCHAR2_TABLE_100
641: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 790: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;

786: , p6_a37 out nocopy NUMBER
787: )
788:
789: as
790: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;
791: ddx_srtv_rec okl_srt_pvt.okl_srtv_rec;
792: ddindx binary_integer; indx binary_integer;
793: begin
794:

Line 791: ddx_srtv_rec okl_srt_pvt.okl_srtv_rec;

787: )
788:
789: as
790: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;
791: ddx_srtv_rec okl_srt_pvt.okl_srtv_rec;
792: ddindx binary_integer; indx binary_integer;
793: begin
794:
795: -- copy data to the local IN or IN-OUT args, if any

Line 842: okl_srt_pvt.insert_row(p_api_version,

838: ddp_srtv_rec.last_update_login := p5_a37;
839:
840:
841: -- here's the delegated call to the old PL/SQL routine
842: okl_srt_pvt.insert_row(p_api_version,
843: p_init_msg_list,
844: x_return_status,
845: x_msg_count,
846: x_msg_data,

Line 981: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;

977: , p6_a37 out nocopy JTF_NUMBER_TABLE
978: )
979:
980: as
981: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
982: ddx_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
983: ddindx binary_integer; indx binary_integer;
984: begin
985:

Line 982: ddx_srtv_tbl okl_srt_pvt.okl_srtv_tbl;

978: )
979:
980: as
981: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
982: ddx_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
983: ddindx binary_integer; indx binary_integer;
984: begin
985:
986: -- copy data to the local IN or IN-OUT args, if any

Line 992: okl_srt_pvt_w.rosetta_table_copy_in_p1(ddp_srtv_tbl, p5_a0

988:
989:
990:
991:
992: okl_srt_pvt_w.rosetta_table_copy_in_p1(ddp_srtv_tbl, p5_a0
993: , p5_a1
994: , p5_a2
995: , p5_a3
996: , p5_a4

Line 1034: okl_srt_pvt.insert_row(p_api_version,

1030: );
1031:
1032:
1033: -- here's the delegated call to the old PL/SQL routine
1034: okl_srt_pvt.insert_row(p_api_version,
1035: p_init_msg_list,
1036: x_return_status,
1037: x_msg_count,
1038: x_msg_data,

Line 1049: okl_srt_pvt_w.rosetta_table_copy_out_p1(ddx_srtv_tbl, p6_a0

1045:
1046:
1047:
1048:
1049: okl_srt_pvt_w.rosetta_table_copy_out_p1(ddx_srtv_tbl, p6_a0
1050: , p6_a1
1051: , p6_a2
1052: , p6_a3
1053: , p6_a4

Line 1174: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;

1170: , p6_a37 out nocopy NUMBER
1171: )
1172:
1173: as
1174: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;
1175: ddx_srtv_rec okl_srt_pvt.okl_srtv_rec;
1176: ddindx binary_integer; indx binary_integer;
1177: begin
1178:

Line 1175: ddx_srtv_rec okl_srt_pvt.okl_srtv_rec;

1171: )
1172:
1173: as
1174: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;
1175: ddx_srtv_rec okl_srt_pvt.okl_srtv_rec;
1176: ddindx binary_integer; indx binary_integer;
1177: begin
1178:
1179: -- copy data to the local IN or IN-OUT args, if any

Line 1226: okl_srt_pvt.update_row(p_api_version,

1222: ddp_srtv_rec.last_update_login := p5_a37;
1223:
1224:
1225: -- here's the delegated call to the old PL/SQL routine
1226: okl_srt_pvt.update_row(p_api_version,
1227: p_init_msg_list,
1228: x_return_status,
1229: x_msg_count,
1230: x_msg_data,

Line 1365: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;

1361: , p6_a37 out nocopy JTF_NUMBER_TABLE
1362: )
1363:
1364: as
1365: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
1366: ddx_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
1367: ddindx binary_integer; indx binary_integer;
1368: begin
1369:

Line 1366: ddx_srtv_tbl okl_srt_pvt.okl_srtv_tbl;

1362: )
1363:
1364: as
1365: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
1366: ddx_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
1367: ddindx binary_integer; indx binary_integer;
1368: begin
1369:
1370: -- copy data to the local IN or IN-OUT args, if any

Line 1376: okl_srt_pvt_w.rosetta_table_copy_in_p1(ddp_srtv_tbl, p5_a0

1372:
1373:
1374:
1375:
1376: okl_srt_pvt_w.rosetta_table_copy_in_p1(ddp_srtv_tbl, p5_a0
1377: , p5_a1
1378: , p5_a2
1379: , p5_a3
1380: , p5_a4

Line 1418: okl_srt_pvt.update_row(p_api_version,

1414: );
1415:
1416:
1417: -- here's the delegated call to the old PL/SQL routine
1418: okl_srt_pvt.update_row(p_api_version,
1419: p_init_msg_list,
1420: x_return_status,
1421: x_msg_count,
1422: x_msg_data,

Line 1433: okl_srt_pvt_w.rosetta_table_copy_out_p1(ddx_srtv_tbl, p6_a0

1429:
1430:
1431:
1432:
1433: okl_srt_pvt_w.rosetta_table_copy_out_p1(ddx_srtv_tbl, p6_a0
1434: , p6_a1
1435: , p6_a2
1436: , p6_a3
1437: , p6_a4

Line 1520: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;

1516: , p5_a37 NUMBER
1517: )
1518:
1519: as
1520: ddp_srtv_rec okl_srt_pvt.okl_srtv_rec;
1521: ddindx binary_integer; indx binary_integer;
1522: begin
1523:
1524: -- copy data to the local IN or IN-OUT args, if any

Line 1570: okl_srt_pvt.delete_row(p_api_version,

1566: ddp_srtv_rec.last_update_date := p5_a36;
1567: ddp_srtv_rec.last_update_login := p5_a37;
1568:
1569: -- here's the delegated call to the old PL/SQL routine
1570: okl_srt_pvt.delete_row(p_api_version,
1571: p_init_msg_list,
1572: x_return_status,
1573: x_msg_count,
1574: x_msg_data,

Line 1631: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;

1627: , p5_a37 JTF_NUMBER_TABLE
1628: )
1629:
1630: as
1631: ddp_srtv_tbl okl_srt_pvt.okl_srtv_tbl;
1632: ddindx binary_integer; indx binary_integer;
1633: begin
1634:
1635: -- copy data to the local IN or IN-OUT args, if any

Line 1641: okl_srt_pvt_w.rosetta_table_copy_in_p1(ddp_srtv_tbl, p5_a0

1637:
1638:
1639:
1640:
1641: okl_srt_pvt_w.rosetta_table_copy_in_p1(ddp_srtv_tbl, p5_a0
1642: , p5_a1
1643: , p5_a2
1644: , p5_a3
1645: , p5_a4

Line 1682: okl_srt_pvt.delete_row(p_api_version,

1678: , p5_a37
1679: );
1680:
1681: -- here's the delegated call to the old PL/SQL routine
1682: okl_srt_pvt.delete_row(p_api_version,
1683: p_init_msg_list,
1684: x_return_status,
1685: x_msg_count,
1686: x_msg_data,

Line 1697: end okl_srt_pvt_w;

1693:
1694:
1695: end;
1696:
1697: end okl_srt_pvt_w;