1 PACKAGE HXT_RETRIEVAL_ROLLBACK AUTHID CURRENT_USER AS
2 /* $Header: hxtrollret.pkh 120.1.12020000.1 2012/07/06 11:31:45 asrajago noship $ */
3
4 TYPE NUMTAB IS TABLE OF NUMBER;
5 TYPE VARCHARTAB IS TABLE OF VARCHAR2(400);
6 TYPE DATETAB IS TABLE OF DATE;
7 TYPE NUMARRAY_INDEXCHAR IS TABLE OF NUMBER INDEX BY VARCHAR2(22);
8 TYPE VARCHARARRAY_INDEXCHAR IS TABLE OF VARCHAR2(400) INDEX BY VARCHAR2(22);
9
10
11 g_reversal_batches NUMARRAY_INDEXCHAR;
12 g_replacement_batches NUMARRAY_INDEXCHAR;
13 g_rev_batch_seq NUMARRAY_INDEXCHAR;
14 g_hours_iv_position NUMARRAY_INDEXCHAR;
15 g_cache VARCHAR2(5) := 'Y';
16 g_person_name VARCHARARRAY_INDEXCHAR;
17 g_element_name VARCHARARRAY_INDEXCHAR;
18 g_batch_name VARCHARARRAY_INDEXCHAR;
19 g_period_details VARCHARARRAY_INDEXCHAR;
20 g_payroll_name VARCHARARRAY_INDEXCHAR;
21 g_batch_status VARCHARARRAY_INDEXCHAR;
22 g_archive_status VARCHARARRAY_INDEXCHAR;
23 g_data_set_status VARCHARARRAY_INDEXCHAR;
24 g_all_rlbk_eligible VARCHARARRAY_INDEXCHAR;
25 g_rlbk_status VARCHAR2(10);
26 g_errored_tc NUMARRAY_INDEXCHAR;
27
28
29 PROCEDURE rollback_normal_batches(p_batch_id IN NUMBER,
30 p_batch_status IN VARCHAR2,
31 p_person_id IN NUMBER DEFAULT 0);
32
33 PROCEDURE rollback_retro_batches(p_batch_id IN NUMBER);
34
35
36 PROCEDURE put_log(p_text IN VARCHAR2 DEFAULT ' ',
37 p_cache IN VARCHAR2 DEFAULT 'N');
38
39 PROCEDURE rollback_bee(errbuff IN OUT NOCOPY VARCHAR2,
40 retcode IN OUT NOCOPY NUMBER,
41 p_bg_id IN NUMBER,
42 p_validate_mode IN VARCHAR2 DEFAULT 'VALIDATE',
43 p_from_batch IN NUMBER,
44 p_to_batch IN NUMBER DEFAULT NULL,
45 p_batch_reference IN VARCHAR2 DEFAULT NULL,
46 p_person_id IN NUMBER DEFAULT 0,
47 p_single IN VARCHAR2 DEFAULT NULL,
48 p_rollback_mode IN VARCHAR2 DEFAULT 'U'
49 );
50
51 PROCEDURE rollback_bee_retro(errbuff IN OUT NOCOPY VARCHAR2,
52 retcode IN OUT NOCOPY NUMBER,
53 p_bg_id IN NUMBER,
54 p_validate_mode IN VARCHAR2 DEFAULT 'VALIDATE',
55 p_from_batch IN NUMBER,
56 p_to_batch IN NUMBER DEFAULT NULL,
57 p_batch_reference IN VARCHAR2 DEFAULT NULL
58 );
59
60 PROCEDURE rollback_xfer_time_otlr(errbuff OUT NOCOPY VARCHAR2,
61 retcode OUT NOCOPY NUMBER,
62 p_bg_id IN NUMBER,
63 p_session_date IN VARCHAR2,
64 p_validate_mode IN VARCHAR2 DEFAULT 'VALIDATE',
65 p_payroll_id IN NUMBER,
66 p_time_period_id IN NUMBER,
67 p_gre_id IN NUMBER DEFAULT NULL,
68 p_organization_id IN NUMBER DEFAULT NULL,
69 p_location_id IN NUMBER DEFAULT NULL,
70 p_person_id IN NUMBER DEFAULT NULL,
71 p_batch_ref IN VARCHAR2 DEFAULT NULL,
72 p_batch_id IN NUMBER DEFAULT NULL,
73 p_batch_status IN VARCHAR2 DEFAULT 'U',
74 p_destination IN VARCHAR2 DEFAULT 'OTM',
75 p_is_timestore IN VARCHAR2 DEFAULT '0',
76 p_delete IN VARCHAR2 DEFAULT 'REPORT'
77 );
78
79
80 END HXT_RETRIEVAL_ROLLBACK;