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.

[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_FLEX_VALUE_VERSION_TL

Line 6700: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,

6696: ,SEQUENCE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6697: VALUES(P_VALUE_SET_ID,REC_DUPLICATEROW.FLEX_VALUE_ID,0,REC_DUPLICATEROW.SEQUENCE,
6698: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID);
6699:
6700: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6701: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6702: SELECT FLEX_VALUE_ID,P_VERSION_SEQ_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6703: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM
6704: EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = REC_DUPLICATEROW.FLEX_VALUE_ID AND VERSION_SEQ_ID=0 ;

Line 6704: EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = REC_DUPLICATEROW.FLEX_VALUE_ID AND VERSION_SEQ_ID=0 ;

6700: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6701: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6702: SELECT FLEX_VALUE_ID,P_VERSION_SEQ_ID,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6703: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM
6704: EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = REC_DUPLICATEROW.FLEX_VALUE_ID AND VERSION_SEQ_ID=0 ;
6705:
6706: END LOOP ;
6707: CLOSE copyDuplicateRow;
6708: x_return_status:='S';

Line 6744: DELETE FROM EGO_FLEX_VALUE_VERSION_TL WHERE VERSION_SEQ_ID =0 AND FLEX_VALUE_ID IN

6740: BEGIN
6741:
6742:
6743:
6744: DELETE FROM EGO_FLEX_VALUE_VERSION_TL WHERE VERSION_SEQ_ID =0 AND FLEX_VALUE_ID IN
6745: (SELECT FLEX_VALUE_ID FROM EGO_FLEX_VALUE_VERSION_B WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID
6746: AND VERSION_SEQ_ID = 0) ;
6747:
6748: DELETE FROM EGO_FLEX_VALUE_VERSION_B

Line 6768: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,

6764: END LOOP;
6765: CLOSE revert_draft;
6766:
6767:
6768: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6769: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6770: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6771: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL
6772: WHERE VERSION_SEQ_ID = P_VERSION_NUMBER AND FLEX_VALUE_ID IN

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

6767:
6768: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6769: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG)
6770: SELECT FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,
6771: FND_GLOBAL.LOGIN_ID,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG FROM EGO_FLEX_VALUE_VERSION_TL
6772: WHERE VERSION_SEQ_ID = P_VERSION_NUMBER AND FLEX_VALUE_ID IN
6773: (SELECT FLEX_VALUE_ID FROM EGO_FLEX_VALUE_VERSION_B
6774: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID = P_VERSION_NUMBER);
6775: x_return_status :='S';

Line 6828: --Creating the record for values in EGO_FLEX_VALUE_VERSION_tl table

6824: A.FLEX_VALUE_SET_ID = P_VALUE_SET_ID
6825: AND A.ENABLED_FLAG='Y'
6826: AND B.VALUE_SET_VALUE_ID = A.FLEX_VALUE_ID ;
6827:
6828: --Creating the record for values in EGO_FLEX_VALUE_VERSION_tl table
6829: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,DESCRIPTION,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6830: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG
6831: ) SELECT A.FLEX_VALUE_ID,B.DESCRIPTION ,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,
6832: B.FLEX_VALUE_MEANING,B.LANGUAGE,USERENV('LANG') FROM EGO_FLEX_VALUE_VERSION_B A,

Line 6829: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,DESCRIPTION,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,

6825: AND A.ENABLED_FLAG='Y'
6826: AND B.VALUE_SET_VALUE_ID = A.FLEX_VALUE_ID ;
6827:
6828: --Creating the record for values in EGO_FLEX_VALUE_VERSION_tl table
6829: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,DESCRIPTION,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
6830: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,FLEX_VALUE_MEANING,LANGUAGE,SOURCE_LANG
6831: ) SELECT A.FLEX_VALUE_ID,B.DESCRIPTION ,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,
6832: B.FLEX_VALUE_MEANING,B.LANGUAGE,USERENV('LANG') FROM EGO_FLEX_VALUE_VERSION_B A,
6833: FND_FLEX_VALUES_TL B

Line 8382: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,

8378: VALUES (x_flex_Value_Set_Id, l_flex_value_id,0,p_sequence,fnd_global.party_id,SYSDATE,
8379: fnd_global.party_id,SYSDATE,fnd_global.login_id);
8380:
8381:
8382: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (FLEX_VALUE_ID,VERSION_SEQ_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,
8383: CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN,DESCRIPTION,FLEX_VALUE_MEANING,LANGUAGE,
8384: SOURCE_LANG
8385: ) SELECT
8386: L_FLEX_VALUE_ID,0,SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.PARTY_ID,FND_GLOBAL.LOGIN_ID,

Line 8709: UPDATE EGO_FLEX_VALUE_VERSION_TL SET DESCRIPTION = P_DESCRIPTION,

8705: IF(l_values_count > 0 ) THEN
8706: UPDATE ego_flex_value_version_b SET SEQUENCE = p_sequence
8707: WHERE version_seq_id = 0 AND flex_value_set_id = l_value_set_id AND flex_value_id = l_flex_value_id ;
8708:
8709: UPDATE EGO_FLEX_VALUE_VERSION_TL SET DESCRIPTION = P_DESCRIPTION,
8710: FLEX_VALUE_MEANING = P_DISPLAY_NAME , SOURCE_LANG = USERENV('LANG'),LAST_UPDATE_DATE =SYSDATE,
8711: LAST_UPDATED_BY = FND_GLOBAL.PARTY_ID,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
8712: WHERE FLEX_VALUE_ID = L_FLEX_VALUE_ID AND VERSION_SEQ_ID = 0 AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
8713:

Line 14647: DELETE FROM EGO_FLEX_VALUE_VERSION_TL T

14643:
14644: PROCEDURE Add_Language_for_Flex_value IS
14645: BEGIN
14646:
14647: DELETE FROM EGO_FLEX_VALUE_VERSION_TL T
14648: WHERE NOT EXISTS
14649: (SELECT NULL
14650: FROM EGO_FLEX_VALUE_VERSION_B B
14651: WHERE B.flex_value_id = T.flex_value_id

Line 14654: UPDATE EGO_FLEX_VALUE_VERSION_TL T

14650: FROM EGO_FLEX_VALUE_VERSION_B B
14651: WHERE B.flex_value_id = T.flex_value_id
14652: );
14653:
14654: UPDATE EGO_FLEX_VALUE_VERSION_TL T
14655: SET (DESCRIPTION,
14656: FLEX_VALUE_MEANING
14657: )
14658: =

Line 14661: FROM EGO_FLEX_VALUE_VERSION_TL B

14657: )
14658: =
14659: (SELECT B.DESCRIPTION,
14660: B.FLEX_VALUE_MEANING
14661: FROM EGO_FLEX_VALUE_VERSION_TL B
14662: WHERE B.flex_value_id = T.flex_value_id
14663: AND B.LANGUAGE = T.SOURCE_LANG)
14664: WHERE (
14665: T.flex_value_id,

Line 14672: from EGO_FLEX_VALUE_VERSION_TL SUBB, EGO_FLEX_VALUE_VERSION_TL SUBT

14668: IN
14669: (SELECT
14670: SUBT.flex_value_id,
14671: SUBT.LANGUAGE
14672: from EGO_FLEX_VALUE_VERSION_TL SUBB, EGO_FLEX_VALUE_VERSION_TL SUBT
14673: where SUBB.flex_value_id = SUBT.flex_value_id
14674: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
14675: and ( SUBB.FLEX_VALUE_MEANING <> SUBT.FLEX_VALUE_MEANING
14676: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 14684: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (

14680: );
14681:
14682:
14683:
14684: INSERT INTO EGO_FLEX_VALUE_VERSION_TL (
14685: FLEX_VALUE_ID,
14686: VERSION_SEQ_ID,
14687: LAST_UPDATE_DATE,
14688: LAST_UPDATED_BY,

Line 14708: FROM EGO_FLEX_VALUE_VERSION_TL B, FND_LANGUAGES L

14704: B.DESCRIPTION,
14705: B.FLEX_VALUE_MEANING,
14706: L.LANGUAGE_CODE,
14707: B.SOURCE_LANG
14708: FROM EGO_FLEX_VALUE_VERSION_TL B, FND_LANGUAGES L
14709: where L.INSTALLED_FLAG in ('I', 'B')
14710: and B.LANGUAGE = userenv('LANG')
14711: and not exists
14712: (select NULL

Line 14713: from EGO_FLEX_VALUE_VERSION_TL T

14709: where L.INSTALLED_FLAG in ('I', 'B')
14710: and B.LANGUAGE = userenv('LANG')
14711: and not exists
14712: (select NULL
14713: from EGO_FLEX_VALUE_VERSION_TL T
14714: where T.flex_value_id = B.flex_value_id
14715: and T.LANGUAGE = L.LANGUAGE_CODE);
14716:
14717: END Add_Language_for_Flex_value;

Line 14741: ELSIF (p_tl_table_name = 'EGO_FLEX_VALUE_VERSION_TL') THEN

14737: ELSIF (p_tl_table_name = 'EGO_PAGES_TL') THEN
14738: Add_Language_for_Pages;
14739: ELSIF (p_tl_table_name = 'EGO_DATA_LEVEL_TL') THEN
14740: Add_Language_for_Data_level;
14741: ELSIF (p_tl_table_name = 'EGO_FLEX_VALUE_VERSION_TL') THEN
14742: Add_Language_for_Flex_Value;
14743: END IF;
14744:
14745: END ADD_LANGUAGE;

Line 15563: DELETE EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = p_value_id AND VERSION_SEQ_ID = 0 ;

15559: ,x_last_updated_by => fnd_global.party_id
15560: ,x_last_update_login => G_CURRENT_LOGIN_ID);
15561:
15562: DELETE EGO_FLEX_VALUE_VERSION_B WHERE FLEX_VALUE_ID = p_value_id AND VERSION_SEQ_ID = 0 ;
15563: DELETE EGO_FLEX_VALUE_VERSION_TL WHERE FLEX_VALUE_ID = p_value_id AND VERSION_SEQ_ID = 0 ;
15564:
15565: x_return_status :='S';
15566: commit;
15567: EXCEPTION