APPS.EGO_EXT_FWK_PUB dependencies on FND_DESCR_FLEX_CONTEXTS_TL

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 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 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');