1 PACKAGE pay_mx_yrend_arch AS
2 /* $Header: paymxyrendarch.pkh 120.3.12010000.1 2008/07/27 21:51:42 appldev ship $ */
3 --
4 PROCEDURE get_payroll_action_info(p_payroll_action_id IN NUMBER
5 ,p_end_date OUT NOCOPY DATE
6 -- ,p_start_date OUT NOCOPY DATE
7 ,p_business_group_id OUT NOCOPY NUMBER
8 ,p_legal_employer_id OUT NOCOPY NUMBER
9 ,p_asg_set_id OUT NOCOPY NUMBER
10 );
11
12 PROCEDURE range_code(p_payroll_action_id IN NUMBER
13 ,p_sqlstr OUT NOCOPY VARCHAR2);
14
15 PROCEDURE assignment_action_code(p_payroll_action_id IN NUMBER
16 ,p_start_person_id IN NUMBER
17 ,p_end_person_id IN NUMBER
18 ,p_chunk IN NUMBER);
19
20 PROCEDURE initialization_code(p_payroll_action_id IN NUMBER);
21
22 PROCEDURE archive_code(p_archive_action_id IN NUMBER
23 ,p_effective_date IN DATE);
24
25 -- Bug 4625794
26 FUNCTION gre_exists (p_gre_id NUMBER) RETURN NUMBER;
27
28 PROCEDURE load_gre(p_business_group_id NUMBER,
29 p_le_id NUMBER,
30 p_effective_date DATE);
31 --
32 -- FUNCTION get_arch_user_entity(p_archive_item IN VARCHAR2)
33 -- RETURN NUMBER;
34
35 TYPE number_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
36 g_gre_tab number_tab;
37
38 g_fiscal_year VARCHAR2(4);
39 g_ER_legal_name hr_organization_information.org_information1%TYPE;
40 g_ER_RFC hr_organization_information.org_information1%TYPE;
41 g_ER_legal_rep_name hr_organization_information.org_information1%TYPE;
42 g_ER_legal_rep_RFC per_people_f.per_information1%TYPE;
43 g_ER_legal_rep_CURP per_people_f.national_identifier%TYPE;
44 g_payroll_action_id NUMBER;
45
46 pai_tab pay_emp_action_arch.action_info_table ;
47
48 --
49 END pay_mx_yrend_arch;