1 PACKAGE HXT_TIM_COL_UTIL AUTHID CURRENT_USER AS
2 /* $Header: hxtclut.pkh 120.0.12010000.2 2009/02/24 14:06:46 asrajago ship $ */
3
4 /*------------------------------
5 || Base Anchored Declarations
6 ------------------------------*/
7 project_id hxt_projects_v.project_id%TYPE;
8 earn_pol_id hxt_earning_policies.id%TYPE;
9
10 /*------------------------------
11 || Constants
12 ------------------------------*/
13 g_orcl_tm_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 808;
14 g_orcl_hr_app_id_cons CONSTANT hr_lookups.application_id%TYPE := 800;
15
16
17 -- Bug 7359347
18 -- The below associative array holds the session date
19 -- indexed by sessionid.
20
21 TYPE DATETAB IS TABLE OF DATE INDEX BY BINARY_INTEGER;
22
23 g_session_date DATETAB;
24
25
26 /*------------------------------------
27 || Public Module Declarations
28 ------------------------------------*/
29 FUNCTION get_person_id(i_employee_number IN VARCHAR2,
30 i_business_group_id IN NUMBER,
31 i_date_worked IN DATE,
32 o_person_id OUT NOCOPY NUMBER,
33 o_last_name OUT NOCOPY VARCHAR2,
34 o_first_name OUT NOCOPY VARCHAR2)RETURN NUMBER;
35
36 FUNCTION determine_pay_date( i_start_time IN DATE,
37 i_end_time IN DATE,
38 i_person_id IN NUMBER,
39 o_date_worked OUT NOCOPY DATE) RETURN NUMBER;
40
41 FUNCTION get_element_type_id(i_element_name IN VARCHAR2,
42 i_date_worked IN DATE,
43 i_bg_id IN NUMBER,
44 o_element_type_id OUT NOCOPY NUMBER)RETURN NUMBER;
45
46 FUNCTION chk_element_link(p_asg_id IN NUMBER,
47 p_date_worked IN DATE,
48 p_element_type_id IN NUMBER) RETURN NUMBER;
49
50 FUNCTION get_earn_pol_id(i_assignment_id IN NUMBER DEFAULT NULL,
51 i_date_worked IN DATE,
52 i_earn_pol_name IN VARCHAR2 DEFAULT NULL,
53 o_earn_pol_id OUT NOCOPY earn_pol_id%TYPE) RETURN NUMBER;
54
55 FUNCTION get_task_id(i_task_number IN VARCHAR2,
56 i_date_worked IN DATE,
57 i_project_id IN NUMBER, /* PWM 05-APR-00 */
58 o_task_id OUT NOCOPY NUMBER)RETURN NUMBER;
59
60 FUNCTION get_grade_id(i_grade_name IN VARCHAR2,
61 i_business_group_id IN NUMBER,
62 i_date_worked IN DATE,
63 o_grade_id OUT NOCOPY NUMBER)RETURN NUMBER;
64
65 FUNCTION get_location_id(i_location_code IN VARCHAR2,
66 i_date_worked IN DATE,
67 o_location_id OUT NOCOPY NUMBER)RETURN NUMBER;
68
69 FUNCTION get_project_id(i_project_number IN VARCHAR2,
70 i_date_worked IN DATE,
71 o_project_id OUT NOCOPY project_id%TYPE)RETURN NUMBER;
72
73 FUNCTION validate_separate_chk_flg(io_separate_check_flag IN OUT NOCOPY VARCHAR2) RETURN NUMBER;
74
75 FUNCTION validate_earn_reason_code(i_earn_reason_code IN VARCHAR2,
76 i_date_worked IN DATE) RETURN NUMBER;
77 -- i_element_type_id IN NUMBER) RETURN NUMBER;
78
79 FUNCTION validate_time_summary_id( i_time_summary_id IN NUMBER)RETURN NUMBER;
80
81 FUNCTION validate_cost_center_id(i_cost_center_id IN NUMBER,
82 i_date_worked IN DATE )RETURN NUMBER;
83
84 FUNCTION validate_timecard_source( i_timecard_source IN VARCHAR2,
85 i_date_worked IN DATE,
86 o_timecard_source_code OUT NOCOPY VARCHAR2 ) RETURN NUMBER;
87
88 FUNCTION validate_wage_code(i_wage_code IN VARCHAR2,
89 i_date_worked IN DATE )RETURN NUMBER;
90
91 FUNCTION get_session_date(o_sess_date OUT NOCOPY DATE )RETURN NUMBER;
92
93
94 -- Bug 7359347
95 -- Added new global function which returns session date for this session id.
96
97 FUNCTION return_session_date RETURN DATE;
98
99
100 END HXT_TIM_COL_UTIL;