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; */
103: BULK COLLECT
104: INTO requiredModelTbl
105: FROM cz_model_ref_expls
106: WHERE deleted_flag = '0'
107: AND model_id IN (SELECT model_id FROM cz_model_publications
108: WHERE source_target_flag = 'T'
109: AND deleted_flag = '0')
110: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id
111: ORDER BY component_id;
282: PURGE_RP_ENTRIES;
283: CZ_BASE_MGR.PURGE('PB');
284:
285: delete from cz_pb_client_apps a
286: where not exists ( select null from cz_model_publications b
287: where b.publication_id = a.publication_id );
288: commit;
289:
290: delete from cz_pb_languages a
287: where b.publication_id = a.publication_id );
288: commit;
289:
290: delete from cz_pb_languages a
291: where not exists ( select null from cz_model_publications b
292: where b.publication_id = a.publication_id );
293: commit;
294:
295: delete from cz_publication_usages a
292: where b.publication_id = a.publication_id );
293: commit;
294:
295: delete from cz_publication_usages a
296: where not exists ( select null from cz_model_publications b
297: where b.publication_id = a.publication_id );
298: commit;
299:
300: --