APPS.EGO_EXT_FWK_PUB dependencies on FND_DESCR_FLEX_CONTEXTS_TL

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