APPS.PO_UDA_TEMPLATES_UTIL dependencies on EGO_ATTR_GROUPS_V

Line 5615: FROM ego_attr_groups_v

5611:
5612: BEGIN
5613: SELECT attr_group_disp_name
5614: INTO l_attr_group_name
5615: FROM ego_attr_groups_v
5616: WHERE attr_group_id = c_get_usage_ctx_ag_unique_rec. attribute_group_id;
5617:
5618: SELECT descriptive_flex_context_name
5619: INTO l_usage_display_name

Line 5726: FROM ego_attr_groups_v

5722:
5723: --Get the dummy attribute group id
5724: SELECT attr_group_id
5725: INTO l_dummy_attr_grp_id
5726: FROM ego_attr_groups_v
5727: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5728: AND attr_group_name = (SELECT attr_group_name FROM ego_attr_groups_v WHERE attr_group_id = p_attr_group_id);
5729:
5730: -- Get the dummy attribute association id

Line 5728: AND attr_group_name = (SELECT attr_group_name FROM ego_attr_groups_v WHERE attr_group_id = p_attr_group_id);

5724: SELECT attr_group_id
5725: INTO l_dummy_attr_grp_id
5726: FROM ego_attr_groups_v
5727: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5728: AND attr_group_name = (SELECT attr_group_name FROM ego_attr_groups_v WHERE attr_group_id = p_attr_group_id);
5729:
5730: -- Get the dummy attribute association id
5731: SELECT EGO_ASSOCS_S.NEXTVAL
5732: INTO l_dummy_associaton_id

Line 5856: FROM ego_attr_groups_v

5852:
5853: --Get the dummy attr grp id
5854: SELECT attr_group_id
5855: INTO l_dummy_attr_grp_id
5856: FROM ego_attr_groups_v
5857: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5858: AND attr_group_name = (SELECT attr_group_name FROM ego_attr_groups_v WHERE attr_group_id = l_real_attr_grp_id);
5859:
5860: --Get the dummy classification code

Line 5858: AND attr_group_name = (SELECT attr_group_name FROM ego_attr_groups_v WHERE attr_group_id = l_real_attr_grp_id);

5854: SELECT attr_group_id
5855: INTO l_dummy_attr_grp_id
5856: FROM ego_attr_groups_v
5857: WHERE attr_group_type='PO_UDA_DUMMY_EXT_ATTRS'
5858: AND attr_group_name = (SELECT attr_group_name FROM ego_attr_groups_v WHERE attr_group_id = l_real_attr_grp_id);
5859:
5860: --Get the dummy classification code
5861: SELECT ptl.display_name || ', Rev ' || pt.revision
5862: INTO l_template_name