APPS.FND_CURRENCIES_PKG dependencies on FND_CURRENCIES_TL

Line 185: insert into FND_CURRENCIES_TL (

181: X_LAST_UPDATED_BY,
182: X_LAST_UPDATE_LOGIN
183: );
184:
185: insert into FND_CURRENCIES_TL (
186: CURRENCY_CODE,
187: NAME,
188: DESCRIPTION,
189: CREATED_BY,

Line 211: from FND_CURRENCIES_TL T

207: from FND_LANGUAGES L
208: where L.INSTALLED_FLAG in ('I', 'B')
209: and not exists
210: (select NULL
211: from FND_CURRENCIES_TL T
212: where T.CURRENCY_CODE = X_CURRENCY_CODE
213: and T.LANGUAGE = L.LANGUAGE_CODE);
214:
215: open c;

Line 338: from FND_CURRENCIES_TL

334:
335: cursor c1 is select
336: NAME,
337: DESCRIPTION
338: from FND_CURRENCIES_TL
339: where CURRENCY_CODE = X_CURRENCY_CODE
340: and LANGUAGE = userenv('LANG')
341: for update of CURRENCY_CODE nowait;
342: tlinfo c1%rowtype;

Line 597: update FND_CURRENCIES_TL set

593: if (sql%notfound) then
594: raise no_data_found;
595: end if;
596:
597: update FND_CURRENCIES_TL set
598: NAME = X_NAME,
599: DESCRIPTION = X_DESCRIPTION,
600: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
601: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 623: delete from FND_CURRENCIES_TL

619: if (sql%notfound) then
620: raise no_data_found;
621: end if;
622:
623: delete from FND_CURRENCIES_TL
624: where CURRENCY_CODE = X_CURRENCY_CODE;
625:
626: if (sql%notfound) then
627: raise no_data_found;

Line 641: delete from FND_CURRENCIES_TL T

637: /* as a quick workaround to fix the time-consuming table handler issue */
638: /* Eventually we'll need to turn them into a separate fix_language procedure */
639: /*
640:
641: delete from FND_CURRENCIES_TL T
642: where not exists
643: (select NULL
644: from FND_CURRENCIES B
645: where B.CURRENCY_CODE = T.CURRENCY_CODE

Line 648: update FND_CURRENCIES_TL T set (

644: from FND_CURRENCIES B
645: where B.CURRENCY_CODE = T.CURRENCY_CODE
646: );
647:
648: update FND_CURRENCIES_TL T set (
649: NAME,
650: DESCRIPTION
651: ) = (select
652: B.NAME,

Line 654: from FND_CURRENCIES_TL B

650: DESCRIPTION
651: ) = (select
652: B.NAME,
653: B.DESCRIPTION
654: from FND_CURRENCIES_TL B
655: where B.CURRENCY_CODE = T.CURRENCY_CODE
656: and B.LANGUAGE = T.SOURCE_LANG)
657: where (
658: T.CURRENCY_CODE,

Line 663: from FND_CURRENCIES_TL SUBB, FND_CURRENCIES_TL SUBT

659: T.LANGUAGE
660: ) in (select
661: SUBT.CURRENCY_CODE,
662: SUBT.LANGUAGE
663: from FND_CURRENCIES_TL SUBB, FND_CURRENCIES_TL SUBT
664: where SUBB.CURRENCY_CODE = SUBT.CURRENCY_CODE
665: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
666: and (SUBB.NAME <> SUBT.NAME
667: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 673: insert into FND_CURRENCIES_TL (

669: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
670: ));
671: */
672:
673: insert into FND_CURRENCIES_TL (
674: CURRENCY_CODE,
675: NAME,
676: DESCRIPTION,
677: CREATED_BY,

Line 695: from FND_CURRENCIES_TL B, FND_LANGUAGES L

691: B.LAST_UPDATE_DATE,
692: B.LAST_UPDATE_LOGIN,
693: L.LANGUAGE_CODE,
694: B.SOURCE_LANG
695: from FND_CURRENCIES_TL B, FND_LANGUAGES L
696: where L.INSTALLED_FLAG in ('I', 'B')
697: and B.LANGUAGE = userenv('LANG')
698: and not exists
699: (select NULL

Line 700: from FND_CURRENCIES_TL T

696: where L.INSTALLED_FLAG in ('I', 'B')
697: and B.LANGUAGE = userenv('LANG')
698: and not exists
699: (select NULL
700: from FND_CURRENCIES_TL T
701: where T.CURRENCY_CODE = B.CURRENCY_CODE
702: and T.LANGUAGE = L.LANGUAGE_CODE);
703: end ADD_LANGUAGE;
704:

Line 861: from FND_CURRENCIES_TL

857: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
858:
859: select last_updated_by, last_update_date
860: into db_luby, db_ludate
861: from FND_CURRENCIES_TL
862: where CURRENCY_CODE = X_CURRENCY_CODE
863: and language = userenv('LANG');
864:
865: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 867: update fnd_currencies_tl set

863: and language = userenv('LANG');
864:
865: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
866: db_ludate, X_CUSTOM_MODE)) then
867: update fnd_currencies_tl set
868: NAME= X_NAME,
869: DESCRIPTION= X_DESCRIPTION,
870: LAST_UPDATE_DATE = f_ludate,
871: LAST_UPDATED_BY = f_luby,