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_EXT_FWK_PUB dependencies on EGO_FND_DF_COL_USGS_EXT

Line 463: FROM EGO_FND_DF_COL_USGS_EXT ext

459: x_fnd_exists :='N';
460: END;
461: BEGIN
462: SELECT 'Y' INTO x_ego_exists
463: FROM EGO_FND_DF_COL_USGS_EXT ext
464: ,FND_DESCR_FLEX_COLUMN_USAGES fl_col
465: WHERE ext.APPLICATION_ID (+) = fl_col.APPLICATION_ID
466: AND ext.DESCRIPTIVE_FLEXFIELD_NAME (+) = fl_col.DESCRIPTIVE_FLEXFIELD_NAME
467: AND ext.DESCRIPTIVE_FLEX_CONTEXT_CODE (+) = fl_col.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 955: DELETE FROM EGO_FND_DF_COL_USGS_EXT

951: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
952: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
953: AND APPLICATION_COLUMN_NAME = l_app_col_name;
954:
955: DELETE FROM EGO_FND_DF_COL_USGS_EXT
956: WHERE APPLICATION_ID = p_application_id
957: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
958: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
959: AND APPLICATION_COLUMN_NAME = l_app_col_name;

Line 1935: ,EGO_FND_DF_COL_USGS_EXT EXT

1931: ,cp_column_type IN VARCHAR2
1932: ) IS
1933: SELECT FC.COLUMN_NAME
1934: FROM FND_COLUMNS FC
1935: ,EGO_FND_DF_COL_USGS_EXT EXT
1936: WHERE EXT.APPLICATION_ID = cp_application_id
1937: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
1938: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name
1939: AND EXT.DATA_TYPE = cp_data_type

Line 4033: EGO_FND_DF_COL_USGS_EXT EXT

4029: ,l_attr_name
4030: ,l_curr_db_column
4031: FROM
4032: FND_DESCR_FLEX_COLUMN_USAGES USGS,
4033: EGO_FND_DF_COL_USGS_EXT EXT
4034: WHERE
4035: USGS.APPLICATION_ID = EXT.APPLICATION_ID
4036: AND USGS.DESCRIPTIVE_FLEXFIELD_NAME = EXT.DESCRIPTIVE_FLEXFIELD_NAME
4037: AND USGS.DESCRIPTIVE_FLEX_CONTEXT_CODE = EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 4192: ' FROM EGO_FND_DF_COL_USGS_EXT' ||

4188: -- Next, use the Attribute IDs to get a list of database --
4189: -- column names to add to the current 'Group By' list --
4190: -----------------------------------------------------------
4191: l_dynamic_sql := ' SELECT APPLICATION_COLUMN_NAME' ||
4192: ' FROM EGO_FND_DF_COL_USGS_EXT' ||
4193: ' WHERE ATTR_ID IN ('||p_id_list||') ';
4194:
4195: OPEN l_dynamic_cursor FOR l_dynamic_sql;
4196: LOOP

Line 5586: INSERT INTO EGO_FND_DF_COL_USGS_EXT

5582: END IF ;-- l_fnd_exists = 'Y' --Bug 4703510 END
5583:
5584:
5585: IF (l_ego_exists <> 'Y') THEN --Bug 4703510
5586: INSERT INTO EGO_FND_DF_COL_USGS_EXT
5587: (
5588: ATTR_ID
5589: ,APPLICATION_ID
5590: ,DESCRIPTIVE_FLEXFIELD_NAME

Line 5945: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;

5941: l_api_version CONSTANT NUMBER := 1.0;
5942:
5943: l_sequence NUMBER;
5944: l_min_seq NUMBER;
5945: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5946: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5947: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5948: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5949: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;

Line 5946: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;

5942:
5943: l_sequence NUMBER;
5944: l_min_seq NUMBER;
5945: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5946: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5947: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5948: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5949: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5950: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;

Line 5947: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;

5943: l_sequence NUMBER;
5944: l_min_seq NUMBER;
5945: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5946: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5947: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5948: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5949: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5950: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5951: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;

Line 5948: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;

5944: l_min_seq NUMBER;
5945: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5946: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5947: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5948: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5949: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5950: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5951: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
5952: l_is_column_indexed VARCHAR2(1);

Line 5949: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;

5945: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5946: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5947: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5948: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5949: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5950: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5951: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
5952: l_is_column_indexed VARCHAR2(1);
5953: l_is_chg_column_indexed VARCHAR2(1);

Line 5950: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;

5946: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5947: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5948: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5949: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5950: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5951: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
5952: l_is_column_indexed VARCHAR2(1);
5953: l_is_chg_column_indexed VARCHAR2(1);
5954: l_table_name VARCHAR2(100);

Line 5994: FROM EGO_FND_DF_COL_USGS_EXT

5990: SELECT SEARCH_FLAG, view_in_hierarchy_code, edit_in_hierarchy_code,
5991: customization_level, attribute_code, uom_class, read_only_flag
5992: INTO l_was_searchable, l_view_in_hierarchy_code, l_edit_in_hierarchy_code,
5993: l_customization_level, l_attribute_code, l_uom_class, l_read_only_flag
5994: FROM EGO_FND_DF_COL_USGS_EXT
5995: WHERE APPLICATION_ID = p_application_id
5996: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5997: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5998: AND APPLICATION_COLUMN_NAME = p_column;

Line 6130: FROM EGO_FND_DF_COL_USGS_EXT

6126: -----------------------------------------------------------
6127: --added for BUGFIX:4547918
6128: SELECT DATA_TYPE
6129: INTO l_data_type_code
6130: FROM EGO_FND_DF_COL_USGS_EXT
6131: WHERE APPLICATION_ID = p_application_id
6132: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6133: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
6134: AND APPLICATION_COLUMN_NAME = p_column;

Line 6265: UPDATE EGO_FND_DF_COL_USGS_EXT

6261: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6262: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
6263: AND APPLICATION_COLUMN_NAME = p_column;
6264:
6265: UPDATE EGO_FND_DF_COL_USGS_EXT
6266: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
6267: LAST_UPDATE_DATE = p_lud,
6268: LAST_UPDATE_LOGIN = g_current_login_id,
6269: INFO_1 = p_info_1,

Line 14970: -- This method will update the control level of an attribute in EGO_FND_DF_COL_USGS_EXT

14966:
14967: END Update_AGV_Name;
14968:
14969: ------------------------------------------------------------------------------------------
14970: -- This method will update the control level of an attribute in EGO_FND_DF_COL_USGS_EXT
14971: -- requires: 1) p_control_level is a valid control level
14972: -- as represented in lookup 'EGO_PC_CONTROL_LEVEL' in fnd_lookups
14973: -- 2) p_application_column_name is not null and is a valid column name
14974: -- 3) p_application_id is not null and is valid

Line 15034: from EGO_FND_DF_COL_USGS_EXT

15030: BEGIN
15031:
15032: -- check if there exists any attributes to be updated
15033: select attr_id into l_attr_id
15034: from EGO_FND_DF_COL_USGS_EXT
15035: where application_id = p_application_id
15036: and descriptive_flexfield_name = p_descriptive_flexfield_name
15037: and application_column_name = p_application_column_name;
15038:

Line 15040: update EGO_FND_DF_COL_USGS_EXT

15036: and descriptive_flexfield_name = p_descriptive_flexfield_name
15037: and application_column_name = p_application_column_name;
15038:
15039: -- change the control level for this attribute
15040: update EGO_FND_DF_COL_USGS_EXT
15041: set control_level = p_control_level
15042: where application_id = p_application_id
15043: and descriptive_flexfield_name = p_descriptive_flexfield_name
15044: and application_column_name = p_application_column_name;