APPS.JTF_PREFAB_CA_FILTERS_PKG dependencies on JTF_PREFAB_CA_FL_RESPS

Line 316: DELETE FROM jtf_prefab_ca_fl_resps

312: X_LAST_UPDATED_BY => f_luby,
313: X_LAST_UPDATE_LOGIN => 0);
314:
315: -- **** delete all the child entries ****
316: DELETE FROM jtf_prefab_ca_fl_resps
317: WHERE ca_filter_id = l_ca_filter_id;
318:
319: DELETE FROM jtf_prefab_ca_fl_langs
320: WHERE ca_filter_id = l_ca_filter_id;

Line 455: cursor c is select nvl(max(CA_FL_RESP_ID), 0) from jtf_prefab_ca_fl_resps where CA_FL_RESP_ID < 10000;

451: db_luby NUMBER;
452: db_ludate DATE;
453: l_ca_filter_id NUMBER;
454:
455: cursor c is select nvl(max(CA_FL_RESP_ID), 0) from jtf_prefab_ca_fl_resps where CA_FL_RESP_ID < 10000;
456: l_pseudo_seq NUMBER := NULL;
457: begin
458:
459: if (X_OWNER = 'SEED') then

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 502: INSERT INTO jtf_prefab_ca_fl_resps(ca_fl_resp_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,
503: object_version_number,
504: created_by,
505: creation_date,
506: last_updated_by,