DBA Data[Home] [Help]

APPS.OKL_QQH_PVT_W dependencies on OKL_QQH_PVT

Line 1: package body okl_qqh_pvt_w as

1: package body okl_qqh_pvt_w as
2: /* $Header: OKLIQQHB.pls 120.1 2005/12/28 13:38:57 abhsaxen noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_qqh_pvt.qqhv_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_qqh_pvt.qqhv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_qqh_pvt_w as
2: /* $Header: OKLIQQHB.pls 120.1 2005/12/28 13:38:57 abhsaxen noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_qqh_pvt.qqhv_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 128: procedure rosetta_table_copy_out_p23(t okl_qqh_pvt.qqhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

124: end loop;
125: end if;
126: end if;
127: end rosetta_table_copy_in_p23;
128: procedure rosetta_table_copy_out_p23(t okl_qqh_pvt.qqhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_NUMBER_TABLE
130: , a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , a3 out nocopy JTF_VARCHAR2_TABLE_500
132: , a4 out nocopy JTF_VARCHAR2_TABLE_500

Line 533: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;

529: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
530: )
531:
532: as
533: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
534: ddx_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
535: ddindx binary_integer; indx binary_integer;
536: begin
537:

Line 534: ddx_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;

530: )
531:
532: as
533: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
534: ddx_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
535: ddindx binary_integer; indx binary_integer;
536: begin
537:
538: -- copy data to the local IN or IN-OUT args, if any

Line 544: okl_qqh_pvt_w.rosetta_table_copy_in_p23(ddp_qqhv_tbl, p5_a0

540:
541:
542:
543:
544: okl_qqh_pvt_w.rosetta_table_copy_in_p23(ddp_qqhv_tbl, p5_a0
545: , p5_a1
546: , p5_a2
547: , p5_a3
548: , p5_a4

Line 602: okl_qqh_pvt.insert_row(p_api_version,

598: );
599:
600:
601: -- here's the delegated call to the old PL/SQL routine
602: okl_qqh_pvt.insert_row(p_api_version,
603: p_init_msg_list,
604: x_return_status,
605: x_msg_count,
606: x_msg_data,

Line 617: okl_qqh_pvt_w.rosetta_table_copy_out_p23(ddx_qqhv_tbl, p6_a0

613:
614:
615:
616:
617: okl_qqh_pvt_w.rosetta_table_copy_out_p23(ddx_qqhv_tbl, p6_a0
618: , p6_a1
619: , p6_a2
620: , p6_a3
621: , p6_a4

Line 790: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;

786: , p6_a53 out nocopy JTF_VARCHAR2_TABLE_100
787: )
788:
789: as
790: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
791: ddx_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
792: ddindx binary_integer; indx binary_integer;
793: begin
794:

Line 791: ddx_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;

787: )
788:
789: as
790: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
791: ddx_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
792: ddindx binary_integer; indx binary_integer;
793: begin
794:
795: -- copy data to the local IN or IN-OUT args, if any

Line 801: okl_qqh_pvt_w.rosetta_table_copy_in_p23(ddp_qqhv_tbl, p5_a0

797:
798:
799:
800:
801: okl_qqh_pvt_w.rosetta_table_copy_in_p23(ddp_qqhv_tbl, p5_a0
802: , p5_a1
803: , p5_a2
804: , p5_a3
805: , p5_a4

Line 859: okl_qqh_pvt.update_row(p_api_version,

855: );
856:
857:
858: -- here's the delegated call to the old PL/SQL routine
859: okl_qqh_pvt.update_row(p_api_version,
860: p_init_msg_list,
861: x_return_status,
862: x_msg_count,
863: x_msg_data,

Line 874: okl_qqh_pvt_w.rosetta_table_copy_out_p23(ddx_qqhv_tbl, p6_a0

870:
871:
872:
873:
874: okl_qqh_pvt_w.rosetta_table_copy_out_p23(ddx_qqhv_tbl, p6_a0
875: , p6_a1
876: , p6_a2
877: , p6_a3
878: , p6_a4

Line 993: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;

989: , p5_a53 JTF_VARCHAR2_TABLE_100
990: )
991:
992: as
993: ddp_qqhv_tbl okl_qqh_pvt.qqhv_tbl_type;
994: ddindx binary_integer; indx binary_integer;
995: begin
996:
997: -- copy data to the local IN or IN-OUT args, if any

Line 1003: okl_qqh_pvt_w.rosetta_table_copy_in_p23(ddp_qqhv_tbl, p5_a0

999:
1000:
1001:
1002:
1003: okl_qqh_pvt_w.rosetta_table_copy_in_p23(ddp_qqhv_tbl, p5_a0
1004: , p5_a1
1005: , p5_a2
1006: , p5_a3
1007: , p5_a4

Line 1060: okl_qqh_pvt.delete_row(p_api_version,

1056: , p5_a53
1057: );
1058:
1059: -- here's the delegated call to the old PL/SQL routine
1060: okl_qqh_pvt.delete_row(p_api_version,
1061: p_init_msg_list,
1062: x_return_status,
1063: x_msg_count,
1064: x_msg_data,

Line 1191: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;

1187: , p6_a53 out nocopy VARCHAR2
1188: )
1189:
1190: as
1191: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1192: ddx_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1193: ddindx binary_integer; indx binary_integer;
1194: begin
1195:

Line 1192: ddx_qqhv_rec okl_qqh_pvt.qqhv_rec_type;

1188: )
1189:
1190: as
1191: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1192: ddx_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1193: ddindx binary_integer; indx binary_integer;
1194: begin
1195:
1196: -- copy data to the local IN or IN-OUT args, if any

Line 1259: okl_qqh_pvt.insert_row(p_api_version,

1255: ddp_qqhv_rec.sts_code := p5_a53;
1256:
1257:
1258: -- here's the delegated call to the old PL/SQL routine
1259: okl_qqh_pvt.insert_row(p_api_version,
1260: p_init_msg_list,
1261: x_return_status,
1262: x_msg_count,
1263: x_msg_data,

Line 1446: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;

1442: , p6_a53 out nocopy VARCHAR2
1443: )
1444:
1445: as
1446: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1447: ddx_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1448: ddindx binary_integer; indx binary_integer;
1449: begin
1450:

Line 1447: ddx_qqhv_rec okl_qqh_pvt.qqhv_rec_type;

1443: )
1444:
1445: as
1446: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1447: ddx_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1448: ddindx binary_integer; indx binary_integer;
1449: begin
1450:
1451: -- copy data to the local IN or IN-OUT args, if any

Line 1514: okl_qqh_pvt.update_row(p_api_version,

1510: ddp_qqhv_rec.sts_code := p5_a53;
1511:
1512:
1513: -- here's the delegated call to the old PL/SQL routine
1514: okl_qqh_pvt.update_row(p_api_version,
1515: p_init_msg_list,
1516: x_return_status,
1517: x_msg_count,
1518: x_msg_data,

Line 1647: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;

1643: , p5_a53 VARCHAR2
1644: )
1645:
1646: as
1647: ddp_qqhv_rec okl_qqh_pvt.qqhv_rec_type;
1648: ddindx binary_integer; indx binary_integer;
1649: begin
1650:
1651: -- copy data to the local IN or IN-OUT args, if any

Line 1713: okl_qqh_pvt.delete_row(p_api_version,

1709: ddp_qqhv_rec.comments := p5_a52;
1710: ddp_qqhv_rec.sts_code := p5_a53;
1711:
1712: -- here's the delegated call to the old PL/SQL routine
1713: okl_qqh_pvt.delete_row(p_api_version,
1714: p_init_msg_list,
1715: x_return_status,
1716: x_msg_count,
1717: x_msg_data,

Line 1728: end okl_qqh_pvt_w;

1724:
1725:
1726: end;
1727:
1728: end okl_qqh_pvt_w;