1 PACKAGE Pay_Za_Tax_Year_Start_Pkg AUTHID CURRENT_USER AS
2 /* $Header: pyzatysp.pkh 115.2 2002/11/28 15:16:28 jlouw noship $ */
3
4 /* This cursur selects all assignments for payroll_id in tax_year */
5 CURSOR c_assignments
6 (p_payroll IN NUMBER,
7 p_effective_date IN DATE)
8 IS
9 SELECT assignment_id,
10 p_payroll,
11 p_effective_date
12 FROM per_assignments_f
13 WHERE payroll_id = p_payroll
14 AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
15
16 /* This cursor select the screen entry values for each assignment */
17 CURSOR c_entry_details
18 (p_element_type_id IN NUMBER,
19 p_input_value_id IN NUMBER,
20 p_assignment_id IN NUMBER,
21 p_payroll IN NUMBER,
22 p_effective_date IN DATE)
23 IS
24 SELECT c.element_entry_id,
25 a.screen_entry_value,
26 d.input_value_id,
27 d.name,
28 p_payroll,
29 p_effective_date
30 FROM pay_element_entry_values_f a,
31 pay_element_links_f b,
32 pay_element_entries_f c,
33 pay_input_values_f d
34 WHERE c.assignment_id = p_assignment_id
35 AND p_effective_date BETWEEN c.effective_start_date AND c.effective_end_date
36 AND p_effective_date BETWEEN a.effective_start_date AND a.effective_end_date
37 AND p_effective_date BETWEEN b.effective_start_date AND b.effective_end_date
38 AND p_effective_date BETWEEN d.effective_start_date AND d.effective_end_date
39 AND b.element_type_id = p_element_type_id
40 AND b.element_link_id = c.element_link_id
41 AND d.input_value_id = a.input_value_id
42 AND c.element_entry_id = a.element_entry_id
43 AND a.input_value_id = p_input_value_id;
44
45
46 PROCEDURE reset_all_ind
47 (
48 p_errmsg OUT NOCOPY VARCHAR2,
49 p_errcode OUT NOCOPY NUMBER,
50 p_payroll NUMBER DEFAULT NULL,
51 p_tax_year VARCHAR2 DEFAULT NULL
52 );
53
54 PROCEDURE rollback_all_ind
55 (
56 p_errmsg OUT NOCOPY VARCHAR2,
57 p_errcode OUT NOCOPY NUMBER,
58 p_payroll NUMBER DEFAULT NULL,
59 p_tax_year VARCHAR2 DEFAULT NULL
60 );
61
62 END Pay_Za_Tax_Year_Start_Pkg;
[Home] [Help]