DBA Data[Home] [Help]

APPS.HXC_TIMECARD dependencies on HXC_TIMECARD_BLOCK_UTILS

Line 59: hxc_timecard_block_utils.sort_blocks

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

Line 135: hxc_timecard_block_utils.sort_blocks

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

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

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:

Line 235: p_timecard_id := p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).time_building_block_id;

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:

Line 236: p_timecard_ovn:= p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).object_version_number;

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

Line 286: hxc_timecard_block_utils.initialize_timecard_index;

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);

Line 289: l_active_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);

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:

Line 290: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).start_time);

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

Line 291: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_active_index).stop_time);

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,

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

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

Line 327: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then

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

Line 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;

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

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;

Line 346: l_tbb_id :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).time_building_block_id;

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

Line 347: l_tbb_ovn :=p_blocks(hxc_timecard_block_utils.find_active_timecard_index (p_blocks)).object_version_number;

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;

Line 357: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_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

Line 358: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time)

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

Line 440: hxc_timecard_block_utils.sort_blocks

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

Line 629: hxc_timecard_block_utils.sort_blocks

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

Line 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:

Line 832: (hxc_timecard_block_utils.find_active_timecard_index(g_deposit_blocks)).object_version_number;

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:

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

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

Line 984: if(hxc_timecard_block_utils.is_new_block(p_blocks(l_timecard_index))) then

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

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

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: --

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

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

Line 1320: ,p_timecard_start_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).start_time)

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

Line 1321: ,p_timecard_stop_time => hxc_timecard_block_utils.date_value(l_blocks(l_timecard_index).stop_time)

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

Line 1334: hxc_timecard_block_utils.sort_blocks

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