1 PACKAGE hxc_archive_restore_utils AS
2 /* $Header: hxcarcresutl.pkh 120.4 2005/11/22 01:16:53 gkrishna noship $ */
3
4 g_error_count number;
5
6 TYPE t_tbb_id is TABLE of hxc_time_building_blocks.time_building_block_id%TYPE;
7
8
9 -------------------------------------------------------------------
10 -- for description about all the following functions and procedures
11 -- please refer the package body
12 -------------------------------------------------------------------
13
14 -- check_max_errors
15 FUNCTION check_max_errors(p_error_count IN NUMBER) RETURN BOOLEAN;
16
17 -- check_data_corruption
18 FUNCTION check_data_corruption(p_data_set_id IN NUMBER) RETURN BOOLEAN;
19
20 -- core_table_count_snapshot
21 PROCEDURE core_table_count_snapshot
22 (p_tbb_count OUT NOCOPY NUMBER,
23 p_tau_count OUT NOCOPY NUMBER,
24 p_ta_count OUT NOCOPY NUMBER,
25 p_td_count OUT NOCOPY NUMBER,
26 p_trans_count OUT NOCOPY NUMBER,
27 p_tal_count OUT NOCOPY NUMBER,
28 p_aps_count OUT NOCOPY NUMBER,
29 p_adl_count OUT NOCOPY NUMBER,
30 p_ld_count OUT NOCOPY NUMBER,
31 p_ts_count OUT NOCOPY NUMBER);
32
33 -- bkup table_count_snapshot
34 PROCEDURE bkup_table_count_snapshot
35 (p_tbb_ar_count OUT NOCOPY NUMBER,
36 p_tau_ar_count OUT NOCOPY NUMBER,
37 p_ta_ar_count OUT NOCOPY NUMBER,
38 p_td_ar_count OUT NOCOPY NUMBER,
39 p_trans_ar_count OUT NOCOPY NUMBER,
40 p_tal_ar_count OUT NOCOPY NUMBER,
41 p_adl_ar_count OUT NOCOPY NUMBER,
42 p_aps_ar_count OUT NOCOPY NUMBER);
43
44 -- chunk count
45 PROCEDURE count_chunk_check
46 (p_tc_ar_count IN NUMBER,
47 p_day_ar_count IN NUMBER,
48 p_detail_ar_count IN NUMBER,
49 p_app_period_ar_count IN NUMBER,
50 p_tau_ar_count IN NUMBER,
51 p_td_ar_count IN NUMBER,
52 p_trans_ar_count IN NUMBER,
53 p_tal_ar_count IN NUMBER,
54 p_adl_ar_count IN NUMBER,
55 p_app_period_sum_ar_count IN NUMBER,
56 p_tbb_count IN NUMBER,
57 p_app_period_count IN NUMBER,
58 p_tau_count IN NUMBER,
59 p_td_count IN NUMBER,
60 p_trans_count IN NUMBER,
61 p_tal_count IN NUMBER,
62 p_adl_count IN NUMBER,
63 p_app_period_sum_count IN NUMBER);
64
65 -- count check
66 PROCEDURE count_snapshot_check (p_tbb_count_1 IN NUMBER,
67 p_tau_count_1 IN NUMBER,
68 p_ta_count_1 IN NUMBER,
69 p_td_count_1 IN NUMBER,
70 p_trans_count_1 IN NUMBER,
71 p_tal_count_1 IN NUMBER,
72 p_aps_count_1 IN NUMBER,
73 p_adl_count_1 IN NUMBER,
74 p_ld_count_1 IN NUMBER,
75 p_ts_count_1 IN NUMBER,
76 p_tbb_ar_count_1 IN NUMBER,
77 p_tau_ar_count_1 IN NUMBER,
78 p_ta_ar_count_1 IN NUMBER,
79 p_td_ar_count_1 IN NUMBER,
80 p_trans_ar_count_1 IN NUMBER,
81 p_tal_ar_count_1 IN NUMBER,
82 p_adl_ar_count_1 IN NUMBER,
83 p_aps_ar_count_1 IN NUMBER,
84 p_tbb_count_2 IN NUMBER,
85 p_tau_count_2 IN NUMBER,
86 p_ta_count_2 IN NUMBER,
87 p_td_count_2 IN NUMBER,
88 p_trans_count_2 IN NUMBER,
89 p_tal_count_2 IN NUMBER,
90 p_aps_count_2 IN NUMBER,
91 p_adl_count_2 IN NUMBER,
92 p_ld_count_2 IN NUMBER,
93 p_ts_count_2 IN NUMBER,
94 p_tbb_ar_count_2 IN NUMBER,
95 p_tau_ar_count_2 IN NUMBER,
96 p_ta_ar_count_2 IN NUMBER,
97 p_td_ar_count_2 IN NUMBER,
98 p_trans_ar_count_2 IN NUMBER,
99 p_tal_ar_count_2 IN NUMBER,
100 p_adl_ar_count_2 IN NUMBER,
101 p_aps_ar_count_2 IN NUMBER,
102 retcode OUT NOCOPY NUMBER);
103
104 -- incompatibility_pg_running
105 FUNCTION incompatibility_pg_running
106 RETURN BOOLEAN;
107
108 --updating the wf_notification_attributes with Archival=Yes URL param
109 --while cancelling the notification via archival.
110 PROCEDURE upd_wf_notif_attributes(p_item_type IN VARCHAR2,
111 p_item_key in VARCHAR2);
112
113 END hxc_archive_restore_utils;