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.

APPS.EGO_EXT_FWK_PUB dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 405: FROM EGO_FND_DSC_FLX_CTX_EXT

401: x_fnd_exists :='N';
402: END;
403: BEGIN
404: SELECT 'Y' INTO x_ego_exists
405: FROM EGO_FND_DSC_FLX_CTX_EXT
406: WHERE APPLICATION_ID = p_application_id
407: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
408: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name;
409: EXCEPTION

Line 848: FROM ego_fnd_dsc_flx_ctx_ext

844: , p_attr_grp_name OUT NOCOPY VARCHAR2
845: )IS
846: CURSOR get_attr_details IS
847: SELECT application_id , descriptive_flexfield_name ,descriptive_flex_context_code
848: FROM ego_fnd_dsc_flx_ctx_ext
849: WHERE attr_group_id = p_attr_group_id;
850: BEGIN
851: OPEN get_attr_details;
852: FETCH get_attr_details

Line 993: DELETE FROM EGO_FND_DSC_FLX_CTX_EXT

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:
993: DELETE FROM EGO_FND_DSC_FLX_CTX_EXT
994: WHERE APPLICATION_ID = p_application_id
995: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
996: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
997:

Line 1105: FROM EGO_FND_DSC_FLX_CTX_EXT

1101: BEGIN
1102:
1103: SELECT APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
1104: INTO l_application_id, l_attr_group_type, l_attr_group_name
1105: FROM EGO_FND_DSC_FLX_CTX_EXT
1106: WHERE ATTR_GROUP_ID = p_attr_group_id;
1107:
1108: RETURN EGO_VARCHAR_TBL_TYPE(TO_CHAR(l_application_id), l_attr_group_type, l_attr_group_name);
1109:

Line 1530: ,EGO_FND_DSC_FLX_CTX_EXT E

1526:
1527: SELECT F.FUNCTION_NAME
1528: INTO l_privilege_name
1529: FROM FND_FORM_FUNCTIONS F
1530: ,EGO_FND_DSC_FLX_CTX_EXT E
1531: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1532: AND E.VIEW_PRIVILEGE_ID = F.FUNCTION_ID;
1533:
1534: ELSIF (UPPER(p_which_priv_to_return) = 'EDIT') THEN

Line 1539: ,EGO_FND_DSC_FLX_CTX_EXT E

1535:
1536: SELECT F.FUNCTION_NAME
1537: INTO l_privilege_name
1538: FROM FND_FORM_FUNCTIONS F
1539: ,EGO_FND_DSC_FLX_CTX_EXT E
1540: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1541: AND E.EDIT_PRIVILEGE_ID = F.FUNCTION_ID;
1542:
1543: END IF;

Line 1651: FROM EGO_FND_DSC_FLX_CTX_EXT

1647:
1648: BEGIN
1649:
1650: SELECT ATTR_GROUP_ID INTO l_attr_group_id
1651: FROM EGO_FND_DSC_FLX_CTX_EXT
1652: WHERE APPLICATION_ID = p_application_id
1653: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1654: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1655:

Line 1678: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

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
1682: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_CTX_TL.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 2328: INSERT INTO EGO_FND_DSC_FLX_CTX_EXT

2324: END IF;--l_fnd_exists = 'Y' Bug 4703510:END
2325:
2326: IF (l_ego_exists <> 'Y' ) THEN
2327: SELECT EGO_ATTR_GROUPS_S.NEXTVAL INTO x_attr_group_id FROM DUAL;
2328: INSERT INTO EGO_FND_DSC_FLX_CTX_EXT
2329: (
2330: ATTR_GROUP_ID
2331: ,APPLICATION_ID
2332: ,DESCRIPTIVE_FLEXFIELD_NAME

Line 3071: UPDATE EGO_FND_DSC_FLX_CTX_EXT

3067: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
3068: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name
3069: AND APPLICATION_ID = p_application_id;
3070:
3071: UPDATE EGO_FND_DSC_FLX_CTX_EXT
3072: SET MULTI_ROW = nvl(p_multi_row_attrib_group, MULTI_ROW),
3073: VARIANT = nvl(p_variant_attrib_group, VARIANT),
3074: NUM_OF_COLS = l_num_of_cols,
3075: NUM_OF_ROWS = l_num_of_rows,

Line 3955: ,EGO_FND_DSC_FLX_CTX_EXT EXT

3951: ,NVL(FLX_EXT.APPLICATION_VL_NAME, FLX.APPLICATION_TABLE_NAME)
3952: INTO l_attr_group_id
3953: ,l_ext_table_vl_name
3954: FROM EGO_OBJECT_EXT_TABLES_B OBJ
3955: ,EGO_FND_DSC_FLX_CTX_EXT EXT
3956: ,FND_DESCRIPTIVE_FLEXS FLX
3957: ,EGO_FND_DESC_FLEXS_EXT FLX_EXT
3958: WHERE OBJ.EXT_TABLE_NAME = FLX.APPLICATION_TABLE_NAME
3959: AND FLX.APPLICATION_ID = l_application_id

Line 4025: ,EGO_FND_DSC_FLX_CTX_EXT EXT

4021: ,l_attr_group_id
4022: ,l_ext_table_vl_name
4023: ,l_tl_table_exists
4024: FROM EGO_OBJECT_EXT_TABLES_B OBJ
4025: ,EGO_FND_DSC_FLX_CTX_EXT EXT
4026: ,FND_DESCRIPTIVE_FLEXS FLX
4027: ,EGO_FND_DESC_FLEXS_EXT FLX_EXT
4028: WHERE OBJ.EXT_TABLE_NAME = FLX.APPLICATION_TABLE_NAME
4029: AND FLX.APPLICATION_ID = p_application_id

Line 4504: FROM ego_fnd_dsc_flx_ctx_ext

4500: BEGIN
4501: IF p_attr_group_id IS NULL THEN
4502: SELECT attr_group_id
4503: INTO l_attr_group_id
4504: FROM ego_fnd_dsc_flx_ctx_ext
4505: WHERE application_id = p_application_id
4506: AND descriptive_flexfield_name = p_attr_group_type
4507: AND descriptive_flex_context_code = p_attr_group_name;
4508: ELSE

Line 4511: FROM ego_fnd_dsc_flx_ctx_ext

4507: AND descriptive_flex_context_code = p_attr_group_name;
4508: ELSE
4509: SELECT attr_group_id
4510: INTO l_attr_group_id
4511: FROM ego_fnd_dsc_flx_ctx_ext
4512: WHERE attr_group_id = p_attr_group_id;
4513: END IF;
4514: code_debug(l_api_name ||' Attr Group Id '||l_attr_group_id);
4515: EXCEPTION

Line 4986: FROM EGO_FND_DSC_FLX_CTX_EXT

4982: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
4983:
4984: SELECT MULTI_ROW
4985: INTO l_multi_row_flag
4986: FROM EGO_FND_DSC_FLX_CTX_EXT
4987: WHERE APPLICATION_ID = p_application_id
4988: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
4989: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
4990:

Line 5805: FROM EGO_FND_DSC_FLX_CTX_EXT

5801: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
5802:
5803: SELECT MULTI_ROW
5804: INTO l_multi_row_flag
5805: FROM EGO_FND_DSC_FLX_CTX_EXT
5806: WHERE APPLICATION_ID = p_application_id
5807: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5808: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
5809:

Line 13744: -- FUNCTION : Update Table 'ego_fnd_dsc_flx_ctx_ext'

13740: -- Start OF comments
13741: -- API name : Update_AGV_Name
13742: -- TYPE : Public
13743: -- Pre-reqs : None
13744: -- FUNCTION : Update Table 'ego_fnd_dsc_flx_ctx_ext'
13745: -- for attribute View Name
13746: -- Version: Current Version 1.0
13747: -- Previous Version : None
13748: --

Line 13757: FROM ego_fnd_dsc_flx_ctx_ext

13753: ,cp_attr_group_type IN VARCHAR2
13754: ,cp_attr_group_name IN VARCHAR2
13755: ) IS
13756: SELECT agv_name
13757: FROM ego_fnd_dsc_flx_ctx_ext
13758: WHERE agv_name = cp_agv_name
13759: AND attr_group_id NOT IN
13760: (select attr_group_id
13761: from ego_fnd_dsc_flx_ctx_ext

Line 13761: from ego_fnd_dsc_flx_ctx_ext

13757: FROM ego_fnd_dsc_flx_ctx_ext
13758: WHERE agv_name = cp_agv_name
13759: AND attr_group_id NOT IN
13760: (select attr_group_id
13761: from ego_fnd_dsc_flx_ctx_ext
13762: where agv_name = cp_agv_name
13763: AND application_id = cp_application_id
13764: AND descriptive_flexfield_name = cp_attr_group_type
13765: AND descriptive_flex_context_code = cp_attr_group_name

Line 13778: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;

13774: l_api_version CONSTANT NUMBER := 1.0 ;
13775: l_api_name CONSTANT VARCHAR (30) := 'Update_AGV_Name' ;
13776:
13777: l_dynamic_sql VARCHAR2(100);
13778: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
13779: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
13780:
13781: BEGIN
13782: -- Standard Start of API savepoint

Line 13779: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;

13775: l_api_name CONSTANT VARCHAR (30) := 'Update_AGV_Name' ;
13776:
13777: l_dynamic_sql VARCHAR2(100);
13778: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
13779: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
13780:
13781: BEGIN
13782: -- Standard Start of API savepoint
13783: IF FND_API.To_Boolean( p_commit ) THEN

Line 13846: -- UPDATE ego_fnd_dsc_flx_ctx_ext

13842: -- As the method is called in validate, we should not update
13843: --
13844: -- -- Insert Attribute Group View name for the corresponding
13845: -- -- Attribute Group
13846: -- UPDATE ego_fnd_dsc_flx_ctx_ext
13847: -- SET agv_name = l_agv_name,
13848: -- last_updated_by = FND_GLOBAL.user_id,
13849: -- last_update_date = SYSDATE,
13850: -- last_update_login = FND_GLOBAL.login_id