1 PACKAGE pay_mx_PTU_calc AS
2 /* $Header: paymxprofitshare.pkh 120.2.12000000.2 2007/02/20 17:31:37 vmehta noship $ */
3 --
4 PROCEDURE get_payroll_action_info(p_payroll_action_id IN NUMBER
5 ,p_start_date OUT NOCOPY DATE
6 ,p_effective_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 -- ,p_incl_temp_EEs OUT NOCOPY VARCHAR2
11 -- ,p_min_days_worked OUT NOCOPY NUMBER
12 ,p_batch_name OUT NOCOPY VARCHAR2
13 );
14
15 PROCEDURE range_code(p_payroll_action_id IN NUMBER
16 ,p_sqlstr OUT NOCOPY VARCHAR2);
17
18 PROCEDURE assignment_action_code(p_payroll_action_id IN NUMBER
19 ,p_start_person_id IN NUMBER
20 ,p_end_person_id IN NUMBER
21 ,p_chunk IN NUMBER);
22
23 PROCEDURE initialization_code(p_payroll_action_id IN NUMBER);
24
25 PROCEDURE archive_code(p_archive_action_id IN NUMBER
26 ,p_effective_date IN DATE);
27
28 PROCEDURE deinit_code(p_payroll_action_id IN NUMBER);
29
30 -- Get latest YTD aaid for the person
31 -- Date constraint relaxed since terminated assignments are also included.
32 CURSOR c_get_ytd_aaid(cp_start_date DATE,
33 cp_end_date DATE,
34 cp_person_id NUMBER)
35 IS
36 SELECT paa.assignment_action_id
37 FROM pay_assignment_actions paa,
38 pay_payroll_actions ppa,
39 per_assignments_f paf,
40 pay_action_classifications pac
41 WHERE paf.person_id = cp_person_id
42 AND paa.assignment_id = paf.assignment_id
43 AND paa.payroll_action_id = ppa.payroll_action_id
44 AND ppa.action_type = pac.action_type
45 AND pac.classification_name = 'SEQUENCED'
46 AND paa.action_status = 'C'
47 AND ppa.effective_date BETWEEN cp_start_date
48 AND cp_end_date
49 ORDER BY paa.action_sequence DESC;
50
51 g_ptu_calc_method FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
52 g_worked_days_def_bal_id NUMBER;
53 g_elig_comp_def_bal_id NUMBER;
54 g_factor_A NUMBER;
55 g_factor_D NUMBER;
56 g_factor_F NUMBER;
57 g_factor_G NUMBER;
58 g_factor_H NUMBER;
59 g_factor_I NUMBER;
60 g_batch_id NUMBER;
61 g_PTU_ele_type_id NUMBER;
62
63 gd_start_date DATE;
64 gd_end_date DATE;
65 gn_legal_employer_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE;
66
67 TYPE number_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
68 g_ytd_aaid_tab number_tab;
69
70
71 --
72 END pay_mx_PTU_calc;