1 PACKAGE PQP_GB_PSI_STH_HISTORY AS
2 -- /* $Header: pqpgbpsisth.pkh 120.1.12000000.2 2007/02/13 14:00:13 mseshadr noship $ */
3 -- Debug Variables.
4 --
5 g_debug BOOLEAN := hr_utility.debug_enabled;
6 g_package VARCHAR2(30) := 'PQP_GB_PSI_STH_HISTORY';
7 c_highest_date CONSTANT DATE := hr_api.g_eot;
8
9 g_assignment_id NUMBER;
10 g_person_id NUMBER;
11 g_business_group_id per_all_people_f.business_group_id%TYPE;
12 g_legislation_code VARCHAR2(4);
13 g_current_layout VARCHAR2(20);
14
15 g_paypoint VARCHAR2(30);
16 g_ext_dfn_id NUMBER;
17 g_pay_proc_evt_tab ben_ext_person.t_detailed_output_table;
18
19
20 g_curr_person_dtls per_all_people_f%ROWTYPE;
21 -- this contains the person details on effective date
22
23 g_curr_assg_dtls per_all_assignments_f%ROWTYPE;
24 -- this contains the person details on effective date
25 g_assg_start_date DATE;
26
27 g_start_date DATE := NULL;
28 g_end_date DATE := NULL;
29 g_effective_date DATE;
30 g_adjusted_hours NUMBER;
31 g_curr_element_entry_id NUMBER;
32 g_curr_element_type_id NUMBER;
33 g_curr_element_type_name PAY_ELEMENT_TYPES_F.element_name%TYPE;
34
35 ------------------------------------------
36 g_adj_hrs_source VARCHAR2(20); -- balance / element entries
37 g_adj_hrs_bal_type VARCHAR2(80);
38 ------------------------------------------
39
40 TYPE r_element_type_details IS RECORD
41 (
42 element_type_name pay_element_types_f.element_name%TYPE
43 );
44
45 TYPE t_element_type_details IS TABLE OF r_element_type_details
46 INDEX BY BINARY_INTEGER;
47
48 g_valid_element_type_details t_element_type_details;
49 -- this contains the valid element type details.
50 TYPE t_number IS TABLE OF NUMBER
51 INDEX BY BINARY_INTEGER;
52
53 TYPE t_varchar2 IS TABLE OF VARCHAR2(100)
54 INDEX BY BINARY_INTEGER;
55
56 g_proc_ele_entries t_varchar2;
57 -- this contains the processed element_entry_ids
58
59 g_reported_claim_dates t_varchar2;
60 -- this contains the reported claim dates.
61 -- this will be storing the element_entry_id indexed by
62 -- date converted to the format 'ddmmyyyy' which will
63 -- be a number
64
65 g_reported_pay_periods t_varchar2;
66 -- this contains the start dates of the reported pay periods
67 -- this will be used only for Accumulated Records when the
68 -- adj hours source s configured as balance type.
69
70 -- ----------------------------------------------------------------------------
71 -- |--------------------< short_time_hours_sin_criteria >----------------------|
72 -- ----------------------------------------------------------------------------
73 FUNCTION short_time_hours_sin_criteria
74 (
75 p_business_group_id IN NUMBER
76 ,p_assignment_id IN NUMBER
77 ,p_effective_date IN DATE
78 )RETURN VARCHAR2;
79 -- ----------------------------------------------------------------------------
80 -- |--------------------< short_time_hours_acc_criteria >----------------------|
81 -- ----------------------------------------------------------------------------
82 FUNCTION short_time_hours_acc_criteria
83 (
84 p_business_group_id IN NUMBER
85 ,p_assignment_id IN NUMBER
86 ,p_effective_date IN DATE
87 )RETURN VARCHAR2;
88 -- ----------------------------------------------------------------------------
89 -- |--------------------< short_time_hours_data_ele_val >----------------------|
90 -- ----------------------------------------------------------------------------
91 FUNCTION short_time_hours_data_ele_val
92 (
93 p_ext_user_value IN VARCHAR2
94 ,p_output_value OUT NOCOPY VARCHAR2
95 ) RETURN NUMBER;
96 -- ----------------------------------------------------------------------------
97 -- |----------------------< short_time_hours_claim_date >--------------------------|
98 -- Description: This is the post-processing rule for the Short-Time Hours History.
99 -- ----------------------------------------------------------------------------
100 FUNCTION short_time_hours_claim_date
101 (
102 p_ext_user_value IN VARCHAR2
103 ,p_output_value OUT NOCOPY VARCHAR2
104 ) RETURN NUMBER;
105 -- ----------------------------------------------------------------------------
106 -- |----------------------< short_time_hours_post_proc >--------------------------|
107 -- Description: This is the post-processing rule for the Short-Time Hours History.
108 -- ----------------------------------------------------------------------------
109 FUNCTION short_time_hours_post_proc RETURN VARCHAR2;
110
111 END PQP_GB_PSI_STH_HISTORY;