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_B

Line 6548: FROM EGO_FLEX_VALUE_VERSION_B

6544: rect_t compareReleaseDates%rowtype;
6545: CURSOR copyDuplicateRow
6546: IS
6547: SELECT flex_value_id,SEQUENCE
6548: FROM EGO_FLEX_VALUE_VERSION_B
6549: WHERE flex_value_set_id = p_value_set_id AND version_seq_id = 0;
6550: rec_duplicateRow copyDuplicateRow % ROWTYPE;
6551:
6552: BEGIN

Line 6560: (SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B

6556: IF(l_max_version_seq_id > 0) THEN
6557:
6558: SELECT COUNT(*) INTO L_DUP_REC FROM
6559: (
6560: (SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6561: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=0
6562: MINUS
6563: SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6564: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=L_MAX_VERSION_SEQ_ID)

Line 6563: SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B

6559: (
6560: (SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6561: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=0
6562: MINUS
6563: SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6564: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=L_MAX_VERSION_SEQ_ID)
6565:
6566: UNION
6567:

Line 6568: (SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B

6564: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=L_MAX_VERSION_SEQ_ID)
6565:
6566: UNION
6567:
6568: (SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6569: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=L_MAX_VERSION_SEQ_ID
6570: MINUS
6571: SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6572: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=0)

Line 6571: SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B

6567:
6568: (SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6569: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=L_MAX_VERSION_SEQ_ID
6570: MINUS
6571: SELECT FLEX_VALUE_ID,SEQUENCE FROM EGO_FLEX_VALUE_VERSION_B
6572: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID=0)
6573: ) ;
6574:
6575: IF(L_DUP_REC = 0) THEN

Line 6688: UPDATE EGO_FLEX_VALUE_VERSION_B SET VERSION_SEQ_ID =P_VERSION_SEQ_ID ,

6684: LOOP
6685: FETCH copyDuplicateRow INTO rec_duplicateRow ;
6686: EXIT WHEN copyDuplicateRow%NOTFOUND ;
6687:
6688: UPDATE EGO_FLEX_VALUE_VERSION_B SET VERSION_SEQ_ID =P_VERSION_SEQ_ID ,
6689: LAST_UPDATED_BY= FND_GLOBAL.PARTY_ID,
6690: LAST_UPDATE_DATE = SYSDATE,
6691: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6692: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID = 0 AND FLEX_VALUE_ID

Line 6695: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID

6691: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6692: WHERE FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND VERSION_SEQ_ID = 0 AND FLEX_VALUE_ID
6693: = REC_DUPLICATEROW.FLEX_VALUE_ID;
6694:
6695: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID,FLEX_VALUE_ID,VERSION_SEQ_ID
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:

Line 6736: FROM ego_flex_value_version_b

6732:
6733: CURSOR revert_draft
6734: IS
6735: SELECT flex_value_id,SEQUENCE
6736: FROM ego_flex_value_version_b
6737: WHERE version_seq_id = p_version_number AND flex_value_set_id = p_value_set_id;
6738: rect_t revert_draft%rowtype;
6739:
6740: BEGIN

Line 6745: (SELECT FLEX_VALUE_ID FROM EGO_FLEX_VALUE_VERSION_B WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID

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
6749: WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID AND VERSION_SEQ_ID = 0;

Line 6748: DELETE FROM EGO_FLEX_VALUE_VERSION_B

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
6749: WHERE FLEX_VALUE_SET_ID =P_VALUE_SET_ID AND VERSION_SEQ_ID = 0;
6750:
6751:
6752:

Line 6757: INSERT INTO EGO_FLEX_VALUE_VERSION_B(FLEX_VALUE_SET_ID,FLEX_VALUE_ID

6753: OPEN revert_draft;
6754: LOOP
6755: FETCH revert_draft INTO rect_t;
6756: EXIT WHEN revert_draft%notfound ;
6757: INSERT INTO EGO_FLEX_VALUE_VERSION_B(FLEX_VALUE_SET_ID,FLEX_VALUE_ID
6758: ,VERSION_SEQ_ID,SEQUENCE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
6759: LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6760: VALUES (P_VALUE_SET_ID,RECT_T.FLEX_VALUE_ID,0,RECT_T.SEQUENCE,FND_GLOBAL.PARTY_ID,
6761: SYSDATE,FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID );

Line 6773: (SELECT FLEX_VALUE_ID FROM EGO_FLEX_VALUE_VERSION_B

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';
6776: COMMIT;
6777:

Line 6817: --Creating the record for values in EGO_FLEX_VALUE_VERSION_B table

6813: --Clearing out the start date and end of values in fnd_flex_values because we are considering all the
6814: -- enabled values for this value set.
6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL
6816: WHERE FLEX_VALUE_SET_ID= P_VALUE_SET_ID AND ENABLED_FLAG='Y';
6817: --Creating the record for values in EGO_FLEX_VALUE_VERSION_B table
6818: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID,SEQUENCE,
6819: VERSION_SEQ_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6820: SELECT P_VALUE_SET_ID, A.FLEX_VALUE_ID, B.DISP_SEQUENCE,0,A.CREATED_BY,SYSDATE,
6821: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID

Line 6818: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID,SEQUENCE,

6814: -- enabled values for this value set.
6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL
6816: WHERE FLEX_VALUE_SET_ID= P_VALUE_SET_ID AND ENABLED_FLAG='Y';
6817: --Creating the record for values in EGO_FLEX_VALUE_VERSION_B table
6818: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID,SEQUENCE,
6819: VERSION_SEQ_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6820: SELECT P_VALUE_SET_ID, A.FLEX_VALUE_ID, B.DISP_SEQUENCE,0,A.CREATED_BY,SYSDATE,
6821: FND_GLOBAL.PARTY_ID,SYSDATE,FND_GLOBAL.LOGIN_ID
6822: FROM FND_FLEX_VALUES A, EGO_VS_VALUES_DISP_ORDER B

Line 6832: B.FLEX_VALUE_MEANING,B.LANGUAGE,USERENV('LANG') FROM EGO_FLEX_VALUE_VERSION_B A,

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
6834: WHERE A.FLEX_VALUE_SET_ID = P_VALUE_SET_ID AND
6835: A.VERSION_SEQ_ID = 0 AND A.FLEX_VALUE_ID = B.FLEX_VALUE_ID;
6836: x_return_status := 'S';

Line 8376: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID, VERSION_SEQ_ID,

8372: SELECT FLEX_VALUE_ID INTO l_flex_value_id FROM FND_FLEX_VALUES
8373: WHERE FLEX_VALUE_SET_ID = x_flex_Value_Set_Id AND FLEX_VALUE like p_internal_name ;
8374:
8375:
8376: INSERT INTO EGO_FLEX_VALUE_VERSION_B (FLEX_VALUE_SET_ID, FLEX_VALUE_ID, VERSION_SEQ_ID,
8377: sequence,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
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:

Line 8706: UPDATE ego_flex_value_version_b SET SEQUENCE = p_sequence

8702: ELSE
8703:
8704: SELECT COUNT(*) INTO L_VALUES_COUNT FROM EGO_FLEX_VALUESET_VERSION_B WHERE FLEX_VALUE_SET_ID = L_VALUE_SET_ID;
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,

Line 14650: FROM EGO_FLEX_VALUE_VERSION_B B

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
14652: );
14653:
14654: UPDATE EGO_FLEX_VALUE_VERSION_TL T

Line 15562: DELETE EGO_FLEX_VALUE_VERSION_B WHERE FLEX_VALUE_ID = p_value_id AND VERSION_SEQ_ID = 0 ;

15558: ,x_last_update_date => sysdate
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;