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 427: FROM EGO_FND_DF_COL_USGS_EXT ext

423: x_fnd_exists :='N';
424: END;
425: BEGIN
426: SELECT 'Y' INTO x_ego_exists
427: FROM EGO_FND_DF_COL_USGS_EXT ext
428: ,FND_DESCR_FLEX_COLUMN_USAGES fl_col
429: WHERE ext.APPLICATION_ID (+) = fl_col.APPLICATION_ID
430: AND ext.DESCRIPTIVE_FLEXFIELD_NAME (+) = fl_col.DESCRIPTIVE_FLEXFIELD_NAME
431: AND ext.DESCRIPTIVE_FLEX_CONTEXT_CODE (+) = fl_col.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 915: DELETE FROM EGO_FND_DF_COL_USGS_EXT

911: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
912: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
913: AND APPLICATION_COLUMN_NAME = l_app_col_name;
914:
915: DELETE FROM EGO_FND_DF_COL_USGS_EXT
916: WHERE APPLICATION_ID = p_application_id
917: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
918: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
919: AND APPLICATION_COLUMN_NAME = l_app_col_name;

Line 1853: ,EGO_FND_DF_COL_USGS_EXT EXT

1849: ,cp_column_type IN VARCHAR2
1850: ) IS
1851: SELECT FC.COLUMN_NAME
1852: FROM FND_COLUMNS FC
1853: ,EGO_FND_DF_COL_USGS_EXT EXT
1854: WHERE EXT.APPLICATION_ID = cp_application_id
1855: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
1856: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name
1857: AND EXT.DATA_TYPE = cp_data_type

Line 3919: EGO_FND_DF_COL_USGS_EXT EXT

3915: ,l_attr_name
3916: ,l_curr_db_column
3917: FROM
3918: FND_DESCR_FLEX_COLUMN_USAGES USGS,
3919: EGO_FND_DF_COL_USGS_EXT EXT
3920: WHERE
3921: USGS.APPLICATION_ID = EXT.APPLICATION_ID
3922: AND USGS.DESCRIPTIVE_FLEXFIELD_NAME = EXT.DESCRIPTIVE_FLEXFIELD_NAME
3923: AND USGS.DESCRIPTIVE_FLEX_CONTEXT_CODE = EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 4067: ' FROM EGO_FND_DF_COL_USGS_EXT' ||

4063: -- Next, use the Attribute IDs to get a list of database --
4064: -- column names to add to the current 'Group By' list --
4065: -----------------------------------------------------------
4066: l_dynamic_sql := ' SELECT APPLICATION_COLUMN_NAME' ||
4067: ' FROM EGO_FND_DF_COL_USGS_EXT' ||
4068: ' WHERE ATTR_ID IN ('||p_id_list||') ';
4069:
4070: OPEN l_dynamic_cursor FOR l_dynamic_sql;
4071: LOOP

Line 5380: INSERT INTO EGO_FND_DF_COL_USGS_EXT

5376: WHERE L.INSTALLED_FLAG in ('I', 'B');
5377: END IF ;-- l_fnd_exists = 'Y' --Bug 4703510 END
5378:
5379: IF (l_ego_exists <> 'Y') THEN --Bug 4703510
5380: INSERT INTO EGO_FND_DF_COL_USGS_EXT
5381: (
5382: ATTR_ID
5383: ,APPLICATION_ID
5384: ,DESCRIPTIVE_FLEXFIELD_NAME

Line 5658: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;

5654: l_api_version CONSTANT NUMBER := 1.0;
5655:
5656: l_sequence NUMBER;
5657: l_min_seq NUMBER;
5658: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5659: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5660: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5661: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5662: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;

Line 5659: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;

5655:
5656: l_sequence NUMBER;
5657: l_min_seq NUMBER;
5658: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5659: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5660: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5661: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5662: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5663: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;

Line 5660: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;

5656: l_sequence NUMBER;
5657: l_min_seq NUMBER;
5658: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5659: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5660: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5661: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5662: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5663: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5664: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;

Line 5661: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;

5657: l_min_seq NUMBER;
5658: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5659: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5660: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5661: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5662: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5663: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5664: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
5665: l_is_column_indexed VARCHAR2(1);

Line 5662: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;

5658: l_was_searchable EGO_FND_DF_COL_USGS_EXT.search_flag%TYPE;
5659: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5660: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5661: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5662: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5663: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5664: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
5665: l_is_column_indexed VARCHAR2(1);
5666: l_is_chg_column_indexed VARCHAR2(1);

Line 5663: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;

5659: l_view_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.view_in_hierarchy_code%TYPE;
5660: l_edit_in_hierarchy_code EGO_FND_DF_COL_USGS_EXT.edit_in_hierarchy_code%TYPE;
5661: l_customization_level EGO_FND_DF_COL_USGS_EXT.customization_level%TYPE;
5662: l_attribute_code EGO_FND_DF_COL_USGS_EXT.attribute_code%TYPE;
5663: l_uom_class EGO_FND_DF_COL_USGS_EXT.uom_class%TYPE;
5664: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
5665: l_is_column_indexed VARCHAR2(1);
5666: l_is_chg_column_indexed VARCHAR2(1);
5667: l_table_name VARCHAR2(100);

Line 5706: FROM EGO_FND_DF_COL_USGS_EXT

5702: SELECT SEARCH_FLAG, view_in_hierarchy_code, edit_in_hierarchy_code,
5703: customization_level, attribute_code, uom_class
5704: INTO l_was_searchable, l_view_in_hierarchy_code, l_edit_in_hierarchy_code,
5705: l_customization_level, l_attribute_code, l_uom_class
5706: FROM EGO_FND_DF_COL_USGS_EXT
5707: WHERE APPLICATION_ID = p_application_id
5708: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5709: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5710: AND APPLICATION_COLUMN_NAME = p_column;

Line 5834: FROM EGO_FND_DF_COL_USGS_EXT

5830: -----------------------------------------------------------
5831: --added for BUGFIX:4547918
5832: SELECT DATA_TYPE
5833: INTO l_data_type_code
5834: FROM EGO_FND_DF_COL_USGS_EXT
5835: WHERE APPLICATION_ID = p_application_id
5836: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5837: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5838: AND APPLICATION_COLUMN_NAME = p_column;

Line 5969: UPDATE EGO_FND_DF_COL_USGS_EXT

5965: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5966: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5967: AND APPLICATION_COLUMN_NAME = p_column;
5968:
5969: UPDATE EGO_FND_DF_COL_USGS_EXT
5970: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
5971: LAST_UPDATE_DATE = p_lud,
5972: LAST_UPDATE_LOGIN = g_current_login_id,
5973: INFO_1 = p_info_1,

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

13896:
13897: END Update_AGV_Name;
13898:
13899: ------------------------------------------------------------------------------------------
13900: -- This method will update the control level of an attribute in EGO_FND_DF_COL_USGS_EXT
13901: -- requires: 1) p_control_level is a valid control level
13902: -- as represented in lookup 'EGO_PC_CONTROL_LEVEL' in fnd_lookups
13903: -- 2) p_application_column_name is not null and is a valid column name
13904: -- 3) p_application_id is not null and is valid

Line 13964: from EGO_FND_DF_COL_USGS_EXT

13960: BEGIN
13961:
13962: -- check if there exists any attributes to be updated
13963: select attr_id into l_attr_id
13964: from EGO_FND_DF_COL_USGS_EXT
13965: where application_id = p_application_id
13966: and descriptive_flexfield_name = p_descriptive_flexfield_name
13967: and application_column_name = p_application_column_name;
13968:

Line 13970: update EGO_FND_DF_COL_USGS_EXT

13966: and descriptive_flexfield_name = p_descriptive_flexfield_name
13967: and application_column_name = p_application_column_name;
13968:
13969: -- change the control level for this attribute
13970: update EGO_FND_DF_COL_USGS_EXT
13971: set control_level = p_control_level
13972: where application_id = p_application_id
13973: and descriptive_flexfield_name = p_descriptive_flexfield_name
13974: and application_column_name = p_application_column_name;