APPS.HXT_HOLIDAY_DAYS_PKG dependencies on HXT_HOLIDAY_DAYS_TL

Line 44: insert into HXT_HOLIDAY_DAYS_TL (

40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into HXT_HOLIDAY_DAYS_TL (
45: ID,
46: NAME,
47: LAST_UPDATE_DATE,
48: LAST_UPDATED_BY,

Line 68: from HXT_HOLIDAY_DAYS_TL T

64: from FND_LANGUAGES L
65: where L.INSTALLED_FLAG in ('I', 'B')
66: and not exists
67: (select NULL
68: from HXT_HOLIDAY_DAYS_TL T
69: where T.ID = X_ID
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 101: from HXT_HOLIDAY_DAYS_TL

97:
98: cursor c1 is select
99: NAME,
100: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
101: from HXT_HOLIDAY_DAYS_TL
102: where ID = X_ID
103: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
104: for update of ID nowait;
105: begin

Line 163: update HXT_HOLIDAY_DAYS_TL set

159: if (sql%notfound) then
160: raise no_data_found;
161: end if;
162:
163: update HXT_HOLIDAY_DAYS_TL set
164: NAME = X_NAME,
165: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
167: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 181: delete from HXT_HOLIDAY_DAYS_TL

177: procedure DELETE_ROW (
178: X_ID in NUMBER
179: ) is
180: begin
181: delete from HXT_HOLIDAY_DAYS_TL
182: where ID = X_ID;
183:
184: if (sql%notfound) then
185: raise no_data_found;

Line 199: delete from HXT_HOLIDAY_DAYS_TL T

195:
196: procedure ADD_LANGUAGE
197: is
198: begin
199: delete from HXT_HOLIDAY_DAYS_TL T
200: where not exists
201: (select NULL
202: from HXT_HOLIDAY_DAYS B
203: where B.ID = T.ID

Line 206: update HXT_HOLIDAY_DAYS_TL T set (

202: from HXT_HOLIDAY_DAYS B
203: where B.ID = T.ID
204: );
205:
206: update HXT_HOLIDAY_DAYS_TL T set (
207: NAME
208: ) = (select
209: B.NAME
210: from HXT_HOLIDAY_DAYS_TL B

Line 210: from HXT_HOLIDAY_DAYS_TL B

206: update HXT_HOLIDAY_DAYS_TL T set (
207: NAME
208: ) = (select
209: B.NAME
210: from HXT_HOLIDAY_DAYS_TL B
211: where B.ID = T.ID
212: and B.LANGUAGE = T.SOURCE_LANG)
213: where (
214: T.ID,

Line 219: from HXT_HOLIDAY_DAYS_TL SUBB, HXT_HOLIDAY_DAYS_TL SUBT

215: T.LANGUAGE
216: ) in (select
217: SUBT.ID,
218: SUBT.LANGUAGE
219: from HXT_HOLIDAY_DAYS_TL SUBB, HXT_HOLIDAY_DAYS_TL SUBT
220: where SUBB.ID = SUBT.ID
221: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
222: and (SUBB.NAME <> SUBT.NAME
223: ));

Line 225: insert into HXT_HOLIDAY_DAYS_TL (

221: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
222: and (SUBB.NAME <> SUBT.NAME
223: ));
224:
225: insert into HXT_HOLIDAY_DAYS_TL (
226: ID,
227: NAME,
228: LAST_UPDATE_DATE,
229: LAST_UPDATED_BY,

Line 245: from HXT_HOLIDAY_DAYS_TL B, FND_LANGUAGES L

241: B.CREATED_BY,
242: B.CREATION_DATE,
243: L.LANGUAGE_CODE,
244: B.SOURCE_LANG
245: from HXT_HOLIDAY_DAYS_TL B, FND_LANGUAGES L
246: where L.INSTALLED_FLAG in ('I', 'B')
247: and B.LANGUAGE = userenv('LANG')
248: and not exists
249: (select NULL

Line 250: from HXT_HOLIDAY_DAYS_TL T

246: where L.INSTALLED_FLAG in ('I', 'B')
247: and B.LANGUAGE = userenv('LANG')
248: and not exists
249: (select NULL
250: from HXT_HOLIDAY_DAYS_TL T
251: where T.ID = B.ID
252: and T.LANGUAGE = L.LANGUAGE_CODE);
253: end ADD_LANGUAGE;
254: