[Home] [Help]
6807: --Inserting the new record in EGO_OBJECT_LOCK for Locking versioned value set agains username.
6808: INSERT INTO EGO_OBJECT_LOCK (LOCK_ID,OBJECT_NAME,PK1_VALUE,LOCKING_PARTY_ID,LOCK_FLAG,
6809: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
6810: VALUES
6811: (EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',P_VALUE_SET_ID,FND_GLOBAL.PARTY_ID,'L',
6812: FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID) ;
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
6909:
6910:
6911: INSERT INTO ego_object_lock (LOCK_ID,OBJECT_NAME,PK1_VALUE,locking_party_id,lock_flag,
6912: created_by,creation_date,last_updated_by,last_update_date,last_update_login) VALUES
6913: (EGO_OBJECT_LOCK_S.nextval,'EGO_VALUE_SET',x_value_set_id,FND_GLOBAL.party_id,'L',FND_GLOBAL.login_id,SYSDATE,
6914: FND_GLOBAL.login_id,SYSDATE,FND_GLOBAL.login_id) ;
6915: END IF;
6916: ------------------------------------------------------------------------------------------------------
6917: END Create_Value_Set;