APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_IMPL_DEV_PKG

Line 658: where bis_impl_dev_pkg.get_function_by_page(object_name)=bis_impl_dev_pkg.get_function_by_page(p_page_name)

654: but it caused number of sqls being executed exceed 10
655: cursor c_direct_date is
656: select LAST_REFRESH_DATE
657: from bis_obj_properties
658: where bis_impl_dev_pkg.get_function_by_page(object_name)=bis_impl_dev_pkg.get_function_by_page(p_page_name)
659: and object_type='PAGE';
660: **/
661:
662: /**The following cursor has logic hole

Line 917: bis_impl_dev_pkg.update_obj_last_refresh_date(l_object_rec.object_type,l_object_rec.object_name, l_date);

913: else
914: l_date:=derive_portlet_report_date(l_object_rec.object_name,l_object_rec.object_type,l_refresh_mode);
915: end if;
916: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||'.'||l_object_rec.object_name||': '||to_char(l_date,'DD-MON-YYYY'));
917: bis_impl_dev_pkg.update_obj_last_refresh_date(l_object_rec.object_type,l_object_rec.object_name, l_date);
918:
919: commit;
920: end if;
921: end if;----implementation flag='N'

Line 935: bis_impl_dev_pkg.update_obj_last_refresh_date('PAGE',l_page_obj_rec.object_name,l_date);

931: for l_page_obj_rec in c_pages_in_set(l_request_id_this) loop
932: l_date:=null;
933: l_date:=derive_page_date(l_page_obj_rec.object_name);
934: BIS_COLLECTION_UTILITIES.put_line('*****'||l_page_obj_rec.object_type||'.'||l_page_obj_rec.object_name||': '||to_char(l_date,'DD-MON-YYYY'));
935: bis_impl_dev_pkg.update_obj_last_refresh_date('PAGE',l_page_obj_rec.object_name,l_date);
936: commit;
937: end loop;
938:
939:

Line 1018: where bis_impl_dev_pkg.get_function_by_page(object_name)=bis_impl_dev_pkg.get_function_by_page(p_name)

1014:
1015: cursor c_page_name(p_name varchar2) is
1016: select object_name
1017: from bis_obj_properties
1018: where bis_impl_dev_pkg.get_function_by_page(object_name)=bis_impl_dev_pkg.get_function_by_page(p_name)
1019: and object_type='PAGE';
1020:
1021: ----This cursor is added for bug 4257955
1022: ----Please note we don't check program refresh mode in this cursor

Line 1166: bis_impl_dev_pkg.update_obj_last_refresh_date(l_obj_type,l_obj_name, l_last_refresh_date);

1162: ------end bug 4257955
1163:
1164: end if; ---end if for bug 4451368
1165:
1166: bis_impl_dev_pkg.update_obj_last_refresh_date(l_obj_type,l_obj_name, l_last_refresh_date);
1167: BIS_COLLECTION_UTILITIES.put_line(' '||l_obj_type ||'.'||l_obj_name ||': ' || to_char(l_last_refresh_date,'DD-MON-YYYY'));
1168: end if;---implementation_flag ='N'
1169: end loop;
1170: close c_obj_with_program;