[Home] [Help]
1: Package Body hxc_timecard AS
2: /* $Header: hxctimecard.pkb 120.18.12010000.1 2008/07/28 11:23:00 appldev ship $ */
3:
4: type attribute_list is table of number index by binary_integer;
5:
4: type attribute_list is table of number index by binary_integer;
5:
6: attribute_id_list attribute_list;
7:
8: g_package varchar2(12) := 'HXC_TIMECARD';
9: g_deposit_blocks hxc_block_table_type;
10: g_deposit_attributes hxc_attribute_table_type;
11: g_audit_messages hxc_message_table_type;
12:
22: l_proc varchar2(31) := g_package||'.alias_translation';
23:
24: Begin
25:
26: hxc_timecard_attribute_utils.set_bld_blk_info_type_id(p_attributes);
27:
28: HXC_ALIAS_TRANSLATOR.DO_DEPOSIT_TRANSLATION
29: (p_attributes => p_attributes
30: ,p_messages => p_messages
34:
35: Procedure save_timecard
36: (p_blocks in out nocopy HXC_BLOCK_TABLE_TYPE
37: ,p_attributes in out nocopy HXC_ATTRIBUTE_TABLE_TYPE
38: ,p_timecard_props in HXC_TIMECARD_PROP_TABLE_TYPE
39: ,p_messages in out nocopy HXC_MESSAGE_TABLE_TYPE
40: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
41: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
42: ,p_resubmit in varchar2
41: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
42: ,p_resubmit in varchar2
43: ) is
44:
45: l_timecard_blocks hxc_timecard.block_list;
46: l_day_blocks hxc_timecard.block_list;
47: l_detail_blocks hxc_timecard.block_list;
48: l_transaction_info hxc_timecard.transaction_info;
49: l_proc varchar2(33) := g_package||'.save_timecard';
42: ,p_resubmit in varchar2
43: ) is
44:
45: l_timecard_blocks hxc_timecard.block_list;
46: l_day_blocks hxc_timecard.block_list;
47: l_detail_blocks hxc_timecard.block_list;
48: l_transaction_info hxc_timecard.transaction_info;
49: l_proc varchar2(33) := g_package||'.save_timecard';
50: l_old_style_blks hxc_self_service_time_deposit.timecard_info;
43: ) is
44:
45: l_timecard_blocks hxc_timecard.block_list;
46: l_day_blocks hxc_timecard.block_list;
47: l_detail_blocks hxc_timecard.block_list;
48: l_transaction_info hxc_timecard.transaction_info;
49: l_proc varchar2(33) := g_package||'.save_timecard';
50: l_old_style_blks hxc_self_service_time_deposit.timecard_info;
51: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
44:
45: l_timecard_blocks hxc_timecard.block_list;
46: l_day_blocks hxc_timecard.block_list;
47: l_detail_blocks hxc_timecard.block_list;
48: l_transaction_info hxc_timecard.transaction_info;
49: l_proc varchar2(33) := g_package||'.save_timecard';
50: l_old_style_blks hxc_self_service_time_deposit.timecard_info;
51: l_old_style_attrs hxc_self_service_time_deposit.building_block_attribute_info;
52: l_old_messages hxc_self_service_time_deposit.message_table;
55:
56: /*
57: Sort blocks
58: */
59: hxc_timecard_block_utils.sort_blocks
60: (p_blocks => p_blocks
61: ,p_timecard_blocks => l_timecard_blocks
62: ,p_day_blocks => l_day_blocks
63: ,p_detail_blocks => l_detail_blocks
77: );
78:
79:
80:
81: hxc_timecard_message_helper.processerrors
82: (p_messages => p_messages);
83:
84: /*
85: Add the security attributes
91: p_timecard_props => p_timecard_props,
92: p_messages => p_messages
93: );
94:
95: hxc_timecard_message_helper.processerrors
96: (p_messages => p_messages);
97:
98: /*
99: Translate any aliases
103: ,p_attributes => p_attributes
104: ,p_messages => p_messages
105: );
106:
107: hxc_timecard_message_helper.processerrors
108: (p_messages => p_messages);
109:
110: /*
111: Set the block and attribute update process flags
119: /*
120: Removed any deleted attributes
121: */
122:
123: hxc_timecard_attribute_utils.remove_deleted_attributes
124: (p_attributes => p_attributes);
125:
126: /* Fix for bug 6489820 */
127:
131:
132: /* End of fix for bug 6489820 */
133:
134: /* fix by senthil for bug 5099360*/
135: hxc_timecard_block_utils.sort_blocks
136: (p_blocks => p_blocks
137: ,p_timecard_blocks => l_timecard_blocks
138: ,p_day_blocks => l_day_blocks
139: ,p_detail_blocks => l_detail_blocks
149: ,p_attributes => p_attributes
150: ,p_timecard_props => p_timecard_props
151: ,p_days => l_day_blocks
152: ,p_details => l_detail_blocks
153: ,p_template => hxc_timecard.c_no
154: ,p_deposit_mode => hxc_timecard.c_save
155: ,p_messages => p_messages
156: );
157:
150: ,p_timecard_props => p_timecard_props
151: ,p_days => l_day_blocks
152: ,p_details => l_detail_blocks
153: ,p_template => hxc_timecard.c_no
154: ,p_deposit_mode => hxc_timecard.c_save
155: ,p_messages => p_messages
156: );
157:
158: hxc_timecard_message_helper.processerrors
154: ,p_deposit_mode => hxc_timecard.c_save
155: ,p_messages => p_messages
156: );
157:
158: hxc_timecard_message_helper.processerrors
159: (p_messages => p_messages);
160:
161: /*
162: Validate blocks, attributes - including TERs.
161: /*
162: Validate blocks, attributes - including TERs.
163: */
164:
165: hxc_timecard_validation.recipients_update_validation
166: (p_blocks => p_blocks
167: ,p_attributes => p_attributes
168: ,p_messages => p_messages
169: ,p_props => p_timecard_props
166: (p_blocks => p_blocks
167: ,p_attributes => p_attributes
168: ,p_messages => p_messages
169: ,p_props => p_timecard_props
170: ,p_deposit_mode => hxc_timecard.c_save
171: ,p_resubmit => p_resubmit
172: );
173:
174: hxc_timecard_message_helper.processerrors
170: ,p_deposit_mode => hxc_timecard.c_save
171: ,p_resubmit => p_resubmit
172: );
173:
174: hxc_timecard_message_helper.processerrors
175: (p_messages => p_messages);
176:
177: hxc_timecard_validation.data_set_validation
178: (p_blocks => p_blocks
173:
174: hxc_timecard_message_helper.processerrors
175: (p_messages => p_messages);
176:
177: hxc_timecard_validation.data_set_validation
178: (p_blocks => p_blocks
179: ,p_messages => p_messages
180: );
181:
178: (p_blocks => p_blocks
179: ,p_messages => p_messages
180: );
181:
182: hxc_timecard_message_helper.processerrors
183: (p_messages => p_messages);
184:
185: /*
186: Store blocks and attributes
185: /*
186: Store blocks and attributes
187: */
188:
189: if hxc_timecard_message_helper.noErrors then
190:
191: hxc_timecard_deposit.execute
192: (p_blocks => p_blocks
193: ,p_attributes => p_attributes
187: */
188:
189: if hxc_timecard_message_helper.noErrors then
190:
191: hxc_timecard_deposit.execute
192: (p_blocks => p_blocks
193: ,p_attributes => p_attributes
194: ,p_timecard_blocks => l_timecard_blocks
195: ,p_day_blocks => l_day_blocks
197: ,p_messages => p_messages
198: ,p_transaction_info => l_transaction_info
199: );
200:
201: hxc_timecard_message_helper.processerrors
202: (p_messages => p_messages);
203:
204: end if;
205: if hxc_timecard_message_helper.noErrors then
201: hxc_timecard_message_helper.processerrors
202: (p_messages => p_messages);
203:
204: end if;
205: if hxc_timecard_message_helper.noErrors then
206:
207: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
208:
209: /*
203:
204: end if;
205: if hxc_timecard_message_helper.noErrors then
206:
207: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
208:
209: /*
210: Bug 3345143 - this is done in the summary apis now.
211:
213: */
214: --
215: -- Maintain summary table
216: --
217: hxc_timecard_summary_api.timecard_deposit
218: (p_blocks => p_blocks
219: ,p_approval_item_type => NULL
220: ,p_approval_process_name => NULL
221: ,p_approval_item_key => NULL
223: ,p_tk_audit_process_name => NULL
224: ,p_tk_audit_item_key => NULL
225: );
226:
227: hxc_timecard_audit.maintain_latest_details
228: (p_blocks => p_blocks );
229:
230: hxc_timecard_message_helper.processerrors
231: (p_messages => p_messages);
226:
227: hxc_timecard_audit.maintain_latest_details
228: (p_blocks => p_blocks );
229:
230: hxc_timecard_message_helper.processerrors
231: (p_messages => p_messages);
232:
233: end if;
234:
231: (p_messages => p_messages);
232:
233: end if;
234:
235: p_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
236: p_timecard_ovn:= p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
237:
238: End save_timecard;
239:
232:
233: end if;
234:
235: p_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;
236: p_timecard_ovn:= p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;
237:
238: End save_timecard;
239:
240: Procedure deposit_controller
250: ,p_timecard_id out nocopy hxc_time_building_blocks.time_building_block_id%type
251: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
252: ) IS
253:
254: l_timecard_blocks hxc_timecard.block_list;
255: l_day_blocks hxc_timecard.block_list;
256: l_detail_blocks hxc_timecard.block_list;
257: l_attributes hxc_attribute_table_type;
258: l_blocks hxc_block_table_type;
251: ,p_timecard_ovn out nocopy hxc_time_building_blocks.object_version_number%type
252: ) IS
253:
254: l_timecard_blocks hxc_timecard.block_list;
255: l_day_blocks hxc_timecard.block_list;
256: l_detail_blocks hxc_timecard.block_list;
257: l_attributes hxc_attribute_table_type;
258: l_blocks hxc_block_table_type;
259: l_transaction_info hxc_timecard.transaction_info;
252: ) IS
253:
254: l_timecard_blocks hxc_timecard.block_list;
255: l_day_blocks hxc_timecard.block_list;
256: l_detail_blocks hxc_timecard.block_list;
257: l_attributes hxc_attribute_table_type;
258: l_blocks hxc_block_table_type;
259: l_transaction_info hxc_timecard.transaction_info;
260: l_timecard_props hxc_timecard_prop_table_type;
255: l_day_blocks hxc_timecard.block_list;
256: l_detail_blocks hxc_timecard.block_list;
257: l_attributes hxc_attribute_table_type;
258: l_blocks hxc_block_table_type;
259: l_transaction_info hxc_timecard.transaction_info;
260: l_timecard_props hxc_timecard_prop_table_type;
261: l_proc varchar2(33) := g_package||'.DEPOSIT_CONTROLLER';
262: l_can_deposit boolean := true;
263: l_resubmit varchar2(10) := c_no;
256: l_detail_blocks hxc_timecard.block_list;
257: l_attributes hxc_attribute_table_type;
258: l_blocks hxc_block_table_type;
259: l_transaction_info hxc_timecard.transaction_info;
260: l_timecard_props hxc_timecard_prop_table_type;
261: l_proc varchar2(33) := g_package||'.DEPOSIT_CONTROLLER';
262: l_can_deposit boolean := true;
263: l_resubmit varchar2(10) := c_no;
264: l_timecard_index number;
282:
283: l_blocks := p_blocks;
284: l_attributes := p_attributes;
285:
286: hxc_timecard_block_utils.initialize_timecard_index;
287:
288: ----------------- Default Attributes -------------------------------------------------------
289: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
290: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
285:
286: hxc_timecard_block_utils.initialize_timecard_index;
287:
288: ----------------- Default Attributes -------------------------------------------------------
289: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
290: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
291: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
292: l_resource_id := p_blocks(l_active_index).resource_id;
293:
286: hxc_timecard_block_utils.initialize_timecard_index;
287:
288: ----------------- Default Attributes -------------------------------------------------------
289: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
290: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
291: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
292: l_resource_id := p_blocks(l_active_index).resource_id;
293:
294: --Get the Preference value - Time Store Days to Hour Conversion
287:
288: ----------------- Default Attributes -------------------------------------------------------
289: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
290: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);
291: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);
292: l_resource_id := p_blocks(l_active_index).resource_id;
293:
294: --Get the Preference value - Time Store Days to Hour Conversion
295: hxc_preference_evaluation.resource_preferences(p_resource_id => l_resource_id,
314: ,p_template => p_template
315: ,p_messages => p_messages
316: );
317:
318: hxc_timecard_message_helper.processerrors
319: (p_messages => p_messages);
320:
321: /*
322: Determine if this is a resubmitted timecard
321: /*
322: Determine if this is a resubmitted timecard
323: */
324:
325: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
326:
327: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then
328: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
329: (p_blocks(l_timecard_index).time_building_block_id
323: */
324:
325: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
326:
327: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then
328: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
329: (p_blocks(l_timecard_index).time_building_block_id
330: ,p_blocks(l_timecard_index).object_version_number
331: ,p_blocks(l_timecard_index).resource_id
324:
325: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
326:
327: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then
328: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
329: (p_blocks(l_timecard_index).time_building_block_id
330: ,p_blocks(l_timecard_index).object_version_number
331: ,p_blocks(l_timecard_index).resource_id
332: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
328: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
329: (p_blocks(l_timecard_index).time_building_block_id
330: ,p_blocks(l_timecard_index).object_version_number
331: ,p_blocks(l_timecard_index).resource_id
332: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
333: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
334: );
335: else
336: l_resubmit := c_delete;
329: (p_blocks(l_timecard_index).time_building_block_id
330: ,p_blocks(l_timecard_index).object_version_number
331: ,p_blocks(l_timecard_index).resource_id
332: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
333: ,hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
334: );
335: else
336: l_resubmit := c_delete;
337: end if;
342: this information in from the
343: middle tier, to avoid another
344: pref evaluation
345: */
346: l_tbb_id :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).time_building_block_id;
347: l_tbb_ovn :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).object_version_number;
348:
349: if (l_tbb_id <0 ) then -- when we are creating tmecard/template the id will be -ve value,so in this case we pass
350: l_tbb_id := null; -- NULL instead of -ve value
343: middle tier, to avoid another
344: pref evaluation
345: */
346: l_tbb_id :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).time_building_block_id;
347: l_tbb_ovn :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).object_version_number;
348:
349: if (l_tbb_id <0 ) then -- when we are creating tmecard/template the id will be -ve value,so in this case we pass
350: l_tbb_id := null; -- NULL instead of -ve value
351: l_tbb_ovn :=null;
350: l_tbb_id := null; -- NULL instead of -ve value
351: l_tbb_ovn :=null;
352: end if;
353:
354: hxc_timecard_properties.get_preference_properties
355: (p_validate => c_yes
356: ,p_resource_id => p_blocks(l_timecard_index).resource_id
357: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
358: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
353:
354: hxc_timecard_properties.get_preference_properties
355: (p_validate => c_yes
356: ,p_resource_id => p_blocks(l_timecard_index).resource_id
357: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
358: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
359: ,p_for_timecard => false
360: ,p_messages => p_messages
361: ,p_property_table => l_timecard_props
354: hxc_timecard_properties.get_preference_properties
355: (p_validate => c_yes
356: ,p_resource_id => p_blocks(l_timecard_index).resource_id
357: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time)
358: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)
359: ,p_for_timecard => false
360: ,p_messages => p_messages
361: ,p_property_table => l_timecard_props
362: ,p_timecard_bb_id => l_tbb_id -- passs the extra parameter timecard ID
362: ,p_timecard_bb_id => l_tbb_id -- passs the extra parameter timecard ID
363: ,p_timecard_bb_ovn => l_tbb_ovn -- pass the extra parameter timecard OVN
364: );
365:
366: hxc_timecard_message_helper.processerrors
367: (p_messages => p_messages);
368:
369: p_messages.delete;
370:
388: elsif (p_deposit_mode = c_audit) then
389:
390:
391: l_blocks := g_deposit_blocks;
392: hxc_timecard_attribute_utils.append_additional_reasons
393: (g_deposit_attributes
394: ,p_attributes);
395: l_attributes := g_deposit_attributes;
396:
418: ,p_attributes => l_attributes
419: ,p_messages => p_messages
420: );
421:
422: hxc_timecard_message_helper.processerrors
423: (p_messages => p_messages);
424:
425: /*
426: Hold the completed blocks and attributes
428: there were no error messages from audit
429: validation
430: */
431:
432: if(hxc_timecard_message_helper.noerrors) then
433: g_deposit_blocks := l_blocks;
434: g_deposit_attributes := l_attributes;
435: end if;
436:
436:
437: else
438: if((p_validate = c_yes)OR(p_template=c_yes)) then
439:
440: hxc_timecard_block_utils.sort_blocks
441: (p_blocks => p_blocks
442: ,p_timecard_blocks => l_timecard_blocks
443: ,p_day_blocks => l_day_blocks
444: ,p_detail_blocks => l_detail_blocks
472: ,p_messages => p_messages
473: );
474:
475:
476: hxc_timecard_message_helper.processerrors
477: (p_messages => p_messages);
478:
479: p_messages.delete;
480:
490: p_timecard_props => l_timecard_props,
491: p_messages => p_messages
492: );
493:
494: hxc_timecard_message_helper.processerrors
495: (p_messages => p_messages);
496:
497: /*
498: Translate any aliases
505: ,p_messages => p_messages
506: );
507:
508:
509: hxc_timecard_message_helper.processerrors
510: (p_messages => p_messages);
511:
512: /*
513: Set the block and attribute update process flags
526:
527: if p_cla_save = 'NO' then ------------- CLA change
528:
529:
530: hxc_timecard_attribute_utils.remove_deleted_attributes
531: (p_attributes => l_attributes);
532:
533: /*
534: Perform process checks
544: ,p_deposit_mode => p_deposit_mode
545: ,p_messages => p_messages
546: );
547:
548: hxc_timecard_message_helper.processerrors
549: (p_messages => p_messages);
550: /*
551: Validate blocks, attributes
552: */
551: Validate blocks, attributes
552: */
553:
554:
555: hxc_timecard_validation.deposit_validation
556: (p_blocks => l_blocks
557: ,p_attributes => l_attributes
558: ,p_messages => p_messages
559: ,p_props => l_timecard_props
562: ,p_resubmit => l_resubmit
563: ,p_can_deposit => l_can_deposit
564: );
565:
566: hxc_timecard_message_helper.processerrors
567: (p_messages => p_messages);
568:
569: --
570: -- Validate the set up for the user
582: );
583:
584: end if;
585:
586: hxc_timecard_message_helper.processerrors
587: (p_messages => p_messages);
588:
589: */
590: /*
594:
595:
596: elsif p_cla_save = 'YES' then ------- CLA change
597:
598: hxc_timecard_validation.timecard_validation
599: (p_blocks => l_blocks,
600: p_attributes => l_attributes,
601: p_messages => p_messages,
602: p_props => l_timecard_props,
615: for immeadiate deposit if required
616: */
617: g_deposit_blocks := l_blocks;
618: g_deposit_attributes := l_attributes;
619: g_audit_messages := hxc_timecard_message_helper.getMessages;
620:
621: end if;
622:
623: if(((p_validate=c_no)OR(p_template=c_yes))AND(l_can_deposit))then
625: if(l_day_blocks.count = 0) then
626: --
627: -- Only bother to resort if we have to
628: --
629: hxc_timecard_block_utils.sort_blocks
630: (p_blocks => g_deposit_blocks
631: ,p_timecard_blocks => l_timecard_blocks
632: ,p_day_blocks => l_day_blocks
633: ,p_detail_blocks => l_detail_blocks
647: ,p_details => l_detail_blocks
648: ,p_messages => p_messages
649: );
650:
651: hxc_timecard_message_helper.processerrors
652: (p_messages => p_messages);
653:
654: p_messages.delete;
655:
657:
658: /*
659: Store blocks and attributes
660: */
661: if(hxc_timecard_message_helper.noErrors) then
662:
663: /*
664: At this point, if we're saving a template,
665: we should look to see if the id corresponding
667: in which case, we'll need to replace the ids
668: to ensure the template is saved properly
669: */
670:
671: if(p_template = hxc_timecard.c_yes) then
672:
673: hxc_block_attribute_update.replace_ids
674: (p_blocks => g_deposit_blocks
675: ,p_attributes => g_deposit_attributes
725: END LOOP;
726:
727: hr_utility.trace('Restrict Blank Rows on Save : '||l_restrict_blank_rows_on_save);
728: -- Added for DA
729: if((p_template <> c_yes) and (hxc_timecard_message_helper.noErrors)) then
730: l_index := g_deposit_blocks.first;
731: LOOP
732: EXIT WHEN NOT g_deposit_blocks.exists(l_index);
733:
811: END IF; -- IF l_restrict_blank_rows_on_save = 'N'
812:
813: --------------------------- Default Attributes -----------------------------------------
814:
815: hxc_timecard_deposit.execute
816: (p_blocks => g_deposit_blocks
817: ,p_attributes => g_deposit_attributes
818: ,p_timecard_blocks => l_timecard_blocks
819: ,p_day_blocks => l_day_blocks
821: ,p_messages => p_messages
822: ,p_transaction_info => l_transaction_info
823: );
824:
825: hxc_timecard_message_helper.processerrors
826: (p_messages => p_messages);
827:
828: p_timecard_id := g_deposit_blocks
829: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).time_building_block_id;
825: hxc_timecard_message_helper.processerrors
826: (p_messages => p_messages);
827:
828: p_timecard_id := g_deposit_blocks
829: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).time_building_block_id;
830:
831: p_timecard_ovn := g_deposit_blocks
832: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;
833:
828: p_timecard_id := g_deposit_blocks
829: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).time_building_block_id;
830:
831: p_timecard_ovn := g_deposit_blocks
832: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;
833:
834: if((p_template <> c_yes) and (hxc_timecard_message_helper.noErrors)) then
835:
836:
830:
831: p_timecard_ovn := g_deposit_blocks
832: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;
833:
834: if((p_template <> c_yes) and (hxc_timecard_message_helper.noErrors)) then
835:
836:
837:
838: -- Maintain summary table
836:
837:
838: -- Maintain summary table
839:
840: hxc_timecard_summary_api.timecard_deposit
841: (p_blocks => g_deposit_blocks
842: ,p_approval_item_type => NULL
843: ,p_approval_process_name => NULL
844: ,p_approval_item_key => NULL
846: ,p_tk_audit_process_name => NULL
847: ,p_tk_audit_item_key => NULL
848: );
849:
850: hxc_timecard_audit.maintain_latest_details
851: (p_blocks => g_deposit_blocks );
852:
853: hxc_timecard_message_helper.processerrors
854: (p_messages => p_messages);
849:
850: hxc_timecard_audit.maintain_latest_details
851: (p_blocks => g_deposit_blocks );
852:
853: hxc_timecard_message_helper.processerrors
854: (p_messages => p_messages);
855:
856: l_item_key :=
857: hxc_timecard_approval.begin_approval
853: hxc_timecard_message_helper.processerrors
854: (p_messages => p_messages);
855:
856: l_item_key :=
857: hxc_timecard_approval.begin_approval
858: (p_blocks => g_deposit_blocks,
859: p_item_type => p_item_type,
860: p_process_name => p_approval_prc,
861: p_resubmitted => l_resubmit,
862: p_timecard_props => l_timecard_props,
863: p_messages => p_messages
864: );
865:
866: hxc_timecard_message_helper.processerrors
867: (p_messages => p_messages);
868:
869: hxc_timecard_summary_pkg.update_summary_row
870: (p_timecard_id => p_timecard_id
865:
866: hxc_timecard_message_helper.processerrors
867: (p_messages => p_messages);
868:
869: hxc_timecard_summary_pkg.update_summary_row
870: (p_timecard_id => p_timecard_id
871: ,p_approval_item_type => p_item_type
872: ,p_approval_process_name => p_approval_prc
873: ,p_approval_item_key => l_item_key
884: --
885: --115.43 Change Note: The delete on the structures are
886: --in both the if and elsif clauses here, since we must only
887: --delete the structures if there has been a successful deposit,
888: --namely the hxc_timecard_message_helper.noErrors function
889: --returns true. Customer tested this configuration.
890: --
891: g_deposit_blocks.delete;
892: g_deposit_attributes.delete;
890: --
891: g_deposit_blocks.delete;
892: g_deposit_attributes.delete;
893: g_audit_messages.delete;
894: elsif((p_template = c_yes) and (hxc_timecard_message_helper.noErrors)) then
895: hxc_template_summary_api.template_deposit
896: (p_blocks => g_deposit_blocks,
897: p_attributes =>g_deposit_attributes,
898: p_template_id =>p_timecard_id);
908: /*
909: Audit this transaction
910: */
911:
912: hxc_timecard_audit.audit_deposit
913: (p_transaction_info => l_transaction_info
914: ,p_messages => p_messages
915: );
916:
913: (p_transaction_info => l_transaction_info
914: ,p_messages => p_messages
915: );
916:
917: hxc_timecard_message_helper.processerrors
918: (p_messages => p_messages);
919:
920: end if;
921:
922: /*
923: Finally, deal with the errors
924: */
925:
926: p_messages := hxc_timecard_message_helper.prepareMessages;
927:
928: END deposit_controller;
929:
930: Procedure create_timecard
959: the back button. No code should be updated in the validate phase
960: in OTL
961: */
962:
963: if(p_validate=hxc_timecard.c_yes) then
964: rollback;
965: end if;
966:
967: fnd_msg_pub.initialize;
965: end if;
966:
967: fnd_msg_pub.initialize;
968:
969: hxc_timecard_message_helper.initializeErrors;
970:
971: p_messages := hxc_message_table_type();
972:
973: if(p_template = hxc_timecard.c_no) then
969: hxc_timecard_message_helper.initializeErrors;
970:
971: p_messages := hxc_message_table_type();
972:
973: if(p_template = hxc_timecard.c_no) then
974: if(hxc_lock_api.check_lock(p_lock_rowid)) then
975: l_valid_lock := true;
976: else
977: --
978: -- For bug
979: -- If the lock is invalid, it might just have timed out, therefore
980: -- request a new lock.
981: --
982: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
983:
984: if(hxc_timecard_block_utils.is_new_block(p_blocks(l_timecard_index))) then
985:
986: hxc_lock_api.request_lock
980: -- request a new lock.
981: --
982: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
983:
984: if(hxc_timecard_block_utils.is_new_block(p_blocks(l_timecard_index))) then
985:
986: hxc_lock_api.request_lock
987: (p_process_locker_type=> hxc_lock_util.c_ss_timecard_action
988: ,p_resource_id=> p_blocks(l_timecard_index).resource_id
1014: end if;
1015: end if;
1016: end if;
1017:
1018: if((l_valid_lock) OR (p_template = hxc_timecard.c_yes)) then
1019:
1020: deposit_controller
1021: (p_validate => p_validate
1022: ,p_blocks => p_blocks
1031: ,p_timecard_ovn => p_timecard_ovn
1032: );
1033:
1034: if(
1035: ((p_deposit_mode = hxc_timecard.c_save) AND (hxc_timecard_message_helper.noerrors))
1036: OR
1037: ((p_deposit_mode = hxc_timecard.c_submit) AND (p_validate = hxc_timecard.c_no) AND (p_template = hxc_timecard.c_no))
1038: ) then
1039:
1033:
1034: if(
1035: ((p_deposit_mode = hxc_timecard.c_save) AND (hxc_timecard_message_helper.noerrors))
1036: OR
1037: ((p_deposit_mode = hxc_timecard.c_submit) AND (p_validate = hxc_timecard.c_no) AND (p_template = hxc_timecard.c_no))
1038: ) then
1039:
1040: hxc_lock_api.release_lock
1041: (P_ROW_LOCK_ID => p_lock_rowid
1049: ,P_MESSAGES => p_messages
1050: ,P_RELEASED_SUCCESS => l_released_success
1051: );
1052:
1053: elsif ((p_template = hxc_timecard.c_yes) AND (hxc_timecard_message_helper.noerrors))then
1054: --
1055: -- This is important, because we might have saved
1056: -- a timecard as a template, in which case, we should
1057: -- release the lock that we might have
1062: end if;
1063:
1064: else
1065:
1066: hxc_timecard_message_helper.addErrorToCollection
1067: (p_messages
1068: ,'HXC_TIMECARD_LOCK_FAILED'
1069: ,hxc_timecard.c_error
1070: ,null
1064: else
1065:
1066: hxc_timecard_message_helper.addErrorToCollection
1067: (p_messages
1068: ,'HXC_TIMECARD_LOCK_FAILED'
1069: ,hxc_timecard.c_error
1070: ,null
1071: ,null
1072: ,hxc_timecard.c_hxc
1065:
1066: hxc_timecard_message_helper.addErrorToCollection
1067: (p_messages
1068: ,'HXC_TIMECARD_LOCK_FAILED'
1069: ,hxc_timecard.c_error
1070: ,null
1071: ,null
1072: ,hxc_timecard.c_hxc
1073: ,null
1068: ,'HXC_TIMECARD_LOCK_FAILED'
1069: ,hxc_timecard.c_error
1070: ,null
1071: ,null
1072: ,hxc_timecard.c_hxc
1073: ,null
1074: ,null
1075: ,null
1076: ,null
1105: Begin
1106:
1107: for block_rec in c_blocks(p_timecard_id) loop
1108: l_blocks.extend;
1109: l_blocks(l_block_count) := hxc_timecard_block_utils.build_block
1110: (block_rec.time_building_block_id
1111: ,block_rec.object_version_number);
1112: if(p_load_mode = c_delete) then
1113: --
1259: l_blocks hxc_block_table_type := hxc_block_table_type();
1260: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1261: l_messages hxc_message_table_type := hxc_message_table_type();
1262:
1263: l_timecard_blocks hxc_timecard.block_list;
1264: l_day_blocks hxc_timecard.block_list;
1265: l_detail_blocks hxc_timecard.block_list;
1266:
1267: l_transaction_info hxc_timecard.transaction_info;
1260: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1261: l_messages hxc_message_table_type := hxc_message_table_type();
1262:
1263: l_timecard_blocks hxc_timecard.block_list;
1264: l_day_blocks hxc_timecard.block_list;
1265: l_detail_blocks hxc_timecard.block_list;
1266:
1267: l_transaction_info hxc_timecard.transaction_info;
1268: l_timecard_props hxc_timecard_prop_table_type;
1261: l_messages hxc_message_table_type := hxc_message_table_type();
1262:
1263: l_timecard_blocks hxc_timecard.block_list;
1264: l_day_blocks hxc_timecard.block_list;
1265: l_detail_blocks hxc_timecard.block_list;
1266:
1267: l_transaction_info hxc_timecard.transaction_info;
1268: l_timecard_props hxc_timecard_prop_table_type;
1269:
1263: l_timecard_blocks hxc_timecard.block_list;
1264: l_day_blocks hxc_timecard.block_list;
1265: l_detail_blocks hxc_timecard.block_list;
1266:
1267: l_transaction_info hxc_timecard.transaction_info;
1268: l_timecard_props hxc_timecard_prop_table_type;
1269:
1270: l_dummy boolean := true;
1271:
1264: l_day_blocks hxc_timecard.block_list;
1265: l_detail_blocks hxc_timecard.block_list;
1266:
1267: l_transaction_info hxc_timecard.transaction_info;
1268: l_timecard_props hxc_timecard_prop_table_type;
1269:
1270: l_dummy boolean := true;
1271:
1272: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
1287: open c_timecard_ovn(p_timecard_id);
1288: fetch c_timecard_ovn into l_timecard_ovn, l_resource_id, l_start_time, l_stop_time;
1289: if(c_timecard_ovn%notfound) then
1290: close c_timecard_ovn;
1291: p_timecard_ok := hxc_timecard.c_no;
1292: else
1293: --
1294: -- Timecard is ok, continue.
1295: --
1292: else
1293: --
1294: -- Timecard is ok, continue.
1295: --
1296: p_timecard_ok := hxc_timecard.c_yes;
1297: close c_timecard_ovn;
1298:
1299: --
1300: -- Initialize the message stack
1300: -- Initialize the message stack
1301: --
1302:
1303: fnd_msg_pub.initialize;
1304: hxc_timecard_message_helper.initializeErrors;
1305: --
1306: -- Get the timecard or timecard template blocks and attributes
1307: --
1308:
1311: --
1312: -- Main delete processing
1313: --
1314:
1315: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
1316:
1317: hxc_timecard_properties.get_preference_properties
1318: (p_validate => hxc_timecard.c_yes
1319: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1313: --
1314:
1315: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
1316:
1317: hxc_timecard_properties.get_preference_properties
1318: (p_validate => hxc_timecard.c_yes
1319: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1320: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)
1321: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)
1314:
1315: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(l_blocks);
1316:
1317: hxc_timecard_properties.get_preference_properties
1318: (p_validate => hxc_timecard.c_yes
1319: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1320: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)
1321: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)
1322: ,p_for_timecard => false
1316:
1317: hxc_timecard_properties.get_preference_properties
1318: (p_validate => hxc_timecard.c_yes
1319: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1320: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)
1321: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)
1322: ,p_for_timecard => false
1323: ,p_messages => l_messages
1324: ,p_property_table => l_timecard_props
1317: hxc_timecard_properties.get_preference_properties
1318: (p_validate => hxc_timecard.c_yes
1319: ,p_resource_id => l_blocks(l_timecard_index).resource_id
1320: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)
1321: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)
1322: ,p_for_timecard => false
1323: ,p_messages => l_messages
1324: ,p_property_table => l_timecard_props
1325: ,p_timecard_bb_id => p_timecard_id --passs the extra parameter timecard ID
1325: ,p_timecard_bb_id => p_timecard_id --passs the extra parameter timecard ID
1326: ,p_timecard_bb_ovn => l_timecard_ovn -- pass the extra parameter timecard OVN
1327: );
1328:
1329: hxc_timecard_message_helper.processerrors
1330: (p_messages => l_messages);
1331:
1332: l_messages.delete;
1333:
1330: (p_messages => l_messages);
1331:
1332: l_messages.delete;
1333:
1334: hxc_timecard_block_utils.sort_blocks
1335: (p_blocks => l_blocks
1336: ,p_timecard_blocks => l_timecard_blocks
1337: ,p_day_blocks => l_day_blocks
1338: ,p_detail_blocks => l_detail_blocks
1361: p_deposit_mode => p_mode,
1362: p_messages => l_messages
1363: );
1364:
1365: hxc_timecard_message_helper.processerrors
1366: (p_messages => l_messages);
1367:
1368: hxc_timecard_validation.deposit_validation
1369: (p_blocks => l_blocks
1364:
1365: hxc_timecard_message_helper.processerrors
1366: (p_messages => l_messages);
1367:
1368: hxc_timecard_validation.deposit_validation
1369: (p_blocks => l_blocks
1370: ,p_attributes => l_attributes
1371: ,p_messages => l_messages
1372: ,p_props => l_timecard_props
1369: (p_blocks => l_blocks
1370: ,p_attributes => l_attributes
1371: ,p_messages => l_messages
1372: ,p_props => l_timecard_props
1373: ,p_deposit_mode => hxc_timecard.c_submit
1374: ,p_template => p_template
1375: ,p_resubmit => c_delete
1376: ,p_can_deposit => l_dummy
1377: );
1375: ,p_resubmit => c_delete
1376: ,p_can_deposit => l_dummy
1377: );
1378:
1379: hxc_timecard_message_helper.processerrors
1380: (p_messages => l_messages);
1381:
1382: elsif(l_blocks(l_timecard_index).scope = c_template_scope) then
1383:
1385: (l_blocks(l_timecard_index).time_building_block_id
1386: ,l_messages
1387: );
1388:
1389: hxc_timecard_message_helper.processerrors
1390: (p_messages => l_messages);
1391:
1392: end if;
1393:
1390: (p_messages => l_messages);
1391:
1392: end if;
1393:
1394: if(hxc_timecard_message_helper.noErrors) then
1395:
1396: hxc_timecard_deposit.execute
1397: (p_blocks => l_blocks
1398: ,p_attributes => l_attributes
1392: end if;
1393:
1394: if(hxc_timecard_message_helper.noErrors) then
1395:
1396: hxc_timecard_deposit.execute
1397: (p_blocks => l_blocks
1398: ,p_attributes => l_attributes
1399: ,p_timecard_blocks => l_timecard_blocks
1400: ,p_day_blocks => l_day_blocks
1401: ,p_detail_blocks => l_detail_blocks
1402: ,p_messages => l_messages
1403: ,p_transaction_info => l_transaction_info
1404: );
1405: hxc_timecard_message_helper.processerrors
1406: (p_messages => l_messages);
1407:
1408: /*
1409: Bug 3345143
1413: */
1414: if(l_blocks(l_timecard_index).scope = c_template_scope) then --Only for templates.
1415: hxc_template_summary_api.DELETE_TEMPLATE(l_blocks(l_timecard_index).time_building_block_id);
1416: else --For Timecard.
1417: hxc_timecard_summary_api.delete_timecard
1418: (p_blocks => l_blocks
1419: ,p_timecard_id => p_timecard_id
1420: );
1421:
1418: (p_blocks => l_blocks
1419: ,p_timecard_id => p_timecard_id
1420: );
1421:
1422: hxc_timecard_audit.audit_deposit
1423: (p_transaction_info => l_transaction_info
1424: ,p_messages => l_messages
1425: );
1426:
1423: (p_transaction_info => l_transaction_info
1424: ,p_messages => l_messages
1425: );
1426:
1427: hxc_timecard_audit.maintain_latest_details
1428: (p_blocks => l_blocks );
1429: end if;
1430: hxc_timecard_message_helper.processerrors
1431: (p_messages => l_messages);
1426:
1427: hxc_timecard_audit.maintain_latest_details
1428: (p_blocks => l_blocks );
1429: end if;
1430: hxc_timecard_message_helper.processerrors
1431: (p_messages => l_messages);
1432:
1433: end if;
1434:
1434:
1435: hxc_lock_api.release_lock
1436: (p_row_lock_id => l_lock_rowid);
1437:
1438: hxc_timecard_message_helper.prepareErrors;
1439:
1440: end if; -- Is the timecard ok?
1441:
1442: End delete_timecard;
1489: CLOSE c_null_blocks;
1490:
1491: End delete_null_entries;
1492:
1493: END hxc_timecard;