eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_FLEX_VALUE_VERSION_TL

Line 1818: DELETE FROM EGO_FLEX_VALUE_VERSION_TL

1814: write_debug(G_PKG_Name,l_api_name,' Start of API ');
1815: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Start of API ');
1816:
1817:
1818: DELETE FROM EGO_FLEX_VALUE_VERSION_TL
1819: WHERE VERSION_SEQ_ID =0
1820: AND FLEX_VALUE_ID IN ( SELECT FLEX_VALUE_ID
1821: FROM EGO_FLEX_VALUE_VERSION_B
1822: WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID

Line 1848: INSERT INTO EGO_FLEX_VALUE_VERSION_TL

1844: END LOOP;
1845: CLOSE Sync_Draft;
1846:
1847:
1848: INSERT INTO EGO_FLEX_VALUE_VERSION_TL
1849: ( FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
1850: LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
1851:
1852: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,

Line 1853: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL

1849: ( FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
1850: LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
1851:
1852: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
1853: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL
1854: WHERE VERSION_SEQ_ID = P_VERSION_NUMBER AND FLEX_VALUE_ID
1855: IN ( SELECT FLEX_VALUE_ID
1856: FROM EGO_FLEX_VALUE_VERSION_B
1857: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID

Line 4135: FROM EGO_FLEX_VALUE_VERSION_TL

4131: cp_version_seq_id NUMBER,
4132: cp_lang_code VARCHAR2)
4133: IS
4134: ( SELECT 1 AS lang_code
4135: FROM EGO_FLEX_VALUE_VERSION_TL
4136: WHERE flex_value_id = cp_value_id
4137: AND version_seq_id = cp_version_seq_id
4138: AND "LANGUAGE" = cp_lang_code
4139: );

Line 5006: INSERT INTO EGO_FLEX_VALUE_VERSION_TL

5002: -- If lang rec does not exist then insert record for the same.
5003: IF l_lang_exist IS NULL THEN
5004:
5005:
5006: INSERT INTO EGO_FLEX_VALUE_VERSION_TL
5007: ( FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
5008: LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
5009:
5010: SELECT FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,

Line 5012: FROM EGO_FLEX_VALUE_VERSION_TL

5008: LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
5009:
5010: SELECT FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,
5011: LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,p.LANGUAGE_code,SOURCE_LANG
5012: FROM EGO_FLEX_VALUE_VERSION_TL
5013: WHERE flex_value_id = l_vs_val_rec(1).flex_value_id
5014: AND version_seq_id = G_OUT_VERSION_SEQ_ID
5015: AND "LANGUAGE" = UserEnv('lang');
5016:

Line 7254: FROM EGO_FLEX_VALUE_VERSION_TL

7250: cp_version_seq_id NUMBER,
7251: cp_lang_code VARCHAR2 )
7252: IS
7253: SELECT 1 AS exist
7254: FROM EGO_FLEX_VALUE_VERSION_TL
7255: WHERE --value_set_id = cp_value_set_id AND
7256: flex_value_id = cp_value_id
7257: AND version_seq_id = cp_version_seq_id
7258: AND "LANGUAGE" = cp_lang_code;

Line 8460: INSERT INTO EGO_FLEX_VALUE_VERSION_TL

8456:
8457:
8458: IF l_trans_val_ver_exist IS NULL THEN
8459:
8460: INSERT INTO EGO_FLEX_VALUE_VERSION_TL
8461: ( FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
8462: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
8463: VALUES ( l_FLEX_VALUE_ID,G_OUT_VERSION_SEQ_ID,SYSDATE,G_Party_Id, SYSDATE,G_Party_Id,G_Login_Id,
8464: l_description, l_flex_value_meaning,l_language,l_source_lang) ;

Line 8467: write_debug(G_PKG_Name,l_api_name, ' Inserted reord in EGO_FLEX_VALUE_VERSION_TL table '||p_value_set_val_tl_tbl(j).flex_value

8463: VALUES ( l_FLEX_VALUE_ID,G_OUT_VERSION_SEQ_ID,SYSDATE,G_Party_Id, SYSDATE,G_Party_Id,G_Login_Id,
8464: l_description, l_flex_value_meaning,l_language,l_source_lang) ;
8465:
8466:
8467: write_debug(G_PKG_Name,l_api_name, ' Inserted reord in EGO_FLEX_VALUE_VERSION_TL table '||p_value_set_val_tl_tbl(j).flex_value
8468: ||','||l_language);
8469: END IF;
8470:
8471: --- commented bug 12759471

Line 8637: INSERT INTO EGO_FLEX_VALUE_VERSION_TL

8633:
8634: write_debug(G_PKG_Name,l_api_name,' Trans record not exist. Insert record '||l_language);
8635:
8636: -- Write a code to verify that no record exist with given flex_value and version_seq_id
8637: INSERT INTO EGO_FLEX_VALUE_VERSION_TL
8638: ( FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
8639: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
8640: VALUES ( l_FLEX_VALUE_ID,G_OUT_VERSION_SEQ_ID,SYSDATE,G_Party_Id, SYSDATE,G_Party_Id,G_Login_Id,
8641: l_description, l_flex_value_meaning,l_language,l_source_lang) ;