APPS.CZ_PUB_MGR dependencies on CZ_BASE_MGR

Line 18: CZ_BASE_MGR.REDO_STATISTICS('PB');

14: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
15:
16: procedure REDO_STATISTICS is
17: begin
18: CZ_BASE_MGR.REDO_STATISTICS('PB');
19: end;
20:
21: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
22: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 27: CZ_BASE_MGR.TRIGGERS_ENABLED('PB',Switch);

23:
24: procedure TRIGGERS_ENABLED
25: (Switch in varchar2) is
26: begin
27: CZ_BASE_MGR.TRIGGERS_ENABLED('PB',Switch);
28: end;
29:
30: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
31: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 36: CZ_BASE_MGR.CONSTRAINTS_ENABLED('PB',Switch);

32:
33: procedure CONSTRAINTS_ENABLED
34: (Switch in varchar2) is
35: begin
36: CZ_BASE_MGR.CONSTRAINTS_ENABLED('PB',Switch);
37: end;
38:
39: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
40: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 46: CZ_BASE_MGR.REDO_SEQUENCES('PB',RedoStart_Flag,incr);

42: procedure REDO_SEQUENCES
43: (RedoStart_Flag in varchar2,
44: incr in integer default null) is
45: begin
46: CZ_BASE_MGR.REDO_SEQUENCES('PB',RedoStart_Flag,incr);
47: end;
48:
49: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
50: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 141: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG',vModelKeyStr, 'Tracking Deleted Projects',0,1);

137: /*SKM: Added Loggin for deleted models / Product Key*/
138: /* Length of the db_logs is 4000 Max and hence inserting little less than that*/
139: vModelKeyStr := vModelKeyStr||deletedPKey||' - '||deletedPubl||'<-->';
140: IF (LENGTH (vModelKeyStr) > 3900 ) THEN
141: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG',vModelKeyStr, 'Tracking Deleted Projects',0,1);
142: vModelKeyStr := NULL;
143: END IF;
144: COMMIT;
145: EXCEPTION WHEN OTHERS THEN

Line 151: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG',vModelKeyStr, 'Tracking Deleted Projects',0,1);

147: END;
148: END IF;
149: END LOOP;
150: --SKM: for the Remaining fetch < 3900 length insert after exit from loop.
151: CZ_BASE_MGR.WRITE_TO_DB_LOGS('CZ_PURGE_LOG',vModelKeyStr, 'Tracking Deleted Projects',0,1);
152: close cDeletedPublication;
153: EXCEPTION
154: WHEN OTHERS THEN
155: errbuf := cz_utils.get_text('CZ_PUB_MGR_ERR','ERR',SQLERRM);

Line 283: CZ_BASE_MGR.PURGE('PB');

279: procedure PURGE is
280: begin
281: Propogate_DeletedFlag;
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 );

Line 332: CZ_BASE_MGR.MODIFIED('PB',AS_OF);

328:
329: procedure MODIFIED
330: (AS_OF in OUT NOCOPY date) is
331: begin
332: CZ_BASE_MGR.MODIFIED('PB',AS_OF);
333: end;
334:
335: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
336: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/