[Home] [Help]
PACKAGE: APPS.PQP_GB_PSI_BON_HISTORY
Source
1 PACKAGE PQP_GB_PSI_BON_HISTORY AUTHID CURRENT_USER AS
2 -- /* $Header: pqpgbpsibon.pkh 120.4.12010000.2 2008/08/05 14:06:51 ubhat ship $ */
3 -- Debug Variables.
4 --
5 g_debug BOOLEAN := hr_utility.debug_enabled;
6 g_package VARCHAR2(30) := 'PQP_GB_PSI_BON_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
26 g_effective_date DATE;
27 g_curr_element_type_id NUMBER;
28 g_curr_element_entry_id NUMBER;
29 g_curr_element_type_name PAY_ELEMENT_TYPES_F.element_name%TYPE;
30 g_curr_ee_start_date DATE;
31 g_curr_ee_end_date DATE;
32
33 g_include_current_row BOOLEAN;
34
35 TYPE t_varchar2 IS TABLE OF VARCHAR2(1000)
36 INDEX BY BINARY_INTEGER;
37 g_proc_bon_codes t_varchar2;
38
39 g_assg_start_date DATE;
40
41 g_bon_bal_type_id pay_balance_types.balance_type_id%TYPE;
42
43 --For BUG 5998129
44 g_first_retro_event DATE;
45 g_first_retro_event_start DATE;
46 g_first_approved_event DATE;
47 g_first_eff_date BOOLEAN; /* For Bug: 6791275 */
48
49
50 -- ----------------------------------------------------------------------------
51 -- |--------------------< bonus_cutover_ext_criteria >----------------------|
52 -- ----------------------------------------------------------------------------
53 FUNCTION bonus_cutover_ext_criteria
54 (
55 p_business_group_id IN NUMBER
56 ,p_assignment_id IN NUMBER
57 ,p_effective_date IN DATE
58 )RETURN VARCHAR2;
59 -- ----------------------------------------------------------------------------
60 -- |--------------------< bonus_periodic_ext_criteria >----------------------|
61 -- ----------------------------------------------------------------------------
62 FUNCTION bonus_periodic_ext_criteria
63 (
64 p_business_group_id IN NUMBER
65 ,p_assignment_id IN NUMBER
66 ,p_effective_date IN DATE
67 )RETURN VARCHAR2;
68 -- ----------------------------------------------------------------------------
69 -- |--------------------< bonus_history_data_ele_val >----------------------|
70 -- ----------------------------------------------------------------------------
71 FUNCTION bonus_history_data_ele_val
72 (
73 p_ext_user_value IN VARCHAR2
74 ,p_output_value OUT NOCOPY VARCHAR2
75 ) RETURN NUMBER;
76
77 -- ----------------------------------------------------------------------------
78 -- |----------------------< bonus_history_post_proc >--------------------------|
79 -- Description: This is the post-processing rule for the Short-Time Hours History.
80 -- ----------------------------------------------------------------------------
81 FUNCTION bonus_history_post_proc RETURN VARCHAR2;
82
83 END PQP_GB_PSI_BON_HISTORY;