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 441: FROM EGO_FND_DSC_FLX_CTX_EXT

437: x_fnd_exists :='N';
438: END;
439: BEGIN
440: SELECT 'Y' INTO x_ego_exists
441: FROM EGO_FND_DSC_FLX_CTX_EXT
442: WHERE APPLICATION_ID = p_application_id
443: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
444: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name;
445: EXCEPTION

Line 888: FROM ego_fnd_dsc_flx_ctx_ext

884: , p_attr_grp_name OUT NOCOPY VARCHAR2
885: )IS
886: CURSOR get_attr_details IS
887: SELECT application_id , descriptive_flexfield_name ,descriptive_flex_context_code
888: FROM ego_fnd_dsc_flx_ctx_ext
889: WHERE attr_group_id = p_attr_group_id;
890: BEGIN
891: OPEN get_attr_details;
892: FETCH get_attr_details

Line 1033: DELETE FROM EGO_FND_DSC_FLX_CTX_EXT

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:
1033: DELETE FROM EGO_FND_DSC_FLX_CTX_EXT
1034: WHERE APPLICATION_ID = p_application_id
1035: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1036: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1037:

Line 1145: FROM EGO_FND_DSC_FLX_CTX_EXT

1141: BEGIN
1142:
1143: SELECT APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
1144: INTO l_application_id, l_attr_group_type, l_attr_group_name
1145: FROM EGO_FND_DSC_FLX_CTX_EXT
1146: WHERE ATTR_GROUP_ID = p_attr_group_id;
1147:
1148: RETURN EGO_VARCHAR_TBL_TYPE(TO_CHAR(l_application_id), l_attr_group_type, l_attr_group_name);
1149:

Line 1588: ,EGO_FND_DSC_FLX_CTX_EXT E

1584:
1585: SELECT F.FUNCTION_NAME
1586: INTO l_privilege_name
1587: FROM FND_FORM_FUNCTIONS F
1588: ,EGO_FND_DSC_FLX_CTX_EXT E
1589: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1590: AND E.VIEW_PRIVILEGE_ID = F.FUNCTION_ID;
1591:
1592: ELSIF (UPPER(p_which_priv_to_return) = 'EDIT') THEN

Line 1597: ,EGO_FND_DSC_FLX_CTX_EXT E

1593:
1594: SELECT F.FUNCTION_NAME
1595: INTO l_privilege_name
1596: FROM FND_FORM_FUNCTIONS F
1597: ,EGO_FND_DSC_FLX_CTX_EXT E
1598: WHERE E.ATTR_GROUP_ID = p_attr_group_id
1599: AND E.EDIT_PRIVILEGE_ID = F.FUNCTION_ID;
1600:
1601: END IF;

Line 1733: FROM EGO_FND_DSC_FLX_CTX_EXT

1729:
1730: BEGIN
1731:
1732: SELECT ATTR_GROUP_ID INTO l_attr_group_id
1733: FROM EGO_FND_DSC_FLX_CTX_EXT
1734: WHERE APPLICATION_ID = p_application_id
1735: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
1736: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name;
1737:

Line 1760: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

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

Line 2413: INSERT INTO EGO_FND_DSC_FLX_CTX_EXT

2409:
2410: IF (l_ego_exists <> 'Y' ) THEN
2411:
2412: SELECT EGO_ATTR_GROUPS_S.NEXTVAL INTO x_attr_group_id FROM DUAL;
2413: INSERT INTO EGO_FND_DSC_FLX_CTX_EXT
2414: (
2415: ATTR_GROUP_ID
2416: ,APPLICATION_ID
2417: ,DESCRIPTIVE_FLEXFIELD_NAME

Line 3157: UPDATE EGO_FND_DSC_FLX_CTX_EXT

3153: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
3154: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name
3155: AND APPLICATION_ID = p_application_id;
3156:
3157: UPDATE EGO_FND_DSC_FLX_CTX_EXT
3158: SET MULTI_ROW = nvl(p_multi_row_attrib_group, MULTI_ROW),
3159: VARIANT = nvl(p_variant_attrib_group, VARIANT),
3160: NUM_OF_COLS = l_num_of_cols,
3161: NUM_OF_ROWS = l_num_of_rows,

Line 4069: ,EGO_FND_DSC_FLX_CTX_EXT EXT

4065: ,NVL(FLX_EXT.APPLICATION_VL_NAME, FLX.APPLICATION_TABLE_NAME)
4066: INTO l_attr_group_id
4067: ,l_ext_table_vl_name
4068: FROM EGO_OBJECT_EXT_TABLES_B OBJ
4069: ,EGO_FND_DSC_FLX_CTX_EXT EXT
4070: ,FND_DESCRIPTIVE_FLEXS FLX
4071: ,EGO_FND_DESC_FLEXS_EXT FLX_EXT
4072: WHERE OBJ.EXT_TABLE_NAME = FLX.APPLICATION_TABLE_NAME
4073: AND FLX.APPLICATION_ID = l_application_id

Line 4150: ,EGO_FND_DSC_FLX_CTX_EXT EXT

4146: ,l_attr_group_id
4147: ,l_ext_table_vl_name
4148: ,l_tl_table_exists
4149: FROM EGO_OBJECT_EXT_TABLES_B OBJ
4150: ,EGO_FND_DSC_FLX_CTX_EXT EXT
4151: ,FND_DESCRIPTIVE_FLEXS FLX
4152: ,EGO_FND_DESC_FLEXS_EXT FLX_EXT
4153: WHERE OBJ.EXT_TABLE_NAME = FLX.APPLICATION_TABLE_NAME
4154: AND FLX.APPLICATION_ID = p_application_id

Line 4635: FROM ego_fnd_dsc_flx_ctx_ext

4631: BEGIN
4632: IF p_attr_group_id IS NULL THEN
4633: SELECT attr_group_id
4634: INTO l_attr_group_id
4635: FROM ego_fnd_dsc_flx_ctx_ext
4636: WHERE application_id = p_application_id
4637: AND descriptive_flexfield_name = p_attr_group_type
4638: AND descriptive_flex_context_code = p_attr_group_name;
4639: ELSE

Line 4642: FROM ego_fnd_dsc_flx_ctx_ext

4638: AND descriptive_flex_context_code = p_attr_group_name;
4639: ELSE
4640: SELECT attr_group_id
4641: INTO l_attr_group_id
4642: FROM ego_fnd_dsc_flx_ctx_ext
4643: WHERE attr_group_id = p_attr_group_id;
4644: END IF;
4645: code_debug(l_api_name ||' Attr Group Id '||l_attr_group_id);
4646:

Line 5194: FROM EGO_FND_DSC_FLX_CTX_EXT

5190: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
5191:
5192: SELECT MULTI_ROW
5193: INTO l_multi_row_flag
5194: FROM EGO_FND_DSC_FLX_CTX_EXT
5195: WHERE APPLICATION_ID = p_application_id
5196: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
5197: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
5198:

Line 6101: FROM EGO_FND_DSC_FLX_CTX_EXT

6097: OR p_display =EGO_EXT_FWK_PUB.G_RADIO_DISP_TYPE ) THEN --bugFix:5292226
6098:
6099: SELECT MULTI_ROW
6100: INTO l_multi_row_flag
6101: FROM EGO_FND_DSC_FLX_CTX_EXT
6102: WHERE APPLICATION_ID = p_application_id
6103: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type
6104: AND DESCRIPTIVE_FLEX_CONTEXT_Code = p_attr_group_name;
6105:

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

14794: -- Start OF comments
14795: -- API name : Update_AGV_Name
14796: -- TYPE : Public
14797: -- Pre-reqs : None
14798: -- FUNCTION : Update Table 'ego_fnd_dsc_flx_ctx_ext'
14799: -- for attribute View Name
14800: -- Version: Current Version 1.0
14801: -- Previous Version : None
14802: --

Line 14816: FROM ego_fnd_dsc_flx_ctx_ext

14812: ,cp_attr_group_type IN VARCHAR2
14813: ,cp_attr_group_name IN VARCHAR2
14814: ) IS
14815: SELECT agv_name
14816: FROM ego_fnd_dsc_flx_ctx_ext
14817: WHERE agv_name = cp_agv_name
14818: AND attr_group_id NOT IN
14819: (select attr_group_id
14820: from ego_fnd_dsc_flx_ctx_ext

Line 14820: from ego_fnd_dsc_flx_ctx_ext

14816: FROM ego_fnd_dsc_flx_ctx_ext
14817: WHERE agv_name = cp_agv_name
14818: AND attr_group_id NOT IN
14819: (select attr_group_id
14820: from ego_fnd_dsc_flx_ctx_ext
14821: where agv_name = cp_agv_name
14822: AND application_id = cp_application_id
14823: AND descriptive_flexfield_name = cp_attr_group_type
14824: AND descriptive_flex_context_code = cp_attr_group_name

Line 14837: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;

14833: l_api_version CONSTANT NUMBER := 1.0 ;
14834: l_api_name CONSTANT VARCHAR (30) := 'Update_AGV_Name' ;
14835:
14836: l_dynamic_sql VARCHAR2(100);
14837: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
14838: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
14839:
14840: BEGIN
14841: -- Standard Start of API savepoint

Line 14838: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;

14834: l_api_name CONSTANT VARCHAR (30) := 'Update_AGV_Name' ;
14835:
14836: l_dynamic_sql VARCHAR2(100);
14837: l_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
14838: l_temp_agv_name ego_fnd_dsc_flx_ctx_ext.agv_name%TYPE;
14839:
14840: BEGIN
14841: -- Standard Start of API savepoint
14842: IF FND_API.To_Boolean( p_commit ) THEN

Line 14916: -- UPDATE ego_fnd_dsc_flx_ctx_ext

14912: -- As the method is called in validate, we should not update
14913: --
14914: -- -- Insert Attribute Group View name for the corresponding
14915: -- -- Attribute Group
14916: -- UPDATE ego_fnd_dsc_flx_ctx_ext
14917: -- SET agv_name = l_agv_name,
14918: -- last_updated_by = FND_GLOBAL.user_id,
14919: -- last_update_date = SYSDATE,
14920: -- last_update_login = FND_GLOBAL.login_id

Line 16222: -- IF NOT PRESENT UPDATE AGV_NAME IN EGO_FND_DSC_FLX_CTX_EXT WITH NULL

16218:
16219:
16220: ------------------------------------------------------------------------------------------
16221: -- METHOD :METHOD TO CHECK FOR VIEW IS PRESENT OR NOT,
16222: -- IF NOT PRESENT UPDATE AGV_NAME IN EGO_FND_DSC_FLX_CTX_EXT WITH NULL
16223: -- PARAMETER : ATTRIBUTE GROUP ID
16224: ------------------------------------------------------------------------------------------
16225:
16226: PROCEDURE Check_Attr_Group_View(p_attr_grp_id IN NUMBER)

Line 16234: FROM EGO_FND_DSC_FLX_CTX_EXT

16230: view_name VARCHAR2(30) ;
16231:
16232: CURSOR csr1 IS
16233: SELECT AGV_NAME
16234: FROM EGO_FND_DSC_FLX_CTX_EXT
16235: WHERE attr_group_id = p_attr_grp_id ;
16236:
16237: CURSOR csr2 IS
16238: SELECT object_name

Line 16245: FROM EGO_FND_DSC_FLX_CTX_EXT

16241: AND UPPER(object_type)='VIEW';
16242:
16243: CURSOR csr3 iS
16244: SELECT AGV_NAME
16245: FROM EGO_FND_DSC_FLX_CTX_EXT
16246: WHERE UPPER(agv_name) LIKE view_name ;
16247:
16248: BEGIN
16249: OPEN csr1;

Line 16263: UPDATE EGO_FND_DSC_FLX_CTX_EXT SET AGV_NAME = NULL WHERE Upper(AGV_NAME) = atg_view_name ;

16259:
16260:
16261: IF csr3%FOUND THEN
16262:
16263: UPDATE EGO_FND_DSC_FLX_CTX_EXT SET AGV_NAME = NULL WHERE Upper(AGV_NAME) = atg_view_name ;
16264: COMMIT ;
16265:
16266: END IF;
16267: CLOSE csr3;