DBA Data[Home] [Help]

APPS.ICX_POR_ITEM_UPLOAD dependencies on FND_LANGUAGES

Line 162: gBaseLanguage fnd_languages.language_code%TYPE;

158: gUpdateItemsNonTLSQL VARCHAR2(32767);
159: gAddRootCtxSQL ICX_POR_CTX_SQL_PKG.SQLTab;
160: gUpdateRootCtxSQL ICX_POR_CTX_SQL_PKG.SQLTab;
161:
162: gBaseLanguage fnd_languages.language_code%TYPE;
163: gJobLanguage fnd_languages.language_code%TYPE;
164: --Bug#2611529 gSupplierId NUMBER;
165: gJobNumber NUMBER;
166: gUserId NUMBER;

Line 163: gJobLanguage fnd_languages.language_code%TYPE;

159: gAddRootCtxSQL ICX_POR_CTX_SQL_PKG.SQLTab;
160: gUpdateRootCtxSQL ICX_POR_CTX_SQL_PKG.SQLTab;
161:
162: gBaseLanguage fnd_languages.language_code%TYPE;
163: gJobLanguage fnd_languages.language_code%TYPE;
164: --Bug#2611529 gSupplierId NUMBER;
165: gJobNumber NUMBER;
166: gUserId NUMBER;
167: gUserLogin NUMBER;

Line 4264: FROM fnd_languages

4260: gJobNumber := p_request_id;
4261: --Bug#2611529 gSupplierId := p_supplier_id;
4262:
4263: SELECT language_code INTO gBaseLanguage
4264: FROM fnd_languages
4265: WHERE installed_flag = 'B';
4266:
4267: --Bug#2611529 gJobLanguage := p_language;
4268: gUserId := p_user_id;

Line 4333: FROM fnd_languages

4329: gJobNumber := p_request_id;
4330: --Bug#2611529 gSupplierId := p_supplier_id;
4331:
4332: SELECT language_code INTO gBaseLanguage
4333: FROM fnd_languages
4334: WHERE installed_flag = 'B';
4335:
4336: gJobLanguage := p_language;
4337: gUserId := p_user_id;

Line 4982: FROM fnd_languages

4978:
4979: xLangArray DBMS_SQL.VARCHAR2_TABLE;
4980: CURSOR langCsr IS
4981: SELECT language_code
4982: FROM fnd_languages
4983: WHERE installed_flag in ('B', 'I')
4984: AND language_code <> gJobLanguage;
4985:
4986: BEGIN