APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_CREATE_REQUESTSET

Line 274: and aa.argument1=to_char(bis_create_requestset.get_indicator_auto_gen(p_obj_name));

270: and aa.program_application_id=bb.application_id
271: and aa.concurrent_program_id=bb.concurrent_program_id
272: and aa.status_code in ('I','R','G','C')
273: and aa.phase_code='C'
274: and aa.argument1=to_char(bis_create_requestset.get_indicator_auto_gen(p_obj_name));
275:
276:
277: l_obj_latest_date date;
278: l_dummy varchar2(1);

Line 307: if p_obj_type='REPORT' and bis_create_requestset.get_report_type(p_obj_name)='BSCREPORT' then

303: fetch c_obj_latest_date into l_obj_latest_date;
304: close c_obj_latest_date;
305: end if;
306:
307: if p_obj_type='REPORT' and bis_create_requestset.get_report_type(p_obj_name)='BSCREPORT' then
308: open c_auto_gen_report_date;
309: fetch c_auto_gen_report_date into l_obj_latest_date;
310: close c_auto_gen_report_date;
311: end if;

Line 906: if l_object_rec.object_owner=bis_create_requestset.get_bsc_schema_name

902: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' is not implemented. Not to update its date.');
903: else
904: l_date:=null;
905: l_indicator:=null;
906: if l_object_rec.object_owner=bis_create_requestset.get_bsc_schema_name
907: and l_object_rec.object_type='REPORT'
908: and l_object_rec.object_name like 'BSC%' then
909: l_indicator:=bis_create_requestset.get_indicator(l_object_rec.object_name);
910: end if;

Line 909: l_indicator:=bis_create_requestset.get_indicator(l_object_rec.object_name);

905: l_indicator:=null;
906: if l_object_rec.object_owner=bis_create_requestset.get_bsc_schema_name
907: and l_object_rec.object_type='REPORT'
908: and l_object_rec.object_name like 'BSC%' then
909: l_indicator:=bis_create_requestset.get_indicator(l_object_rec.object_name);
910: end if;
911: if l_indicator is not null then
912: l_date:=get_kpi_refresh_date(l_indicator);
913: else

Line 1143: and (bis_create_requestset.get_indicator_auto_gen(l_obj_name) is null

1139: -----corresponding to the auto-gen report, then we should set the date to null for the report
1140: -----so that it doesn't affect the page date
1141: if l_obj_type='REPORT'
1142: and has_loader_sum_prog(l_obj_name)='Y'
1143: and (bis_create_requestset.get_indicator_auto_gen(l_obj_name) is null
1144: or bis_create_requestset.get_report_type(l_obj_name)<>'BSCREPORT') then
1145: l_last_refresh_date:=null;
1146:
1147: else

Line 1144: or bis_create_requestset.get_report_type(l_obj_name)<>'BSCREPORT') then

1140: -----so that it doesn't affect the page date
1141: if l_obj_type='REPORT'
1142: and has_loader_sum_prog(l_obj_name)='Y'
1143: and (bis_create_requestset.get_indicator_auto_gen(l_obj_name) is null
1144: or bis_create_requestset.get_report_type(l_obj_name)<>'BSCREPORT') then
1145: l_last_refresh_date:=null;
1146:
1147: else
1148: l_last_refresh_date:=get_obj_refresh_date_old(l_obj_type,null,l_obj_name);