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 FND_DESCR_FLEX_COLUMN_USAGES

Line 416: FROM FND_DESCR_FLEX_COLUMN_USAGES

412: END;
413: ELSIF (p_context = 'ATTRIBUTE') THEN
414: BEGIN
415: SELECT 'Y' INTO x_fnd_exists
416: FROM FND_DESCR_FLEX_COLUMN_USAGES
417: WHERE APPLICATION_ID = p_application_id
418: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
419: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
420: AND END_USER_COLUMN_NAME = p_internal_name;

Line 428: ,FND_DESCR_FLEX_COLUMN_USAGES fl_col

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
432: AND ext.APPLICATION_COLUMN_NAME (+) = fl_col.APPLICATION_COLUMN_NAME

Line 897: FROM FND_DESCR_FLEX_COLUMN_USAGES

893: END IF;
894:
895: SELECT APPLICATION_COLUMN_NAME
896: INTO l_app_col_name
897: FROM FND_DESCR_FLEX_COLUMN_USAGES
898: WHERE APPLICATION_ID = p_application_id
899: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
900: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
901: AND END_USER_COLUMN_NAME = p_attr_name;

Line 903: DELETE FROM FND_DESCR_FLEX_COLUMN_USAGES

899: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
900: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
901: AND END_USER_COLUMN_NAME = p_attr_name;
902:
903: DELETE FROM FND_DESCR_FLEX_COLUMN_USAGES
904: WHERE APPLICATION_ID = p_application_id
905: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
906: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
907: AND END_USER_COLUMN_NAME = p_attr_name;

Line 963: FROM FND_DESCR_FLEX_COLUMN_USAGES

959: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attr_Group_Internal';
960:
961: CURSOR attrs IS
962: SELECT END_USER_COLUMN_NAME
963: FROM FND_DESCR_FLEX_COLUMN_USAGES
964: WHERE APPLICATION_ID = p_application_id
965: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
966: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
967:

Line 1206: FROM FND_DESCR_FLEX_COLUMN_USAGES

1202: l_uom_column_name VARCHAR2(300);
1203: BEGIN
1204: SELECT 1
1205: INTO l_uom_column_name
1206: FROM FND_DESCR_FLEX_COLUMN_USAGES
1207: WHERE APPLICATION_ID = p_application_id
1208: AND DESCRIPTIVE_FLEXFIELD_NAME= p_attr_group_type
1209: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
1210: AND END_USER_COLUMN_NAME <> p_internal_name

Line 3918: FND_DESCR_FLEX_COLUMN_USAGES USGS,

3914: ,l_attr_group_name
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

Line 3936: FROM FND_DESCR_FLEX_COLUMN_USAGES EXT

3932: l_attr_name := p_attr_name;
3933:
3934: SELECT APPLICATION_COLUMN_NAME
3935: INTO l_curr_db_column
3936: FROM FND_DESCR_FLEX_COLUMN_USAGES EXT
3937: WHERE
3938: EXT.APPLICATION_ID = l_application_id
3939: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = l_attr_group_type
3940: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = l_attr_group_name

Line 4885: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;

4881: e_col_internal_name_error EXCEPTION; --vkeerthi - Fix for bug 5884003.
4882: --Bug 4703510
4883: l_fnd_exists VARCHAR2(1) ;
4884: l_ego_exists VARCHAR2(1);
4885: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
4886: l_multi_row_flag VARCHAR2(2);
4887: l_min_seq NUMBER;
4888:
4889:

Line 4943: FROM FND_DESCR_FLEX_COLUMN_USAGES

4939: --commenting this out as the flags l_fnd_exists and l_ego_exists take care of this now.
4940: -- Make sure passed-in sequence does not already exist
4941: SELECT COUNT(*)
4942: INTO l_sequence
4943: FROM FND_DESCR_FLEX_COLUMN_USAGES
4944: WHERE APPLICATION_ID = p_application_id
4945: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
4946: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
4947: AND COLUMN_SEQ_NUM = p_sequence;

Line 4960: FROM FND_DESCR_FLEX_COLUMN_USAGES

4956: ELSE
4957: -- If user didn't pass in a sequence, add 10 to highest one (or start with 10) --
4958: SELECT MAX(COLUMN_SEQ_NUM)
4959: INTO l_sequence
4960: FROM FND_DESCR_FLEX_COLUMN_USAGES
4961: WHERE APPLICATION_ID = p_application_id
4962: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
4963: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
4964:

Line 4995: FROM FND_DESCR_FLEX_COLUMN_USAGES

4991: IF (l_multi_row_flag = 'Y') THEN
4992:
4993: SELECT MIN(COLUMN_SEQ_NUM)
4994: INTO l_min_seq
4995: FROM FND_DESCR_FLEX_COLUMN_USAGES
4996: WHERE APPLICATION_ID = p_application_id
4997: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
4998: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
4999:

Line 5248: FROM FND_DESCR_FLEX_COLUMN_USAGES

5244: IF (l_fnd_exists = 'Y') THEN --Bug 4703510
5245: BEGIN
5246: SELECT flex_value_set_id
5247: INTO l_value_set_id
5248: FROM FND_DESCR_FLEX_COLUMN_USAGES
5249: WHERE APPLICATION_ID = p_application_id
5250: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5251: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
5252: AND END_USER_COLUMN_NAME = p_internal_name;

Line 5258: UPDATE FND_DESCR_FLEX_COLUMN_USAGES

5254: WHEN OTHERS THEN
5255: l_value_set_id := NULL;
5256: END;
5257:
5258: UPDATE FND_DESCR_FLEX_COLUMN_USAGES
5259: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
5260: LAST_UPDATE_DATE = p_lud,
5261: LAST_UPDATE_LOGIN = g_current_login_id,
5262: COLUMN_SEQ_NUM = NVL(l_sequence, COLUMN_SEQ_NUM),

Line 5289: INSERT INTO FND_DESCR_FLEX_COLUMN_USAGES

5285: --AND LANGUAGE = USERENV('LANG');
5286: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
5287: ELSE --l_fnd_exists = 'Y'
5288:
5289: INSERT INTO FND_DESCR_FLEX_COLUMN_USAGES
5290: (
5291: APPLICATION_ID
5292: ,DESCRIPTIVE_FLEXFIELD_NAME
5293: ,DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 5664: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%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);
5668: l_chg_table_name VARCHAR2(30);

Line 5746: FROM FND_DESCR_FLEX_COLUMN_USAGES

5742: -----------------------------------
5743: BEGIN
5744: SELECT flex_value_set_id
5745: INTO l_value_set_id
5746: FROM FND_DESCR_FLEX_COLUMN_USAGES
5747: WHERE APPLICATION_ID = p_application_id
5748: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5749: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
5750: AND END_USER_COLUMN_NAME = p_internal_name;

Line 5774: FROM FND_DESCR_FLEX_COLUMN_USAGES

5770:
5771: -- Make sure updated sequence does not already exist
5772: SELECT COLUMN_SEQ_NUM
5773: INTO l_sequence
5774: FROM FND_DESCR_FLEX_COLUMN_USAGES
5775: WHERE APPLICATION_ID = p_application_id
5776: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5777: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
5778: AND END_USER_COLUMN_NAME = p_internal_name;

Line 5786: FROM FND_DESCR_FLEX_COLUMN_USAGES

5782: -- check for uniqueness
5783:
5784: SELECT COUNT(*)
5785: INTO l_sequence
5786: FROM FND_DESCR_FLEX_COLUMN_USAGES
5787: WHERE APPLICATION_ID = p_application_id
5788: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5789: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
5790: AND COLUMN_SEQ_NUM = p_sequence;

Line 5814: FROM FND_DESCR_FLEX_COLUMN_USAGES

5810: IF (l_multi_row_flag = 'Y') THEN
5811:
5812: SELECT MIN(COLUMN_SEQ_NUM)
5813: INTO l_min_seq
5814: FROM FND_DESCR_FLEX_COLUMN_USAGES
5815: WHERE APPLICATION_ID = p_application_id
5816: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5817: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
5818:

Line 5954: UPDATE FND_DESCR_FLEX_COLUMN_USAGES

5950:
5951: END IF;
5952:
5953:
5954: UPDATE FND_DESCR_FLEX_COLUMN_USAGES
5955: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
5956: LAST_UPDATE_DATE = p_lud,
5957: LAST_UPDATE_LOGIN = g_current_login_id,
5958: COLUMN_SEQ_NUM = NVL(l_sequence, COLUMN_SEQ_NUM),

Line 6128: ,FND_DESCR_FLEX_COLUMN_USAGES FL_COL

6124: l_token_table(1).TOKEN_NAME := 'ATTR_DISP_NAME';
6125: SELECT TL.FORM_LEFT_PROMPT
6126: INTO l_token_table(1).TOKEN_VALUE
6127: FROM FND_DESCR_FLEX_COL_USAGE_TL TL
6128: ,FND_DESCR_FLEX_COLUMN_USAGES FL_COL
6129: WHERE FL_COL.APPLICATION_ID = p_application_id
6130: AND FL_COL.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6131: AND FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
6132: AND FL_COL.END_USER_COLUMN_NAME = p_attr_name

Line 14315: FROM FND_DESCR_FLEX_COLUMN_USAGES

14311:
14312: BEGIN
14313: SELECT APPLICATION_COLUMN_NAME
14314: INTO l_col_name
14315: FROM FND_DESCR_FLEX_COLUMN_USAGES
14316: WHERE APPLICATION_ID = p_target_appl_id
14317: AND DESCRIPTIVE_FLEXFIELD_NAME = p_target_ag_type
14318: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_target_ag_name
14319: AND END_USER_COLUMN_NAME = l_attr_metadata_table(i).ATTR_NAME;