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 3773: l_auctioneer_nls_language fnd_languages.nls_language%TYPE;

3769: x_nls_language VARCHAR2(60) := 'AMERICAN';
3770: x_territory_code VARCHAR2(30) := 'AMERICA';
3771: x_nls_territory VARCHAR2(60);
3772:
3773: l_auctioneer_nls_language fnd_languages.nls_language%TYPE;
3774: l_auctioneer_nls_territory fnd_territories.nls_territory%TYPE;
3775:
3776:
3777: CURSOR new_bidders IS

Line 3824: from fnd_languages

3820: -- Bug 3824928: Store the auctioneer's language and territory in new
3821: -- variables so that they can be used later.
3822:
3823: select NLS_LANGUAGE into l_auctioneer_nls_language
3824: from fnd_languages
3825: where language_code = x_language_code;
3826:
3827: select nls_territory into l_auctioneer_nls_territory
3828: from fnd_territories

Line 3920: from fnd_languages

3916:
3917:
3918: begin
3919: select NLS_LANGUAGE into x_nls_language
3920: from fnd_languages
3921: where language_code = x_language_code;
3922:
3923: select nls_territory into x_nls_territory
3924: from fnd_territories

Line 5811: from fnd_languages

5807: END IF; --}
5808:
5809: select nls_language
5810: into g_original_language
5811: from fnd_languages
5812: where language_code = g_original_lang_code;
5813:
5814: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5815: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 5850: from fnd_languages

5846: END IF; --}
5847:
5848: select language_code
5849: into x_language_code
5850: from fnd_languages
5851: where nls_language = p_language;
5852:
5853: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5854: FND_LOG.string(log_level => FND_LOG.level_statement,

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

5893:
5894: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5895: FND_LOG.string(log_level => FND_LOG.level_statement,
5896: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
5897: message => 'p_language is NULL so selecting it from fnd_languages');
5898: END IF; --}
5899:
5900: select nls_language
5901: into x_language

Line 5902: from fnd_languages

5898: END IF; --}
5899:
5900: select nls_language
5901: into x_language
5902: from fnd_languages
5903: where language_code = x_language_code;
5904:
5905: dbms_session.set_nls('NLS_LANGUAGE', x_language);
5906:

Line 6699: from fnd_languages

6695: PON_PROFILE_UTIL_PKG.GET_WF_PREFERENCES(x_auctioneer_user_name,x_language_code,x_territory_code);
6696: END IF;
6697:
6698: select NLS_LANGUAGE into x_nls_language
6699: from fnd_languages
6700: where language_code = x_language_code;
6701:
6702: select nls_territory into x_nls_territory
6703: from fnd_territories

Line 7093: from fnd_languages

7089: -- Bug 3824928: if tpcontactid is not null use language and territory
7090: -- from tp contact id else use auctioneer's language and territory
7091:
7092: select NLS_LANGUAGE into x_nls_addnl_language
7093: from fnd_languages
7094: where language_code = x_language_code;
7095:
7096: select nls_territory into x_nls_addnl_territory
7097: from fnd_territories

Line 9857: FROM FND_LANGUAGES

9853: l_progress := '010';
9854:
9855: SELECT LANGUAGE_CODE
9856: INTO l_lang_code
9857: FROM FND_LANGUAGES
9858: WHERE NLS_LANGUAGE = l_language_code;
9859:
9860: l_progress := '020';
9861:

Line 10292: FROM FND_LANGUAGES

10288: l_progress := '010';
10289:
10290: SELECT LANGUAGE_CODE
10291: INTO l_lang_code
10292: FROM FND_LANGUAGES
10293: WHERE NLS_LANGUAGE = l_language_code;
10294:
10295: l_progress := '020';
10296:

Line 11859: FROM FND_LANGUAGES

11855: END;
11856:
11857: SELECT LANGUAGE_CODE
11858: INTO l_lang_code
11859: FROM FND_LANGUAGES
11860: WHERE NLS_LANGUAGE = l_language;
11861:
11862: l_recipient_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_userPartyId, 2 ,l_lang_code) ;
11863: l_sender_name := PON_LOCALE_PKG.GET_PARTY_DISPLAY_NAME(p_from_id, 2 ,l_lang_code);