1 PACKAGE ghr_ss_views_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghssview.pkh 120.9 2012/01/19 07:03:02 rpahune noship $ */
3 --
4 g_package constant varchar2(33) := ' GHR_SS_VIEWS_PKG.';
5
6
7 --
8 function get_people_ei_id_ason_date(
9 p_person_id in number,
10 p_information_type in varchar2,
11 p_effective_date in date
12 ) return number ;
13 --
14
15 function get_ele_value_ason_date (
16 p_ele_name in varchar2,
17 p_input_name in varchar2,
18 p_asg_id in number,
19 p_eff_date in date,
20 P_BUSINESS_GROUP_ID in Number
21 ) return varchar2 ;
22 --
23 function get_latest_pa_req_id (
24 p_person_id in number,
25 p_effective_date in date
26 ) return number;
27 --
28 Function get_latest_perf_rating(P_person_id in number,
29 p_effective_date in Date) return varchar2;
30
31 --
32 Function retrieve_element_curr_code (p_element_name in pay_element_types_f.element_name%type,
33 p_assignment_id in pay_element_entries_f.assignment_id%type,
34 p_business_group_id in per_all_assignments_f.business_group_id%type,
35 p_effective_date in date ) return varchar2;
36 --
37 function get_loc_pay_area_percentage (p_location_id in number,
38 p_effective_date in date ) return varchar2;
39 --
40
41 function get_ele_entry_value_ason_date (p_element_entry_id IN NUMBER,
42 p_input_value_name IN VARCHAR2,
43 p_effective_date IN DATE ) return varchar2 ;
44 --
45 FUNCTION check_if_awards_exists (p_assignment_id IN NUMBER,
46 p_effective_date IN DATE ) RETURN VARCHAR2 ;
47 --
48 FUNCTION check_if_bonus_exists (p_assignment_id IN NUMBER,
49 p_effective_date IN DATE ) RETURN VARCHAR2;
50 --
51 function get_history_id(p_assignment_type in varchar2,
52 p_person_id in number,
53 p_information_type in varchar2,
54 p_effective_date in date
55 ) return number;
56 --
57 function get_assignment_ei_id_ason_date( p_asg_id in number,
58 p_information_type in varchar2,
59 p_effective_date in date
60 ) return number ;
61 --
62
63 function get_position_ei_id_ason_date( p_position_id in number,
64 p_information_type in varchar2,
65 p_effective_date in date
66 ) return number ;
67 --
68
69 Function get_rating_of_record(P_person_id in number) return varchar2;
70 --
71 Function get_assignment_start_date(p_person_id in number) return date;
72
73 Function get_assignment_end_date(p_person_id in number) return date;
74 --
75
76 /*Bug: 8653508 Detail Action*/
77 FUNCTION get_duty_station_desc(p_DUTY_STATION_ID in number, p_EFFECTIVE_DATE in date) return varchar2;
78 /*Bug: 8653508 Detail Action*/
79 --Begin Bug 10174467
80 FUNCTION get_per_ele_value_ason_date(p_ele_name in varchar2
81 ,p_input_name in varchar2
82 ,p_person_id IN NUMBER
83 ,P_BUSINESS_GROUP_ID in Number) RETURN varchar2;
84 Function get_elmt_curr_code_ason_dt (
85 p_element_name in pay_element_types_f.element_name%type,
86 p_person_id in number,
87 p_business_group_id in per_all_assignments_f.business_group_id%type)
88 return varchar2;
89 --End Bug 10174467
90 END ghr_ss_views_pkg;
91 --
[Home] [Help]