APPS.CZ_BASE_MGR dependencies on CZ_DB_SETTINGS

Line 480: select value from CZ_DB_SETTINGS

476: RedoStart_Flag in varchar2,
477: incr in integer default null) is
478:
479: cursor c0 is
480: select value from CZ_DB_SETTINGS
481: where setting_id='OracleSequenceIncr' and section_name='SCHEMA';
482: var_value integer;
483: var_incr varchar2(10);
484: Flag varchar2(1);

Line 528: LOG_REPORT(Proc_Name,'Wrong value OracleSequenceIncr in CZ_DB_SETTINGS. ');

524:
525:
526: exception
527: when WRONG_INCR then
528: LOG_REPORT(Proc_Name,'Wrong value OracleSequenceIncr in CZ_DB_SETTINGS. ');
529: when OTHERS then
530: LOG_REPORT(Proc_Name,SQLERRM);
531: end REDO_SEQUENCES;
532:

Line 606: select TO_NUMBER(VALUE) into CZ_BASE_MGR.BATCH_SIZE from CZ_DB_SETTINGS

602: begin
603: RECORD_COUNTER:=0;
604:
605: begin
606: select TO_NUMBER(VALUE) into CZ_BASE_MGR.BATCH_SIZE from CZ_DB_SETTINGS
607: where upper(setting_id)='BATCHSIZE';
608: exception
609: when no_data_found then
610: null;

Line 620: ,'CZ_DB_SETTINGS'

616: begin
617:
618: if Tables(i).name IN ( 'CZ_ATP_REQUESTS'
619: ,'CZ_DB_LOGS'
620: ,'CZ_DB_SETTINGS'
621: ,'CZ_DB_SIZES'
622: ,'CZ_DES_CHART_COLUMNS'
623: ,'CZ_EXP_TMP_LINES'
624: ,'CZ_LCE_TEXTS'

Line 953: Tables(2).name:='CZ_DB_SETTINGS';Tables(2).pk_name:=null;

949: end if;
950:
951: if upper(SubSchema)='GN' then
952: Tables(1).name:='CZ_DB_LOGS';Tables(1).pk_name:=null;
953: Tables(2).name:='CZ_DB_SETTINGS';Tables(2).pk_name:=null;
954: end if;
955:
956: if upper(SubSchema)='XF' then
957: --Tables(1).name:='CZ_XFR_PROJECT_BILLS'; Tables(1).pk_name:=null;