APPS.JTF_PREFAB_FILTERS_PKG dependencies on JTF_PREFAB_FILTERS_B

Line 20: cursor C is select ROWID from JTF_PREFAB_FILTERS_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from JTF_PREFAB_FILTERS_B
21: where FILTER_ID = X_FILTER_ID
22: ;
23: begin
24: insert into JTF_PREFAB_FILTERS_B (

Line 24: insert into JTF_PREFAB_FILTERS_B (

20: cursor C is select ROWID from JTF_PREFAB_FILTERS_B
21: where FILTER_ID = X_FILTER_ID
22: ;
23: begin
24: insert into JTF_PREFAB_FILTERS_B (
25: FILTER_ID,
26: OBJECT_VERSION_NUMBER,
27: -- SECURITY_GROUP_ID,
28: APPLICATION_ID,

Line 113: from JTF_PREFAB_FILTERS_B

109: FILTER_NAME,
110: FILTER_STRING,
111: EXCLUSION_FLAG,
112: ENABLED_FLAG
113: from JTF_PREFAB_FILTERS_B
114: where FILTER_ID = X_FILTER_ID
115: for update of FILTER_ID nowait;
116: recinfo c%rowtype;
117:

Line 178: update JTF_PREFAB_FILTERS_B set

174: X_LAST_UPDATED_BY in NUMBER,
175: X_LAST_UPDATE_LOGIN in NUMBER
176: ) is
177: begin
178: update JTF_PREFAB_FILTERS_B set
179: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
180: -- SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
181: APPLICATION_ID = X_APPLICATION_ID,
182: FILTER_NAME = X_FILTER_NAME,

Line 220: delete from JTF_PREFAB_FILTERS_B

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from JTF_PREFAB_FILTERS_B
221: where FILTER_ID = X_FILTER_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 234: from JTF_PREFAB_FILTERS_B B

230: begin
231: delete from JTF_PREFAB_FILTERS_TL T
232: where not exists
233: (select NULL
234: from JTF_PREFAB_FILTERS_B B
235: where B.FILTER_ID = T.FILTER_ID
236: );
237:
238: update JTF_PREFAB_FILTERS_TL T set (

Line 311: cursor c is select nvl(max(FILTER_ID), 0) from jtf_prefab_filters_b where FILTER_ID < 10000;

307: db_luby NUMBER;
308: db_ludate DATE;
309: l_filter_id NUMBER;
310:
311: cursor c is select nvl(max(FILTER_ID), 0) from jtf_prefab_filters_b where FILTER_ID < 10000;
312: l_pseudo_seq NUMBER := NULL;
313: begin
314:
315: if (X_OWNER = 'SEED') then

Line 326: FROM JTF_PREFAB_FILTERS_B

322:
323: begin
324: SELECT FILTER_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
325: INTO l_filter_id, db_luby, db_ludate
326: FROM JTF_PREFAB_FILTERS_B
327: WHERE APPLICATION_ID = X_APPLICATION_ID AND
328: FILTER_NAME = X_FILTER_NAME;
329:
330: -- **** Entry is there, check if it's legal to update ****

Line 405: FROM JTF_PREFAB_FILTERS_B b, JTF_PREFAB_FILTERS_TL tl

401:
402: begin
403: SELECT tl.FILTER_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
404: INTO l_filter_id, db_luby, db_ludate
405: FROM JTF_PREFAB_FILTERS_B b, JTF_PREFAB_FILTERS_TL tl
406: WHERE b.FILTER_ID = tl.FILTER_ID AND
407: b.APPLICATION_ID = X_APPLICATION_ID AND
408: b.FILTER_NAME = X_FILTER_NAME AND
409: tl.LANGUAGE = userenv('LANG');