[Home] [Help]
PACKAGE: APPS.HZ_GEOGRAPHY_PUB_UIW_JW
Source
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
9 , a3 JTF_VARCHAR2_TABLE_100
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
19 , a5 out nocopy JTF_DATE_TABLE
20 , a6 out nocopy JTF_DATE_TABLE
21 );
22
23 procedure create_master_relation(p_init_msg_list VARCHAR2
24 , x_relationship_id out nocopy NUMBER
25 , x_return_status out nocopy VARCHAR2
26 , x_msg_count out nocopy NUMBER
27 , x_msg_data out nocopy VARCHAR2
28 , p1_a0 NUMBER := null
29 , p1_a1 NUMBER := null
30 , p1_a2 DATE := SYSDATE
31 , p1_a3 DATE := to_date('31-12-4712','DD-MM-YYYY')
32 , p1_a4 VARCHAR2 := null
33 , p1_a5 NUMBER := null
34 );
35 procedure create_geo_identifier(p_init_msg_list VARCHAR2
36 , x_return_status out nocopy VARCHAR2
37 , x_msg_count out nocopy NUMBER
38 , x_msg_data out nocopy VARCHAR2
39 , p1_a0 NUMBER := null
40 , p1_a1 VARCHAR2 := null
41 , p1_a2 VARCHAR2 := null
42 , p1_a3 VARCHAR2 := null
43 , p1_a4 VARCHAR2 := 'USER_ENTERED'
44 , p1_a5 VARCHAR2 := 'N'
45 , p1_a6 VARCHAR2 := userenv('LANG')
46 , p1_a7 VARCHAR2 := null
47 , p1_a8 NUMBER := null
48 , p1_a9 VARCHAR2 := null
49 , p1_a10 VARCHAR2 := null
50 );
51 procedure update_geo_identifier(p_init_msg_list VARCHAR2
52 , p_object_version_number in out nocopy NUMBER
53 , x_cp_request_id out nocopy NUMBER
54 , x_return_status out nocopy VARCHAR2
55 , x_msg_count out nocopy NUMBER
56 , x_msg_data out nocopy VARCHAR2
57 , p1_a0 NUMBER := null
58 , p1_a1 VARCHAR2 := null
59 , p1_a2 VARCHAR2 := null
60 , p1_a3 VARCHAR2 := null
61 , p1_a4 VARCHAR2 := null
62 , p1_a5 VARCHAR2 := null
63 , p1_a6 VARCHAR2 := userenv('LANG')
64 , p1_a7 VARCHAR2 := null
65 , p1_a8 NUMBER := null
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
75 , p1_a0 VARCHAR2 := null
76 , p1_a1 VARCHAR2 := null
77 , p1_a2 VARCHAR2 := null
78 , p1_a3 VARCHAR2 := null
79 , p1_a4 DATE := SYSDATE
80 , p1_a5 DATE := to_date('31-12-4712', 'DD-MM-YYYY')
81 , p1_a6 VARCHAR2 := 'USER_ENTERED'
82 , p1_a7 VARCHAR2 := userenv('LANG')
83 , p1_a8 VARCHAR2 := null
84 , p1_a9 VARCHAR2 := null
85 , p1_a10 NUMBER := null
86 );
87 procedure update_geography(p_init_msg_list VARCHAR2
88 , p_geography_id NUMBER
89 , p_end_date date
90 , p_timezone_code VARCHAR2
91 , p_object_version_number in out nocopy NUMBER
92 , x_return_status out nocopy VARCHAR2
93 , x_msg_count out nocopy NUMBER
94 , x_msg_data out nocopy VARCHAR2
95 );
96 procedure create_geography_range(p_init_msg_list VARCHAR2
97 , x_return_status out nocopy VARCHAR2
98 , x_msg_count out nocopy NUMBER
99 , x_msg_data out nocopy VARCHAR2
100 , p1_a0 NUMBER := null
101 , p1_a1 NUMBER := null
102 , p1_a2 VARCHAR2 := null
103 , p1_a3 VARCHAR2 := null
104 , p1_a4 VARCHAR2 := null
105 , p1_a5 VARCHAR2 := null
106 , p1_a6 DATE := SYSDATE
107 , p1_a7 DATE := to_date('31-12-4712','DD-MM-YYYY')
108 , p1_a8 VARCHAR2 := null
109 , p1_a9 NUMBER := null
110 );
111 procedure update_geography_range(p_init_msg_list VARCHAR2
112 , p_geography_id NUMBER
113 , p_geography_from VARCHAR2
114 , p_start_date date
115 , p_end_date date
116 , p_object_version_number in out nocopy NUMBER
117 , x_return_status out nocopy VARCHAR2
118 , x_msg_count out nocopy NUMBER
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
128 , p2_a5 JTF_DATE_TABLE
129 , p2_a6 JTF_DATE_TABLE
130 , p_created_by_module VARCHAR2
131 , p_application_id NUMBER
132 , x_return_status out nocopy VARCHAR2
133 , x_msg_count out nocopy NUMBER
134 , x_msg_data out nocopy VARCHAR2
135 );
136 procedure create_zone(p_init_msg_list VARCHAR2
137 , p_zone_type VARCHAR2
138 , p_zone_name VARCHAR2
139 , p_zone_code VARCHAR2
140 , p_zone_code_type VARCHAR2
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
150 , p9_a5 JTF_DATE_TABLE
151 , p9_a6 JTF_DATE_TABLE
152 , p_timezone_code VARCHAR2
153 , x_geography_id out nocopy NUMBER
154 , p_created_by_module VARCHAR2
155 , p_application_id NUMBER
156 , x_return_status out nocopy VARCHAR2
157 , x_msg_count out nocopy NUMBER
158 , x_msg_data out nocopy VARCHAR2
159 );
160 end hz_geography_pub_uiw_jw;