DBA Data[Home] [Help]

APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on EGO_ATTR_GROUPS_V

Line 203: from ego_attr_groups_v

199:
200: --Cursor to check if attr group is multi row enabled
201: Cursor c_is_multi_row IS
202: select multi_row_code
203: from ego_attr_groups_v
204: where attr_group_id = p_attr_group_id;
205:
206: l_multi_row_code VARCHAR2(1) := 'N';
207:

Line 344: FROM ego_attr_groups_v

340: ,p_attr_group_type IN VARCHAR2
341: ,p_attr_group_name IN VARCHAR2)IS
342:
343: SELECT attr_group_id
344: FROM ego_attr_groups_v
345: WHERE application_id = p_attr_group_app_id
346: AND attr_group_type = p_attr_group_type
347: AND attr_group_name = p_attr_group_name;
348:

Line 1999: from ego_attr_groups_v

1995: Cursor c_get_attr_group_cur(p_attr_group_id IN NUMBER) IS
1996: select application_id,
1997: attr_group_type,
1998: attr_group_name
1999: from ego_attr_groups_v
2000: where attr_group_id = p_attr_group_id;
2001:
2002: BEGIN
2003:

Line 2106: from ego_attr_groups_v

2102: and attr_group_id = p_attr_group_id;
2103:
2104: Cursor c_is_multi_row IS
2105: select multi_row_code
2106: from ego_attr_groups_v
2107: where attr_group_id = p_attr_group_id;
2108:
2109: Cursor c_get_unique_key (p_application_id IN NUMBER,
2110: p_attr_group_name IN VARCHAR2,

Line 3021: from ego_attr_groups_v

3017: and attr_group_id = p_attr_group_id;
3018:
3019: Cursor c_is_multi_row IS
3020: select multi_row_code
3021: from ego_attr_groups_v
3022: where attr_group_id = p_attr_group_id;
3023:
3024: Cursor c_get_unique_key (p_application_id IN NUMBER,
3025: p_attr_group_name IN VARCHAR2,

Line 3953: from ego_attr_groups_v

3949: order by sequence;
3950:
3951: Cursor c_get_attr_group_disp_name(p_attr_group_id IN NUMBER) IS
3952: select ATTR_GROUP_DISP_NAME
3953: from ego_attr_groups_v
3954: where attr_group_id = p_attr_group_id;
3955:
3956: Cursor c_get_sr_pks(p_ext_id IN NUMBER)IS
3957: SELECT incident_id, context