DBA Data[Home] [Help]

PACKAGE: APPS.BIV_DBI_COLLECTION_UTIL

Source


1 package biv_dbi_collection_util as
2 /* $Header: bivsrvcutls.pls 120.0 2005/05/30 05:32:37 appldev noship $ */
3 
4 function correct_bad_audit
5 ( x_error_message out nocopy varchar2 )
6 return number;
7 
8 function get_schema_name
9 ( x_schema_name   out nocopy varchar2
10 , x_error_message out nocopy varchar2 )
11 return number;
12 
13 function truncate_table
14 ( p_biv_schema    in varchar2
15 , p_table_name    in varchar2
16 , x_error_message out nocopy varchar2 )
17 return number;
18 
19 function gather_statistics
20 ( p_biv_schema    in varchar2
21 , p_table_name    in varchar2
22 , x_error_message out nocopy varchar2)
23 return number;
24 
25 procedure set_log_error
26 ( p_rowid             in rowid
27 , p_staging_error     in varchar2 default null
28 , p_activity_error    in varchar2 default null
29 , p_closed_error      in varchar2 default null
30 , p_backlog_error     in varchar2 default null
31 , p_resolution_error  in varchar2 default null
32 );
33 
34 procedure get_last_log
35 ( x_rowid             out nocopy rowid
36 , x_process_type      out nocopy varchar2
37 , x_collect_from_date out nocopy date
38 , x_collect_to_date   out nocopy date
39 , x_success_flag      out nocopy varchar2
40 , x_staging_flag      out nocopy varchar2
41 , x_activity_flag     out nocopy varchar2
42 , x_closed_flag       out nocopy varchar2
43 , x_backlog_flag      out nocopy varchar2
44 , x_resolution_flag   out nocopy varchar2
45 );
46 
47 function get_missing_owner_group_id
48 return number;
49 
50 function get_missing_inventory_item_id
51 return number;
52 
53 function get_missing_organization_id
54 return number;
55 
56 end biv_dbi_collection_util;