[Home] [Help]
110: X_LAST_UPDATE_LOGIN,
111: X_ORG_ID
112: );
113:
114: insert into CN_INTERVAL_TYPES_ALL_TL (
115: INTERVAL_TYPE_ID,
116: NAME,
117: CREATED_BY,
118: CREATION_DATE,
136: from FND_LANGUAGES L
137: where L.INSTALLED_FLAG in ('I', 'B')
138: and not exists
139: (select NULL
140: from CN_INTERVAL_TYPES_ALL_TL T
141: where T.INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID
142: and T.LANGUAGE = L.LANGUAGE_CODE
143: and T.ORG_ID = X_ORG_ID);
144:
200:
201: cursor c1 is select
202: NAME,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from CN_INTERVAL_TYPES_ALL_TL
205: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of INTERVAL_TYPE_ID nowait;
208: begin
322: if (sql%notfound) then
323: raise no_data_found;
324: end if;
325:
326: update CN_INTERVAL_TYPES_ALL_TL set
327: NAME = X_NAME,
328: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
329: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
330: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
340: procedure DELETE_ROW (
341: X_INTERVAL_TYPE_ID in NUMBER
342: ) is
343: begin
344: delete from CN_INTERVAL_TYPES_ALL_TL
345: where INTERVAL_TYPE_ID = X_INTERVAL_TYPE_ID;
346:
347: if (sql%notfound) then
348: raise no_data_found;
358:
359: procedure ADD_LANGUAGE
360: is
361: begin
362: delete from CN_INTERVAL_TYPES_ALL_TL T
363: where not exists
364: (select NULL
365: from CN_INTERVAL_TYPES_ALL_B B
366: where B.INTERVAL_TYPE_ID = T.interval_type_id
366: where B.INTERVAL_TYPE_ID = T.interval_type_id
367: and B.ORG_ID = T.ORG_ID
368: );
369:
370: update CN_INTERVAL_TYPES_ALL_TL T set (
371: NAME
372: ) = (select
373: B.NAME
374: from CN_INTERVAL_TYPES_ALL_TL B
370: update CN_INTERVAL_TYPES_ALL_TL T set (
371: NAME
372: ) = (select
373: B.NAME
374: from CN_INTERVAL_TYPES_ALL_TL B
375: where B.INTERVAL_TYPE_ID = T.INTERVAL_TYPE_ID
376: and B.LANGUAGE = T.source_lang
377: and B.ORG_ID = T.ORG_ID)
378: where (
380: T.LANGUAGE
381: ) in (select
382: SUBT.INTERVAL_TYPE_ID,
383: SUBT.LANGUAGE
384: from CN_INTERVAL_TYPES_ALL_TL SUBB, CN_INTERVAL_TYPES_ALL_TL SUBT
385: where SUBB.INTERVAL_TYPE_ID = SUBT.INTERVAL_TYPE_ID
386: and SUBB.LANGUAGE = SUBT.source_lang
387: and SUBB.ORG_ID =SUBT.ORG_ID
388: and (SUBB.NAME <> SUBT.NAME
389: or (SUBB.NAME is null and SUBT.NAME is not null)
390: or (SUBB.NAME is not null and SUBT.NAME is null)
391: ));
392:
393: insert into CN_INTERVAL_TYPES_ALL_TL (
394: ORG_ID,
395: INTERVAL_TYPE_ID,
396: NAME,
397: CREATED_BY,
411: B.LAST_UPDATE_DATE,
412: B.LAST_UPDATE_LOGIN,
413: L.LANGUAGE_CODE,
414: B.SOURCE_LANG
415: from CN_INTERVAL_TYPES_ALL_TL B, FND_LANGUAGES L
416: where L.INSTALLED_FLAG in ('I', 'B')
417: and B.LANGUAGE = userenv('LANG')
418: and not exists
419: (select NULL
416: where L.INSTALLED_FLAG in ('I', 'B')
417: and B.LANGUAGE = userenv('LANG')
418: and not exists
419: (select NULL
420: from CN_INTERVAL_TYPES_ALL_TL T
421: where T.INTERVAL_TYPE_ID = B.INTERVAL_TYPE_ID
422: and T.LANGUAGE = L.language_code
423: and T.ORG_ID = B.ORG_ID );
424: end ADD_LANGUAGE;
550: x_org_id
551: );
552: END IF;
553: -- Load The record to _TL table
554: UPDATE cn_interval_types_all_tl SET
555: name = x_name,
556: last_update_date = sysdate,
557: last_updated_by = user_id,
558: last_update_login = 0,
561: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
562:
563: IF (SQL%NOTFOUND) THEN
564: -- Insert new record to _TL table
565: INSERT INTO cn_interval_types_all_tl
566: (interval_type_id,
567: name,
568: creation_date,
569: created_by,
587: FROM fnd_languages l
588: WHERE l.installed_flag IN ('I', 'B')
589: AND NOT EXISTS
590: (SELECT NULL
591: FROM cn_interval_types_all_tl t
592: WHERE t.interval_type_id = x_interval_type_id
593: AND t.language = l.language_code
594: and t.org_id = x_org_id);
595: END IF;
619: ELSE
620: user_id := 0;
621: END IF;
622: -- Update the translation
623: UPDATE cn_interval_types_all_tl SET
624: name = x_name,
625: last_update_date = sysdate,
626: last_updated_by = user_id,
627: last_update_login = 0,