APPS.CZ_BASE_MGR dependencies on CZ_DB_SETTINGS

Line 479: select value from CZ_DB_SETTINGS

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

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

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

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

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

Line 619: ,'CZ_DB_SETTINGS'

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

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

920: end if;
921:
922: if upper(SubSchema)='GN' then
923: Tables(1).name:='CZ_DB_LOGS';Tables(1).pk_name:=null;
924: Tables(2).name:='CZ_DB_SETTINGS';Tables(2).pk_name:=null;
925: end if;
926:
927: if upper(SubSchema)='XF' then
928: --Tables(1).name:='CZ_XFR_PROJECT_BILLS'; Tables(1).pk_name:=null;