[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;