1 PACKAGE hxt_time_summary AS
2 /* $Header: hxttsum.pkh 120.2 2005/08/16 14:20:35 mhanda noship $ */
3
4
5 --TYPE t_char IS TABLE of varchar2(8000) INDEX BY BINARY_INTEGER;
6 TYPE t_date IS TABLE of DATE INDEX BY BINARY_INTEGER;
7
8 SEGMENT_CHUNKS t_date;
9 SORTED_CHUNKS t_date;
10
11 --FUNCTION sort (V_char in t_num, p_order in Varchar2:= 'ASC') RETURN t_char;
12 --FUNCTION sort (segment_chunks in t_num, p_order in Varchar2) RETURN t_num;
13
14 FUNCTION generate_details(
15 p_ep_id IN NUMBER,
16 p_ep_type IN VARCHAR2,
17 p_egt_id IN NUMBER,
18 p_sdp_id IN NUMBER,
19 p_hdp_id IN NUMBER,
20 p_hol_id IN NUMBER,
21 p_pep_id IN NUMBER,
22 p_pip_id IN NUMBER,
23 p_sdovr_id IN NUMBER,
24 p_osp_id IN NUMBER,
25 p_standard_start IN NUMBER,
26 p_standard_stop IN NUMBER,
27 p_early_start IN NUMBER,
28 p_late_stop IN NUMBER,
29 p_hol_yn IN VARCHAR2,
30 p_person_id IN NUMBER,
31 p_location IN VARCHAR2,
32 p_ID IN NUMBER,
33 p_TIM_ID IN NUMBER,
34 p_DATE_WORKED IN DATE,
35 p_ASSIGNMENT_ID IN NUMBER,
36 p_HOURS IN NUMBER,
37 p_TIME_IN IN DATE,
38 p_TIME_OUT IN DATE,
39 p_ELEMENT_TYPE_ID IN NUMBER,
40 p_FCL_EARN_REASON_CODE IN VARCHAR2,
41 p_FFV_COST_CENTER_ID IN NUMBER,
42 p_FFV_LABOR_ACCOUNT_ID IN NUMBER,
43 p_TAS_ID IN NUMBER,
44 p_LOCATION_ID IN NUMBER,
45 p_SHT_ID IN NUMBER,
46 p_HRW_COMMENT IN VARCHAR2,
47 p_FFV_RATE_CODE_ID IN NUMBER,
48 p_RATE_MULTIPLE IN NUMBER,
49 p_HOURLY_RATE IN NUMBER,
50 p_AMOUNT IN NUMBER,
51 p_FCL_TAX_RULE_CODE IN VARCHAR2,
52 p_SEPARATE_CHECK_FLAG IN VARCHAR2,
53 p_SEQNO IN NUMBER,
54 p_CREATED_BY IN NUMBER,
55 p_CREATION_DATE IN DATE,
56 p_LAST_UPDATED_BY IN NUMBER,
57 p_LAST_UPDATE_DATE IN DATE,
58 p_LAST_UPDATE_LOGIN IN NUMBER,
59 p_PERIOD_START_DATE IN DATE,
60 p_ROWIDIN IN VARCHAR2,
61 p_EFFECTIVE_START_DATE IN DATE,
62 p_EFFECTIVE_END_DATE IN DATE,
63 p_PROJECT_ID IN NUMBER,
64 p_JOB_ID IN NUMBER,
65 p_PAY_STATUS IN VARCHAR2,
66 p_PA_STATUS IN VARCHAR2,
67 p_RETRO_BATCH_ID IN NUMBER,
68 p_DT_UPDATE_MODE IN VARCHAR2,
69 p_CALL_ADJUST_ABS IN VARCHAR2 DEFAULT 'Y',
70 p_STATE_NAME IN VARCHAR2 DEFAULT NULL,
71 p_COUNTY_NAME IN VARCHAR2 DEFAULT NULL,
72 p_CITY_NAME IN VARCHAR2 DEFAULT NULL,
73 p_ZIP_CODE IN VARCHAR2 DEFAULT NULL
74 -- p_GROUP_ID IN NUMBER
75 )
76 RETURN NUMBER;
77
78 PROCEDURE time_in_dates(ln_start in number
79 ,ln_stop in number
80 ,ln_carryover in number
81 ,time_in out nocopy date
82 ,time_out out nocopy date
83 ,carryover_time out nocopy date
84 ,l_date_worked in date);
85
86 END;