APPS.PON_AUCTION_PKG dependencies on FND_LANGUAGES

Line 11: g_original_language FND_LANGUAGES.nls_language%TYPE;

7: g_faxNumber varchar2(2000);
8: g_eMail varchar2(2000);
9: p_t_zone_temp varchar2(20) := '243';
10: g_module varchar2(200) := 'pon.plsql.pon_auction_pkg';
11: g_original_language FND_LANGUAGES.nls_language%TYPE;
12: g_original_lang_code FND_LANGUAGES.language_code%TYPE;
13: g_tp_cache_rec two_part_cache_rec; -- bug 6374353
14:
15: -------------------------------------------------------------------------------

Line 12: g_original_lang_code FND_LANGUAGES.language_code%TYPE;

8: g_eMail varchar2(2000);
9: p_t_zone_temp varchar2(20) := '243';
10: g_module varchar2(200) := 'pon.plsql.pon_auction_pkg';
11: g_original_language FND_LANGUAGES.nls_language%TYPE;
12: g_original_lang_code FND_LANGUAGES.language_code%TYPE;
13: g_tp_cache_rec two_part_cache_rec; -- bug 6374353
14:
15: -------------------------------------------------------------------------------
16: -------------------------- HELPER FUNCTIONS ----------------------------------

Line 4339: l_auctioneer_nls_language fnd_languages.nls_language%TYPE;

4335: x_nls_language VARCHAR2(60) := 'AMERICAN';
4336: x_territory_code VARCHAR2(30) := 'AMERICA';
4337: x_nls_territory VARCHAR2(60);
4338:
4339: l_auctioneer_nls_language fnd_languages.nls_language%TYPE;
4340: l_auctioneer_nls_territory fnd_territories.nls_territory%TYPE;
4341: l_users WF_DIRECTORY.UserTable;
4342:
4343: CURSOR new_bidders IS

Line 4390: from fnd_languages

4386: -- Bug 3824928: Store the auctioneer's language and territory in new
4387: -- variables so that they can be used later.
4388:
4389: select NLS_LANGUAGE into l_auctioneer_nls_language
4390: from fnd_languages
4391: where language_code = x_language_code;
4392:
4393: select nls_territory into l_auctioneer_nls_territory
4394: from fnd_territories

Line 4493: from fnd_languages

4489:
4490:
4491: begin
4492: select NLS_LANGUAGE into x_nls_language
4493: from fnd_languages
4494: where language_code = x_language_code;
4495:
4496: select nls_territory into x_nls_territory
4497: from fnd_territories

Line 6407: from fnd_languages

6403: END IF; --}
6404:
6405: select nls_language
6406: into g_original_language
6407: from fnd_languages
6408: where language_code = g_original_lang_code;
6409:
6410: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6411: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 6446: from fnd_languages

6442: END IF; --}
6443:
6444: select language_code
6445: into x_language_code
6446: from fnd_languages
6447: where nls_language = p_language;
6448:
6449: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6450: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 6493: message => 'p_language is NULL so selecting it from fnd_languages');

6489:
6490: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6491: FND_LOG.string(log_level => FND_LOG.level_statement,
6492: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
6493: message => 'p_language is NULL so selecting it from fnd_languages');
6494: END IF; --}
6495:
6496: select nls_language
6497: into x_language

Line 6498: from fnd_languages

6494: END IF; --}
6495:
6496: select nls_language
6497: into x_language
6498: from fnd_languages
6499: where language_code = x_language_code;
6500:
6501: dbms_session.set_nls('NLS_LANGUAGE', x_language);
6502:

Line 7308: from fnd_languages

7304: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
7305: END IF;
7306:
7307: select NLS_LANGUAGE into x_nls_language
7308: from fnd_languages
7309: where language_code = x_language_code;
7310:
7311: select nls_territory into x_nls_territory
7312: from fnd_territories

Line 7731: from fnd_languages

7727: -- Bug 3824928: if tpcontactid is not null use language and territory
7728: -- from tp contact id else use auctioneer's language and territory
7729:
7730: select NLS_LANGUAGE into x_nls_addnl_language
7731: from fnd_languages
7732: where language_code = x_language_code;
7733:
7734: select nls_territory into x_nls_addnl_territory
7735: from fnd_territories

Line 10693: FROM FND_LANGUAGES

10689: l_progress := '010';
10690:
10691: SELECT LANGUAGE_CODE
10692: INTO l_lang_code
10693: FROM FND_LANGUAGES
10694: WHERE NLS_LANGUAGE = l_language_code;
10695:
10696: l_progress := '020';
10697:

Line 11128: FROM FND_LANGUAGES

11124: l_progress := '010';
11125:
11126: SELECT LANGUAGE_CODE
11127: INTO l_lang_code
11128: FROM FND_LANGUAGES
11129: WHERE NLS_LANGUAGE = l_language_code;
11130:
11131: l_progress := '020';
11132:

Line 12714: FROM FND_LANGUAGES

12710: END;
12711:
12712: SELECT LANGUAGE_CODE
12713: INTO l_lang_code
12714: FROM FND_LANGUAGES
12715: WHERE NLS_LANGUAGE = l_language;
12716:
12717: l_recipient_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_userPartyId, 2 ,l_lang_code) ;
12718: l_sender_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_from_id, 2 ,l_lang_code);