DBA Data[Home] [Help]

PACKAGE: APPS.FND_TERRITORIES_PKG

Source


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;