eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIMEKEEPER dependencies on HXC_TIMECARD

Line 118: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

114: ) is
115:
116:
117: cursor c_previous_timecard(
118: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
119: select tk_audit_item_key,tk_audit_item_type
120: from hxc_timecard_summary
121: where timecard_id = p_timecard_id;
122:

Line 120: from hxc_timecard_summary

116:
117: cursor c_previous_timecard(
118: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
119: select tk_audit_item_key,tk_audit_item_type
120: from hxc_timecard_summary
121: where timecard_id = p_timecard_id;
122:
123: l_timecard_blocks hxc_timecard.block_list;
124: l_day_blocks hxc_timecard.block_list;

Line 123: l_timecard_blocks hxc_timecard.block_list;

119: select tk_audit_item_key,tk_audit_item_type
120: from hxc_timecard_summary
121: where timecard_id = p_timecard_id;
122:
123: l_timecard_blocks hxc_timecard.block_list;
124: l_day_blocks hxc_timecard.block_list;
125: l_detail_blocks hxc_timecard.block_list;
126: l_transaction_info hxc_timecard.transaction_info;
127: l_timecard_props hxc_timecard_prop_table_type;

Line 124: l_day_blocks hxc_timecard.block_list;

120: from hxc_timecard_summary
121: where timecard_id = p_timecard_id;
122:
123: l_timecard_blocks hxc_timecard.block_list;
124: l_day_blocks hxc_timecard.block_list;
125: l_detail_blocks hxc_timecard.block_list;
126: l_transaction_info hxc_timecard.transaction_info;
127: l_timecard_props hxc_timecard_prop_table_type;
128: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';

Line 125: l_detail_blocks hxc_timecard.block_list;

121: where timecard_id = p_timecard_id;
122:
123: l_timecard_blocks hxc_timecard.block_list;
124: l_day_blocks hxc_timecard.block_list;
125: l_detail_blocks hxc_timecard.block_list;
126: l_transaction_info hxc_timecard.transaction_info;
127: l_timecard_props hxc_timecard_prop_table_type;
128: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';
129: l_timecard_index number;

Line 126: l_transaction_info hxc_timecard.transaction_info;

122:
123: l_timecard_blocks hxc_timecard.block_list;
124: l_day_blocks hxc_timecard.block_list;
125: l_detail_blocks hxc_timecard.block_list;
126: l_transaction_info hxc_timecard.transaction_info;
127: l_timecard_props hxc_timecard_prop_table_type;
128: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';
129: l_timecard_index number;
130:

Line 127: l_timecard_props hxc_timecard_prop_table_type;

123: l_timecard_blocks hxc_timecard.block_list;
124: l_day_blocks hxc_timecard.block_list;
125: l_detail_blocks hxc_timecard.block_list;
126: l_transaction_info hxc_timecard.transaction_info;
127: l_timecard_props hxc_timecard_prop_table_type;
128: l_proc varchar2(50) := g_package||'.SAVE_CONTROLLER';
129: l_timecard_index number;
130:
131: l_old_style_blks hxc_self_service_time_deposit.timecard_info;

Line 135: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;

131: l_old_style_blks hxc_self_service_time_deposit.timecard_info;
132: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
133: l_old_messages hxc_self_service_time_deposit.message_table;
134:
135: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;
136:
137: l_rollback BOOLEAN := FALSE;
138: l_status_error BOOLEAN := FALSE;
139: e_timekeeper_check EXCEPTION;

Line 143: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

139: e_timekeeper_check EXCEPTION;
140:
141: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
142:
143: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
144: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
145:
146: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
147: tk_audit_process_name VARCHAR2(50) :=NULL;

Line 144: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

140:
141: l_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
142:
143: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
144: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
145:
146: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
147: tk_audit_process_name VARCHAR2(50) :=NULL;
148:

Line 166: hxc_timecard_message_helper.initializeerrors;

162: */
163: ----------------------------------------------------------------------------
164: -- Timecard Preparation
165: ----------------------------------------------------------------------------
166: hxc_timecard_message_helper.initializeerrors;
167:
168: p_messages := hxc_message_table_type ();
169:
170: hxc_timecard_block_utils.initialize_timecard_index;

Line 170: hxc_timecard_block_utils.initialize_timecard_index;

166: hxc_timecard_message_helper.initializeerrors;
167:
168: p_messages := hxc_message_table_type ();
169:
170: hxc_timecard_block_utils.initialize_timecard_index;
171:
172: --
173: -- Check input parameters
174: --

Line 178: ,p_deposit_mode => hxc_timecard_deposit_common.c_save

174: --
175: hxc_deposit_checks.check_inputs
176: (p_blocks => p_blocks
177: ,p_attributes => p_attributes
178: ,p_deposit_mode => hxc_timecard_deposit_common.c_save
179: ,p_template => hxc_timecard_deposit_common.c_no
180: ,p_messages => p_messages
181: );
182: /*

Line 179: ,p_template => hxc_timecard_deposit_common.c_no

175: hxc_deposit_checks.check_inputs
176: (p_blocks => p_blocks
177: ,p_attributes => p_attributes
178: ,p_deposit_mode => hxc_timecard_deposit_common.c_save
179: ,p_template => hxc_timecard_deposit_common.c_no
180: ,p_messages => p_messages
181: );
182: /*
183: -- debug

Line 188: hxc_timecard_message_helper.processerrors

184: IF g_debug THEN
185: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',20);
186: END IF;
187: */
188: hxc_timecard_message_helper.processerrors
189: (p_messages => p_messages);
190:
191: --
192: -- First we are getting the preference

Line 196: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

192: -- First we are getting the preference
193: -- for the resource of the timecard
194: --
195:
196: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
197:
198: -- this procedure has the otl setup validation
199: hxc_timecard_properties.get_preference_properties
200: (p_validate => hxc_timecard_deposit_common.c_yes

Line 199: hxc_timecard_properties.get_preference_properties

195:
196: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
197:
198: -- this procedure has the otl setup validation
199: hxc_timecard_properties.get_preference_properties
200: (p_validate => hxc_timecard_deposit_common.c_yes
201: ,p_resource_id => p_blocks(l_timecard_index).resource_id
202: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
203: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)

Line 200: (p_validate => hxc_timecard_deposit_common.c_yes

196: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
197:
198: -- this procedure has the otl setup validation
199: hxc_timecard_properties.get_preference_properties
200: (p_validate => hxc_timecard_deposit_common.c_yes
201: ,p_resource_id => p_blocks(l_timecard_index).resource_id
202: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
203: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)
204: ,p_for_timecard => false

Line 214: hxc_timecard_message_helper.processerrors

210: IF g_debug THEN
211: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',30);
212: END IF;
213: */
214: hxc_timecard_message_helper.processerrors
215: (p_messages => p_messages);
216:
217: --
218: -- Sort blocks

Line 220: hxc_timecard_block_utils.sort_blocks

216:
217: --
218: -- Sort blocks
219: --
220: hxc_timecard_block_utils.sort_blocks
221: (p_blocks => p_blocks
222: ,p_timecard_blocks => l_timecard_blocks
223: ,p_day_blocks => l_day_blocks
224: ,p_detail_blocks => l_detail_blocks

Line 247: hxc_timecard_message_helper.processerrors

243: IF g_debug THEN
244: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',40);
245: END IF;
246: */
247: hxc_timecard_message_helper.processerrors
248: (p_messages => p_messages);
249:
250: ----------------------------------------------------------------------------
251: -- Timecard Preparation

Line 265: hxc_timecard_message_helper.processerrors

261: ,p_timecard_props => l_timecard_props
262: ,p_messages => p_messages
263: );
264:
265: hxc_timecard_message_helper.processerrors
266: (p_messages => p_messages);
267: --
268: -- Translate any aliases
269: --

Line 270: hxc_timecard_deposit_common.alias_translation

266: (p_messages => p_messages);
267: --
268: -- Translate any aliases
269: --
270: hxc_timecard_deposit_common.alias_translation
271: (p_blocks => p_blocks
272: ,p_attributes => p_attributes
273: ,p_messages => p_messages
274: );

Line 281: hxc_timecard_message_helper.processerrors

277: IF g_debug THEN
278: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',50);
279: END IF;
280: */
281: hxc_timecard_message_helper.processerrors
282: (p_messages => p_messages);
283:
284: --
285: -- Set the block and attribute update process flags

Line 297: hxc_timecard_attribute_utils.remove_deleted_attributes

293: --
294: -- Removed any deleted attributes
295: --
296:
297: hxc_timecard_attribute_utils.remove_deleted_attributes
298: (p_attributes => p_attributes);
299:
300: remove_blank_attribute_rows (p_attributes => p_attributes);
301:

Line 309: hxc_timecard_deposit_common.validate_setup

305: --
306: -- Validate the set up for the user
307: --
308: /*
309: hxc_timecard_deposit_common.validate_setup
310: (p_deposit_mode => hxc_timecard.c_save
311: ,p_blocks => p_blocks
312: ,p_attributes => p_attributes
313: ,p_messages => p_messages

Line 310: (p_deposit_mode => hxc_timecard.c_save

306: -- Validate the set up for the user
307: --
308: /*
309: hxc_timecard_deposit_common.validate_setup
310: (p_deposit_mode => hxc_timecard.c_save
311: ,p_blocks => p_blocks
312: ,p_attributes => p_attributes
313: ,p_messages => p_messages
314: );

Line 321: hxc_timecard_message_helper.processerrors

317: IF g_debug THEN
318: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',60);
319: END IF;
320:
321: hxc_timecard_message_helper.processerrors
322: (p_messages => p_messages);
323: */
324: /*
325: Call time entry rules for save

Line 329: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks

325: Call time entry rules for save
326: */
327:
328: /*
329: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks
330: (p_blocks);
331:
332: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
333: (p_attributes);

Line 332: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes

328: /*
329: l_old_style_blks := HXC_TIMECARD_BLOCK_UTILS.convert_to_dpwr_blocks
330: (p_blocks);
331:
332: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
333: (p_attributes);
334:
335: HXC_TIME_ENTRY_RULES_UTILS_PKG.EXECUTE_TIME_ENTRY_RULES
336: (P_OPERATION => hxc_timecard_deposit_common.c_save

Line 336: (P_OPERATION => hxc_timecard_deposit_common.c_save

332: l_old_style_attrs := HXC_TIMECARD_ATTRIBUTE_UTILS.convert_to_dpwr_attributes
333: (p_attributes);
334:
335: HXC_TIME_ENTRY_RULES_UTILS_PKG.EXECUTE_TIME_ENTRY_RULES
336: (P_OPERATION => hxc_timecard_deposit_common.c_save
337: ,P_TIME_BUILDING_BLOCKS => l_old_style_blks
338: ,P_TIME_ATTRIBUTES => l_old_style_attrs
339: ,P_MESSAGES => l_old_messages
340: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no

Line 340: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no

336: (P_OPERATION => hxc_timecard_deposit_common.c_save
337: ,P_TIME_BUILDING_BLOCKS => l_old_style_blks
338: ,P_TIME_ATTRIBUTES => l_old_style_attrs
339: ,P_MESSAGES => l_old_messages
340: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no
341: );
342:
343: hxc_timecard_message_utils.append_old_messages
344: (p_messages => p_messages

Line 343: hxc_timecard_message_utils.append_old_messages

339: ,P_MESSAGES => l_old_messages
340: ,P_RESUBMIT => hxc_timecard_deposit_common.c_no
341: );
342:
343: hxc_timecard_message_utils.append_old_messages
344: (p_messages => p_messages
345: ,p_old_messages => l_old_messages
346: ,p_retrieval_process_id => null
347: );

Line 349: hxc_timecard_message_helper.processerrors

345: ,p_old_messages => l_old_messages
346: ,p_retrieval_process_id => null
347: );
348:
349: hxc_timecard_message_helper.processerrors
350: (p_messages => p_messages);
351: */
352:
353: --

Line 356: hxc_timecard_validation.recipients_update_validation

352:
353: --
354: -- call the application validation
355: --
356: hxc_timecard_validation.recipients_update_validation
357: (p_blocks => p_blocks
358: ,p_attributes => p_attributes
359: ,p_messages => p_messages
360: ,p_props => l_timecard_props

Line 361: ,p_deposit_mode => hxc_timecard_deposit_common.c_save

357: (p_blocks => p_blocks
358: ,p_attributes => p_attributes
359: ,p_messages => p_messages
360: ,p_props => l_timecard_props
361: ,p_deposit_mode => hxc_timecard_deposit_common.c_save
362: ,p_resubmit => l_resubmit);
363:
364: /* fix for bug 6130457 */
365:

Line 373: hxc_timecard_block_utils.sort_blocks

369:
370: /* end of fix for bug 6130457 */
371:
372: /* fix by senthil for bug 5099360*/
373: hxc_timecard_block_utils.sort_blocks
374: (p_blocks => p_blocks
375: ,p_timecard_blocks => l_timecard_blocks
376: ,p_day_blocks => l_day_blocks
377: ,p_detail_blocks => l_detail_blocks

Line 381: hxc_timecard_message_helper.processerrors

377: ,p_detail_blocks => l_detail_blocks
378: );
379: /* end of fix for bug 5099360*/
380:
381: hxc_timecard_message_helper.processerrors
382: (p_messages => p_messages);
383:
384: hxc_timecard_validation.data_set_validation
385: (p_blocks => p_blocks

Line 384: hxc_timecard_validation.data_set_validation

380:
381: hxc_timecard_message_helper.processerrors
382: (p_messages => p_messages);
383:
384: hxc_timecard_validation.data_set_validation
385: (p_blocks => p_blocks
386: ,p_messages => p_messages
387: );
388:

Line 389: hxc_timecard_message_helper.processerrors

385: (p_blocks => p_blocks
386: ,p_messages => p_messages
387: );
388:
389: hxc_timecard_message_helper.processerrors
390: (p_messages => p_messages);
391:
392: --
393: -- At this point of the process

Line 397: p_messages := hxc_timecard_message_helper.getMessages;

393: -- At this point of the process
394: -- we know if the timecard needs to be in error.
395: --
396: -- get all the errors
397: p_messages := hxc_timecard_message_helper.getMessages;
398: /*
399: -- debug
400: IF g_debug THEN
401: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);

Line 431: hxc_timecard_deposit.execute

427: -- in order to main the -ve ids
428: -- at this point p_messages is not delete
429: -- so we still have the full message structures
430:
431: hxc_timecard_deposit.execute
432: (p_blocks => p_blocks
433: ,p_attributes => p_attributes
434: ,p_timecard_blocks => l_timecard_blocks
435: ,p_day_blocks => l_day_blocks

Line 442: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

438: ,p_transaction_info => l_transaction_info
439: );
440:
441: p_timecard_id :=
442: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
443: p_timecard_ovn:=
444: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
445:
446: hxc_timecard_audit.maintain_latest_details

Line 444: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

440:
441: p_timecard_id :=
442: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
443: p_timecard_ovn:=
444: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
445:
446: hxc_timecard_audit.maintain_latest_details
447: (p_blocks => p_blocks );
448:

Line 446: hxc_timecard_audit.maintain_latest_details

442: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
443: p_timecard_ovn:=
444: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
445:
446: hxc_timecard_audit.maintain_latest_details
447: (p_blocks => p_blocks );
448:
449:
450: IF p_timekeeper_id IS NOT NULL and

Line 472: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id

468: l_item_key :=
469: hxc_timekeeper_wf_pkg.begin_audit_process
470: (p_timecard_id => p_timecard_id
471: ,p_timecard_ovn => p_timecard_ovn
472: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id
473: ,p_timekeeper_id => p_timekeeper_id
474: ,p_tk_audit_enabled => p_tk_audit_enabled
475: ,p_tk_notify_to => p_tk_notify_to
476: ,p_tk_notify_type => p_tk_notify_type

Line 486: --hxc_timecard_message_helper.processerrors

482: tk_audit_process_name := 'HXC_TK_AUDIT_PROCESS';
483: tk_audit_item_type := 'HXCTKWF';
484: END IF;
485:
486: --hxc_timecard_message_helper.processerrors
487: --(p_messages => p_messages);
488:
489: --
490: -- Maintain summary table

Line 493: hxc_timecard_summary_api.timecard_deposit

489: --
490: -- Maintain summary table
491: --
492:
493: hxc_timecard_summary_api.timecard_deposit
494: (p_blocks => p_blocks
495: ,p_approval_item_type => NULL
496: ,p_approval_process_name => NULL
497: ,p_approval_item_key => NULL

Line 503: hxc_timecard_audit.audit_deposit

499: ,p_tk_audit_process_name => tk_audit_process_name
500: ,p_tk_audit_item_key => l_item_key
501: );
502:
503: hxc_timecard_audit.audit_deposit
504: (p_transaction_info => l_transaction_info
505: ,p_messages => p_messages
506: );
507:

Line 512: -- p_messages := hxc_timecard_message_helper.getMessages;

508: --
509: -- store error
510: --
511: -- get all the errors
512: -- p_messages := hxc_timecard_message_helper.getMessages;
513: /*
514: if g_debug THEN
515: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
516: end if;

Line 533: hxc_timecard_message_helper.prepareErrors;

529: --dbms_profiler.stop_profiler;
530:
531: EXCEPTION
532: WHEN e_timekeeper_check then
533: hxc_timecard_message_helper.prepareErrors;
534: rollback;
535:
536: End save_timecard;
537:

Line 557: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

553: ,p_tk_notify_type in VARCHAR2 DEFAULT NULL
554: ) IS
555:
556: cursor c_previous_timecard(
557: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
558: select tk_audit_item_key,tk_audit_item_type
559: from hxc_timecard_summary
560: where timecard_id = p_timecard_id;
561:

Line 559: from hxc_timecard_summary

555:
556: cursor c_previous_timecard(
557: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
558: select tk_audit_item_key,tk_audit_item_type
559: from hxc_timecard_summary
560: where timecard_id = p_timecard_id;
561:
562:
563: l_timecard_blocks hxc_timecard.block_list;

Line 563: l_timecard_blocks hxc_timecard.block_list;

559: from hxc_timecard_summary
560: where timecard_id = p_timecard_id;
561:
562:
563: l_timecard_blocks hxc_timecard.block_list;
564: l_day_blocks hxc_timecard.block_list;
565: l_detail_blocks hxc_timecard.block_list;
566: l_transaction_info hxc_timecard.transaction_info;
567: l_timecard_props hxc_timecard_prop_table_type;

Line 564: l_day_blocks hxc_timecard.block_list;

560: where timecard_id = p_timecard_id;
561:
562:
563: l_timecard_blocks hxc_timecard.block_list;
564: l_day_blocks hxc_timecard.block_list;
565: l_detail_blocks hxc_timecard.block_list;
566: l_transaction_info hxc_timecard.transaction_info;
567: l_timecard_props hxc_timecard_prop_table_type;
568:

Line 565: l_detail_blocks hxc_timecard.block_list;

561:
562:
563: l_timecard_blocks hxc_timecard.block_list;
564: l_day_blocks hxc_timecard.block_list;
565: l_detail_blocks hxc_timecard.block_list;
566: l_transaction_info hxc_timecard.transaction_info;
567: l_timecard_props hxc_timecard_prop_table_type;
568:
569: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';

Line 566: l_transaction_info hxc_timecard.transaction_info;

562:
563: l_timecard_blocks hxc_timecard.block_list;
564: l_day_blocks hxc_timecard.block_list;
565: l_detail_blocks hxc_timecard.block_list;
566: l_transaction_info hxc_timecard.transaction_info;
567: l_timecard_props hxc_timecard_prop_table_type;
568:
569: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';
570: l_can_deposit boolean := true;

Line 567: l_timecard_props hxc_timecard_prop_table_type;

563: l_timecard_blocks hxc_timecard.block_list;
564: l_day_blocks hxc_timecard.block_list;
565: l_detail_blocks hxc_timecard.block_list;
566: l_transaction_info hxc_timecard.transaction_info;
567: l_timecard_props hxc_timecard_prop_table_type;
568:
569: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';
570: l_can_deposit boolean := true;
571: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;

Line 571: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;

567: l_timecard_props hxc_timecard_prop_table_type;
568:
569: l_proc varchar2(50) := g_package||'.SUBMIT_TIMECARD';
570: l_can_deposit boolean := true;
571: l_resubmit varchar2(10) := hxc_timecard_deposit_common.c_no;
572: l_timecard_index number;
573:
574: l_rollback BOOLEAN := FALSE;
575:

Line 583: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

579: tk_item_key WF_ITEMS.ITEM_KEY%TYPE :=NULL;
580: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
581: tk_audit_process_name VARCHAR2(50) :=NULL;
582:
583: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
584: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
585:
586:
587: BEGIN

Line 584: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

580: tk_audit_item_type WF_ITEMS.ITEM_TYPE%TYPE :=NULL;
581: tk_audit_process_name VARCHAR2(50) :=NULL;
582:
583: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
584: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
585:
586:
587: BEGIN
588:

Line 598: hxc_timecard_block_utils.initialize_timecard_index;

594: ----------------------------------------------------------------------------
595: -- Timecard Preparation
596: ----------------------------------------------------------------------------
597:
598: hxc_timecard_block_utils.initialize_timecard_index;
599:
600: hxc_timecard_message_helper.initializeerrors;
601:
602: p_messages := hxc_message_table_type ();

Line 600: hxc_timecard_message_helper.initializeerrors;

596: ----------------------------------------------------------------------------
597:
598: hxc_timecard_block_utils.initialize_timecard_index;
599:
600: hxc_timecard_message_helper.initializeerrors;
601:
602: p_messages := hxc_message_table_type ();
603:
604: --

Line 611: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

607:
608: hxc_deposit_checks.check_inputs
609: (p_blocks => p_blocks
610: ,p_attributes => p_attributes
611: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
612: ,p_template => hxc_timecard_deposit_common.c_no
613: ,p_messages => p_messages
614: );
615:

Line 612: ,p_template => hxc_timecard_deposit_common.c_no

608: hxc_deposit_checks.check_inputs
609: (p_blocks => p_blocks
610: ,p_attributes => p_attributes
611: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
612: ,p_template => hxc_timecard_deposit_common.c_no
613: ,p_messages => p_messages
614: );
615:
616: hxc_timecard_message_helper.processerrors

Line 616: hxc_timecard_message_helper.processerrors

612: ,p_template => hxc_timecard_deposit_common.c_no
613: ,p_messages => p_messages
614: );
615:
616: hxc_timecard_message_helper.processerrors
617: (p_messages => p_messages);
618:
619: --
620: -- Determine if this is a resubmitted timecard

Line 622: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

618:
619: --
620: -- Determine if this is a resubmitted timecard
621: --
622: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
623:
624: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)
625: = hr_general.end_of_time)
626: then

Line 624: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)

620: -- Determine if this is a resubmitted timecard
621: --
622: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
623:
624: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)
625: = hr_general.end_of_time)
626: then
627: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
628: (p_blocks(l_timecard_index).time_building_block_id

Line 627: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted

623:
624: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to)
625: = hr_general.end_of_time)
626: then
627: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
628: (p_blocks(l_timecard_index).time_building_block_id
629: ,p_blocks(l_timecard_index).object_version_number
630: ,p_blocks(l_timecard_index).resource_id
631: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)

Line 631: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)

627: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
628: (p_blocks(l_timecard_index).time_building_block_id
629: ,p_blocks(l_timecard_index).object_version_number
630: ,p_blocks(l_timecard_index).resource_id
631: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
632: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
633: );
634: else
635: l_resubmit := hxc_timecard_deposit_common.c_delete;

Line 632: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)

628: (p_blocks(l_timecard_index).time_building_block_id
629: ,p_blocks(l_timecard_index).object_version_number
630: ,p_blocks(l_timecard_index).resource_id
631: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
632: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
633: );
634: else
635: l_resubmit := hxc_timecard_deposit_common.c_delete;
636: end if;

Line 635: l_resubmit := hxc_timecard_deposit_common.c_delete;

631: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
632: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
633: );
634: else
635: l_resubmit := hxc_timecard_deposit_common.c_delete;
636: end if;
637:
638: --
639: -- Obtain the timecard properties

Line 646: hxc_timecard_properties.get_preference_properties

642: -- middle tier, to avoid another
643: -- pref evaluation
644: --
645:
646: hxc_timecard_properties.get_preference_properties
647: (p_validate => hxc_timecard_deposit_common.c_yes
648: ,p_resource_id => p_blocks(l_timecard_index).resource_id
649: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
650: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)

Line 647: (p_validate => hxc_timecard_deposit_common.c_yes

643: -- pref evaluation
644: --
645:
646: hxc_timecard_properties.get_preference_properties
647: (p_validate => hxc_timecard_deposit_common.c_yes
648: ,p_resource_id => p_blocks(l_timecard_index).resource_id
649: ,p_timecard_start_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).start_time)
650: ,p_timecard_stop_time => fnd_date.canonical_to_date(p_blocks(l_timecard_index).stop_time)
651: ,p_for_timecard => false

Line 656: hxc_timecard_message_helper.processerrors

652: ,p_messages => p_messages
653: ,p_property_table => l_timecard_props
654: );
655:
656: hxc_timecard_message_helper.processerrors
657: (p_messages => p_messages);
658:
659: --
660: -- Sort the blocks - needed for deposit

Line 664: hxc_timecard_block_utils.sort_blocks

660: -- Sort the blocks - needed for deposit
661: -- and all sorts of short cuts!
662: --
663:
664: hxc_timecard_block_utils.sort_blocks
665: (p_blocks => p_blocks
666: ,p_timecard_blocks => l_timecard_blocks
667: ,p_day_blocks => l_day_blocks
668: ,p_detail_blocks => l_detail_blocks

Line 697: hxc_timecard_message_helper.processerrors

693: ,p_details => l_detail_blocks
694: ,p_messages => p_messages
695: );
696:
697: hxc_timecard_message_helper.processerrors
698: (p_messages => p_messages);
699:
700: --
701: -- Add the security attributes

Line 711: hxc_timecard_message_helper.processerrors

707: p_timecard_props => l_timecard_props,
708: p_messages => p_messages
709: );
710:
711: hxc_timecard_message_helper.processerrors
712: (p_messages => p_messages);
713: --
714: -- Translate any aliases
715: --

Line 716: hxc_timecard_deposit_common.alias_translation

712: (p_messages => p_messages);
713: --
714: -- Translate any aliases
715: --
716: hxc_timecard_deposit_common.alias_translation
717: (p_blocks => p_blocks
718: ,p_attributes => p_attributes
719: ,p_messages => p_messages
720: );

Line 722: hxc_timecard_message_helper.processerrors

718: ,p_attributes => p_attributes
719: ,p_messages => p_messages
720: );
721:
722: hxc_timecard_message_helper.processerrors
723: (p_messages => p_messages);
724:
725: --
726: -- Set the block and attribute update process flags

Line 738: hxc_timecard_attribute_utils.remove_deleted_attributes

734: --
735: -- Removed any deleted attributes
736: --
737:
738: hxc_timecard_attribute_utils.remove_deleted_attributes
739: (p_attributes => p_attributes);
740:
741:
742: --

Line 751: ,p_template => hxc_timecard_deposit_common.c_no

747: ,p_attributes => p_attributes
748: ,p_timecard_props => l_timecard_props
749: ,p_days => l_day_blocks
750: ,p_details => l_detail_blocks
751: ,p_template => hxc_timecard_deposit_common.c_no
752: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
753: ,p_messages => p_messages
754: );
755:

Line 752: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

748: ,p_timecard_props => l_timecard_props
749: ,p_days => l_day_blocks
750: ,p_details => l_detail_blocks
751: ,p_template => hxc_timecard_deposit_common.c_no
752: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
753: ,p_messages => p_messages
754: );
755:
756: --in case of rejected TC again resubmit so remove the error raised

Line 770: hxc_timecard_message_helper.processerrors

766: );
767: END IF;
768:
769:
770: hxc_timecard_message_helper.processerrors
771: (p_messages => p_messages);
772: --
773: -- Validate blocks, attributes
774: --

Line 776: hxc_timecard_validation.deposit_validation

772: --
773: -- Validate blocks, attributes
774: --
775: /*
776: hxc_timecard_validation.deposit_validation
777: (p_blocks => p_blocks
778: ,p_attributes => p_attributes
779: ,p_messages => p_messages
780: ,p_props => l_timecard_props

Line 781: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

777: (p_blocks => p_blocks
778: ,p_attributes => p_attributes
779: ,p_messages => p_messages
780: ,p_props => l_timecard_props
781: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
782: ,p_template => hxc_timecard_deposit_common.c_no
783: ,p_resubmit => l_resubmit
784: ,p_can_deposit => l_can_deposit
785: );

Line 782: ,p_template => hxc_timecard_deposit_common.c_no

778: ,p_attributes => p_attributes
779: ,p_messages => p_messages
780: ,p_props => l_timecard_props
781: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
782: ,p_template => hxc_timecard_deposit_common.c_no
783: ,p_resubmit => l_resubmit
784: ,p_can_deposit => l_can_deposit
785: );
786: */

Line 790: hxc_timecard_validation.recipients_update_validation

786: */
787:
788:
789:
790: hxc_timecard_validation.recipients_update_validation
791: (p_blocks => p_blocks
792: ,p_attributes => p_attributes
793: ,p_messages => p_messages
794: ,p_props => l_timecard_props

Line 795: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit

791: (p_blocks => p_blocks
792: ,p_attributes => p_attributes
793: ,p_messages => p_messages
794: ,p_props => l_timecard_props
795: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
796: ,p_resubmit => l_resubmit);
797:
798: hxc_timecard_message_helper.processerrors
799: (p_messages => p_messages);

Line 798: hxc_timecard_message_helper.processerrors

794: ,p_props => l_timecard_props
795: ,p_deposit_mode => hxc_timecard_deposit_common.c_submit
796: ,p_resubmit => l_resubmit);
797:
798: hxc_timecard_message_helper.processerrors
799: (p_messages => p_messages);
800:
801: hxc_timecard_validation.data_set_validation
802: (p_blocks => p_blocks

Line 801: hxc_timecard_validation.data_set_validation

797:
798: hxc_timecard_message_helper.processerrors
799: (p_messages => p_messages);
800:
801: hxc_timecard_validation.data_set_validation
802: (p_blocks => p_blocks
803: ,p_messages => p_messages
804: );
805:

Line 806: hxc_timecard_message_helper.processerrors

802: (p_blocks => p_blocks
803: ,p_messages => p_messages
804: );
805:
806: hxc_timecard_message_helper.processerrors
807: (p_messages => p_messages);
808:
809:
810: --

Line 816: hxc_timecard_deposit_common.validate_setup

812: -- Do this only for timecards, and not
813: -- for templates.
814: --
815: /*
816: hxc_timecard_deposit_common.validate_setup
817: (p_deposit_mode => hxc_timecard_deposit_common.c_submit
818: ,p_blocks => p_blocks
819: ,p_attributes => p_attributes
820: ,p_messages => p_messages

Line 817: (p_deposit_mode => hxc_timecard_deposit_common.c_submit

813: -- for templates.
814: --
815: /*
816: hxc_timecard_deposit_common.validate_setup
817: (p_deposit_mode => hxc_timecard_deposit_common.c_submit
818: ,p_blocks => p_blocks
819: ,p_attributes => p_attributes
820: ,p_messages => p_messages
821: );

Line 823: hxc_timecard_message_helper.processerrors

819: ,p_attributes => p_attributes
820: ,p_messages => p_messages
821: );
822:
823: hxc_timecard_message_helper.processerrors
824: (p_messages => p_messages);
825: */
826: --
827: -- Reform time data, if required

Line 841: p_messages := hxc_timecard_message_helper.getMessages;

837: -- we know if the timecard needs to be in error.
838: --
839:
840: -- get all the errors
841: p_messages := hxc_timecard_message_helper.getMessages;
842: /*
843: -- debug
844: IF g_debug THEN
845: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);

Line 864: hxc_timecard_deposit.execute

860:
861: --
862: -- Store blocks and attributes
863: --
864: hxc_timecard_deposit.execute
865: (p_blocks => p_blocks
866: ,p_attributes => p_attributes
867: ,p_timecard_blocks => l_timecard_blocks
868: ,p_day_blocks => l_day_blocks

Line 876: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

872: );
873:
874:
875: p_timecard_id :=
876: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
877: p_timecard_ovn:=
878: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
879:
880: --hxc_timecard_message_helper.processerrors

Line 878: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

874:
875: p_timecard_id :=
876: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
877: p_timecard_ovn:=
878: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
879:
880: --hxc_timecard_message_helper.processerrors
881: -- (p_messages => p_messages);
882:

Line 880: --hxc_timecard_message_helper.processerrors

876: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
877: p_timecard_ovn:=
878: p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
879:
880: --hxc_timecard_message_helper.processerrors
881: -- (p_messages => p_messages);
882:
883: hxc_timecard_audit.maintain_latest_details
884: (p_blocks => p_blocks );

Line 883: hxc_timecard_audit.maintain_latest_details

879:
880: --hxc_timecard_message_helper.processerrors
881: -- (p_messages => p_messages);
882:
883: hxc_timecard_audit.maintain_latest_details
884: (p_blocks => p_blocks );
885:
886: IF p_timekeeper_id IS NOT NULL and
887: p_tk_audit_enabled = 'Y' and

Line 908: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id

904: tk_item_key :=
905: hxc_timekeeper_wf_pkg.begin_audit_process
906: (p_timecard_id => p_timecard_id
907: ,p_timecard_ovn => p_timecard_ovn
908: ,p_resource_id => p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).resource_id
909: ,p_timekeeper_id => p_timekeeper_id
910: ,p_tk_audit_enabled => p_tk_audit_enabled
911: ,p_tk_notify_to => p_tk_notify_to
912: ,p_tk_notify_type => p_tk_notify_type

Line 925: hxc_timecard_summary_api.timecard_deposit

921: END IF;
922: --
923: -- Maintain summary table
924: --
925: hxc_timecard_summary_api.timecard_deposit
926: (p_blocks => p_blocks
927: ,p_approval_item_type => NULL
928: ,p_approval_process_name => NULL
929: ,p_approval_item_key => NULL

Line 941: hxc_timecard_approval.begin_approval

937: --
938: IF not(l_status_error) THEN
939:
940: l_item_key :=
941: hxc_timecard_approval.begin_approval
942: (p_blocks => p_blocks
943: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
944: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
945: ,p_resubmitted => l_resubmit

Line 943: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype

939:
940: l_item_key :=
941: hxc_timecard_approval.begin_approval
942: (p_blocks => p_blocks
943: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
944: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
945: ,p_resubmitted => l_resubmit
946: ,p_timecard_props => l_timecard_props
947: ,p_messages => p_messages

Line 944: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess

940: l_item_key :=
941: hxc_timecard_approval.begin_approval
942: (p_blocks => p_blocks
943: ,p_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
944: ,p_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
945: ,p_resubmitted => l_resubmit
946: ,p_timecard_props => l_timecard_props
947: ,p_messages => p_messages
948: );

Line 959: hxc_timecard_audit.audit_deposit

955: -- Audit this transaction
956: --
957: --p_messages.delete;
958:
959: hxc_timecard_audit.audit_deposit
960: (p_transaction_info => l_transaction_info
961: ,p_messages => p_messages
962: );
963:

Line 966: --hxc_timecard_message_helper.processerrors

962: );
963:
964:
965:
966: --hxc_timecard_message_helper.processerrors
967: -- (p_messages => p_messages);
968:
969: -- get all the errors
970: --p_messages := hxc_timecard_message_helper.getMessages;

Line 970: --p_messages := hxc_timecard_message_helper.getMessages;

966: --hxc_timecard_message_helper.processerrors
967: -- (p_messages => p_messages);
968:
969: -- get all the errors
970: --p_messages := hxc_timecard_message_helper.getMessages;
971:
972:
973: -- set the out parameters --
974:

Line 975: hxc_timecard_summary_pkg.update_summary_row

971:
972:
973: -- set the out parameters --
974:
975: hxc_timecard_summary_pkg.update_summary_row
976: (p_timecard_id => p_timecard_id
977: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
978: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
979: ,p_approval_item_key => l_item_key

Line 977: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype

973: -- set the out parameters --
974:
975: hxc_timecard_summary_pkg.update_summary_row
976: (p_timecard_id => p_timecard_id
977: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
978: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
979: ,p_approval_item_key => l_item_key
980: );
981:

Line 978: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess

974:
975: hxc_timecard_summary_pkg.update_summary_row
976: (p_timecard_id => p_timecard_id
977: ,p_approval_item_type => hxc_timecard_deposit_common.c_hxcempitemtype
978: ,p_approval_process_name => hxc_timecard_deposit_common.c_hxcapprovalprocess
979: ,p_approval_item_key => l_item_key
980: );
981:
982: /*

Line 1005: hxc_timecard_deposit_common.delete_timecard

1001: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
1002: ) is
1003:
1004: /*
1005: hxc_timecard_deposit_common.delete_timecard
1006: (p_mode => 'DELETE'
1007: ,p_template => 'N'
1008: ,p_timecard_id => p_timecard_id
1009: );

Line 1013: p_timecard_id in hxc_timecard_summary.timecard_id%type) is

1009: );
1010: */
1011:
1012: cursor c_previous_timecard(
1013: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1014: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
1015: from hxc_timecard_summary
1016: where timecard_id = p_timecard_id;
1017:

Line 1015: from hxc_timecard_summary

1011:
1012: cursor c_previous_timecard(
1013: p_timecard_id in hxc_timecard_summary.timecard_id%type) is
1014: select tk_audit_item_key,tk_audit_item_type,timecard_ovn
1015: from hxc_timecard_summary
1016: where timecard_id = p_timecard_id;
1017:
1018: /*
1019: cursor c_timecard_ovn

Line 1043: l_timecard_blocks hxc_timecard.block_list;

1039: l_blocks hxc_block_table_type := hxc_block_table_type();
1040: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1041: l_messages hxc_message_table_type := hxc_message_table_type();
1042:
1043: l_timecard_blocks hxc_timecard.block_list;
1044: l_day_blocks hxc_timecard.block_list;
1045: l_detail_blocks hxc_timecard.block_list;
1046:
1047: l_transaction_info hxc_timecard.transaction_info;

Line 1044: l_day_blocks hxc_timecard.block_list;

1040: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1041: l_messages hxc_message_table_type := hxc_message_table_type();
1042:
1043: l_timecard_blocks hxc_timecard.block_list;
1044: l_day_blocks hxc_timecard.block_list;
1045: l_detail_blocks hxc_timecard.block_list;
1046:
1047: l_transaction_info hxc_timecard.transaction_info;
1048: l_timecard_props hxc_timecard_prop_table_type;

Line 1045: l_detail_blocks hxc_timecard.block_list;

1041: l_messages hxc_message_table_type := hxc_message_table_type();
1042:
1043: l_timecard_blocks hxc_timecard.block_list;
1044: l_day_blocks hxc_timecard.block_list;
1045: l_detail_blocks hxc_timecard.block_list;
1046:
1047: l_transaction_info hxc_timecard.transaction_info;
1048: l_timecard_props hxc_timecard_prop_table_type;
1049:

Line 1047: l_transaction_info hxc_timecard.transaction_info;

1043: l_timecard_blocks hxc_timecard.block_list;
1044: l_day_blocks hxc_timecard.block_list;
1045: l_detail_blocks hxc_timecard.block_list;
1046:
1047: l_transaction_info hxc_timecard.transaction_info;
1048: l_timecard_props hxc_timecard_prop_table_type;
1049:
1050: l_dummy boolean := true;
1051:

Line 1048: l_timecard_props hxc_timecard_prop_table_type;

1044: l_day_blocks hxc_timecard.block_list;
1045: l_detail_blocks hxc_timecard.block_list;
1046:
1047: l_transaction_info hxc_timecard.transaction_info;
1048: l_timecard_props hxc_timecard_prop_table_type;
1049:
1050: l_dummy boolean := true;
1051:
1052: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;

Line 1060: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;

1056:
1057: l_rollback BOOLEAN := FALSE;
1058: e_timekeeper_check EXCEPTION;
1059:
1060: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1061: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1062:
1063: l_dummy_num NUMBER(1);
1064:

Line 1061: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;

1057: l_rollback BOOLEAN := FALSE;
1058: e_timekeeper_check EXCEPTION;
1059:
1060: l_previous_tk_item_key hxc_timecard_summary.tk_audit_item_key%type;
1061: l_previous_tk_item_type hxc_timecard_summary.tk_audit_item_type%type;
1062:
1063: l_dummy_num NUMBER(1);
1064:
1065: Begin

Line 1093: hxc_timecard_message_helper.initializeErrors;

1089: -- Initialize the message stack
1090: --
1091:
1092: fnd_msg_pub.initialize;
1093: hxc_timecard_message_helper.initializeErrors;
1094: --
1095: -- Get the timecard or timecard template blocks and attributes
1096: --
1097:

Line 1098: l_blocks := hxc_timecard_deposit_common.load_blocks(p_timecard_id, l_timecard_ovn);

1094: --
1095: -- Get the timecard or timecard template blocks and attributes
1096: --
1097:
1098: l_blocks := hxc_timecard_deposit_common.load_blocks(p_timecard_id, l_timecard_ovn);
1099: l_attributes := hxc_timecard_deposit_common.load_attributes(l_blocks);
1100:
1101: --
1102: -- Main delete processing

Line 1099: l_attributes := hxc_timecard_deposit_common.load_attributes(l_blocks);

1095: -- Get the timecard or timecard template blocks and attributes
1096: --
1097:
1098: l_blocks := hxc_timecard_deposit_common.load_blocks(p_timecard_id, l_timecard_ovn);
1099: l_attributes := hxc_timecard_deposit_common.load_attributes(l_blocks);
1100:
1101: --
1102: -- Main delete processing
1103: --

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

1101: --
1102: -- Main delete processing
1103: --
1104:
1105: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
1106:
1107: -- we need to check if the timecard is in error and
1108: -- if it has been retrieved.
1109: IF (l_blocks(l_timecard_index).approval_status = 'ERROR')

Line 1119: hxc_timecard_message_helper.addErrorToCollection

1115: THEN
1116: close csr_chk_transfer;
1117:
1118: -- add the message in the message table
1119: hxc_timecard_message_helper.addErrorToCollection
1120: (p_messages,
1121: 'HXC_DEL_ERROR_RET',
1122: hxc_timecard.c_error,
1123: null,

Line 1122: hxc_timecard.c_error,

1118: -- add the message in the message table
1119: hxc_timecard_message_helper.addErrorToCollection
1120: (p_messages,
1121: 'HXC_DEL_ERROR_RET',
1122: hxc_timecard.c_error,
1123: null,
1124: null,
1125: hxc_timecard.c_hxc,
1126: null,

Line 1125: hxc_timecard.c_hxc,

1121: 'HXC_DEL_ERROR_RET',
1122: hxc_timecard.c_error,
1123: null,
1124: null,
1125: hxc_timecard.c_hxc,
1126: null,
1127: null,
1128: null,
1129: null

Line 1138: hxc_timecard_properties.get_preference_properties

1134:
1135: close csr_chk_transfer;
1136: END IF;
1137:
1138: hxc_timecard_properties.get_preference_properties
1139: (p_validate => hxc_timecard.c_yes
1140: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1141: ,p_timecard_start_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).start_time)
1142: ,p_timecard_stop_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).stop_time)

Line 1139: (p_validate => hxc_timecard.c_yes

1135: close csr_chk_transfer;
1136: END IF;
1137:
1138: hxc_timecard_properties.get_preference_properties
1139: (p_validate => hxc_timecard.c_yes
1140: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1141: ,p_timecard_start_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).start_time)
1142: ,p_timecard_stop_time => fnd_date.canonical_to_date(l_blocks(l_timecard_index).stop_time)
1143: ,p_for_timecard => false

Line 1148: hxc_timecard_message_helper.processerrors

1144: ,p_messages => l_messages
1145: ,p_property_table => l_timecard_props
1146: );
1147:
1148: hxc_timecard_message_helper.processerrors
1149: (p_messages => l_messages);
1150:
1151:
1152: hxc_timecard_block_utils.sort_blocks

Line 1152: hxc_timecard_block_utils.sort_blocks

1148: hxc_timecard_message_helper.processerrors
1149: (p_messages => l_messages);
1150:
1151:
1152: hxc_timecard_block_utils.sort_blocks
1153: (p_blocks => l_blocks
1154: ,p_timecard_blocks => l_timecard_blocks
1155: ,p_day_blocks => l_day_blocks
1156: ,p_detail_blocks => l_detail_blocks

Line 1164: hxc_timecard_validation.deposit_validation

1160: (p_blocks => l_blocks
1161: ,p_attributes => l_attributes
1162: );
1163:
1164: hxc_timecard_validation.deposit_validation
1165: (p_blocks => l_blocks
1166: ,p_attributes => l_attributes
1167: ,p_messages => l_messages
1168: ,p_props => l_timecard_props

Line 1169: ,p_deposit_mode => hxc_timecard.c_submit

1165: (p_blocks => l_blocks
1166: ,p_attributes => l_attributes
1167: ,p_messages => l_messages
1168: ,p_props => l_timecard_props
1169: ,p_deposit_mode => hxc_timecard.c_submit
1170: ,p_template => 'N'
1171: ,p_resubmit => hxc_timecard_deposit_common.c_delete
1172: ,p_can_deposit => l_dummy
1173: );

Line 1171: ,p_resubmit => hxc_timecard_deposit_common.c_delete

1167: ,p_messages => l_messages
1168: ,p_props => l_timecard_props
1169: ,p_deposit_mode => hxc_timecard.c_submit
1170: ,p_template => 'N'
1171: ,p_resubmit => hxc_timecard_deposit_common.c_delete
1172: ,p_can_deposit => l_dummy
1173: );
1174:
1175: hxc_timecard_message_helper.processerrors

Line 1175: hxc_timecard_message_helper.processerrors

1171: ,p_resubmit => hxc_timecard_deposit_common.c_delete
1172: ,p_can_deposit => l_dummy
1173: );
1174:
1175: hxc_timecard_message_helper.processerrors
1176: (p_messages => l_messages);
1177:
1178:
1179: -- get all the errors

Line 1180: l_messages := hxc_timecard_message_helper.getMessages;

1176: (p_messages => l_messages);
1177:
1178:
1179: -- get all the errors
1180: l_messages := hxc_timecard_message_helper.getMessages;
1181: /*
1182: -- debug
1183: IF g_debug THEN
1184: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',70);

Line 1208: hxc_timecard_deposit.execute

1204:
1205: ELSE
1206:
1207: --l_messages.delete;
1208: hxc_timecard_deposit.execute
1209: (p_blocks => l_blocks
1210: ,p_attributes => l_attributes
1211: ,p_timecard_blocks => l_timecard_blocks
1212: ,p_day_blocks => l_day_blocks

Line 1218: --hxc_timecard_message_helper.processerrors

1214: ,p_messages => l_messages
1215: ,p_transaction_info => l_transaction_info
1216: );
1217:
1218: --hxc_timecard_message_helper.processerrors
1219: --(p_messages => l_messages);
1220:
1221:
1222: hxc_timecard_summary_api.delete_timecard

Line 1222: hxc_timecard_summary_api.delete_timecard

1218: --hxc_timecard_message_helper.processerrors
1219: --(p_messages => l_messages);
1220:
1221:
1222: hxc_timecard_summary_api.delete_timecard
1223: (p_blocks => l_blocks
1224: ,p_timecard_id => p_timecard_id
1225: );
1226:

Line 1228: hxc_timecard_audit.audit_deposit

1224: ,p_timecard_id => p_timecard_id
1225: );
1226:
1227: --l_messages.delete;
1228: hxc_timecard_audit.audit_deposit
1229: (p_transaction_info => l_transaction_info
1230: ,p_messages => l_messages
1231: );
1232: -- hxc_timecard_message_helper.processerrors

Line 1232: -- hxc_timecard_message_helper.processerrors

1228: hxc_timecard_audit.audit_deposit
1229: (p_transaction_info => l_transaction_info
1230: ,p_messages => l_messages
1231: );
1232: -- hxc_timecard_message_helper.processerrors
1233: -- (p_messages => l_messages);
1234:
1235: hxc_timecard_audit.maintain_latest_details
1236: (p_blocks => l_blocks );

Line 1235: hxc_timecard_audit.maintain_latest_details

1231: );
1232: -- hxc_timecard_message_helper.processerrors
1233: -- (p_messages => l_messages);
1234:
1235: hxc_timecard_audit.maintain_latest_details
1236: (p_blocks => l_blocks );
1237:
1238: hxc_timecard_message_helper.prepareErrors;
1239:

Line 1238: hxc_timecard_message_helper.prepareErrors;

1234:
1235: hxc_timecard_audit.maintain_latest_details
1236: (p_blocks => l_blocks );
1237:
1238: hxc_timecard_message_helper.prepareErrors;
1239:
1240: -- get all the errors
1241: --l_messages := hxc_timecard_message_helper.getMessages;
1242: /*

Line 1241: --l_messages := hxc_timecard_message_helper.getMessages;

1237:
1238: hxc_timecard_message_helper.prepareErrors;
1239:
1240: -- get all the errors
1241: --l_messages := hxc_timecard_message_helper.getMessages;
1242: /*
1243: if g_debug THEN
1244: hxc_debug_timecard.writeMessages(p_messages,'HXC_TIMEKEEPER',80);
1245: end if;

Line 1258: hxc_timecard_message_helper.prepareErrors;

1254:
1255:
1256: EXCEPTION
1257: WHEN e_timekeeper_check then
1258: hxc_timecard_message_helper.prepareErrors;
1259: rollback;
1260:
1261: End delete_timecard;
1262: