1 Package hxc_generic_retrieval_utils AUTHID CURRENT_USER as
2 /* $Header: hxcretutl.pkh 120.7.12020000.1 2012/06/28 05:38:58 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' hxc_generic_retrieval_utils.'; -- Global package name
9
10 TYPE r_ret_ranges IS RECORD (
11 rtr_grp_id NUMBER(15)
12 ,start_date DATE
13 ,stop_date DATE);
14
15 TYPE t_ret_ranges IS TABLE OF r_ret_ranges INDEX BY BINARY_INTEGER;
16
17 TYPE r_ret_rule IS RECORD (
18 rtr_grp_id NUMBER(15)
19 ,time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
20 ,status VARCHAR2(40)
21 ,outcome_exists VARCHAR2(1)
22 ,outcome_start BINARY_INTEGER
23 ,outcome_stop BINARY_INTEGER );
24
25 TYPE t_ret_rule IS TABLE OF r_ret_rule INDEX BY BINARY_INTEGER;
26
27 TYPE r_rtr_exists IS RECORD (
28 rtr_start BINARY_INTEGER
29 ,rtr_stop BINARY_INTEGER );
30
31 TYPE t_rtr_exists IS TABLE OF r_rtr_exists INDEX BY BINARY_INTEGER;
32
33 TYPE r_pref IS RECORD (
34 prefs_ok varchar2(1)
35 ,rtr_start BINARY_INTEGER
36 ,rtr_end BINARY_INTEGER );
37
38 TYPE t_pref IS TABLE OF r_pref INDEX BY BINARY_INTEGER;
39
40 TYPE r_app_set IS RECORD (
41 app_set_ok VARCHAR2(1) );
42
43 TYPE t_app_set IS TABLE OF r_app_set INDEX BY BINARY_INTEGER;
44
45 TYPE r_resource IS RECORD ( resource_id hxc_time_building_blocks.resource_id%TYPE
46 , start_time hxc_time_building_blocks.start_time%TYPE
47 , stop_time hxc_time_building_blocks.stop_time%TYPE );
48
49 TYPE t_resource IS TABLE OF r_resource INDEX BY BINARY_INTEGER;
50
51 g_resources t_resource;
52
53 TYPE r_rtr_outcome IS RECORD ( rtr_grp_id number(15)
54 , time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
55 , start_time hxc_time_building_blocks.start_time%TYPE
56 , stop_time hxc_time_building_blocks.stop_time%TYPE );
57
58 TYPE t_rtr_outcome IS TABLE OF r_rtr_outcome INDEX BY BINARY_INTEGER;
59
60 TYPE r_errors IS RECORD ( exception_description hxc_transaction_details.exception_description%TYPE );
61
62 TYPE t_errors IS TABLE OF r_errors INDEX BY BINARY_INTEGER;
63
64
65 -- Bug 8366309
66 -- Added the below data structure to hold preferences for the employee.
67
68 -- This is a record with Flag (Y/N) and date range
69 -- for rules evaluation pref.
70 TYPE RULES_LIST IS RECORD
71 ( flag VARCHAR2(2),
72 start_date DATE,
73 end_date DATE
74 );
75
76 -- Here is a table of the above record type.
77 TYPE RULES_TAB IS TABLE OF RULES_LIST INDEX BY BINARY_INTEGER ;
78
79
80 -- Here is a record of the table above.
81 TYPE OTM_RULES_REC IS RECORD
82 ( otm_rules RULES_TAB );
83
84 -- A table of the above record type -- effectively, a table of tables.
85 TYPE RESOURCE_PREF_LIST IS TABLE OF OTM_RULES_REC INDEX BY BINARY_INTEGER;
86
87 -- Instantiated a global object of the above type
88 g_res_pref_list RESOURCE_PREF_LIST ;
89
90 -- Each of the resources you are considering would have one record
91 -- in the above table. So effectively, each resource would have
92 -- one table of preferences, with flag, and date ranges specified.
93
94
95
96
97
98
99
100 -- public function
101 -- time_bld_blk_changed
102 --
103 -- description
104 -- This function returns TRUE if the latest version of the
105 -- time building block specified by P_BB_ID has a greater
106 -- Object Version Number in the time store than that specified
107 -- by P_BB_OVN
108 --
109 -- parameters
110 -- p_bb_id - time building block id
111 -- p_bb_ovn - time building block object version number
112
113 FUNCTION time_bld_blk_changed ( p_bb_id NUMBER
114 , p_bb_ovn NUMBER )RETURN BOOLEAN;
115
116 PROCEDURE parse_resources (
117 p_process_id NUMBER
118 , p_ret_tr_id NUMBER
119 , p_prefs IN OUT NOCOPY t_pref
120 , p_ret_rules IN OUT NOCOPY t_ret_rule
121 , p_rtr_outcomes IN OUT NOCOPY t_rtr_outcome
122 , p_errors IN OUT NOCOPY t_errors );
123
124 -- Added p_attribute_category for Absences Integration (Bug 8779478)
125 PROCEDURE chk_retrieve (
126 p_resource_id NUMBER
127 , p_bb_status VARCHAR2
128 , p_bb_deleted VARCHAR2
129 , p_bb_start_time DATE
130 , p_bb_stop_time DATE
131 , p_bb_id NUMBER
132 , p_bb_ovn NUMBER
133 , p_attribute_category VARCHAR2
134 , p_process VARCHAR2
135 , p_prefs t_pref
136 , p_ret_rules t_ret_rule
137 , p_rtr_outcomes t_rtr_outcome
138 , p_tc_bb_id NUMBER
139 , p_tc_bb_ovn NUMBER
140 , p_timecard_retrieve IN OUT NOCOPY BOOLEAN
141 , p_day_retrieve IN OUT NOCOPY BOOLEAN
142 , p_tc_locked IN OUT NOCOPY BOOLEAN
143 , p_tc_first_lock IN OUT NOCOPY BOOLEAN
144 , p_bb_skipped_reason OUT NOCOPY VARCHAR2 );
145
146 PROCEDURE set_parent_statuses;
147
148 PROCEDURE recovery ( p_process_id NUMBER
149 , p_process VARCHAR2 );
150
151 FUNCTION chk_terminated ( p_conc_request_id NUMBER ) RETURN BOOLEAN;
152
153 FUNCTION get_ret_criteria RETURN VARCHAR2;
154
155
156
157 -- Bug 8366309
158 -- Added new parameters for chk_need_adj
159 -- and a new function to check preferences.
160
161 FUNCTION chk_need_adj ( p_tc_id NUMBER ,
162 p_tc_ovn NUMBER ,
163 p_resource_id NUMBER ,
164 p_date_earned DATE ,
165 p_bb_id NUMBER ,
166 p_bb_ovn NUMBER ,
167 p_action VARCHAR2,
168 p_retr_process_id NUMBER ) RETURN BOOLEAN ;
169
170
171 FUNCTION chk_otm_pref ( p_resource_id NUMBER,
172 p_date DATE,
173 p_process_id NUMBER )
174 RETURN BOOLEAN ;
175
176
177 -- OTL-Absences Integration (Bug 8779478)
178 FUNCTION absence_link_exists ( p_element_type_id NUMBER )
179 RETURN BOOLEAN;
180
181
182 end hxc_generic_retrieval_utils;