DBA Data[Home] [Help]

APPS.OKL_LSQ_PVT_W dependencies on OKL_LSQ_PVT

Line 1: package body okl_lsq_pvt_w as

1: package body okl_lsq_pvt_w as
2: /* $Header: OKLILSQB.pls 120.2 2007/03/20 23:14:39 rravikir noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_lsq_pvt.lsqv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p23(t out nocopy okl_lsq_pvt.lsqv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_lsq_pvt_w as
2: /* $Header: OKLILSQB.pls 120.2 2007/03/20 23:14:39 rravikir noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_lsq_pvt.lsqv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500

Line 164: procedure rosetta_table_copy_out_p23(t okl_lsq_pvt.lsqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p23;
164: procedure rosetta_table_copy_out_p23(t okl_lsq_pvt.lsqv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_VARCHAR2_TABLE_100
167: , a3 out nocopy JTF_VARCHAR2_TABLE_500
168: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 695: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;

691: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000
692: )
693:
694: as
695: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
696: ddx_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
697: ddindx binary_integer; indx binary_integer;
698: begin
699:

Line 696: ddx_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;

692: )
693:
694: as
695: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
696: ddx_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
697: ddindx binary_integer; indx binary_integer;
698: begin
699:
700: -- copy data to the local IN or IN-OUT args, if any

Line 706: okl_lsq_pvt_w.rosetta_table_copy_in_p23(ddp_lsqv_tbl, p5_a0

702:
703:
704:
705:
706: okl_lsq_pvt_w.rosetta_table_copy_in_p23(ddp_lsqv_tbl, p5_a0
707: , p5_a1
708: , p5_a2
709: , p5_a3
710: , p5_a4

Line 782: okl_lsq_pvt.insert_row(p_api_version,

778: );
779:
780:
781: -- here's the delegated call to the old PL/SQL routine
782: okl_lsq_pvt.insert_row(p_api_version,
783: p_init_msg_list,
784: x_return_status,
785: x_msg_count,
786: x_msg_data,

Line 797: okl_lsq_pvt_w.rosetta_table_copy_out_p23(ddx_lsqv_tbl, p6_a0

793:
794:
795:
796:
797: okl_lsq_pvt_w.rosetta_table_copy_out_p23(ddx_lsqv_tbl, p6_a0
798: , p6_a1
799: , p6_a2
800: , p6_a3
801: , p6_a4

Line 1024: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;

1020: , p6_a71 out nocopy JTF_VARCHAR2_TABLE_2000
1021: )
1022:
1023: as
1024: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
1025: ddx_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
1026: ddindx binary_integer; indx binary_integer;
1027: begin
1028:

Line 1025: ddx_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;

1021: )
1022:
1023: as
1024: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
1025: ddx_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
1026: ddindx binary_integer; indx binary_integer;
1027: begin
1028:
1029: -- copy data to the local IN or IN-OUT args, if any

Line 1035: okl_lsq_pvt_w.rosetta_table_copy_in_p23(ddp_lsqv_tbl, p5_a0

1031:
1032:
1033:
1034:
1035: okl_lsq_pvt_w.rosetta_table_copy_in_p23(ddp_lsqv_tbl, p5_a0
1036: , p5_a1
1037: , p5_a2
1038: , p5_a3
1039: , p5_a4

Line 1111: okl_lsq_pvt.update_row(p_api_version,

1107: );
1108:
1109:
1110: -- here's the delegated call to the old PL/SQL routine
1111: okl_lsq_pvt.update_row(p_api_version,
1112: p_init_msg_list,
1113: x_return_status,
1114: x_msg_count,
1115: x_msg_data,

Line 1126: okl_lsq_pvt_w.rosetta_table_copy_out_p23(ddx_lsqv_tbl, p6_a0

1122:
1123:
1124:
1125:
1126: okl_lsq_pvt_w.rosetta_table_copy_out_p23(ddx_lsqv_tbl, p6_a0
1127: , p6_a1
1128: , p6_a2
1129: , p6_a3
1130: , p6_a4

Line 1281: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;

1277: , p5_a71 JTF_VARCHAR2_TABLE_2000
1278: )
1279:
1280: as
1281: ddp_lsqv_tbl okl_lsq_pvt.lsqv_tbl_type;
1282: ddindx binary_integer; indx binary_integer;
1283: begin
1284:
1285: -- copy data to the local IN or IN-OUT args, if any

Line 1291: okl_lsq_pvt_w.rosetta_table_copy_in_p23(ddp_lsqv_tbl, p5_a0

1287:
1288:
1289:
1290:
1291: okl_lsq_pvt_w.rosetta_table_copy_in_p23(ddp_lsqv_tbl, p5_a0
1292: , p5_a1
1293: , p5_a2
1294: , p5_a3
1295: , p5_a4

Line 1366: okl_lsq_pvt.delete_row(p_api_version,

1362: , p5_a71
1363: );
1364:
1365: -- here's the delegated call to the old PL/SQL routine
1366: okl_lsq_pvt.delete_row(p_api_version,
1367: p_init_msg_list,
1368: x_return_status,
1369: x_msg_count,
1370: x_msg_data,

Line 1533: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;

1529: , p6_a71 out nocopy VARCHAR2
1530: )
1531:
1532: as
1533: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1534: ddx_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1535: ddindx binary_integer; indx binary_integer;
1536: begin
1537:

Line 1534: ddx_lsqv_rec okl_lsq_pvt.lsqv_rec_type;

1530: )
1531:
1532: as
1533: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1534: ddx_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1535: ddindx binary_integer; indx binary_integer;
1536: begin
1537:
1538: -- copy data to the local IN or IN-OUT args, if any

Line 1619: okl_lsq_pvt.insert_row(p_api_version,

1615: ddp_lsqv_rec.comments := p5_a71;
1616:
1617:
1618: -- here's the delegated call to the old PL/SQL routine
1619: okl_lsq_pvt.insert_row(p_api_version,
1620: p_init_msg_list,
1621: x_return_status,
1622: x_msg_count,
1623: x_msg_data,

Line 1860: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;

1856: , p6_a71 out nocopy VARCHAR2
1857: )
1858:
1859: as
1860: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1861: ddx_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1862: ddindx binary_integer; indx binary_integer;
1863: begin
1864:

Line 1861: ddx_lsqv_rec okl_lsq_pvt.lsqv_rec_type;

1857: )
1858:
1859: as
1860: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1861: ddx_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
1862: ddindx binary_integer; indx binary_integer;
1863: begin
1864:
1865: -- copy data to the local IN or IN-OUT args, if any

Line 1946: okl_lsq_pvt.update_row(p_api_version,

1942: ddp_lsqv_rec.comments := p5_a71;
1943:
1944:
1945: -- here's the delegated call to the old PL/SQL routine
1946: okl_lsq_pvt.update_row(p_api_version,
1947: p_init_msg_list,
1948: x_return_status,
1949: x_msg_count,
1950: x_msg_data,

Line 2115: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;

2111: , p5_a71 VARCHAR2
2112: )
2113:
2114: as
2115: ddp_lsqv_rec okl_lsq_pvt.lsqv_rec_type;
2116: ddindx binary_integer; indx binary_integer;
2117: begin
2118:
2119: -- copy data to the local IN or IN-OUT args, if any

Line 2199: okl_lsq_pvt.delete_row(p_api_version,

2195: ddp_lsqv_rec.description := p5_a70;
2196: ddp_lsqv_rec.comments := p5_a71;
2197:
2198: -- here's the delegated call to the old PL/SQL routine
2199: okl_lsq_pvt.delete_row(p_api_version,
2200: p_init_msg_list,
2201: x_return_status,
2202: x_msg_count,
2203: x_msg_data,

Line 2214: end okl_lsq_pvt_w;

2210:
2211:
2212: end;
2213:
2214: end okl_lsq_pvt_w;