APPS.EGO_EXT_FWK_PUB dependencies on FND_FLEX_VALUES_S

Line 651: SELECT fnd_flex_values_s.NEXTVAL

647: WHERE flex_value_set_name = p_value_set_name;
648:
649: IF p_transaction_type = 'CREATE' THEN
650: -- create an translatable independent value set
651: SELECT fnd_flex_values_s.NEXTVAL
652: INTO l_flex_value_id
653: FROM dual;
654: FND_FLEX_VALUES_PKG.INSERT_ROW
655: (x_rowid => l_rowid

Line 748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL

744: ,x_start_date_active => p_start_date
745: ,x_end_date_active => p_end_date
746: ,x_parent_flex_value_low =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_LOW
747: ,x_parent_flex_value_high =>l_rec_fnd_flex_values.PARENT_FLEX_VALUE_HIGH
748: ,x_structured_hierarchy_level =>l_rec_fnd_flex_values.STRUCTURED_HIERARCHY_LEVEL
749: ,x_hierarchy_level => l_rec_fnd_flex_values.HIERARCHY_LEVEL
750: ,x_compiled_value_attributes =>l_rec_fnd_flex_values.COMPILED_VALUE_ATTRIBUTES
751: ,x_value_category => l_rec_fnd_flex_values.VALUE_CATEGORY
752: ,x_attribute1 => l_rec_fnd_flex_values.ATTRIBUTE1

Line 6815: UPDATE FND_FLEX_VALUES SET START_DATE_ACTIVE = NULL ,END_DATE_ACTIVE= NULL

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
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)