APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_ATTR_GROUP_DL

Line 6217: FROM EGO_ATTR_GROUP_DL

6213: FROM EGO_FND_DSC_FLX_CTX_EXT
6214: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID;*/
6215: SELECT COUNT(*)
6216: INTO l_dummy
6217: FROM EGO_ATTR_GROUP_DL
6218: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID
6219: AND DATA_LEVEL_ID = NVL(p_data_level_id,DATA_LEVEL_ID)
6220: AND RAISE_POST_EVENT = 'Y'; -- abedajna 6137035
6221: IF (l_dummy > 0) THEN

Line 6235: FROM EGO_ATTR_GROUP_DL

6231: FROM EGO_FND_DSC_FLX_CTX_EXT
6232: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID;*/
6233: SELECT COUNT(*)
6234: INTO l_dummy
6235: FROM EGO_ATTR_GROUP_DL
6236: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID
6237: AND DATA_LEVEL_ID = NVL(p_data_level_id,DATA_LEVEL_ID)
6238: AND RAISE_PRE_EVENT = 'Y'; --abedajna 6137035
6239: IF (l_dummy > 0) THEN

Line 10979: FROM ego_attr_group_dl agdl,

10975: p_data_level IN VARCHAR2) RETURN VARCHAR2 IS
10976:
10977: CURSOR c IS
10978: SELECT agdl.defaulting
10979: FROM ego_attr_group_dl agdl,
10980: ego_data_level_b dl
10981: WHERE agdl.attr_group_id = p_attr_group_id
10982: AND agdl.data_level_id = dl.data_level_id
10983: AND dl.data_level_name = p_data_level;

Line 10985: l_temp ego_attr_group_dl.defaulting%TYPE;

10981: WHERE agdl.attr_group_id = p_attr_group_id
10982: AND agdl.data_level_id = dl.data_level_id
10983: AND dl.data_level_name = p_data_level;
10984:
10985: l_temp ego_attr_group_dl.defaulting%TYPE;
10986:
10987: BEGIN
10988: OPEN c;
10989: FETCH c INTO l_temp;

Line 11032: l_defaulting ego_attr_group_dl.defaulting%TYPE;

11028: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
11029: l_organization_id mtl_system_items_b.organization_id%TYPE;
11030: l_style_item_flag mtl_system_items_b.style_item_flag%TYPE;
11031: l_style_item_id mtl_system_items_b.style_item_id%TYPE;
11032: l_defaulting ego_attr_group_dl.defaulting%TYPE;
11033:
11034: BEGIN
11035: Debug_msg('get_itmmgmt_pkcol: ' || ' Entering method');
11036: l_pk_column_name_value_pairs := p_pkcol_value_pairs;