DBA Data[Home] [Help]

APPS.IGS_CO_PROCESS dependencies on IBC_CITEMS_V

Line 138: CURSOR c_att_id(cp_itm_id ibc_citems_v.citem_id%TYPE) IS

134: l_group_type VARCHAR2(10);
135: l_static_group VARCHAR2(1);
136: lv_status VARCHAR2(1);
137:
138: CURSOR c_att_id(cp_itm_id ibc_citems_v.citem_id%TYPE) IS
139: SELECT attach_fid
140: FROM ibc_citems_v
141: WHERE CITEM_ID = cp_itm_id
142: AND language = USERENV('LANG');

Line 140: FROM ibc_citems_v

136: lv_status VARCHAR2(1);
137:
138: CURSOR c_att_id(cp_itm_id ibc_citems_v.citem_id%TYPE) IS
139: SELECT attach_fid
140: FROM ibc_citems_v
141: WHERE CITEM_ID = cp_itm_id
142: AND language = USERENV('LANG');
143: /*
144: CURSOR c_group_member(cp_group_id VARCHAR2) IS

Line 167: l_attach_fid ibc_citems_v.attach_fid%TYPE;

163: l_query_desc cur_query;*/
164: l_query_str VARCHAR2(32767);
165: l_person_id NUMBER;
166: l_and_con VARCHAR2(32767);
167: l_attach_fid ibc_citems_v.attach_fid%TYPE;
168: l_query_text VARCHAR2(32767);
169:
170: BEGIN
171: l_static_group := 'Y';