DBA Data[Home] [Help]

APPS.BIS_BIA_STATS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 80

    select num_rows
    into l_num_rows
    from all_tables
    where owner=l_object_owner
    and table_name=l_object_log;
Line: 115

     bis_collection_utilities.put_line('Calling BIS_COLL_RS_HISTORY.insert_program_object_data ');
Line: 117

       BIS_COLL_RS_HISTORY.insert_program_object_data
                                     (x_request_id  => l_request_id,
                                     x_stage_req_id  =>null,
                                     x_object_name   =>objectname,
                                     x_object_type   =>objecttype,
                                     x_refresh_type  =>'ANALYZED',
                                     x_set_request_id =>l_root_request_id);
Line: 127

       BIS_COLL_RS_HISTORY.insert_program_object_data
                                     (x_request_id  => l_request_id,
                                     x_stage_req_id  =>null,
                                     x_object_name   =>l_object_log,
                                     x_object_type   =>'MV_LOG',
                                     x_refresh_type  =>'ANALYZED',
                                     x_set_request_id =>l_root_request_id);
Line: 136

     bis_collection_utilities.put_line('Called BIS_COLL_RS_HISTORY.insert_program_object_data');
Line: 139

       bis_collection_utilities.put_line('Error happened in BIS_COLL_RS_HISTORY.insert_program_object_data'||sqlcode||sqlerrm);