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.

[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 452: FROM FND_DESCR_FLEX_COLUMN_USAGES

448: END;
449: ELSIF (p_context = 'ATTRIBUTE') THEN
450: BEGIN
451: SELECT 'Y' INTO x_fnd_exists
452: FROM FND_DESCR_FLEX_COLUMN_USAGES
453: WHERE APPLICATION_ID = p_application_id
454: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
455: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
456: AND END_USER_COLUMN_NAME = p_internal_name;

Line 464: ,FND_DESCR_FLEX_COLUMN_USAGES fl_col

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

Line 937: FROM FND_DESCR_FLEX_COLUMN_USAGES

933: END IF;
934:
935: SELECT APPLICATION_COLUMN_NAME
936: INTO l_app_col_name
937: FROM FND_DESCR_FLEX_COLUMN_USAGES
938: WHERE APPLICATION_ID = p_application_id
939: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
940: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
941: AND END_USER_COLUMN_NAME = p_attr_name;

Line 943: DELETE FROM FND_DESCR_FLEX_COLUMN_USAGES

939: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
940: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
941: AND END_USER_COLUMN_NAME = p_attr_name;
942:
943: DELETE FROM FND_DESCR_FLEX_COLUMN_USAGES
944: WHERE APPLICATION_ID = p_application_id
945: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
946: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
947: AND END_USER_COLUMN_NAME = p_attr_name;

Line 1003: FROM FND_DESCR_FLEX_COLUMN_USAGES

999: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attr_Group_Internal';
1000:
1001: CURSOR attrs IS
1002: SELECT END_USER_COLUMN_NAME
1003: FROM FND_DESCR_FLEX_COLUMN_USAGES
1004: WHERE APPLICATION_ID = p_application_id
1005: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1006: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1007:

Line 1246: FROM FND_DESCR_FLEX_COLUMN_USAGES

1242: l_uom_column_name VARCHAR2(300);
1243: BEGIN
1244: SELECT 1
1245: INTO l_uom_column_name
1246: FROM FND_DESCR_FLEX_COLUMN_USAGES
1247: WHERE APPLICATION_ID = p_application_id
1248: AND DESCRIPTIVE_FLEXFIELD_NAME= p_attr_group_type
1249: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
1250: AND END_USER_COLUMN_NAME <> p_internal_name

Line 4032: FND_DESCR_FLEX_COLUMN_USAGES USGS,

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

Line 4050: FROM FND_DESCR_FLEX_COLUMN_USAGES EXT

4046: l_attr_name := p_attr_name;
4047:
4048: SELECT APPLICATION_COLUMN_NAME
4049: INTO l_curr_db_column
4050: FROM FND_DESCR_FLEX_COLUMN_USAGES EXT
4051: WHERE
4052: EXT.APPLICATION_ID = l_application_id
4053: AND EXT.DESCRIPTIVE_FLEXFIELD_NAME = l_attr_group_type
4054: AND EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = l_attr_group_name

Line 5096: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;

5092: e_col_internal_name_error EXCEPTION; --vkeerthi - Fix for bug 5884003.
5093: --Bug 4703510
5094: l_fnd_exists VARCHAR2(1) ;
5095: l_ego_exists VARCHAR2(1);
5096: l_value_set_id FND_DESCR_FLEX_COLUMN_USAGES.flex_value_set_id%TYPE;
5097: l_multi_row_flag VARCHAR2(2);
5098: l_min_seq NUMBER;
5099:
5100: BEGIN

Line 5152: FROM FND_DESCR_FLEX_COLUMN_USAGES

5148: --commenting this out as the flags l_fnd_exists and l_ego_exists take care of this now.
5149: -- Make sure passed-in sequence does not already exist
5150: SELECT COUNT(*)
5151: INTO l_sequence
5152: FROM FND_DESCR_FLEX_COLUMN_USAGES
5153: WHERE APPLICATION_ID = p_application_id
5154: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5155: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
5156: AND COLUMN_SEQ_NUM = p_sequence;

Line 5169: FROM FND_DESCR_FLEX_COLUMN_USAGES

5165: ELSE
5166: -- If user didn't pass in a sequence, add 10 to highest one (or start with 10) --
5167: SELECT MAX(COLUMN_SEQ_NUM)
5168: INTO l_sequence
5169: FROM FND_DESCR_FLEX_COLUMN_USAGES
5170: WHERE APPLICATION_ID = p_application_id
5171: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5172: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
5173:

Line 5203: FROM FND_DESCR_FLEX_COLUMN_USAGES

5199: IF (l_multi_row_flag = 'Y') THEN
5200:
5201: SELECT MIN(COLUMN_SEQ_NUM)
5202: INTO l_min_seq
5203: FROM FND_DESCR_FLEX_COLUMN_USAGES
5204: WHERE APPLICATION_ID = p_application_id
5205: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5206: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
5207:

Line 5454: FROM FND_DESCR_FLEX_COLUMN_USAGES

5450: IF (l_fnd_exists = 'Y') THEN --Bug 4703510
5451: BEGIN
5452: SELECT flex_value_set_id
5453: INTO l_value_set_id
5454: FROM FND_DESCR_FLEX_COLUMN_USAGES
5455: WHERE APPLICATION_ID = p_application_id
5456: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5457: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
5458: AND END_USER_COLUMN_NAME = p_internal_name;

Line 5464: UPDATE FND_DESCR_FLEX_COLUMN_USAGES

5460: WHEN OTHERS THEN
5461: l_value_set_id := NULL;
5462: END;
5463:
5464: UPDATE FND_DESCR_FLEX_COLUMN_USAGES
5465: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
5466: LAST_UPDATE_DATE = p_lud,
5467: LAST_UPDATE_LOGIN = g_current_login_id,
5468: COLUMN_SEQ_NUM = NVL(l_sequence, COLUMN_SEQ_NUM),

Line 5494: INSERT INTO FND_DESCR_FLEX_COLUMN_USAGES

5490: AND APPLICATION_COLUMN_NAME = p_column
5491: --AND LANGUAGE = USERENV('LANG');
5492: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);
5493: ELSE --l_fnd_exists = 'Y'
5494: INSERT INTO FND_DESCR_FLEX_COLUMN_USAGES
5495: (
5496: APPLICATION_ID
5497: ,DESCRIPTIVE_FLEXFIELD_NAME
5498: ,DESCRIPTIVE_FLEX_CONTEXT_CODE

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

Line 6041: FROM FND_DESCR_FLEX_COLUMN_USAGES

6037: -----------------------------------
6038: BEGIN
6039: SELECT flex_value_set_id
6040: INTO l_value_set_id
6041: FROM FND_DESCR_FLEX_COLUMN_USAGES
6042: WHERE APPLICATION_ID = p_application_id
6043: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6044: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
6045: AND END_USER_COLUMN_NAME = p_internal_name;

Line 6070: FROM FND_DESCR_FLEX_COLUMN_USAGES

6066:
6067: -- Make sure updated sequence does not already exist
6068: SELECT COLUMN_SEQ_NUM
6069: INTO l_sequence
6070: FROM FND_DESCR_FLEX_COLUMN_USAGES
6071: WHERE APPLICATION_ID = p_application_id
6072: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6073: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
6074: AND END_USER_COLUMN_NAME = p_internal_name;

Line 6082: FROM FND_DESCR_FLEX_COLUMN_USAGES

6078: -- check for uniqueness
6079:
6080: SELECT COUNT(*)
6081: INTO l_sequence
6082: FROM FND_DESCR_FLEX_COLUMN_USAGES
6083: WHERE APPLICATION_ID = p_application_id
6084: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6085: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name
6086: AND COLUMN_SEQ_NUM = p_sequence;

Line 6110: FROM FND_DESCR_FLEX_COLUMN_USAGES

6106: IF (l_multi_row_flag = 'Y') THEN
6107:
6108: SELECT MIN(COLUMN_SEQ_NUM)
6109: INTO l_min_seq
6110: FROM FND_DESCR_FLEX_COLUMN_USAGES
6111: WHERE APPLICATION_ID = p_application_id
6112: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6113: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
6114:

Line 6250: UPDATE FND_DESCR_FLEX_COLUMN_USAGES

6246:
6247: END IF;
6248:
6249:
6250: UPDATE FND_DESCR_FLEX_COLUMN_USAGES
6251: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
6252: LAST_UPDATE_DATE = p_lud,
6253: LAST_UPDATE_LOGIN = g_current_login_id,
6254: COLUMN_SEQ_NUM = NVL(l_sequence, COLUMN_SEQ_NUM),

Line 6425: ,FND_DESCR_FLEX_COLUMN_USAGES FL_COL

6421: l_token_table(1).TOKEN_NAME := 'ATTR_DISP_NAME';
6422: SELECT TL.FORM_LEFT_PROMPT
6423: INTO l_token_table(1).TOKEN_VALUE
6424: FROM FND_DESCR_FLEX_COL_USAGE_TL TL
6425: ,FND_DESCR_FLEX_COLUMN_USAGES FL_COL
6426: WHERE FL_COL.APPLICATION_ID = p_application_id
6427: AND FL_COL.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6428: AND FL_COL.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
6429: AND FL_COL.END_USER_COLUMN_NAME = p_attr_name

Line 15385: FROM FND_DESCR_FLEX_COLUMN_USAGES

15381:
15382: BEGIN
15383: SELECT APPLICATION_COLUMN_NAME
15384: INTO l_col_name
15385: FROM FND_DESCR_FLEX_COLUMN_USAGES
15386: WHERE APPLICATION_ID = p_target_appl_id
15387: AND DESCRIPTIVE_FLEXFIELD_NAME = p_target_ag_type
15388: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_target_ag_name
15389: AND END_USER_COLUMN_NAME = l_attr_metadata_table(i).ATTR_NAME;