APPS.FND_DELIVERY dependencies on FND_LANGUAGES

Line 418: iso_lang fnd_languages.iso_language%TYPE := null;

414: lob_of_type IN varchar2,
415: nls_lang IN varchar2 default null,
416: nls_terry IN varchar2 default null) return boolean is
417:
418: iso_lang fnd_languages.iso_language%TYPE := null;
419: iso_terry fnd_languages.iso_territory%TYPE := null;
420: dummy number;
421:
422: begin

Line 419: iso_terry fnd_languages.iso_territory%TYPE := null;

415: nls_lang IN varchar2 default null,
416: nls_terry IN varchar2 default null) return boolean is
417:
418: iso_lang fnd_languages.iso_language%TYPE := null;
419: iso_terry fnd_languages.iso_territory%TYPE := null;
420: dummy number;
421:
422: begin
423:

Line 427: FROM fnd_languages l

423:
424: if nls_lang is not null then
425: SELECT distinct upper(iso_language)
426: INTO iso_lang
427: FROM fnd_languages l
428: WHERE upper(l.nls_language) = upper(nls_lang);
429: end if;
430:
431: if nls_terry is not null then

Line 434: FROM fnd_languages l

430:
431: if nls_terry is not null then
432: SELECT distinct upper(iso_territory)
433: INTO iso_terry
434: FROM fnd_languages l
435: WHERE upper(l.nls_territory) = upper(nls_terry);
436: end if;
437:
438: SELECT count(*)