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.8.12020000.4 2013/01/02 18:56:51 smanna ship $ */
3:
4:
5: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

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

117: END IF;
118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.delete_Orphaned_Nodes',SQLERRM );
122: raise;
123: END;
124:
125: DECLARE

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

156: END LOOP;
157: ClOSE C1;
158: EXCEPTION
159: WHEN OTHERS THEN
160: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.delete_Orphaned_Nodes',SQLERRM );
161: raise;
162: END;
163:
164: CZ_BASE_MGR.exec('CZ_PS_NODES','WHERE NOT EXISTS '||

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

406: begin
407: execute immediate 'drop view '||i.view_name;
408: exception
409: when others then
410: CZ_BASE_MGR.LOG_REPORT('CZ_PS_MGR.Purge','View "'||i.view_name||'" error :'||SQLERRM );
411: end;
412: end loop;
413:
414: --