1 PACKAGE HXT_TIM_COL_UTIL AUTHID CURRENT_USER AS
2 /* $Header: hxtclut.pkh 115.9 2004/01/20 01:51:02 sonarasi 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 /*------------------------------------
18 || Public Module Declarations
19 ------------------------------------*/
20 FUNCTION get_person_id(i_employee_number IN VARCHAR2,
21 i_business_group_id IN NUMBER,
22 i_date_worked IN DATE,
23 o_person_id OUT NOCOPY NUMBER,
24 o_last_name OUT NOCOPY VARCHAR2,
25 o_first_name OUT NOCOPY VARCHAR2)RETURN NUMBER;
26
27 FUNCTION determine_pay_date( i_start_time IN DATE,
28 i_end_time IN DATE,
29 i_person_id IN NUMBER,
30 o_date_worked OUT NOCOPY DATE) RETURN NUMBER;
31
32 FUNCTION get_element_type_id(i_element_name IN VARCHAR2,
33 i_date_worked IN DATE,
34 i_bg_id IN NUMBER,
35 o_element_type_id OUT NOCOPY NUMBER)RETURN NUMBER;
36
37 FUNCTION chk_element_link(p_asg_id IN NUMBER,
38 p_date_worked IN DATE,
39 p_element_type_id IN NUMBER) RETURN NUMBER;
40
41 FUNCTION get_earn_pol_id(i_assignment_id IN NUMBER DEFAULT NULL,
42 i_date_worked IN DATE,
43 i_earn_pol_name IN VARCHAR2 DEFAULT NULL,
44 o_earn_pol_id OUT NOCOPY earn_pol_id%TYPE) RETURN NUMBER;
45
46 FUNCTION get_task_id(i_task_number IN VARCHAR2,
47 i_date_worked IN DATE,
48 i_project_id IN NUMBER, /* PWM 05-APR-00 */
49 o_task_id OUT NOCOPY NUMBER)RETURN NUMBER;
50
51 FUNCTION get_grade_id(i_grade_name IN VARCHAR2,
52 i_business_group_id IN NUMBER,
53 i_date_worked IN DATE,
54 o_grade_id OUT NOCOPY NUMBER)RETURN NUMBER;
55
56 FUNCTION get_location_id(i_location_code IN VARCHAR2,
57 i_date_worked IN DATE,
58 o_location_id OUT NOCOPY NUMBER)RETURN NUMBER;
59
60 FUNCTION get_project_id(i_project_number IN VARCHAR2,
61 i_date_worked IN DATE,
62 o_project_id OUT NOCOPY project_id%TYPE)RETURN NUMBER;
63
64 FUNCTION validate_separate_chk_flg(io_separate_check_flag IN OUT NOCOPY VARCHAR2) RETURN NUMBER;
65
66 FUNCTION validate_earn_reason_code(i_earn_reason_code IN VARCHAR2,
67 i_date_worked IN DATE) RETURN NUMBER;
68 -- i_element_type_id IN NUMBER) RETURN NUMBER;
69
70 FUNCTION validate_time_summary_id( i_time_summary_id IN NUMBER)RETURN NUMBER;
71
72 FUNCTION validate_cost_center_id(i_cost_center_id IN NUMBER,
73 i_date_worked IN DATE )RETURN NUMBER;
74
75 FUNCTION validate_timecard_source( i_timecard_source IN VARCHAR2,
76 i_date_worked IN DATE,
77 o_timecard_source_code OUT NOCOPY VARCHAR2 ) RETURN NUMBER;
78
79 FUNCTION validate_wage_code(i_wage_code IN VARCHAR2,
80 i_date_worked IN DATE )RETURN NUMBER;
81
82 FUNCTION get_session_date(o_sess_date OUT NOCOPY DATE )RETURN NUMBER;
83
84 END HXT_TIM_COL_UTIL;