APPS.AMS_IBA_PS_FILTERS_PKG dependencies on AMS_IBA_PS_FILTERS_B

Line 17: insert into AMS_IBA_PS_FILTERS_B (

13: P_LAST_UPDATED_BY in NUMBER,
14: P_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: begin
17: insert into AMS_IBA_PS_FILTERS_B (
18: OBJECT_VERSION_NUMBER,
19: FILTER_ID,
20: FILTER_REF_CODE,
21: CONTENT_TYPE,

Line 86: from AMS_IBA_PS_FILTERS_B

82: OBJECT_VERSION_NUMBER,
83: FILTER_REF_CODE,
84: CONTENT_TYPE,
85: GROUP_NUM
86: from AMS_IBA_PS_FILTERS_B
87: where FILTER_ID = X_FILTER_ID
88: for update of FILTER_ID nowait;
89: recinfo c%rowtype;
90:

Line 149: update AMS_IBA_PS_FILTERS_B set

145: P_LAST_UPDATED_BY in NUMBER,
146: P_LAST_UPDATE_LOGIN in NUMBER
147: ) is
148: begin
149: update AMS_IBA_PS_FILTERS_B set
150: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
151: FILTER_REF_CODE = P_FILTER_REF_CODE,
152: CONTENT_TYPE = P_CONTENT_TYPE,
153: GROUP_NUM = P_GROUP_NUM,

Line 189: delete from AMS_IBA_PS_FILTERS_B

185: if (sql%notfound) then
186: raise no_data_found;
187: end if;
188:
189: delete from AMS_IBA_PS_FILTERS_B
190: where FILTER_ID = P_FILTER_ID;
191:
192: if (sql%notfound) then
193: raise no_data_found;

Line 203: from AMS_IBA_PS_FILTERS_B B

199: begin
200: delete from AMS_IBA_PS_FILTERS_TL T
201: where not exists
202: (select NULL
203: from AMS_IBA_PS_FILTERS_B B
204: where B.FILTER_ID = T.FILTER_ID
205: );
206:
207: update AMS_IBA_PS_FILTERS_TL T set (

Line 294: from ams_iba_ps_filters_b

290: l_filter_id number;
291:
292: cursor c_obj_verno is
293: select object_version_number
294: from ams_iba_ps_filters_b
295: where filter_id = x_filter_id;
296:
297: cursor c_chk_filter_exists is
298: select 'x'

Line 299: from ams_iba_ps_filters_b

295: where filter_id = x_filter_id;
296:
297: cursor c_chk_filter_exists is
298: select 'x'
299: from ams_iba_ps_filters_b
300: where filter_id = x_filter_id;
301:
302: cursor c_get_filter_id is
303: select ams_iba_ps_filters_b_s.nextval

Line 303: select ams_iba_ps_filters_b_s.nextval

299: from ams_iba_ps_filters_b
300: where filter_id = x_filter_id;
301:
302: cursor c_get_filter_id is
303: select ams_iba_ps_filters_b_s.nextval
304: from dual;
305: BEGIN
306: if X_OWNER = 'SEED' then
307: l_user_id := 1;