1 PACKAGE HXC_RETRIEVAL_ROLLBACK AUTHID CURRENT_USER AS
2 /* $Header: hxcrollret.pkh 120.1.12020000.1 2012/07/06 11:29:05 asrajago noship $ */
3
4 TYPE NUMTAB IS TABLE OF NUMBER;
5 TYPE VARCHARTAB IS TABLE OF VARCHAR2(4000);
6 TYPE DATETAB IS TABLE OF DATE;
7
8 TYPE VARCHARARRAY_INDEXCHAR IS TABLE OF VARCHAR2(1000) INDEX BY VARCHAR2(50);
9 TYPE NUMARRAY_INDEXCHAR IS TABLE OF NUMBER INDEX BY VARCHAR2(50);
10
11 g_batches_to_process NUMTAB;
12 g_hours_iv_position NUMARRAY_INDEXCHAR;
13 g_reversal_batches NUMARRAY_INDEXCHAR;
14 g_rev_batch_seq NUMARRAY_INDEXCHAR;
15 g_tainted_timecards NUMARRAY_INDEXCHAR;
16 g_tainted_timecards2 NUMARRAY_INDEXCHAR;
17 g_person_name VARCHARARRAY_INDEXCHAR;
18 g_element_name VARCHARARRAY_INDEXCHAR;
19 g_batch_name VARCHARARRAY_INDEXCHAR;
20 g_otlr_status VARCHARARRAY_INDEXCHAR;
21 g_archive_status VARCHARARRAY_INDEXCHAR;
22 g_data_set_status VARCHARARRAY_INDEXCHAR;
23 g_batch_status VARCHARARRAY_INDEXCHAR;
24 g_all_rlbk_eligible VARCHARARRAY_INDEXCHAR;
25 g_ld_rlbk_eligible VARCHARARRAY_INDEXCHAR;
26 g_rlbk_status VARCHAR2(10);
27 g_errored_tc NUMARRAY_INDEXCHAR;
28
29
30 g_process_dependent_batches BOOLEAN;
31
32 PROCEDURE gather_snapshot(p_timecard_id IN NUMBER);
33
34
35
36 PROCEDURE rollback_xfer_time(errbuff OUT NOCOPY VARCHAR2,
37 retcode OUT NOCOPY NUMBER,
38 p_bg_id IN NUMBER,
39 p_session_date IN VARCHAR2,
40 p_validate_mode IN VARCHAR2 DEFAULT 'VALIDATE',
41 p_start_date IN VARCHAR2,
42 p_end_date IN VARCHAR2,
43 p_gre_id IN NUMBER DEFAULT NULL,
44 p_organization_id IN NUMBER DEFAULT NULL,
45 p_location_id IN NUMBER DEFAULT NULL,
46 p_payroll_id IN NUMBER DEFAULT NULL,
47 p_person_id IN NUMBER DEFAULT NULL,
48 p_rollback_mode IN VARCHAR2 DEFAULT 'LATEST',
49 p_is_latest IN VARCHAR2,
50 p_request_id IN NUMBER DEFAULT NULL,
51 p_retrieval_transaction_code IN VARCHAR2 DEFAULT NULL,
52 p_batch_id IN NUMBER DEFAULT NULL,
53 p_batch_ref IN VARCHAR2 DEFAULT NULL,
54 p_batch_specified IN VARCHAR2,
55 p_process_dependent IN VARCHAR2 DEFAULT 'NO',
56 p_batch_status IN VARCHAR2 DEFAULT 'U'
57 );
58
59
60 PROCEDURE rollback_latest_retrieval(
61 p_bg_id IN NUMBER,
62 p_session_date IN VARCHAR2,
63 p_start_date IN VARCHAR2,
64 p_end_date IN VARCHAR2,
65 p_gre_id IN NUMBER DEFAULT NULL,
66 p_organization_id IN NUMBER DEFAULT NULL,
67 p_location_id IN NUMBER DEFAULT NULL,
68 p_payroll_id IN NUMBER DEFAULT NULL,
69 p_person_id IN NUMBER DEFAULT NULL,
70 p_batches_list IN VARCHAR2,
71 p_request_id IN NUMBER
72 );
73
74 PROCEDURE rollback_all_retrievals(
75 p_bg_id IN NUMBER,
76 p_session_date IN VARCHAR2,
77 p_start_date IN VARCHAR2,
78 p_end_date IN VARCHAR2,
79 p_gre_id IN NUMBER DEFAULT NULL,
80 p_organization_id IN NUMBER DEFAULT NULL,
81 p_location_id IN NUMBER DEFAULT NULL,
82 p_payroll_id IN NUMBER DEFAULT NULL,
83 p_person_id IN NUMBER DEFAULT NULL
84 );
85
86
87 PROCEDURE log(p_text IN VARCHAR2 DEFAULT ' ',
88 p_cache IN VARCHAR2 DEFAULT 'N');
89
90
91 FUNCTION return_ids(p_lines NUMTAB)
92 RETURN NUMTAB
93 PIPELINED ;
94
95 FUNCTION reversed_line(p_lines pay_batch_lines%ROWTYPE)
96 RETURN pay_batch_lines%ROWTYPE;
97
98 FUNCTION reversal_batch(p_batch_id IN NUMBER)
99 RETURN NUMBER;
100
101 FUNCTION reversal_batch_sequence(p_batch_id IN NUMBER)
102 RETURN NUMBER;
103
104 PROCEDURE init;
105
106
107
108 END HXC_RETRIEVAL_ROLLBACK;