APPS.CZ_PUB_MGR dependencies on CZ_MODEL_PUBLICATIONS

Line 54: TYPE tPublTable IS TABLE OF CZ_MODEL_PUBLICATIONS.PUBLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

50: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
51:
52: procedure Propogate_DeletedFlag is
53:
54: TYPE tPublTable IS TABLE OF CZ_MODEL_PUBLICATIONS.PUBLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
55: TYPE tModelTable is table of cz_model_ref_expls.component_id%type index by binary_integer;
56: TYPE tModelTableIndexVC2 is table of cz_model_ref_expls.component_id%type index by VARCHAR2(15);
57:
58: /* requiredModelTbl tPublTable; */

Line 93: AND model_id IN (SELECT model_id FROM cz_model_publications

89: BULK COLLECT
90: INTO requiredModelTbl
91: FROM cz_model_ref_expls
92: WHERE deleted_flag = '0'
93: AND model_id IN (SELECT model_id FROM cz_model_publications
94: WHERE source_target_flag = 'T'
95: AND deleted_flag = '0')
96: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id
97: ORDER BY component_id;

Line 261: where not exists ( select null from cz_model_publications b

257: PURGE_RP_ENTRIES;
258: CZ_BASE_MGR.PURGE('PB');
259:
260: delete from cz_pb_client_apps a
261: where not exists ( select null from cz_model_publications b
262: where b.publication_id = a.publication_id );
263: commit;
264:
265: delete from cz_pb_languages a

Line 266: where not exists ( select null from cz_model_publications b

262: where b.publication_id = a.publication_id );
263: commit;
264:
265: delete from cz_pb_languages a
266: where not exists ( select null from cz_model_publications b
267: where b.publication_id = a.publication_id );
268: commit;
269:
270: delete from cz_publication_usages a

Line 271: where not exists ( select null from cz_model_publications b

267: where b.publication_id = a.publication_id );
268: commit;
269:
270: delete from cz_publication_usages a
271: where not exists ( select null from cz_model_publications b
272: where b.publication_id = a.publication_id );
273: commit;
274:
275: --