APPS.BSC_AW_LOAD_DIM dependencies on BSC_AW_LOAD_DIM

Line 1: package body BSC_AW_LOAD_DIM AS

1: package body BSC_AW_LOAD_DIM AS
2: /*$Header: BSCAWLDB.pls 120.11 2006/04/20 11:39 vsurendr noship $*/
3:
4: /*
5: the top procedure is called with a list of dim levels. from RSG, a list of dim levels affecting a kpi or base table

Line 125: l_process:='bsc_aw_load_dim.load_aw_dim('''||p_dim_list(i)||''','||i||','''||l_job_name||''','''||bsc_aw_utility.get_option_string||''');';

121: Begin
122: bsc_aw_utility.clean_up_jobs('all');
123: for i in 1..p_dim_list.count loop
124: l_job_name:='bsc_aw_job_dim_'||bsc_aw_utility.get_session_id||'_'||i;
125: l_process:='bsc_aw_load_dim.load_aw_dim('''||p_dim_list(i)||''','||i||','''||l_job_name||''','''||bsc_aw_utility.get_option_string||''');';
126: bsc_aw_utility.start_job(l_job_name,i,l_process,null);
127: end loop;
128: --wait (this will lock and wait)
129: bsc_aw_utility.wait_on_jobs(null,l_job_status);

Line 824: END BSC_AW_LOAD_DIM;

820: Exception when others then
821: null;
822: End;
823:
824: END BSC_AW_LOAD_DIM;