APPS.IEC_G_CAL_CALENDARS_PKG dependencies on IEC_G_CAL_CALENDARS_TL

Line 45: insert into IEC_G_CAL_CALENDARS_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into IEC_G_CAL_CALENDARS_TL (
46: CALENDAR_ID,
47: CALENDAR_NAME,
48: CREATED_BY,
49: CREATION_DATE,

Line 69: from IEC_G_CAL_CALENDARS_TL T

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

Line 104: from IEC_G_CAL_CALENDARS_TL

100:
101: cursor c1 is select
102: CALENDAR_NAME,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from IEC_G_CAL_CALENDARS_TL
105: where CALENDAR_ID = X_CALENDAR_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of CALENDAR_ID nowait;
108: begin

Line 170: update IEC_G_CAL_CALENDARS_TL set

166: if (sql%notfound) then
167: raise no_data_found;
168: end if;
169:
170: update IEC_G_CAL_CALENDARS_TL set
171: CALENDAR_NAME = X_CALENDAR_NAME,
172: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
173: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
174: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 188: delete from IEC_G_CAL_CALENDARS_TL

184: procedure DELETE_ROW (
185: X_CALENDAR_ID in NUMBER
186: ) is
187: begin
188: delete from IEC_G_CAL_CALENDARS_TL
189: where CALENDAR_ID = X_CALENDAR_ID;
190:
191: if (sql%notfound) then
192: raise no_data_found;

Line 206: delete from IEC_G_CAL_CALENDARS_TL T

202:
203: procedure ADD_LANGUAGE
204: is
205: begin
206: delete from IEC_G_CAL_CALENDARS_TL T
207: where not exists
208: (select NULL
209: from IEC_G_CAL_CALENDARS_B B
210: where B.CALENDAR_ID = T.CALENDAR_ID

Line 213: update IEC_G_CAL_CALENDARS_TL T set (

209: from IEC_G_CAL_CALENDARS_B B
210: where B.CALENDAR_ID = T.CALENDAR_ID
211: );
212:
213: update IEC_G_CAL_CALENDARS_TL T set (
214: CALENDAR_NAME
215: ) = (select
216: B.CALENDAR_NAME
217: from IEC_G_CAL_CALENDARS_TL B

Line 217: from IEC_G_CAL_CALENDARS_TL B

213: update IEC_G_CAL_CALENDARS_TL T set (
214: CALENDAR_NAME
215: ) = (select
216: B.CALENDAR_NAME
217: from IEC_G_CAL_CALENDARS_TL B
218: where B.CALENDAR_ID = T.CALENDAR_ID
219: and B.LANGUAGE = T.SOURCE_LANG)
220: where (
221: T.CALENDAR_ID,

Line 226: from IEC_G_CAL_CALENDARS_TL SUBB, IEC_G_CAL_CALENDARS_TL SUBT

222: T.LANGUAGE
223: ) in (select
224: SUBT.CALENDAR_ID,
225: SUBT.LANGUAGE
226: from IEC_G_CAL_CALENDARS_TL SUBB, IEC_G_CAL_CALENDARS_TL SUBT
227: where SUBB.CALENDAR_ID = SUBT.CALENDAR_ID
228: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
229: and (SUBB.CALENDAR_NAME <> SUBT.CALENDAR_NAME
230: or (SUBB.CALENDAR_NAME is null and SUBT.CALENDAR_NAME is not null)

Line 234: insert into IEC_G_CAL_CALENDARS_TL (

230: or (SUBB.CALENDAR_NAME is null and SUBT.CALENDAR_NAME is not null)
231: or (SUBB.CALENDAR_NAME is not null and SUBT.CALENDAR_NAME is null)
232: ));
233:
234: insert into IEC_G_CAL_CALENDARS_TL (
235: CALENDAR_ID,
236: CALENDAR_NAME,
237: CREATED_BY,
238: CREATION_DATE,

Line 254: from IEC_G_CAL_CALENDARS_TL B, FND_LANGUAGES L

250: B.LAST_UPDATE_DATE,
251: B.LAST_UPDATE_LOGIN,
252: L.LANGUAGE_CODE,
253: B.SOURCE_LANG
254: from IEC_G_CAL_CALENDARS_TL B, FND_LANGUAGES L
255: where L.INSTALLED_FLAG in ('I', 'B')
256: and B.LANGUAGE = userenv('LANG')
257: and not exists
258: (select NULL

Line 259: from IEC_G_CAL_CALENDARS_TL T

255: where L.INSTALLED_FLAG in ('I', 'B')
256: and B.LANGUAGE = userenv('LANG')
257: and not exists
258: (select NULL
259: from IEC_G_CAL_CALENDARS_TL T
260: where T.CALENDAR_ID = B.CALENDAR_ID
261: and T.LANGUAGE = L.LANGUAGE_CODE);
262: end ADD_LANGUAGE;
263:

Line 318: update IEC_G_CAL_CALENDARS_TL set

314: begin
315:
316: -- only UPDATE rows that have not been altered by user
317:
318: update IEC_G_CAL_CALENDARS_TL set
319: SOURCE_LANG = userenv('LANG'),
320: CALENDAR_NAME = X_CALENDAR_NAME,
321: LAST_UPDATE_DATE = SYSDATE,
322: LAST_UPDATED_BY = DECODE(X_OWNER, 'SEED', 1, 0),