APPS.HZ_STYLE_FMT_LOCALES_PKG dependencies on HZ_STYLE_FMT_LOCALES

Line 1: package body HZ_STYLE_FMT_LOCALES_PKG as

1: package body HZ_STYLE_FMT_LOCALES_PKG as
2: /* $Header: ARHPSFLB.pls 115.8 2004/02/25 23:15:15 geliu noship $ */
3:
4: L_USER_ID_FOR_SEED NUMBER := NULL;
5:

Line 16: cursor C is select ROWID from HZ_STYLE_FMT_LOCALES

12: X_START_DATE_ACTIVE in DATE,
13: X_END_DATE_ACTIVE in DATE,
14: X_OBJECT_VERSION_NUMBER in NUMBER
15: ) is
16: cursor C is select ROWID from HZ_STYLE_FMT_LOCALES
17: where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID
18: ;
19: begin
20: insert into HZ_STYLE_FMT_LOCALES (

Line 20: insert into HZ_STYLE_FMT_LOCALES (

16: cursor C is select ROWID from HZ_STYLE_FMT_LOCALES
17: where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID
18: ;
19: begin
20: insert into HZ_STYLE_FMT_LOCALES (
21: STYLE_FMT_LOCALE_ID,
22: STYLE_FORMAT_CODE,
23: LANGUAGE_CODE,
24: TERRITORY_CODE,

Line 34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),

30: LAST_UPDATE_DATE,
31: LAST_UPDATED_BY,
32: OBJECT_VERSION_NUMBER
33: ) values (
34: DECODE( X_STYLE_FMT_LOCALE_ID, FND_API.G_MISS_NUM, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, NULL, HZ_STYLE_FMT_LOCALES_S.NEXTVAL, X_STYLE_FMT_LOCALE_ID ),
35: DECODE( X_STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
36: DECODE( X_LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
37: DECODE( X_TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
38: DECODE( X_START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),

Line 71: from HZ_STYLE_FMT_LOCALES

67: cursor c is select
68: STYLE_FORMAT_CODE,
69: LANGUAGE_CODE,
70: TERRITORY_CODE
71: from HZ_STYLE_FMT_LOCALES
72: where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID
73: for update of LANGUAGE_CODE nowait;
74: recinfo c%rowtype;
75:

Line 109: update HZ_STYLE_FMT_LOCALES set

105: X_OBJECT_VERSION_NUMBER in NUMBER
106: ) is
107: begin
108:
109: update HZ_STYLE_FMT_LOCALES set
110: STYLE_FORMAT_CODE = DECODE( X_STYLE_FORMAT_CODE, NULL, STYLE_FORMAT_CODE, FND_API.G_MISS_CHAR, NULL, X_STYLE_FORMAT_CODE ),
111: LANGUAGE_CODE = DECODE( X_LANGUAGE_CODE, NULL, LANGUAGE_CODE, FND_API.G_MISS_CHAR, NULL, X_LANGUAGE_CODE ),
112: TERRITORY_CODE = DECODE( X_TERRITORY_CODE, NULL, TERRITORY_CODE, FND_API.G_MISS_CHAR, NULL, X_TERRITORY_CODE ),
113: START_DATE_ACTIVE = DECODE( X_START_DATE_ACTIVE, NULL, START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_START_DATE_ACTIVE ),

Line 150: FROM HZ_STYLE_FMT_LOCALES

146: X_LANGUAGE_CODE,
147: X_TERRITORY_CODE,
148: X_START_DATE_ACTIVE,
149: X_END_DATE_ACTIVE
150: FROM HZ_STYLE_FMT_LOCALES
151: WHERE STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID ;
152:
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN

Line 169: delete from HZ_STYLE_FMT_LOCALES

165: procedure DELETE_ROW (
166: X_STYLE_FMT_LOCALE_ID in NUMBER
167: ) is
168: begin
169: delete from HZ_STYLE_FMT_LOCALES
170: where STYLE_FMT_LOCALE_ID = X_STYLE_FMT_LOCALE_ID;
171:
172: if (sql%notfound) then
173: raise no_data_found;

Line 217: from HZ_STYLE_FMT_LOCALES

213: begin
214:
215: select STYLE_FMT_LOCALE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER
216: into l_id, l_db_luby, l_db_ludate, l_object_version_number
217: from HZ_STYLE_FMT_LOCALES
218: where STYLE_FORMAT_CODE = x_style_format_code
219: and nvl(LANGUAGE_CODE,'XXXX') = nvl(x_language_code,'XXXX')
220: and nvl(TERRITORY_CODE,'XX') = nvl(x_territory_code,'XX');
221:

Line 232: hz_style_fmt_locales_pkg.update_row (

228: if ((x_custom_mode = 'FORCE') or
229: ((l_f_luby = 0) and (l_db_luby = 1)) or
230: ((l_f_luby = l_db_luby) and (l_f_ludate > l_db_ludate)))
231: then
232: hz_style_fmt_locales_pkg.update_row (
233: X_STYLE_FMT_LOCALE_ID => l_id,
234: X_STYLE_FORMAT_CODE => X_STYLE_FORMAT_CODE,
235: X_LANGUAGE_CODE => X_LANGUAGE_CODE,
236: X_TERRITORY_CODE => X_TERRITORY_CODE,

Line 246: hz_style_fmt_locales_pkg.insert_row(

242:
243: exception
244: when no_data_found then
245: -- record not found, insert in all cases
246: hz_style_fmt_locales_pkg.insert_row(
247: x_rowid => l_rowid,
248: x_style_fmt_locale_id => l_id, -- will be generated
249: x_style_format_code => X_STYLE_FORMAT_CODE,
250: x_language_code => X_LANGUAGE_CODE,

Line 260: end HZ_STYLE_FMT_LOCALES_PKG;

256: end;
257:
258: end LOAD_ROW;
259:
260: end HZ_STYLE_FMT_LOCALES_PKG;