APPS.EGO_EXT_FWK_PUB dependencies on FND_DESCR_FLEX_CONTEXTS

Line 395: FROM FND_DESCR_FLEX_CONTEXTS

391:
392: IF (p_context = 'ATTRIBUTE GROUP') THEN
393: BEGIN
394: SELECT 'Y' INTO x_fnd_exists
395: FROM FND_DESCR_FLEX_CONTEXTS
396: WHERE APPLICATION_ID = p_application_id
397: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
398: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name;
399: EXCEPTION

Line 983: DELETE FROM FND_DESCR_FLEX_CONTEXTS

979: x_return_status, x_errorcode, x_msg_count, x_msg_data);
980:
981: END LOOP;
982:
983: DELETE FROM FND_DESCR_FLEX_CONTEXTS
984: WHERE APPLICATION_ID = p_application_id
985: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
986: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
987:

Line 988: DELETE FROM FND_DESCR_FLEX_CONTEXTS_TL

984: WHERE APPLICATION_ID = p_application_id
985: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
986: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
987:
988: DELETE FROM FND_DESCR_FLEX_CONTEXTS_TL
989: WHERE APPLICATION_ID = p_application_id
990: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
991: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
992:

Line 1677: FROM FND_DESCR_FLEX_CONTEXTS_TL FL_CTX_TL,

1673:
1674: BEGIN
1675:
1676: SELECT FL_CTX_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME INTO l_attr_group_name
1677: FROM FND_DESCR_FLEX_CONTEXTS_TL FL_CTX_TL,
1678: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1679: WHERE
1680: FL_CTX_EXT.APPLICATION_ID = FL_CTX_TL.APPLICATION_ID
1681: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = FL_CTX_TL.DESCRIPTIVE_FLEXFIELD_NAME

Line 2292: UPDATE FND_DESCR_FLEX_CONTEXTS

2288: ,x_fnd_exists => l_fnd_exists
2289: ,x_ego_exists => l_ego_exists
2290: );
2291: IF (l_fnd_exists = 'Y') THEN --Bug 4703510
2292: UPDATE FND_DESCR_FLEX_CONTEXTS
2293: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
2294: LAST_UPDATE_DATE = p_lud,
2295: LAST_UPDATE_LOGIN = g_current_login_id
2296: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type

Line 2300: UPDATE FND_DESCR_FLEX_CONTEXTS_TL

2296: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
2297: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name
2298: AND APPLICATION_ID = p_application_id;
2299:
2300: UPDATE FND_DESCR_FLEX_CONTEXTS_TL
2301: SET DESCRIPTION = p_attr_group_desc,
2302: DESCRIPTIVE_FLEX_CONTEXT_NAME = p_display_name,
2303: LAST_UPDATE_DATE = p_lud,
2304: LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),

Line 3063: UPDATE FND_DESCR_FLEX_CONTEXTS

3059: ELSE
3060:
3061: -- We only update this information if we are NOT in NLS mode
3062: -- (i.e., we don't update it if we are in NLS mode)
3063: UPDATE FND_DESCR_FLEX_CONTEXTS
3064: SET LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),
3065: LAST_UPDATE_DATE = p_lud,
3066: LAST_UPDATE_LOGIN = g_current_login_id
3067: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type

Line 3092: UPDATE FND_DESCR_FLEX_CONTEXTS_TL

3088:
3089: END IF;
3090:
3091: -- We update the TL information whether or not we're in NLS mode
3092: UPDATE FND_DESCR_FLEX_CONTEXTS_TL
3093: SET DESCRIPTION = p_attr_group_desc,
3094: DESCRIPTIVE_FLEX_CONTEXT_NAME = p_display_name,
3095: LAST_UPDATE_DATE = p_lud,
3096: LAST_UPDATED_BY = NVL(p_owner, g_current_user_id),

Line 3251: FROM FND_DESCR_FLEX_CONTEXTS_TL

3247: x_return_status := FND_API.G_RET_STS_ERROR;
3248:
3249: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
3250: INTO l_attr_group_disp_name
3251: FROM FND_DESCR_FLEX_CONTEXTS_TL
3252: WHERE APPLICATION_ID = p_application_id
3253: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
3254: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
3255: AND LANGUAGE = USERENV('LANG');

Line 5567: l_attr_group_disp_name FND_DESCR_FLEX_CONTEXTS_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;

5563: ROLLBACK TO Create_Attribute_PUB;
5564: END IF;
5565:
5566: DECLARE
5567: l_attr_group_disp_name FND_DESCR_FLEX_CONTEXTS_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;
5568: BEGIN
5569: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
5570: INTO l_attr_group_disp_name
5571: FROM FND_DESCR_FLEX_CONTEXTS_TL

Line 5571: FROM FND_DESCR_FLEX_CONTEXTS_TL

5567: l_attr_group_disp_name FND_DESCR_FLEX_CONTEXTS_TL.DESCRIPTIVE_FLEX_CONTEXT_NAME%TYPE;
5568: BEGIN
5569: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
5570: INTO l_attr_group_disp_name
5571: FROM FND_DESCR_FLEX_CONTEXTS_TL
5572: WHERE APPLICATION_ID = p_application_id
5573: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5574: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5575: AND LANGUAGE = USERENV('LANG');

Line 6142: FROM FND_DESCR_FLEX_CONTEXTS_TL

6138:
6139: l_token_table(2).TOKEN_NAME := 'ATTR_GRP_NAME';
6140: SELECT DESCRIPTIVE_FLEX_CONTEXT_NAME
6141: INTO l_token_table(2).TOKEN_VALUE
6142: FROM FND_DESCR_FLEX_CONTEXTS_TL
6143: WHERE APPLICATION_ID = p_application_id
6144: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6145: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
6146: AND LANGUAGE = USERENV('LANG');