APPS.HZ_GNR_PVT_W dependencies on HZ_GNR_PVT

Line 1: package body hz_gnr_pvt_w as

1: package body hz_gnr_pvt_w as
2: /* $Header: ARHGNRWB.pls 120.4 2006/02/09 21:51:33 nsinghai 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_p4(t out nocopy hz_gnr_pvt.geo_struct_tbl_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy hz_gnr_pvt.geo_struct_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_300

Line 51: procedure rosetta_table_copy_out_p4(t hz_gnr_pvt.geo_struct_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p4;
51: procedure rosetta_table_copy_out_p4(t hz_gnr_pvt.geo_struct_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_100
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 100: procedure rosetta_table_copy_in_p6(t out nocopy hz_gnr_pvt.geo_suggest_tbl_type, a0 JTF_VARCHAR2_TABLE_100

96: end if;
97: end if;
98: end rosetta_table_copy_out_p4;
99:
100: procedure rosetta_table_copy_in_p6(t out nocopy hz_gnr_pvt.geo_suggest_tbl_type, a0 JTF_VARCHAR2_TABLE_100
101: , a1 JTF_VARCHAR2_TABLE_100
102: , a2 JTF_NUMBER_TABLE
103: , a3 JTF_VARCHAR2_TABLE_100
104: , a4 JTF_VARCHAR2_TABLE_100

Line 227: procedure rosetta_table_copy_out_p6(t hz_gnr_pvt.geo_suggest_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

223: end loop;
224: end if;
225: end if;
226: end rosetta_table_copy_in_p6;
227: procedure rosetta_table_copy_out_p6(t hz_gnr_pvt.geo_suggest_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
228: , a1 out nocopy JTF_VARCHAR2_TABLE_100
229: , a2 out nocopy JTF_NUMBER_TABLE
230: , a3 out nocopy JTF_VARCHAR2_TABLE_100
231: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 613: ddx_geo_suggest_tbl hz_gnr_pvt.geo_suggest_tbl_type;

609: , x_msg_data out nocopy VARCHAR2
610: )
611:
612: as
613: ddx_geo_suggest_tbl hz_gnr_pvt.geo_suggest_tbl_type;
614: ddx_geo_struct_tbl hz_gnr_pvt.geo_struct_tbl_type;
615: ddx_geo_suggest_misc_rec hz_gnr_pvt.geo_suggest_misc_rec;
616: ddindx binary_integer; indx binary_integer;
617: begin

Line 614: ddx_geo_struct_tbl hz_gnr_pvt.geo_struct_tbl_type;

610: )
611:
612: as
613: ddx_geo_suggest_tbl hz_gnr_pvt.geo_suggest_tbl_type;
614: ddx_geo_struct_tbl hz_gnr_pvt.geo_struct_tbl_type;
615: ddx_geo_suggest_misc_rec hz_gnr_pvt.geo_suggest_misc_rec;
616: ddindx binary_integer; indx binary_integer;
617: begin
618:

Line 615: ddx_geo_suggest_misc_rec hz_gnr_pvt.geo_suggest_misc_rec;

611:
612: as
613: ddx_geo_suggest_tbl hz_gnr_pvt.geo_suggest_tbl_type;
614: ddx_geo_struct_tbl hz_gnr_pvt.geo_struct_tbl_type;
615: ddx_geo_suggest_misc_rec hz_gnr_pvt.geo_suggest_misc_rec;
616: ddindx binary_integer; indx binary_integer;
617: begin
618:
619: -- copy data to the local IN or IN-OUT args, if any

Line 651: hz_gnr_pvt.search_geographies(p_table_name,

647:
648:
649:
650: -- here's the delegated call to the old PL/SQL routine
651: hz_gnr_pvt.search_geographies(p_table_name,
652: p_address_style,
653: p_address_usage,
654: p_country_code,
655: p_state,

Line 707: hz_gnr_pvt_w.rosetta_table_copy_out_p6(ddx_geo_suggest_tbl, p24_a0

703:
704:
705:
706:
707: hz_gnr_pvt_w.rosetta_table_copy_out_p6(ddx_geo_suggest_tbl, p24_a0
708: , p24_a1
709: , p24_a2
710: , p24_a3
711: , p24_a4

Line 764: hz_gnr_pvt_w.rosetta_table_copy_out_p4(ddx_geo_struct_tbl, p25_a0

760: , p24_a53
761: , p24_a54
762: );
763:
764: hz_gnr_pvt_w.rosetta_table_copy_out_p4(ddx_geo_struct_tbl, p25_a0
765: , p25_a1
766: , p25_a2
767: , p25_a3
768: , p25_a4

Line 778: end hz_gnr_pvt_w;

774:
775:
776: end;
777:
778: end hz_gnr_pvt_w;