DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB_UIW_JW dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy hz_geography_pub_uiw.parent_geography_tbl_type, a0 JTF_NUMBER_TABLE);

1: package hz_geography_pub_uiw_jw as
2: /* $Header: ARHGEOJB.pls 120.2 2006/02/21 05:58:19 idali noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy hz_geography_pub_uiw.parent_geography_tbl_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p2(t hz_geography_pub_uiw.parent_geography_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p6(t out nocopy hz_geography_pub_uiw.zone_relation_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_400

Line 4: procedure rosetta_table_copy_out_p2(t hz_geography_pub_uiw.parent_geography_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

1: package hz_geography_pub_uiw_jw as
2: /* $Header: ARHGEOJB.pls 120.2 2006/02/21 05:58:19 idali noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy hz_geography_pub_uiw.parent_geography_tbl_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p2(t hz_geography_pub_uiw.parent_geography_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p6(t out nocopy hz_geography_pub_uiw.zone_relation_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_400
8: , a2 JTF_VARCHAR2_TABLE_400

Line 6: procedure rosetta_table_copy_in_p6(t out nocopy hz_geography_pub_uiw.zone_relation_tbl_type, a0 JTF_NUMBER_TABLE

2: /* $Header: ARHGEOJB.pls 120.2 2006/02/21 05:58:19 idali noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy hz_geography_pub_uiw.parent_geography_tbl_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p2(t hz_geography_pub_uiw.parent_geography_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p6(t out nocopy hz_geography_pub_uiw.zone_relation_tbl_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_VARCHAR2_TABLE_400
8: , a2 JTF_VARCHAR2_TABLE_400
9: , a3 JTF_VARCHAR2_TABLE_100
10: , a4 JTF_VARCHAR2_TABLE_100

Line 14: procedure rosetta_table_copy_out_p6(t hz_geography_pub_uiw.zone_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

10: , a4 JTF_VARCHAR2_TABLE_100
11: , a5 JTF_DATE_TABLE
12: , a6 JTF_DATE_TABLE
13: );
14: procedure rosetta_table_copy_out_p6(t hz_geography_pub_uiw.zone_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_400
16: , a2 out nocopy JTF_VARCHAR2_TABLE_400
17: , a3 out nocopy JTF_VARCHAR2_TABLE_100
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , p_parent_geography_id JTF_NUMBER_TABLE

66: , p1_a9 VARCHAR2 := null
67: , p1_a10 VARCHAR2 := null
68: );
69: procedure create_master_geography(p_init_msg_list VARCHAR2
70: , p_parent_geography_id JTF_NUMBER_TABLE
71: , x_geography_id out nocopy NUMBER
72: , x_return_status out nocopy VARCHAR2
73: , x_msg_count out nocopy NUMBER
74: , x_msg_data out nocopy VARCHAR2

Line 123: , p2_a0 JTF_NUMBER_TABLE

119: , x_msg_data out nocopy VARCHAR2
120: );
121: procedure create_zone_relation(p_init_msg_list VARCHAR2
122: , p_geography_id NUMBER
123: , p2_a0 JTF_NUMBER_TABLE
124: , p2_a1 JTF_VARCHAR2_TABLE_400
125: , p2_a2 JTF_VARCHAR2_TABLE_400
126: , p2_a3 JTF_VARCHAR2_TABLE_100
127: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 145: , p9_a0 JTF_NUMBER_TABLE

141: , p_start_date date
142: , p_end_date date
143: , p_geo_data_provider VARCHAR2
144: , p_language_code VARCHAR2
145: , p9_a0 JTF_NUMBER_TABLE
146: , p9_a1 JTF_VARCHAR2_TABLE_400
147: , p9_a2 JTF_VARCHAR2_TABLE_400
148: , p9_a3 JTF_VARCHAR2_TABLE_100
149: , p9_a4 JTF_VARCHAR2_TABLE_100