APPS.JTF_PREFAB_CA_FILTERS_PKG dependencies on JTF_PREFAB_CA_FILTERS_B

Line 17: insert into JTF_PREFAB_CA_FILTERS_B (

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: begin
17: insert into JTF_PREFAB_CA_FILTERS_B (
18: CA_FILTER_NAME,
19: APPLICATION_ID,
20: -- SECURITY_GROUP_ID,
21: OBJECT_VERSION_NUMBER,

Line 86: from JTF_PREFAB_CA_FILTERS_B

82: CA_FILTER_NAME,
83: APPLICATION_ID,
84: SECURITY_GROUP_ID,
85: OBJECT_VERSION_NUMBER
86: from JTF_PREFAB_CA_FILTERS_B
87: where CA_FILTER_ID = X_CA_FILTER_ID
88: for update of CA_FILTER_ID nowait;
89: recinfo c%rowtype;
90:

Line 145: update JTF_PREFAB_CA_FILTERS_B set

141: X_LAST_UPDATED_BY in NUMBER,
142: X_LAST_UPDATE_LOGIN in NUMBER
143: ) is
144: begin
145: update JTF_PREFAB_CA_FILTERS_B set
146: CA_FILTER_NAME = X_CA_FILTER_NAME,
147: APPLICATION_ID = X_APPLICATION_ID,
148: -- SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
149: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 184: delete from JTF_PREFAB_CA_FILTERS_B

180: if (sql%notfound) then
181: raise no_data_found;
182: end if;
183:
184: delete from JTF_PREFAB_CA_FILTERS_B
185: where CA_FILTER_ID = X_CA_FILTER_ID;
186:
187: if (sql%notfound) then
188: raise no_data_found;

Line 198: from JTF_PREFAB_CA_FILTERS_B B

194: begin
195: delete from JTF_PREFAB_CA_FILTERS_TL T
196: where not exists
197: (select NULL
198: from JTF_PREFAB_CA_FILTERS_B B
199: where B.CA_FILTER_ID = T.CA_FILTER_ID
200: );
201:
202: update JTF_PREFAB_CA_FILTERS_TL T set (

Line 271: cursor c is select nvl(max(CA_FILTER_ID), 0) from jtf_prefab_ca_filters_b where CA_FILTER_ID < 10000;

267: db_ludate DATE;
268: l_ca_filter_id NUMBER;
269: l_host_app_id NUMBER;
270:
271: cursor c is select nvl(max(CA_FILTER_ID), 0) from jtf_prefab_ca_filters_b where CA_FILTER_ID < 10000;
272: cursor c_ha is select nvl(max(HA_FILTER_ID), 0) from jtf_prefab_ha_filters where HA_FILTER_ID < 10000;
273: l_pseudo_seq NUMBER := NULL;
274: l_pseudo_seq_ha NUMBER := NULL;
275:

Line 293: FROM JTF_PREFAB_CA_FILTERS_B

289:
290: begin
291: SELECT CA_FILTER_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
292: INTO l_ca_filter_id, db_luby, db_ludate
293: FROM JTF_PREFAB_CA_FILTERS_B
294: WHERE APPLICATION_ID = X_APPLICATION_ID AND
295: CA_FILTER_NAME = X_CA_FILTER_NAME;
296:
297: -- **** Entry is there, check if it's legal to update ****

Line 413: FROM JTF_PREFAB_CA_FILTERS_B b, JTF_PREFAB_CA_FILTERS_TL tl

409:
410: begin
411: SELECT tl.CA_FILTER_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
412: INTO l_ca_filter_id, db_luby, db_ludate
413: FROM JTF_PREFAB_CA_FILTERS_B b, JTF_PREFAB_CA_FILTERS_TL tl
414: WHERE b.CA_FILTER_ID = tl.CA_FILTER_ID AND
415: b.APPLICATION_ID = X_APPLICATION_ID AND
416: b.CA_FILTER_NAME = X_CA_FILTER_NAME AND
417: tl.LANGUAGE = userenv('LANG');

Line 470: FROM JTF_PREFAB_CA_FL_RESPS child, JTF_PREFAB_CA_FILTERS_B parent

466:
467: begin
468: SELECT child.LAST_UPDATED_BY, child.LAST_UPDATE_DATE
469: INTO db_luby, db_ludate
470: FROM JTF_PREFAB_CA_FL_RESPS child, JTF_PREFAB_CA_FILTERS_B parent
471: WHERE child.ca_filter_id = parent.ca_filter_id
472: AND parent.APPLICATION_ID = X_APPLICATION_ID
473: AND parent.CA_FILTER_NAME = X_CA_FILTER_NAME
474: AND child.RESPONSIBILITY_ID = X_RESPONSIBILITY_ID;

Line 498: FROM JTF_PREFAB_CA_FILTERS_B

494:
495: -- **** get ca_filter_id ***
496: SELECT CA_FILTER_ID
497: INTO l_ca_filter_id
498: FROM JTF_PREFAB_CA_FILTERS_B
499: WHERE APPLICATION_ID = X_APPLICATION_ID
500: AND CA_FILTER_NAME = X_CA_FILTER_NAME;
501:
502: INSERT INTO jtf_prefab_ca_fl_resps(ca_fl_resp_id,

Line 558: FROM JTF_PREFAB_CA_FL_LANGS child, JTF_PREFAB_CA_FILTERS_B parent

554:
555: begin
556: SELECT child.LAST_UPDATED_BY, child.LAST_UPDATE_DATE
557: INTO db_luby, db_ludate
558: FROM JTF_PREFAB_CA_FL_LANGS child, JTF_PREFAB_CA_FILTERS_B parent
559: WHERE child.ca_filter_id = parent.ca_filter_id
560: AND parent.APPLICATION_ID = X_APPLICATION_ID
561: AND parent.CA_FILTER_NAME = X_CA_FILTER_NAME
562: AND child.LANGUAGE_CODE = X_LANGUAGE_CODE;

Line 586: FROM JTF_PREFAB_CA_FILTERS_B

582:
583: -- **** get ca_filter_id ***
584: SELECT CA_FILTER_ID
585: INTO l_ca_filter_id
586: FROM JTF_PREFAB_CA_FILTERS_B
587: WHERE APPLICATION_ID = X_APPLICATION_ID
588: AND CA_FILTER_NAME = X_CA_FILTER_NAME;
589:
590: INSERT INTO jtf_prefab_ca_fl_langs(ca_fl_lang_id,