APPS.IC_CLDR_HDR_PKG dependencies on IC_CLDR_HDR_TL

Line 55: insert into IC_CLDR_HDR_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into IC_CLDR_HDR_TL (
56: CALENDAR_DESC,
57: CREATION_DATE,
58: CREATED_BY,
59: LAST_UPDATE_DATE,

Line 81: from IC_CLDR_HDR_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from IC_CLDR_HDR_TL T
82: where T.ORGN_CODE = X_ORGN_CODE
83: and T.FISCAL_YEAR = X_FISCAL_YEAR
84: and T.LANGUAGE = L.LANGUAGE_CODE);
85:

Line 123: from IC_CLDR_HDR_TL

119:
120: cursor c1 is select
121: CALENDAR_DESC,
122: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
123: from IC_CLDR_HDR_TL
124: where ORGN_CODE = X_ORGN_CODE
125: and FISCAL_YEAR = X_FISCAL_YEAR
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of ORGN_CODE nowait;

Line 198: update IC_CLDR_HDR_TL set

194: if (sql%notfound) then
195: raise no_data_found;
196: end if;
197:
198: update IC_CLDR_HDR_TL set
199: CALENDAR_DESC = X_CALENDAR_DESC,
200: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
201: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
202: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 219: delete from IC_CLDR_HDR_TL

215: X_FISCAL_YEAR in VARCHAR2
216: ) is
217: begin
218: /*****************
219: delete from IC_CLDR_HDR_TL
220: where ORGN_CODE = X_ORGN_CODE
221: and FISCAL_YEAR = X_FISCAL_YEAR;
222:
223: if (sql%notfound) then

Line 240: delete from IC_CLDR_HDR_TL T

236:
237: procedure ADD_LANGUAGE
238: is
239: begin
240: delete from IC_CLDR_HDR_TL T
241: where not exists
242: (select NULL
243: from IC_CLDR_HDR_B B
244: where B.ORGN_CODE = T.ORGN_CODE

Line 248: update IC_CLDR_HDR_TL T set (

244: where B.ORGN_CODE = T.ORGN_CODE
245: and B.FISCAL_YEAR = T.FISCAL_YEAR
246: );
247:
248: update IC_CLDR_HDR_TL T set (
249: CALENDAR_DESC
250: ) = (select
251: B.CALENDAR_DESC
252: from IC_CLDR_HDR_TL B

Line 252: from IC_CLDR_HDR_TL B

248: update IC_CLDR_HDR_TL T set (
249: CALENDAR_DESC
250: ) = (select
251: B.CALENDAR_DESC
252: from IC_CLDR_HDR_TL B
253: where B.ORGN_CODE = T.ORGN_CODE
254: and B.FISCAL_YEAR = T.FISCAL_YEAR
255: and B.LANGUAGE = T.SOURCE_LANG)
256: where (

Line 264: from IC_CLDR_HDR_TL SUBB, IC_CLDR_HDR_TL SUBT

260: ) in (select
261: SUBT.ORGN_CODE,
262: SUBT.FISCAL_YEAR,
263: SUBT.LANGUAGE
264: from IC_CLDR_HDR_TL SUBB, IC_CLDR_HDR_TL SUBT
265: where SUBB.ORGN_CODE = SUBT.ORGN_CODE
266: and SUBB.FISCAL_YEAR = SUBT.FISCAL_YEAR
267: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
268: and (SUBB.CALENDAR_DESC <> SUBT.CALENDAR_DESC

Line 271: insert into IC_CLDR_HDR_TL (

267: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
268: and (SUBB.CALENDAR_DESC <> SUBT.CALENDAR_DESC
269: ));
270:
271: insert into IC_CLDR_HDR_TL (
272: CALENDAR_DESC,
273: CREATION_DATE,
274: CREATED_BY,
275: LAST_UPDATE_DATE,

Line 293: from IC_CLDR_HDR_TL B, FND_LANGUAGES L

289: B.ORGN_CODE,
290: B.FISCAL_YEAR,
291: L.LANGUAGE_CODE,
292: B.SOURCE_LANG
293: from IC_CLDR_HDR_TL B, FND_LANGUAGES L
294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL

Line 298: from IC_CLDR_HDR_TL T

294: where L.INSTALLED_FLAG in ('I', 'B')
295: and B.LANGUAGE = userenv('LANG')
296: and not exists
297: (select NULL
298: from IC_CLDR_HDR_TL T
299: where T.ORGN_CODE = B.ORGN_CODE
300: and T.FISCAL_YEAR = B.FISCAL_YEAR
301: and T.LANGUAGE = L.LANGUAGE_CODE);
302: end ADD_LANGUAGE;