APPS.IRC_PARTY_API dependencies on FND_LANGUAGES

Line 3071: from fnd_languages

3067: l_allow_access irc_notification_preferences.allow_access%type;
3068: l_start_date date;
3069: cursor get_nls_language is
3070: select nls_language
3071: from fnd_languages
3072: where language_code=p_language;
3073: --
3074: l_nls_language fnd_languages.nls_language%type;
3075: --

Line 3074: l_nls_language fnd_languages.nls_language%type;

3070: select nls_language
3071: from fnd_languages
3072: where language_code=p_language;
3073: --
3074: l_nls_language fnd_languages.nls_language%type;
3075: --
3076: begin
3077: --
3078: -- Truncate time portion from date

Line 3641: from fnd_languages

3637: l_purge_party_id number;
3638: --
3639: cursor get_nls_language is
3640: select nls_language
3641: from fnd_languages
3642: where language_code=p_language;
3643: --
3644: l_nls_language fnd_languages.nls_language%type;
3645: --

Line 3644: l_nls_language fnd_languages.nls_language%type;

3640: select nls_language
3641: from fnd_languages
3642: where language_code=p_language;
3643: --
3644: l_nls_language fnd_languages.nls_language%type;
3645: --
3646: l_proc varchar2(72) := g_package||'self_register_user';
3647: --
3648: l_password_length number;

Line 4310: from fnd_languages

4306: l_start_date date;
4307: --
4308: cursor get_nls_language is
4309: select nls_language
4310: from fnd_languages
4311: where language_code=p_language;
4312: --
4313: l_user_id number;
4314: l_person_id number;

Line 4353: l_nls_language fnd_languages.nls_language%type;

4349: --
4350: cursor get_menu_id (p_menu_name varchar2)is
4351: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
4352: --
4353: l_nls_language fnd_languages.nls_language%type;
4354: --
4355: --
4356: -- dummy variables
4357: --

Line 5326: from fnd_languages

5322: l_allow_access irc_notification_preferences.allow_access%type;
5323: l_start_date date;
5324: cursor get_nls_language is
5325: select nls_language
5326: from fnd_languages
5327: where language_code=p_language;
5328: --
5329: l_nls_language fnd_languages.nls_language%type;
5330: --

Line 5329: l_nls_language fnd_languages.nls_language%type;

5325: select nls_language
5326: from fnd_languages
5327: where language_code=p_language;
5328: --
5329: l_nls_language fnd_languages.nls_language%type;
5330: --
5331: begin
5332: --
5333: -- Truncate time portion from date