APPS.BIS_INIT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

  select count(*) into sorc_records from dba_tables
  where owner = l_schema  --bug 3871867
  and table_name = 'EDW_LOCAL_INSTANCE';

Line: 51

	sql_stmt := 'select count(*) from edw_local_instance';

Line: 58

  select count(*) into wh_records from dba_tables
  where owner = l_schema    --bug 3871867
  and table_name = 'EDW_SOURCE_INSTANCES';

Line: 63

        sql_stmt := 'select count(*) from edw_source_instances';

Line: 94

        insert into edw_error_log
        (object_name, object_type, resp_id, message,
        last_update_date, last_updated_by, creation_date, created_by, last_update_login)
        values
        ('BIS_INIT.INITIALIZE', 'BIS/EDW Initialization Procedure', NULL,
	'Oracle error occured in edw_init.initialize procedure at step : '|| x_step
         || '. Errorcode is : ' || v_ErrorCode || ' and Errortext is : ' || v_ErrorText,
        sysdate, 0, sysdate, 0, 0);