DBA Data[Home] [Help]

APPS.CZ_PS_MGR dependencies on CZ_PS_MGR

Line 1: package body CZ_PS_MGR as

1: package body CZ_PS_MGR as
2: /* $Header: czpsmgrb.pls 120.4 2006/06/29 16:06:59 skudryav ship $ */
3:
4:
5: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 115: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.delete_Orphaned_Nodes',SQLERRM );

111: END IF;
112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.delete_Orphaned_Nodes',SQLERRM );
116: raise;
117: END;
118:
119: DECLARE

Line 152: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.delete_Orphaned_Nodes',SQLERRM );

148: END LOOP;
149: ClOSE C1;
150: EXCEPTION
151: WHEN OTHERS THEN
152: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.delete_Orphaned_Nodes',SQLERRM );
153: raise;
154: END;
155:
156: CZ_BASE_MGR.exec('CZ_PS_NODES','WHERE NOT EXISTS '||

Line 344: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.Purge','View "'||i.view_name||'" error :'||SQLERRM );

340: begin
341: execute immediate 'drop view '||i.view_name;
342: exception
343: when others then
344: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.Purge','View "'||i.view_name||'" error :'||SQLERRM );
345: end;
346: end loop;
347:
348: --