DBA Data[Home] [Help]

APPS.BIS_CREATE_REQUESTSET dependencies on BIS_IMPL_OPT_PKG

Line 474: l_impl_flag:= BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.object_name,l_obj_rec.object_type);

470:
471: begin
472: ---added for bug 4610116
473: for l_obj_rec in c_objects_per_page loop
474: l_impl_flag:= BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_rec.object_name,l_obj_rec.object_type);
475: l_sql_stmt:='insert into BIS_BIA_RSG_IMPL_FLAG_TEMP(set_name,set_app,top_object_type,top_object_name,object_type,object_name,object_impl_flag)
476: values (:1,:2,:3,:4,:5,:6,:7)';
477: EXECUTE IMMEDIATE l_sql_stmt USING p_set_name,p_set_app,p_object_type,p_object_name,l_obj_rec.object_type ,l_obj_rec.object_name,l_impl_flag;
478: end loop;

Line 3708: BIS_IMPL_OPT_PKG.set_implflag_reports_in_set(p_request_set_code,l_req_set_appl_id);

3704: ------added for enhancement 3999465. But commented for 4422645
3705: ------ THis call can be removed if in the future we have UI
3706: ------for the user to set impl flag for reports
3707: BIS_COLLECTION_UTILITIES.put_line('Set implementation flag for reports directly included in this request set');
3708: BIS_IMPL_OPT_PKG.set_implflag_reports_in_set(p_request_set_code,l_req_set_appl_id);
3709: **/
3710:
3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';

Line 3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');

3707: BIS_COLLECTION_UTILITIES.put_line('Set implementation flag for reports directly included in this request set');
3708: BIS_IMPL_OPT_PKG.set_implflag_reports_in_set(p_request_set_code,l_req_set_appl_id);
3709: **/
3710:
3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';
3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);

Line 3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';

3708: BIS_IMPL_OPT_PKG.set_implflag_reports_in_set(p_request_set_code,l_req_set_appl_id);
3709: **/
3710:
3711: BIS_COLLECTION_UTILITIES.put_line('Invoking ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3712: l_stmt := 'BEGIN BIS_IMPL_OPT_PKG.setImplementationOptions(:errbuf, :retcode); END;';
3713: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
3714: DBMS_SQL.parse(l_cursor_id,l_stmt,DBMS_SQL.V7);
3715: DBMS_SQL.bind_variable(l_cursor_id,'errbuf',errbuf, 32767);
3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);

Line 3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');

3716: DBMS_SQL.bind_variable(l_cursor_id,'retcode',retcode, 200);
3717: l_rows:=DBMS_SQL.execute(l_cursor_id);
3718: DBMS_SQL.close_cursor(l_cursor_id);
3719:
3720: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BIS_IMPL_OPT_PKG.setImplementationOptions');
3721: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
3722:
3723: ---Added for bug 4532066
3724: check_unimpl_objects_is_sets(p_request_set_code);