DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 9352: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V

9348: -- SSARNOBA: Why do we have this SELECT INTO statement? We're not using
9349: -- l_variant_exist_count anywhere.
9350: SELECT COUNT(*)
9351: INTO l_variant_exist_count
9352: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V
9353: WHERE OBJECT_ID = p_object_id
9354: AND CLASSIFICATION_CODE = p_classification_code
9355: AND VARIANT = 'Y'
9356: AND EXISTS (SELECT 'X'

Line 10024: l_association_row EGO_OBJ_ATTR_GRP_ASSOCS_V%ROWTYPE;

10020: INDEX BY BINARY_INTEGER;
10021:
10022: l_dummy_rec LOCAL_DEL_ASSOC_CHECK_REC;
10023: l_del_assoc_table LOCAL_DEL_ASSOC_CHECK_TABLE;
10024: l_association_row EGO_OBJ_ATTR_GRP_ASSOCS_V%ROWTYPE;
10025: l_del_assoc_check_index NUMBER;
10026: l_is_ok_to_delete BOOLEAN := TRUE;
10027: l_api_to_call VARCHAR2(999);
10028:

Line 10031: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V

10027: l_api_to_call VARCHAR2(999);
10028:
10029: CURSOR get_assoc_records (cp_association_id IN NUMBER) IS
10030: SELECT *
10031: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V
10032: WHERE (object_id, classification_code, attr_group_id) IN
10033: (SELECT object_id, classification_code, attr_group_id
10034: FROM ego_obj_ag_assocs_b
10035: where association_id = cp_association_id);

Line 10842: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

10838: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
10839: INTO l_ag_disp_name
10840: ,l_page_disp_name
10841: ,l_class_meaning
10842: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,
10843: EGO_PAGE_ENTRIES_V PE
10844: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
10845: AND PE.PAGE_ID = p_page_id
10846: AND PE.ASSOCIATION_ID = p_association_id;

Line 10969: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,

10965: ,EGO_EXT_FWK_PUB.Get_Class_Meaning(A.OBJECT_ID, PE.CLASSIFICATION_CODE)
10966: INTO l_ag_disp_name
10967: ,l_page_disp_name
10968: ,l_class_meaning
10969: FROM EGO_OBJ_ATTR_GRP_ASSOCS_V A,
10970: EGO_PAGE_ENTRIES_V PE
10971: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
10972: AND PE.PAGE_ID = p_page_id
10973: AND PE.ASSOCIATION_ID = p_new_association_id;

Line 15701: FROM ego_obj_attr_grp_assocs_v

15697: FROM EGO_ACTIONS_V EAV, FND_FORM_FUNCTIONS FFF
15698: WHERE EAV.SECURITY_PRIVILEGE_ID = FFF.FUNCTION_ID(+)
15699: AND classification_code IN
15700: (SELECT classification_code
15701: FROM ego_obj_attr_grp_assocs_v
15702: WHERE attr_group_id = EAV.ATTR_GROUP_ID)) QRSLT
15703: WHERE ACTION_ID = v_action_id
15704: ORDER BY FUNCTION_ID ASC;
15705: