DBA Data[Home] [Help]

APPS.HZ_GEO_UI_UTIL_PUB_W dependencies on HZ_GEO_UI_UTIL_PUB

Line 1: package body hz_geo_ui_util_pub_w as

1: package body hz_geo_ui_util_pub_w as
2: /* $Header: ARHGEUJB.pls 120.3 2005/09/28 20:10:59 sroychou 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_p1(t out nocopy hz_geo_ui_util_pub.tax_geo_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_p1(t out nocopy hz_geo_ui_util_pub.tax_geo_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_400
24: , a2 JTF_VARCHAR2_TABLE_400
25: , a3 JTF_VARCHAR2_TABLE_100
26: ) as

Line 47: procedure rosetta_table_copy_out_p1(t hz_geo_ui_util_pub.tax_geo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

43: end loop;
44: end if;
45: end if;
46: end rosetta_table_copy_in_p1;
47: procedure rosetta_table_copy_out_p1(t hz_geo_ui_util_pub.tax_geo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_400
49: , a2 out nocopy JTF_VARCHAR2_TABLE_400
50: , a3 out nocopy JTF_VARCHAR2_TABLE_100
51: ) as

Line 103: ddp_tax_tbl hz_geo_ui_util_pub.tax_geo_tbl_type;

99: , x_show_gnr out nocopy VARCHAR2
100: )
101:
102: as
103: ddp_tax_tbl hz_geo_ui_util_pub.tax_geo_tbl_type;
104: ddp_geo_tbl hz_geo_ui_util_pub.tax_geo_tbl_type;
105: ddindx binary_integer; indx binary_integer;
106: begin
107:

Line 104: ddp_geo_tbl hz_geo_ui_util_pub.tax_geo_tbl_type;

100: )
101:
102: as
103: ddp_tax_tbl hz_geo_ui_util_pub.tax_geo_tbl_type;
104: ddp_geo_tbl hz_geo_ui_util_pub.tax_geo_tbl_type;
105: ddindx binary_integer; indx binary_integer;
106: begin
107:
108: -- copy data to the local IN or IN-OUT args, if any

Line 110: hz_geo_ui_util_pub_w.rosetta_table_copy_in_p1(ddp_tax_tbl, p1_a0

106: begin
107:
108: -- copy data to the local IN or IN-OUT args, if any
109:
110: hz_geo_ui_util_pub_w.rosetta_table_copy_in_p1(ddp_tax_tbl, p1_a0
111: , p1_a1
112: , p1_a2
113: , p1_a3
114: );

Line 116: hz_geo_ui_util_pub_w.rosetta_table_copy_in_p1(ddp_geo_tbl, p2_a0

112: , p1_a2
113: , p1_a3
114: );
115:
116: hz_geo_ui_util_pub_w.rosetta_table_copy_in_p1(ddp_geo_tbl, p2_a0
117: , p2_a1
118: , p2_a2
119: , p2_a3
120: );

Line 128: hz_geo_ui_util_pub.update_map_usages(p_map_id,

124:
125:
126:
127: -- here's the delegated call to the old PL/SQL routine
128: hz_geo_ui_util_pub.update_map_usages(p_map_id,
129: ddp_tax_tbl,
130: ddp_geo_tbl,
131: p_init_msg_list,
132: x_return_status,

Line 147: end hz_geo_ui_util_pub_w;

143:
144:
145: end;
146:
147: end hz_geo_ui_util_pub_w;