1 package FND_TERRITORIES_PKG as
2 /* $Header: AFNLDTIS.pls 120.1.12010000.1 2008/07/25 14:16:48 appldev ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_TERRITORY_CODE in VARCHAR2,
7 X_EU_CODE in VARCHAR2 default NULL,
8 X_ISO_NUMERIC_CODE in VARCHAR2,
9 X_ALTERNATE_TERRITORY_CODE in VARCHAR2,
10 X_NLS_TERRITORY in VARCHAR2,
11 X_ADDRESS_STYLE in VARCHAR2,
12 X_ADDRESS_VALIDATION in VARCHAR2,
13 X_BANK_INFO_STYLE in VARCHAR2,
14 X_BANK_INFO_VALIDATION in VARCHAR2,
15 X_TERRITORY_SHORT_NAME in VARCHAR2,
16 X_DESCRIPTION in VARCHAR2,
17 X_CREATION_DATE in DATE,
18 X_CREATED_BY in NUMBER,
19 X_LAST_UPDATE_DATE in DATE,
20 X_LAST_UPDATED_BY in NUMBER,
21 X_LAST_UPDATE_LOGIN in NUMBER
22 );
23
24 procedure INSERT_ROW (
25 X_ROWID in out nocopy VARCHAR2,
26 X_TERRITORY_CODE in VARCHAR2,
27 X_EU_CODE in VARCHAR2 default NULL,
28 X_ISO_NUMERIC_CODE in VARCHAR2,
29 X_ALTERNATE_TERRITORY_CODE in VARCHAR2,
30 X_NLS_TERRITORY in VARCHAR2,
31 X_ADDRESS_STYLE in VARCHAR2,
32 X_ADDRESS_VALIDATION in VARCHAR2,
33 X_BANK_INFO_STYLE in VARCHAR2,
34 X_BANK_INFO_VALIDATION in VARCHAR2,
35 X_TERRITORY_SHORT_NAME in VARCHAR2,
36 X_DESCRIPTION in VARCHAR2,
37 X_CREATION_DATE in DATE,
38 X_CREATED_BY in NUMBER,
39 X_LAST_UPDATE_DATE in DATE,
40 X_LAST_UPDATED_BY in NUMBER,
41 X_LAST_UPDATE_LOGIN in NUMBER,
42 X_OBSOLETE_FLAG in VARCHAR2
43 );
44
45 procedure INSERT_ROW (
46 X_ROWID in out nocopy VARCHAR2,
47 X_TERRITORY_CODE in VARCHAR2,
48 X_EU_CODE in VARCHAR2 default NULL,
49 X_ISO_NUMERIC_CODE in VARCHAR2,
50 X_ALTERNATE_TERRITORY_CODE in VARCHAR2,
51 X_NLS_TERRITORY in VARCHAR2,
52 X_ADDRESS_STYLE in VARCHAR2,
53 X_ADDRESS_VALIDATION in VARCHAR2,
54 X_BANK_INFO_STYLE in VARCHAR2,
55 X_BANK_INFO_VALIDATION in VARCHAR2,
56 X_TERRITORY_SHORT_NAME in VARCHAR2,
57 X_DESCRIPTION in VARCHAR2,
58 X_CREATION_DATE in DATE,
59 X_CREATED_BY in NUMBER,
60 X_LAST_UPDATE_DATE in DATE,
61 X_LAST_UPDATED_BY in NUMBER,
62 X_LAST_UPDATE_LOGIN in NUMBER,
63 X_OBSOLETE_FLAG in VARCHAR2,
64 X_ISO_TERRITORY_CODE in VARCHAR2
65 );
66
67 procedure LOCK_ROW (
68 X_TERRITORY_CODE in VARCHAR2,
69 X_EU_CODE in VARCHAR2 default NULL,
70 X_ISO_NUMERIC_CODE in VARCHAR2,
71 X_ALTERNATE_TERRITORY_CODE in VARCHAR2,
72 X_NLS_TERRITORY in VARCHAR2,
73 X_ADDRESS_STYLE in VARCHAR2,
74 X_ADDRESS_VALIDATION in VARCHAR2,
75 X_BANK_INFO_STYLE in VARCHAR2,
76 X_BANK_INFO_VALIDATION in VARCHAR2,
77 X_TERRITORY_SHORT_NAME in VARCHAR2,
78 X_DESCRIPTION in VARCHAR2
79 );
80
81 procedure UPDATE_ROW (
82 X_TERRITORY_CODE in VARCHAR2,
83 X_EU_CODE in VARCHAR2 default NULL,
84 X_ISO_NUMERIC_CODE in VARCHAR2,
85 X_ALTERNATE_TERRITORY_CODE in VARCHAR2,
86 X_NLS_TERRITORY in VARCHAR2,
87 X_ADDRESS_STYLE in VARCHAR2,
88 X_ADDRESS_VALIDATION in VARCHAR2,
89 X_BANK_INFO_STYLE in VARCHAR2,
90 X_BANK_INFO_VALIDATION in VARCHAR2,
91 X_TERRITORY_SHORT_NAME in VARCHAR2,
92 X_DESCRIPTION in VARCHAR2,
93 X_LAST_UPDATE_DATE in DATE,
94 X_LAST_UPDATED_BY in NUMBER,
95 X_LAST_UPDATE_LOGIN in NUMBER
96 );
97
98 procedure UPDATE_ROW (
99 X_TERRITORY_CODE in VARCHAR2,
100 X_EU_CODE in VARCHAR2 default NULL,
101 X_ISO_NUMERIC_CODE in VARCHAR2,
102 X_ALTERNATE_TERRITORY_CODE in VARCHAR2,
103 X_NLS_TERRITORY in VARCHAR2,
104 X_ADDRESS_STYLE in VARCHAR2,
105 X_ADDRESS_VALIDATION in VARCHAR2,
106 X_BANK_INFO_STYLE in VARCHAR2,
107 X_BANK_INFO_VALIDATION in VARCHAR2,
108 X_TERRITORY_SHORT_NAME in VARCHAR2,
109 X_DESCRIPTION in VARCHAR2,
110 X_LAST_UPDATE_DATE in DATE,
111 X_LAST_UPDATED_BY in NUMBER,
112 X_LAST_UPDATE_LOGIN in NUMBER,
113 X_OBSOLETE_FLAG in VARCHAR2
114 );
115
116 procedure UPDATE_ROW (
117 X_TERRITORY_CODE in VARCHAR2,
118 X_EU_CODE in VARCHAR2 default NULL,
119 X_ISO_NUMERIC_CODE in VARCHAR2,
120 X_ALTERNATE_TERRITORY_CODE in VARCHAR2,
121 X_NLS_TERRITORY in VARCHAR2,
122 X_ADDRESS_STYLE in VARCHAR2,
123 X_ADDRESS_VALIDATION in VARCHAR2,
124 X_BANK_INFO_STYLE in VARCHAR2,
125 X_BANK_INFO_VALIDATION in VARCHAR2,
126 X_TERRITORY_SHORT_NAME in VARCHAR2,
127 X_DESCRIPTION in VARCHAR2,
128 X_LAST_UPDATE_DATE in DATE,
129 X_LAST_UPDATED_BY in NUMBER,
130 X_LAST_UPDATE_LOGIN in NUMBER,
131 X_OBSOLETE_FLAG in VARCHAR2,
132 X_ISO_TERRITORY_CODE in VARCHAR2
133 );
134
135 procedure DELETE_ROW (
136 X_TERRITORY_CODE in VARCHAR2
137 );
138
139 procedure ADD_LANGUAGE;
140
141 procedure TRANSLATE_ROW (
142 X_TERRITORY_CODE in VARCHAR2,
143 X_TERRITORY_SHORT_NAME in VARCHAR2,
144 X_DESCRIPTION in VARCHAR2,
145 X_OWNER in VARCHAR2
146 );
147
148 procedure LOAD_ROW (
149 X_TERRITORY_CODE in VARCHAR2,
150 X_EU_CODE in VARCHAR2 default NULL,
151 X_ISO_NUMERIC_CODE in VARCHAR2,
152 X_ALTERNATE_TERRITORY_CODE in VARCHAR2 default NULL,
153 X_NLS_TERRITORY in VARCHAR2 default NULL,
154 X_ADDRESS_STYLE in VARCHAR2 default NULL,
155 X_ADDRESS_VALIDATION in VARCHAR2 default NULL,
156 X_BANK_INFO_STYLE in VARCHAR2 default NULL,
157 X_BANK_INFO_VALIDATION in VARCHAR2 default NULL,
158 X_TERRITORY_SHORT_NAME in VARCHAR2,
159 X_DESCRIPTION in VARCHAR2,
160 X_OWNER in VARCHAR2
161 );
162
163 procedure TRANSLATE_ROW (
164 X_TERRITORY_CODE in VARCHAR2,
165 X_TERRITORY_SHORT_NAME in VARCHAR2,
166 X_DESCRIPTION in VARCHAR2,
167 X_OWNER in VARCHAR2,
168 X_LAST_UPDATE_DATE in VARCHAR2,
169 X_CUSTOM_MODE in VARCHAR2
170 );
171
172 procedure LOAD_ROW (
173 X_TERRITORY_CODE in VARCHAR2,
174 X_EU_CODE in VARCHAR2 default NULL,
175 X_ISO_NUMERIC_CODE in VARCHAR2,
176 X_ALTERNATE_TERRITORY_CODE in VARCHAR2 default NULL,
177 X_NLS_TERRITORY in VARCHAR2 default NULL,
178 X_ADDRESS_STYLE in VARCHAR2 default NULL,
179 X_ADDRESS_VALIDATION in VARCHAR2 default NULL,
180 X_BANK_INFO_STYLE in VARCHAR2 default NULL,
181 X_BANK_INFO_VALIDATION in VARCHAR2 default NULL,
182 X_TERRITORY_SHORT_NAME in VARCHAR2,
183 X_DESCRIPTION in VARCHAR2,
184 X_OWNER in VARCHAR2,
185 X_LAST_UPDATE_DATE in VARCHAR2,
186 X_CUSTOM_MODE in VARCHAR2
187 );
188
189 procedure LOAD_ROW (
190 X_TERRITORY_CODE in VARCHAR2,
191 X_EU_CODE in VARCHAR2 default NULL,
192 X_ISO_NUMERIC_CODE in VARCHAR2,
193 X_ALTERNATE_TERRITORY_CODE in VARCHAR2 default NULL,
194 X_NLS_TERRITORY in VARCHAR2 default NULL,
195 X_ADDRESS_STYLE in VARCHAR2 default NULL,
196 X_ADDRESS_VALIDATION in VARCHAR2 default NULL,
197 X_BANK_INFO_STYLE in VARCHAR2 default NULL,
198 X_BANK_INFO_VALIDATION in VARCHAR2 default NULL,
199 X_TERRITORY_SHORT_NAME in VARCHAR2,
200 X_DESCRIPTION in VARCHAR2,
201 X_OWNER in VARCHAR2,
202 X_LAST_UPDATE_DATE in VARCHAR2,
203 X_CUSTOM_MODE in VARCHAR2,
204 X_OBSOLETE_FLAG in VARCHAR2
205 );
206
207 procedure LOAD_ROW (
208 X_TERRITORY_CODE in VARCHAR2,
209 X_EU_CODE in VARCHAR2 default NULL,
210 X_ISO_NUMERIC_CODE in VARCHAR2,
211 X_ALTERNATE_TERRITORY_CODE in VARCHAR2 default NULL,
212 X_NLS_TERRITORY in VARCHAR2 default NULL,
213 X_ADDRESS_STYLE in VARCHAR2 default NULL,
214 X_ADDRESS_VALIDATION in VARCHAR2 default NULL,
215 X_BANK_INFO_STYLE in VARCHAR2 default NULL,
216 X_BANK_INFO_VALIDATION in VARCHAR2 default NULL,
217 X_TERRITORY_SHORT_NAME in VARCHAR2,
218 X_DESCRIPTION in VARCHAR2,
219 X_OWNER in VARCHAR2,
220 X_LAST_UPDATE_DATE in VARCHAR2,
221 X_CUSTOM_MODE in VARCHAR2,
222 X_OBSOLETE_FLAG in VARCHAR2,
223 X_ISO_TERRITORY_CODE in VARCHAR2
224 );
225
226 null_char varchar2(8) := '*NULL*';
227 null_date date := to_date('2', 'J');
228 null_number number := -999;
229
230 end FND_TERRITORIES_PKG;