APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_IMPL_OPT_PKG

Line 157: if BIS_IMPL_OPT_PKG.get_impl_flag(l_report_rec.depend_object_name,'REPORT')='Y' then

153: l_impl_report:='N';
154: l_dummy:=0;
155: for l_report_rec in c_reports loop
156: l_dummy:=l_dummy+1;
157: if BIS_IMPL_OPT_PKG.get_impl_flag(l_report_rec.depend_object_name,'REPORT')='Y' then
158: l_impl_report:='Y';
159: exit;
160: end if;
161: end loop;

Line 441: if BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.object_name,l_obj_rec.object_type)='Y' then

437: l_dummy:=null;
438: l_counter:=0;
439: for l_obj_rec in c_objects loop
440: ----added for bug 4532066
441: if BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.object_name,l_obj_rec.object_type)='Y' then
442: l_temp_date:=null;
443: open c_obj_has_program(l_obj_rec.object_type, l_obj_rec.object_name,p_refresh_mode);
444: fetch c_obj_has_program into l_prog_flag;
445: if c_obj_has_program%notfound then

Line 607: and BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.depend_object_name,l_obj_rec.depend_object_type)='Y' )

603: -----it is possible that a table or MV is attached to page directly
604: for l_obj_rec in c_depend_objects loop
605: ---added for bug 4532066
606: if (l_obj_rec.depend_object_type='REPORT'
607: and BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.depend_object_name,l_obj_rec.depend_object_type)='Y' )
608: ---added for bug 4675702
609: ---The check is necessary. If none of the reports under a portlet is implement
610: --then the portlet should not affect page's date
611: OR (l_obj_rec.depend_object_type='PORTLET'

Line 612: and BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.depend_object_name,l_obj_rec.depend_object_type)='Y'

608: ---added for bug 4675702
609: ---The check is necessary. If none of the reports under a portlet is implement
610: --then the portlet should not affect page's date
611: OR (l_obj_rec.depend_object_type='PORTLET'
612: and BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.depend_object_name,l_obj_rec.depend_object_type)='Y'
613: and portlet_has_impl_report(l_obj_rec.depend_object_name)='Y') then
614:
615: l_temp_date:=get_last_refreshdate(l_obj_rec.depend_object_type,null,l_obj_rec.depend_object_name);
616:

Line 899: if l_object_rec.object_type='PORTLET' and BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='Y' and portlet_has_impl_report(l_object_rec.object_name)='N' then

895: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for reports/portlets in the request set===');
896: for l_object_rec in c_portlet_report_in_set(l_request_id_this) loop
897:
898: ---added for bug 4532066
899: if l_object_rec.object_type='PORTLET' and BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='Y' and portlet_has_impl_report(l_object_rec.object_name)='N' then
900: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' has no implemented reports. Not to update its date.');
901: else if BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='N' then
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

Line 901: else if BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='N' then

897:
898: ---added for bug 4532066
899: if l_object_rec.object_type='PORTLET' and BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='Y' and portlet_has_impl_report(l_object_rec.object_name)='N' then
900: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' has no implemented reports. Not to update its date.');
901: else if BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='N' then
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;

Line 1090: if BIS_IMPL_OPT_PKG.get_impl_flag(l_top_obj_name,l_top_obj_type)='N' then

1086: close c_page_name;
1087: end if;
1088:
1089: ---added for bug 4532066
1090: if BIS_IMPL_OPT_PKG.get_impl_flag(l_top_obj_name,l_top_obj_type)='N' then
1091: BIS_COLLECTION_UTILITIES.put_line(l_top_obj_type||' '||l_top_obj_name||' is not implemented. Not to update its date.');
1092:
1093: else
1094:

Line 1132: if BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_name,l_obj_type)='N' then

1128: fetch c_obj_with_program into l_obj_type, l_obj_name;
1129: exit when c_obj_with_program%NOTFOUND;
1130:
1131: ---added for bug 4532066
1132: if BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_name,l_obj_type)='N' then
1133: BIS_COLLECTION_UTILITIES.put_line(l_obj_type||' '||l_obj_name||' is not implemented. Not to update its date.');
1134: else
1135:
1136: