1 PACKAGE hxt_time_summary AUTHID CURRENT_USER AS
2 /* $Header: hxttsum.pkh 120.9 2011/12/16 10:24:54 asrajago ship $ */
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 -- Bug 11837942
15 TYPE NUMTAB2 IS TABLE OF NUMBER INDEX BY VARCHAR2(50);
16 g_sum_prev_ids NUMTAB2;
17
18 g_rec_period_id NUMTAB2; -- Bug 12689562
19
20 -- Bug 7359347
21 -- New global variable for session date.
22 g_sum_session_date DATE;
23
24 -- Bug 10123886
25 TYPE det_tab IS TABLE OF hxt_det_duplicate_regular%ROWTYPE;
26 g_det_tab det_tab := det_tab();
27 g_index BINARY_INTEGER := 0;
28
29
30 -- Bug 9218428
31 -- New table type and variable to store daily rule caps
32
33 -- Bug 13408603
34 -- Modified this to index by VARCHAR2
35 TYPE NUMTAB IS TABLE OF NUMBER INDEX BY VARCHAR2(20);
36 g_daily_cap NUMTAB;
37
38
39
40 FUNCTION generate_details(
41 p_ep_id IN NUMBER,
42 p_ep_type IN VARCHAR2,
43 p_egt_id IN NUMBER,
44 p_sdp_id IN NUMBER,
45 p_hdp_id IN NUMBER,
46 p_hol_id IN NUMBER,
47 p_pep_id IN NUMBER,
48 p_pip_id IN NUMBER,
49 p_sdovr_id IN NUMBER,
50 p_osp_id IN NUMBER,
51 p_standard_start IN NUMBER,
52 p_standard_stop IN NUMBER,
53 p_early_start IN NUMBER,
54 p_late_stop IN NUMBER,
55 p_hol_yn IN VARCHAR2,
56 p_person_id IN NUMBER,
57 p_location IN VARCHAR2,
58 p_ID IN NUMBER,
59 p_TIM_ID IN NUMBER,
60 p_DATE_WORKED IN DATE,
61 p_ASSIGNMENT_ID IN NUMBER,
62 p_HOURS IN NUMBER,
63 p_TIME_IN IN DATE,
64 p_TIME_OUT IN DATE,
65 p_ELEMENT_TYPE_ID IN NUMBER,
66 p_FCL_EARN_REASON_CODE IN VARCHAR2,
67 p_FFV_COST_CENTER_ID IN NUMBER,
68 p_FFV_LABOR_ACCOUNT_ID IN NUMBER,
69 p_TAS_ID IN NUMBER,
70 p_LOCATION_ID IN NUMBER,
71 p_SHT_ID IN NUMBER,
72 p_HRW_COMMENT IN VARCHAR2,
73 p_FFV_RATE_CODE_ID IN NUMBER,
74 p_RATE_MULTIPLE IN NUMBER,
75 p_HOURLY_RATE IN NUMBER,
76 p_AMOUNT IN NUMBER,
77 p_FCL_TAX_RULE_CODE IN VARCHAR2,
78 p_SEPARATE_CHECK_FLAG IN VARCHAR2,
79 p_SEQNO IN NUMBER,
80 p_CREATED_BY IN NUMBER,
81 p_CREATION_DATE IN DATE,
82 p_LAST_UPDATED_BY IN NUMBER,
83 p_LAST_UPDATE_DATE IN DATE,
84 p_LAST_UPDATE_LOGIN IN NUMBER,
85 p_PERIOD_START_DATE IN DATE,
86 p_ROWIDIN IN VARCHAR2,
87 p_EFFECTIVE_START_DATE IN DATE,
88 p_EFFECTIVE_END_DATE IN DATE,
89 p_PROJECT_ID IN NUMBER,
90 p_JOB_ID IN NUMBER,
91 p_PAY_STATUS IN VARCHAR2,
92 p_PA_STATUS IN VARCHAR2,
93 p_RETRO_BATCH_ID IN NUMBER,
94 p_DT_UPDATE_MODE IN VARCHAR2,
95 p_CALL_ADJUST_ABS IN VARCHAR2 DEFAULT 'Y',
96 p_STATE_NAME IN VARCHAR2 DEFAULT NULL,
97 p_COUNTY_NAME IN VARCHAR2 DEFAULT NULL,
98 p_CITY_NAME IN VARCHAR2 DEFAULT NULL,
99 p_ZIP_CODE IN VARCHAR2 DEFAULT NULL
100 -- p_GROUP_ID IN NUMBER
101 )
102 RETURN NUMBER;
103
104 PROCEDURE time_in_dates(ln_start in number
105 ,ln_stop in number
106 ,ln_carryover in number
107 ,time_in out nocopy date
108 ,time_out out nocopy date
109 ,carryover_time out nocopy date
110 ,l_date_worked in date);
111
112 END;