[Home] [Help]
PACKAGE: APPS.HXC_TIMESTORE_DEPOSIT_UTIL
Source
1 PACKAGE hxc_timestore_deposit_util AUTHID CURRENT_USER AS
2 /* $Header: hxctsdputil.pkh 120.8 2011/04/18 14:25:41 pnshukla ship $ */
3
4
5
6 --11896973 to cache Page context code.
10 --11896973 to cache reference field
7 TYPE VARCHARARRAY IS TABLE OF VARCHAR2(50) INDEX BY VARCHAR2(50);
8 g_dupdff_code VARCHARARRAY;
9
11 g_reference_field FND_DESCRIPTIVE_FLEXS.DEFAULT_CONTEXT_FIELD_NAME%TYPE;
12
13 TYPE translated_message_info IS RECORD (
14 message_name fnd_new_messages.message_name%TYPE,
15 MESSAGE_TEXT VARCHAR2 (4000),
16 time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
17 time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
18 time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
19 time_attribute_ovn hxc_time_attributes.object_version_number%TYPE
20 );
21
22 TYPE translated_message_table IS TABLE OF translated_message_info
23 INDEX BY BINARY_INTEGER;
24
25 FUNCTION get_retrieval_process_id (
26 p_retrieval_process_name IN hxc_retrieval_processes.NAME%TYPE
27 )
28 RETURN hxc_retrieval_processes.retrieval_process_id%TYPE;
29
30 FUNCTION approval_style_id (
31 p_approval_style_name hxc_approval_styles.NAME%TYPE
32 )
33 RETURN hxc_approval_styles.approval_style_id%TYPE;
34
35 PROCEDURE begin_approval (
36 p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
37 p_blocks IN hxc_block_table_type
38 );
39
40 PROCEDURE save_timecard (
41 p_blocks IN OUT NOCOPY hxc_block_table_type,
42 p_attributes IN OUT NOCOPY hxc_attribute_table_type,
43 p_messages IN OUT NOCOPY hxc_message_table_type,
44 p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
45 p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
46 );
47
48 PROCEDURE submit_timecard (
49 p_item_type IN wf_items.item_type%TYPE,
50 p_approval_prc IN wf_process_activities.process_name%TYPE,
51 p_template IN VARCHAR2,
52 p_mode IN VARCHAR2,
53 p_retrieval_process IN hxc_retrieval_processes.NAME%TYPE
54 DEFAULT NULL,
55 p_blocks IN OUT NOCOPY hxc_block_table_type,
56 p_attributes IN OUT NOCOPY hxc_attribute_table_type,
57 p_messages IN OUT NOCOPY hxc_message_table_type,
58 p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
59 p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
60 );
61
62 FUNCTION convert_new_trans_info_to_old (
63 p_transaction_info IN hxc_timecard.transaction_info
64 )
65 RETURN hxc_deposit_wrapper_utilities.t_transaction;
66
67 FUNCTION convert_tbb_to_type (
68 p_blocks IN hxc_self_service_time_deposit.timecard_info
69 )
70 RETURN hxc_block_table_type;
71
72 PROCEDURE convert_app_attributes_to_type (
73 p_attributes IN OUT NOCOPY hxc_attribute_table_type,
74 p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
75 );
76
77 FUNCTION convert_to_dpwr_messages (p_messages IN hxc_message_table_type)
78 RETURN hxc_self_service_time_deposit.message_table;
79
80 -- NOT USED
81 /* FUNCTION convert_msg_to_type (
82 p_messages IN hxc_self_service_time_deposit.message_table
83 )
84 RETURN hxc_message_table_type; */
85 FUNCTION get_approval_status (p_mode IN VARCHAR2)
86 RETURN VARCHAR2;
87
88 PROCEDURE find_parent_building_block (
89 p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90 p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91 p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92 p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93 p_app_blocks IN hxc_block_table_type,
94 p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95 p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96 );
97
98 PROCEDURE find_parent_building_block (
99 p_start_time IN hxc_time_building_blocks.start_time%TYPE,
100 p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
101 p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102 p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103 p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
104 p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105 p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106 );
107
108 PROCEDURE set_new_change_flags (
109 p_attributes IN OUT NOCOPY hxc_attribute_table_type
110 );
111
112 PROCEDURE get_timecard_bb_id (
113 p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
114 p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
115 p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
116 );
117
118 FUNCTION get_index_in_bb_table (
119 p_bb_table IN hxc_block_table_type,
120 p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE
121 )
122 RETURN PLS_INTEGER;
123
124 FUNCTION get_deposit_process_id (
125 p_deposit_process_name IN hxc_deposit_processes.NAME%TYPE
126 )
127 RETURN hxc_deposit_processes.deposit_process_id%TYPE;
128
129 FUNCTION get_index_in_attr_table (
130 p_attr_table IN hxc_self_service_time_deposit.app_attributes_info,
131 p_attr_id_to_find IN hxc_time_attributes.time_attribute_id%TYPE,
132 p_attribute_name_to_find IN hxc_mapping_components.field_name%TYPE
133 )
134 RETURN PLS_INTEGER;
135 -- ARR: Next two procedures add p_clear_mapping_cache for update case
136 PROCEDURE get_timecard_tables (
137 p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
138 -- p_time_recipient_id IN NUMBER,
139 p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
140 p_clear_mapping_cache IN BOOLEAN default false,
141 p_app_blocks OUT NOCOPY hxc_block_table_type,
142 p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
143 );
144
145 PROCEDURE get_timecard_tables (
146 p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
147 -- p_time_recipient_id IN NUMBER,
148 p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
149 p_clear_mapping_cache IN BOOLEAN default false,
150 p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,
151 p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
152 );
153
154 PROCEDURE get_bld_blk_info_type (
155 p_attribute_name IN hxc_mapping_components.field_name%TYPE,
156 p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
157 p_bld_blk_info_type OUT NOCOPY hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
158 p_segment OUT NOCOPY hxc_mapping_components.SEGMENT%TYPE
159 );
160
161 PROCEDURE clear_building_block_table (
162 p_app_blocks IN OUT NOCOPY hxc_block_table_type
163 );
164
165 PROCEDURE clear_attribute_table (
166 p_app_attributes IN OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
167 );
168
169 PROCEDURE clear_message_table (
170 p_messages IN OUT NOCOPY hxc_message_table_type
171 );
172
173 PROCEDURE request_lock (
174 p_app_blocks IN hxc_block_table_type,
175 p_messages IN OUT NOCOPY hxc_message_table_type,
176 p_locked_success OUT NOCOPY BOOLEAN,
177 p_row_lock_id OUT NOCOPY ROWID
178 );
179
180 PROCEDURE release_lock (
181 p_app_blocks IN hxc_block_table_type,
182 p_messages IN OUT NOCOPY hxc_message_table_type,
183 p_released_success OUT NOCOPY BOOLEAN,
184 p_row_lock_id IN OUT NOCOPY ROWID
185 );
186
187 PROCEDURE log_timecard (
188 p_app_blocks IN hxc_block_table_type,
189 p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
190 );
191
192 PROCEDURE log_timecard (
193 p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
194 p_app_attributes IN hxc_self_service_time_deposit.app_attributes_info
195 );
196
197 PROCEDURE log_messages (p_messages IN hxc_message_table_type);
198
199 PROCEDURE log_messages (
200 p_messages IN hxc_self_service_time_deposit.message_table
201 );
202
203 FUNCTION translate_message_table (
204 p_messages IN hxc_self_service_time_deposit.message_table
205 )
206 RETURN translated_message_table;
207
208 PROCEDURE find_current_period (
209 p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
210 p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
211 p_day IN hxc_time_building_blocks.start_time%TYPE,
212 p_start_time OUT NOCOPY DATE,
213 p_stop_time OUT NOCOPY DATE
214 );
215
216 FUNCTION cla_enabled (
217 p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
218 )
219 RETURN BOOLEAN;
220
221 -- Procedure added for bug 8900783
222 PROCEDURE get_past_future_limits (
223 p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
224 p_timecard_start_time IN date,
225 p_timecard_stop_time IN date,
226 p_messages IN OUT NOCOPY hxc_message_table_type
227 );
228
229
230 END hxc_timestore_deposit_util;