APPS.EGO_EXT_FWK_PUB dependencies on FND_DESCR_FLEX_CONTEXTS

Line 431: FROM FND_DESCR_FLEX_CONTEXTS

427:
428: IF (p_context = 'ATTRIBUTE GROUP') THEN
429: BEGIN
430: SELECT 'Y' INTO x_fnd_exists
431: FROM FND_DESCR_FLEX_CONTEXTS
432: WHERE APPLICATION_ID = p_application_id
433: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
434: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name;
435: EXCEPTION

Line 1023: DELETE FROM FND_DESCR_FLEX_CONTEXTS

1019: x_return_status, x_errorcode, x_msg_count, x_msg_data);
1020:
1021: END LOOP;
1022:
1023: DELETE FROM FND_DESCR_FLEX_CONTEXTS
1024: WHERE APPLICATION_ID = p_application_id
1025: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1026: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1027:

Line 1028: DELETE FROM FND_DESCR_FLEX_CONTEXTS_TL

1024: WHERE APPLICATION_ID = p_application_id
1025: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1026: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1027:
1028: DELETE FROM FND_DESCR_FLEX_CONTEXTS_TL
1029: WHERE APPLICATION_ID = p_application_id
1030: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1031: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1032:

Line 1759: FROM FND_DESCR_FLEX_CONTEXTS_TL FL_CTX_TL,

1755:
1756: BEGIN
1757:
1758: SELECT FL_CTX_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME INTO l_attr_group_name
1759: FROM FND_DESCR_FLEX_CONTEXTS_TL FL_CTX_TL,
1760: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1761: WHERE
1762: FL_CTX_EXT.APPLICATION_ID = FL_CTX_TL.APPLICATION_ID
1763: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = FL_CTX_TL.DESCRIPTIVE_FLEXFIELD_NAME

Line 2376: UPDATE FND_DESCR_FLEX_CONTEXTS

2372: ,x_ego_exists => l_ego_exists
2373: );
2374: IF (l_fnd_exists = 'Y') THEN --Bug 4703510
2375:
2376: UPDATE FND_DESCR_FLEX_CONTEXTS
2377: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
2378: LAST_UPDATE_DATE = p_lud,
2379: LAST_UPDATE_LOGIN = g_current_login_id
2380: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type

Line 2384: UPDATE FND_DESCR_FLEX_CONTEXTS_TL

2380: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
2381: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name
2382: AND APPLICATION_ID = p_application_id;
2383:
2384: UPDATE FND_DESCR_FLEX_CONTEXTS_TL
2385: SET DESCRIPTION = p_attr_group_desc,
2386: DESCRIPTIVE_FLEX_CONTEXT_NAME = p_display_name,
2387: LAST_UPDATE_DATE = p_lud,
2388: LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),

Line 3149: UPDATE FND_DESCR_FLEX_CONTEXTS

3145: ELSE
3146:
3147: -- We only update this information if we are NOT in NLS mode
3148: -- (i.e., we don't update it if we are in NLS mode)
3149: UPDATE FND_DESCR_FLEX_CONTEXTS
3150: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
3151: LAST_UPDATE_DATE = p_lud,
3152: LAST_UPDATE_LOGIN = g_current_login_id
3153: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type

Line 3178: UPDATE FND_DESCR_FLEX_CONTEXTS_TL

3174:
3175: END IF;
3176:
3177: -- We update the TL information whether or not we're in NLS mode
3178: UPDATE FND_DESCR_FLEX_CONTEXTS_TL
3179: SET DESCRIPTION = p_attr_group_desc,
3180: DESCRIPTIVE_FLEX_CONTEXT_NAME = p_display_name,
3181: LAST_UPDATE_DATE = p_lud,
3182: LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),

Line 3337: FROM FND_DESCR_FLEX_CONTEXTS_TL

3333: x_return_status := FND_API.G_RET_STS_ERROR;
3334:
3335: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
3336: INTO l_attr_group_disp_name
3337: FROM FND_DESCR_FLEX_CONTEXTS_TL
3338: WHERE APPLICATION_ID = p_application_id
3339: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
3340: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
3341: AND LANGUAGE = USERENV('LANG');

Line 5783: l_attr_group_disp_name FND_DESCR_FLEX_CONTEXTS_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;

5779: ROLLBACK TO Create_Attribute_PUB;
5780: END IF;
5781:
5782: DECLARE
5783: l_attr_group_disp_name FND_DESCR_FLEX_CONTEXTS_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;
5784: BEGIN
5785: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
5786: INTO l_attr_group_disp_name
5787: FROM FND_DESCR_FLEX_CONTEXTS_TL

Line 5787: FROM FND_DESCR_FLEX_CONTEXTS_TL

5783: l_attr_group_disp_name FND_DESCR_FLEX_CONTEXTS_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;
5784: BEGIN
5785: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
5786: INTO l_attr_group_disp_name
5787: FROM FND_DESCR_FLEX_CONTEXTS_TL
5788: WHERE APPLICATION_ID = p_application_id
5789: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5790: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5791: AND LANGUAGE = USERENV('LANG');

Line 6439: FROM FND_DESCR_FLEX_CONTEXTS_TL

6435:
6436: l_token_table(2).TOKEN_NAME := 'ATTR_GRP_NAME';
6437: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
6438: INTO l_token_table(2).TOKEN_VALUE
6439: FROM FND_DESCR_FLEX_CONTEXTS_TL
6440: WHERE APPLICATION_ID = p_application_id
6441: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6442: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
6443: AND LANGUAGE = USERENV('LANG');