DBA Data[Home] [Help]

APPS.HXC_TIMECARD_APPROVAL dependencies on HXC_TIMECARD

Line 1: package body hxc_timecard_approval as

1: package body hxc_timecard_approval as
2: /* $Header: hxctimeapprove.pkb 120.8 2006/09/08 08:59:11 rchennur noship $ */
3:
4: g_package varchar2(30) := 'hxc_timecard_approval.';
5: g_debug boolean := hr_utility.debug_enabled;

Line 4: g_package varchar2(30) := 'hxc_timecard_approval.';

1: package body hxc_timecard_approval as
2: /* $Header: hxctimeapprove.pkb 120.8 2006/09/08 08:59:11 rchennur noship $ */
3:
4: g_package varchar2(30) := 'hxc_timecard_approval.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: TYPE application_period_table IS TABLE OF hxc_app_period_summary.APPLICATION_PERIOD_ID%TYPE;
8: TYPE tc_ap_links IS RECORD

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

118: p_timecard_info out nocopy timecard_info
119: ) is
120: l_timecard_index number;
121: Begin
122: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
123: p_timecard_id := p_blocks(l_timecard_index).time_building_block_id;
124: p_timecard_ovn := p_blocks(l_timecard_index).object_version_number;
125: p_new_blocks := hxc_timecard_block_utils.any_new_blocks(p_blocks);
126: p_timecard_info.time_building_block_id := p_blocks(l_timecard_index).time_building_block_id;

Line 125: p_new_blocks := hxc_timecard_block_utils.any_new_blocks(p_blocks);

121: Begin
122: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
123: p_timecard_id := p_blocks(l_timecard_index).time_building_block_id;
124: p_timecard_ovn := p_blocks(l_timecard_index).object_version_number;
125: p_new_blocks := hxc_timecard_block_utils.any_new_blocks(p_blocks);
126: p_timecard_info.time_building_block_id := p_blocks(l_timecard_index).time_building_block_id;
127: p_timecard_info.object_version_number := p_blocks(l_timecard_index).object_version_number;
128: p_timecard_info.type := p_blocks(l_timecard_index).type;
129: p_timecard_info.start_time := to_date(p_blocks(l_timecard_index).start_time,'rrrr/mm/dd hh24:mi:ss');

Line 202: l_assignment_periods hxc_timecard_utilities.periods;

198: l_period_start_date HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE ;
199: l_period_end_date HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE ;
200: l_tc_ap_links_table tc_ap_links_table;
201: l_index number ;
202: l_assignment_periods hxc_timecard_utilities.periods;
203: l_app_period_info application_period_table;
204: l_creation_date hxc_time_building_blocks.creation_date%TYPE := NULL;
205: l_dup_index number;
206: l_detail_array ap_detail_links_rec;

Line 209: l_timecard_blocks hxc_timecard.block_list;

205: l_dup_index number;
206: l_detail_array ap_detail_links_rec;
207: l_index_1 number;
208: l_index_2 number;
209: l_timecard_blocks hxc_timecard.block_list;
210: l_day_blocks hxc_timecard.block_list;
211: l_detail_blocks hxc_timecard.block_list;
212: l_proc varchar2(70);
213:

Line 210: l_day_blocks hxc_timecard.block_list;

206: l_detail_array ap_detail_links_rec;
207: l_index_1 number;
208: l_index_2 number;
209: l_timecard_blocks hxc_timecard.block_list;
210: l_day_blocks hxc_timecard.block_list;
211: l_detail_blocks hxc_timecard.block_list;
212: l_proc varchar2(70);
213:
214: Begin

Line 211: l_detail_blocks hxc_timecard.block_list;

207: l_index_1 number;
208: l_index_2 number;
209: l_timecard_blocks hxc_timecard.block_list;
210: l_day_blocks hxc_timecard.block_list;
211: l_detail_blocks hxc_timecard.block_list;
212: l_proc varchar2(70);
213:
214: Begin
215: if g_debug then

Line 244: * been deleted in the hxc_timecard package */

240: (p_timecard_id => p_tc_bb_id);
241:
242: /*Remove existing records from hxc_tc_ap_links
243: * Most probably there wont be any records as they would have
244: * been deleted in the hxc_timecard package */
245:
246: hxc_tc_ap_links_pkg.remove_timecard_links
247: (p_timecard_id => p_tc_bb_id );
248:

Line 299: hxc_timecard_block_utils.sort_blocks

295:
296: /* For each of the recipient Application present in the Application set of the person*/
297: /* We get the detail blocks of the Timecard from p_blocks */
298:
299: hxc_timecard_block_utils.sort_blocks
300: (p_blocks => p_blocks,
301: p_timecard_blocks => l_timecard_blocks,
302: p_day_blocks => l_day_blocks,
303: p_detail_blocks => l_detail_blocks

Line 416: update hxc_timecard_summary

412: if g_debug then
413: hr_utility.set_location('Processing '||l_proc, 120);
414: end if;
415:
416: update hxc_timecard_summary
417: set approval_status = hxc_timecard.c_approved_status
418: where timecard_id = p_tc_bb_id;
419:
420: if g_debug then

Line 417: set approval_status = hxc_timecard.c_approved_status

413: hr_utility.set_location('Processing '||l_proc, 120);
414: end if;
415:
416: update hxc_timecard_summary
417: set approval_status = hxc_timecard.c_approved_status
418: where timecard_id = p_tc_bb_id;
419:
420: if g_debug then
421: hr_utility.set_location('Processing '||l_proc, 130);

Line 428: p_timecard_props hxc_timecard_prop_table_type)

424: end light_approve_timecards;
425:
426: Function active_assignment_over_period
427: (p_timecard_info timecard_info,
428: p_timecard_props hxc_timecard_prop_table_type)
429: return Boolean is
430:
431: l_return boolean := true;
432: l_types_done boolean := false;

Line 468: p_timecard_props in hxc_timecard_prop_table_type,

464: (p_blocks in hxc_block_table_type,
465: p_item_type in wf_items.item_type%type,
466: p_process_name in wf_process_activities.process_name%type,
467: p_resubmitted in varchar2,
468: p_timecard_props in hxc_timecard_prop_table_type,
469: p_messages in out nocopy hxc_message_table_type
470: ) return VARCHAR2 is
471:
472: l_item_key number;

Line 558: hxc_timecard_message_helper.addErrorToCollection

554: -- other non-active assignment, we should inform them
555: -- that the timecard has been auto-approved.
556: if(not l_active_asg) then
557: -- Add informational Message
558: hxc_timecard_message_helper.addErrorToCollection
559: (p_messages,
560: 'HXC_366547_INACTIVE_ASG_APPR',
561: hxc_timecard.c_business_message,
562: null,

Line 561: hxc_timecard.c_business_message,

557: -- Add informational Message
558: hxc_timecard_message_helper.addErrorToCollection
559: (p_messages,
560: 'HXC_366547_INACTIVE_ASG_APPR',
561: hxc_timecard.c_business_message,
562: null,
563: null,
564: hxc_timecard.c_hxc,
565: l_timecard_id,

Line 564: hxc_timecard.c_hxc,

560: 'HXC_366547_INACTIVE_ASG_APPR',
561: hxc_timecard.c_business_message,
562: null,
563: null,
564: hxc_timecard.c_hxc,
565: l_timecard_id,
566: l_timecard_ovn,
567: null,
568: null

Line 580: end hxc_timecard_approval;

576: return to_char(l_item_key);
577:
578: End begin_approval;
579:
580: end hxc_timecard_approval;