1 PACKAGE hxc_data_set AUTHID CURRENT_USER as
2 /* $Header: hxcdataset.pkh 120.1 2005/10/04 05:38:20 sechandr noship $ */
3
4 --
5 -- validate_data_set_range function
6 --
7 FUNCTION validate_data_set_range
8 (p_data_set_name IN VARCHAR2,
9 p_start_date IN DATE,
10 p_stop_date IN DATE)
11 RETURN BOOLEAN;
12
13
14 --
15 -- show data set
16 --
17 PROCEDURE show_data_set;
18
19 --
20 -- insert into data set
21 --
22 PROCEDURE insert_into_data_set(p_data_set_id out NOCOPY number,
23 p_data_set_name in varchar2,
24 p_description in varchar2,
25 p_start_date in DATE,
26 p_stop_date in DATE,
27 p_status in varchar2);
28
29 --
30 -- Mark main tables with data set id
31 --
32 PROCEDURE mark_tables_with_data_set(p_data_set_id in number,
33 p_start_date in DATE,
34 p_stop_date in DATE);
35
36 --
37 -- Get data set information
38 --
39 PROCEDURE get_data_set_info(p_data_set_id IN NUMBER,
40 p_data_set_name OUT NOCOPY VARCHAR2,
41 p_description OUT NOCOPY VARCHAR2,
42 p_start_date OUT NOCOPY DATE,
43 p_stop_date OUT NOCOPY DATE,
44 p_data_set_mode OUT NOCOPY VARCHAR2,
45 p_status OUT NOCOPY VARCHAR2,
46 p_validation_status OUT NOCOPY VARCHAR2,
47 p_found_data_set OUT NOCOPY BOOLEAN);
48
49
50 --
51 -- Undo define Data Set
52 --
53 PROCEDURE undo_define_data_set(p_data_set_id IN NUMBER);
54
55 --
56 -- Validate Data Set
57 --
58 PROCEDURE validate_data_set (p_data_set_id in number,
59 p_error_count out NOCOPY number,
60 p_all_errors in boolean default FALSE);
61
62 --
63 -- Lock Data Set
64 --
65 PROCEDURE lock_data_set (p_data_set_id in number,
66 p_start_date in date,
67 p_stop_date in date,
68 p_data_set_lock out NOCOPY BOOLEAN);
69
70
71 --
72 -- Release Lock Data Set
73 --
74 PROCEDURE release_lock_data_set(p_data_set_id in number);
75
76
77 END hxc_data_set;