APPS.HXT_HOLIDAY_DAYS_PKG dependencies on HXT_HOLIDAY_DAYS

Line 1: package body HXT_HOLIDAY_DAYS_PKG as

1: package body HXT_HOLIDAY_DAYS_PKG as
2: /* $Header: hxthddml.pkb 120.1 2005/10/07 02:29:49 nissharm noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_ID in NUMBER,

Line 16: cursor C is select ROWID from HXT_HOLIDAY_DAYS

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from HXT_HOLIDAY_DAYS
17: where ID = X_ID
18: ;
19: begin
20: insert into HXT_HOLIDAY_DAYS (

Line 20: insert into HXT_HOLIDAY_DAYS (

16: cursor C is select ROWID from HXT_HOLIDAY_DAYS
17: where ID = X_ID
18: ;
19: begin
20: insert into HXT_HOLIDAY_DAYS (
21: ID,
22: HCL_ID,
23: HOLIDAY_DATE,
24: HOURS,

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 93: from HXT_HOLIDAY_DAYS

89: cursor c is select
90: HCL_ID,
91: HOLIDAY_DATE,
92: HOURS
93: from HXT_HOLIDAY_DAYS
94: where ID = X_ID
95: for update of ID nowait;
96: recinfo c%rowtype;
97:

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 150: update HXT_HOLIDAY_DAYS set

146: X_LAST_UPDATED_BY in NUMBER,
147: X_LAST_UPDATE_LOGIN in NUMBER
148: ) is
149: begin
150: update HXT_HOLIDAY_DAYS set
151: HCL_ID = X_HCL_ID,
152: HOLIDAY_DATE = X_HOLIDAY_DATE,
153: HOURS = X_HOURS,
154: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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 188: delete from HXT_HOLIDAY_DAYS

184: if (sql%notfound) then
185: raise no_data_found;
186: end if;
187:
188: delete from HXT_HOLIDAY_DAYS
189: where ID = X_ID;
190:
191: if (sql%notfound) then
192: 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 202: from HXT_HOLIDAY_DAYS B

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
204: );
205:
206: update HXT_HOLIDAY_DAYS_TL T set (

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:

Line 255: end HXT_HOLIDAY_DAYS_PKG;

251: where T.ID = B.ID
252: and T.LANGUAGE = L.LANGUAGE_CODE);
253: end ADD_LANGUAGE;
254:
255: end HXT_HOLIDAY_DAYS_PKG;