DBA Data[Home] [Help]

APPS.HXC_TIMECARD_DEPOSIT_COMMON dependencies on HXC_TIMECARD

Line 1: PACKAGE body hxc_timecard_deposit_common AS

1: PACKAGE body hxc_timecard_deposit_common AS
2: /* $Header: hxctcdpcommon.pkb 115.2 2003/07/25 10:38:34 jdupont noship $ */
3:
4: g_package varchar2(50) := 'hxc_timecard_deposit_common';
5:

Line 4: g_package varchar2(50) := 'hxc_timecard_deposit_common';

1: PACKAGE body hxc_timecard_deposit_common AS
2: /* $Header: hxctcdpcommon.pkb 115.2 2003/07/25 10:38:34 jdupont noship $ */
3:
4: g_package varchar2(50) := 'hxc_timecard_deposit_common';
5:
6: /**************************************************************************
7: Alias Translator Procedure
8: This procedure....

Line 23: hxc_timecard_attribute_utils.set_bld_blk_info_type_id(p_attributes);

19: l_proc varchar2(80) := g_package||'.alias_translation';
20:
21: Begin
22:
23: hxc_timecard_attribute_utils.set_bld_blk_info_type_id(p_attributes);
24:
25: HXC_ALIAS_TRANSLATOR.DO_DEPOSIT_TRANSLATION
26: (p_attributes => p_attributes
27: ,p_messages => p_messages

Line 61: hxc_timecard_message_helper.addErrorToCollection

57: open c_deposit_process;
58: fetch c_deposit_process into l_deposit_process_id;
59: if(c_deposit_process%notfound) then
60: close c_deposit_process;
61: hxc_timecard_message_helper.addErrorToCollection
62: (p_messages
63: ,'HXC_NO_OTL_DEPOSIT_PROC'
64: ,hxc_timecard.c_error
65: ,null

Line 64: ,hxc_timecard.c_error

60: close c_deposit_process;
61: hxc_timecard_message_helper.addErrorToCollection
62: (p_messages
63: ,'HXC_NO_OTL_DEPOSIT_PROC'
64: ,hxc_timecard.c_error
65: ,null
66: ,null
67: ,hxc_timecard.c_hxc
68: ,null

Line 67: ,hxc_timecard.c_hxc

63: ,'HXC_NO_OTL_DEPOSIT_PROC'
64: ,hxc_timecard.c_error
65: ,null
66: ,null
67: ,hxc_timecard.c_hxc
68: ,null
69: ,null
70: ,null
71: ,null

Line 85: l_old_blocks := hxc_timecard_block_utils.convert_to_dpwr_blocks

81: ,p_retrieval_process_id => null
82: ,p_deposit_process_id => l_deposit_process_id
83: );
84:
85: l_old_blocks := hxc_timecard_block_utils.convert_to_dpwr_blocks
86: (p_blocks => p_blocks);
87:
88: l_old_attributes := hxc_timecard_attribute_utils.convert_to_dpwr_attributes
89: (p_attributes => p_attributes);

Line 88: l_old_attributes := hxc_timecard_attribute_utils.convert_to_dpwr_attributes

84:
85: l_old_blocks := hxc_timecard_block_utils.convert_to_dpwr_blocks
86: (p_blocks => p_blocks);
87:
88: l_old_attributes := hxc_timecard_attribute_utils.convert_to_dpwr_attributes
89: (p_attributes => p_attributes);
90:
91: hxc_timecard_message_utils.append_old_messages
92: (p_messages => p_messages

Line 91: hxc_timecard_message_utils.append_old_messages

87:
88: l_old_attributes := hxc_timecard_attribute_utils.convert_to_dpwr_attributes
89: (p_attributes => p_attributes);
90:
91: hxc_timecard_message_utils.append_old_messages
92: (p_messages => p_messages
93: ,p_old_messages => l_old_messages
94: ,p_retrieval_process_id => null
95: );

Line 130: l_blocks(l_block_count) := hxc_timecard_block_utils.build_block

126: Begin
127:
128: for block_rec in c_blocks(p_timecard_id) loop
129: l_blocks.extend;
130: l_blocks(l_block_count) := hxc_timecard_block_utils.build_block
131: (block_rec.time_building_block_id
132: ,block_rec.object_version_number);
133: --
134: -- Date effectively end date the block

Line 175: l_attributes(l_attribute_index) := hxc_timecard_attribute_utils.build_attribute

171: loop
172: exit when not p_blocks.exists(l_block_index);
173: for attribute_rec in c_attributes(p_blocks(l_block_index).time_building_block_id,p_blocks(l_block_index).object_version_number) loop
174: l_attributes.extend;
175: l_attributes(l_attribute_index) := hxc_timecard_attribute_utils.build_attribute
176: (attribute_rec.time_attribute_id
177: ,1
178: ,p_blocks(l_block_index).time_building_block_id
179: ,p_blocks(l_block_index).object_version_number

Line 211: l_timecard_blocks hxc_timecard.block_list;

207: l_blocks hxc_block_table_type := hxc_block_table_type();
208: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
209: l_messages hxc_message_table_type := hxc_message_table_type();
210:
211: l_timecard_blocks hxc_timecard.block_list;
212: l_day_blocks hxc_timecard.block_list;
213: l_detail_blocks hxc_timecard.block_list;
214:
215: l_transaction_info hxc_timecard.transaction_info;

Line 212: l_day_blocks hxc_timecard.block_list;

208: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
209: l_messages hxc_message_table_type := hxc_message_table_type();
210:
211: l_timecard_blocks hxc_timecard.block_list;
212: l_day_blocks hxc_timecard.block_list;
213: l_detail_blocks hxc_timecard.block_list;
214:
215: l_transaction_info hxc_timecard.transaction_info;
216: l_timecard_props hxc_timecard_prop_table_type;

Line 213: l_detail_blocks hxc_timecard.block_list;

209: l_messages hxc_message_table_type := hxc_message_table_type();
210:
211: l_timecard_blocks hxc_timecard.block_list;
212: l_day_blocks hxc_timecard.block_list;
213: l_detail_blocks hxc_timecard.block_list;
214:
215: l_transaction_info hxc_timecard.transaction_info;
216: l_timecard_props hxc_timecard_prop_table_type;
217:

Line 215: l_transaction_info hxc_timecard.transaction_info;

211: l_timecard_blocks hxc_timecard.block_list;
212: l_day_blocks hxc_timecard.block_list;
213: l_detail_blocks hxc_timecard.block_list;
214:
215: l_transaction_info hxc_timecard.transaction_info;
216: l_timecard_props hxc_timecard_prop_table_type;
217:
218: l_dummy boolean := true;
219:

Line 216: l_timecard_props hxc_timecard_prop_table_type;

212: l_day_blocks hxc_timecard.block_list;
213: l_detail_blocks hxc_timecard.block_list;
214:
215: l_transaction_info hxc_timecard.transaction_info;
216: l_timecard_props hxc_timecard_prop_table_type;
217:
218: l_dummy boolean := true;
219:
220: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

Line 244: hxc_timecard_message_helper.initializeErrors;

240: -- Initialize the message stack
241: --
242:
243: fnd_msg_pub.initialize;
244: hxc_timecard_message_helper.initializeErrors;
245: --
246: -- Get the timecard or timecard template blocks and attributes
247: --
248:

Line 256: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);

252: --
253: -- Main delete processing
254: --
255:
256: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
257:
258: hxc_timecard_properties.get_preference_properties
259: (p_validate => hxc_timecard.c_yes
260: ,p_resource_id => l_blocks(l_timecard_index).resource_id

Line 258: hxc_timecard_properties.get_preference_properties

254: --
255:
256: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
257:
258: hxc_timecard_properties.get_preference_properties
259: (p_validate => hxc_timecard.c_yes
260: ,p_resource_id => l_blocks(l_timecard_index).resource_id
261: ,p_timecard_start_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).start_time)
262: ,p_timecard_stop_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).stop_time)

Line 259: (p_validate => hxc_timecard.c_yes

255:
256: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
257:
258: hxc_timecard_properties.get_preference_properties
259: (p_validate => hxc_timecard.c_yes
260: ,p_resource_id => l_blocks(l_timecard_index).resource_id
261: ,p_timecard_start_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).start_time)
262: ,p_timecard_stop_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).stop_time)
263: ,p_for_timecard => false

Line 268: hxc_timecard_message_helper.processerrors

264: ,p_messages => l_messages
265: ,p_property_table => l_timecard_props
266: );
267:
268: hxc_timecard_message_helper.processerrors
269: (p_messages => l_messages);
270:
271: l_messages.delete;
272:

Line 273: hxc_timecard_block_utils.sort_blocks

269: (p_messages => l_messages);
270:
271: l_messages.delete;
272:
273: hxc_timecard_block_utils.sort_blocks
274: (p_blocks => l_blocks
275: ,p_timecard_blocks => l_timecard_blocks
276: ,p_day_blocks => l_day_blocks
277: ,p_detail_blocks => l_detail_blocks

Line 285: hxc_timecard_validation.deposit_validation

281: (p_blocks => l_blocks
282: ,p_attributes => l_attributes
283: );
284:
285: hxc_timecard_validation.deposit_validation
286: (p_blocks => l_blocks
287: ,p_attributes => l_attributes
288: ,p_messages => l_messages
289: ,p_props => l_timecard_props

Line 290: ,p_deposit_mode => hxc_timecard.c_submit

286: (p_blocks => l_blocks
287: ,p_attributes => l_attributes
288: ,p_messages => l_messages
289: ,p_props => l_timecard_props
290: ,p_deposit_mode => hxc_timecard.c_submit
291: ,p_template => p_template
292: ,p_resubmit => c_delete
293: ,p_can_deposit => l_dummy
294: );

Line 296: hxc_timecard_message_helper.processerrors

292: ,p_resubmit => c_delete
293: ,p_can_deposit => l_dummy
294: );
295:
296: hxc_timecard_message_helper.processerrors
297: (p_messages => l_messages);
298:
299: hxc_timecard_deposit.execute
300: (p_blocks => l_blocks

Line 299: hxc_timecard_deposit.execute

295:
296: hxc_timecard_message_helper.processerrors
297: (p_messages => l_messages);
298:
299: hxc_timecard_deposit.execute
300: (p_blocks => l_blocks
301: ,p_attributes => l_attributes
302: ,p_timecard_blocks => l_timecard_blocks
303: ,p_day_blocks => l_day_blocks

Line 308: hxc_timecard_message_helper.processerrors

304: ,p_detail_blocks => l_detail_blocks
305: ,p_messages => l_messages
306: ,p_transaction_info => l_transaction_info
307: );
308: hxc_timecard_message_helper.processerrors
309: (p_messages => l_messages);
310:
311: hxc_timecard_summary_api.delete_timecard
312: (p_blocks => l_blocks

Line 311: hxc_timecard_summary_api.delete_timecard

307: );
308: hxc_timecard_message_helper.processerrors
309: (p_messages => l_messages);
310:
311: hxc_timecard_summary_api.delete_timecard
312: (p_blocks => l_blocks
313: ,p_timecard_id => p_timecard_id
314: );
315:

Line 316: hxc_timecard_audit.audit_deposit

312: (p_blocks => l_blocks
313: ,p_timecard_id => p_timecard_id
314: );
315:
316: hxc_timecard_audit.audit_deposit
317: (p_transaction_info => l_transaction_info
318: ,p_messages => l_messages
319: );
320: hxc_timecard_message_helper.processerrors

Line 320: hxc_timecard_message_helper.processerrors

316: hxc_timecard_audit.audit_deposit
317: (p_transaction_info => l_transaction_info
318: ,p_messages => l_messages
319: );
320: hxc_timecard_message_helper.processerrors
321: (p_messages => l_messages);
322:
323: hxc_timecard_message_helper.prepareErrors;
324:

Line 323: hxc_timecard_message_helper.prepareErrors;

319: );
320: hxc_timecard_message_helper.processerrors
321: (p_messages => l_messages);
322:
323: hxc_timecard_message_helper.prepareErrors;
324:
325: End delete_timecard;
326:
327: END hxc_timecard_deposit_common;

Line 327: END hxc_timecard_deposit_common;

323: hxc_timecard_message_helper.prepareErrors;
324:
325: End delete_timecard;
326:
327: END hxc_timecard_deposit_common;