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