APPS.IRC_PARTY_API dependencies on FND_LANGUAGES

Line 2954: from fnd_languages

2950: l_allow_access irc_notification_preferences.allow_access%type;
2951: l_start_date date;
2952: cursor get_nls_language is
2953: select nls_language
2954: from fnd_languages
2955: where language_code=p_language;
2956: --
2957: l_nls_language fnd_languages.nls_language%type;
2958: --

Line 2957: l_nls_language fnd_languages.nls_language%type;

2953: select nls_language
2954: from fnd_languages
2955: where language_code=p_language;
2956: --
2957: l_nls_language fnd_languages.nls_language%type;
2958: --
2959: begin
2960: --
2961: -- Truncate time portion from date

Line 3504: from fnd_languages

3500: l_allow_access irc_notification_preferences.allow_access%type;
3501: --
3502: cursor get_nls_language is
3503: select nls_language
3504: from fnd_languages
3505: where language_code=p_language;
3506: --
3507: l_nls_language fnd_languages.nls_language%type;
3508: --

Line 3507: l_nls_language fnd_languages.nls_language%type;

3503: select nls_language
3504: from fnd_languages
3505: where language_code=p_language;
3506: --
3507: l_nls_language fnd_languages.nls_language%type;
3508: --
3509: l_proc varchar2(72) := g_package||'self_register_user';
3510: --
3511: l_password_length number;

Line 4082: from fnd_languages

4078: l_start_date date;
4079: --
4080: cursor get_nls_language is
4081: select nls_language
4082: from fnd_languages
4083: where language_code=p_language;
4084: --
4085: l_user_id number;
4086: l_person_id number;

Line 4125: l_nls_language fnd_languages.nls_language%type;

4121: --
4122: cursor get_menu_id (p_menu_name varchar2)is
4123: select menu_id from fnd_menus where menu_name=upper(p_menu_name);
4124: --
4125: l_nls_language fnd_languages.nls_language%type;
4126: --
4127: --
4128: -- dummy variables
4129: --

Line 5092: from fnd_languages

5088: l_allow_access irc_notification_preferences.allow_access%type;
5089: l_start_date date;
5090: cursor get_nls_language is
5091: select nls_language
5092: from fnd_languages
5093: where language_code=p_language;
5094: --
5095: l_nls_language fnd_languages.nls_language%type;
5096: --

Line 5095: l_nls_language fnd_languages.nls_language%type;

5091: select nls_language
5092: from fnd_languages
5093: where language_code=p_language;
5094: --
5095: l_nls_language fnd_languages.nls_language%type;
5096: --
5097: begin
5098: --
5099: -- Truncate time portion from date