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_TIMECARD_SUMMARY_PKG dependencies on HXC_TIMECARD_SUMMARY

Line 1: package body hxc_timecard_summary_pkg as

1: package body hxc_timecard_summary_pkg as
2: /* $Header: hxctcsum.pkb 120.4.12010000.3 2008/08/05 12:06:11 ubhat ship $ */
3:
4: g_check_for_reasons varchar2(1) := null;
5:

Line 276: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;

272: l_submission_date hxc_time_building_blocks.creation_date%type;
273: l_creation_date hxc_time_building_blocks.creation_date%type;
274: l_ovn hxc_time_building_blocks.object_version_number%type;
275: l_has_reasons varchar2(1);
276: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
277: l_details details;
278: l_data_set_id hxc_time_building_blocks.data_set_id%type;
279:
280: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;

Line 280: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;

276: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
277: l_details details;
278: l_data_set_id hxc_time_building_blocks.data_set_id%type;
279:
280: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
281: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
282: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;
283:
284: Begin

Line 281: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;

277: l_details details;
278: l_data_set_id hxc_time_building_blocks.data_set_id%type;
279:
280: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
281: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
282: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;
283:
284: Begin
285:

Line 282: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;

278: l_data_set_id hxc_time_building_blocks.data_set_id%type;
279:
280: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
281: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
282: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;
283:
284: Begin
285:
286: if(g_check_for_reasons is null) then

Line 362: insert into hxc_timecard_summary

358: l_approval_process_name := p_approval_process_name;
359: l_approval_item_key := p_approval_item_key;
360: END IF;
361:
362: insert into hxc_timecard_summary
363: (timecard_id
364: ,timecard_ovn
365: ,approval_status
366: ,resource_id

Line 472: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type

468:
469: End insert_summary_row;
470:
471: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
472: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
473: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
474: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
475: ) is
476:

Line 473: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type

469: End insert_summary_row;
470:
471: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
472: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
473: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
474: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
475: ) is
476:
477: l_item_key hxc_timecard_summary.approval_item_key%type;

Line 474: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type

470:
471: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
472: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
473: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
474: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
475: ) is
476:
477: l_item_key hxc_timecard_summary.approval_item_key%type;
478: l_dummy varchar2(1);

Line 477: l_item_key hxc_timecard_summary.approval_item_key%type;

473: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
474: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
475: ) is
476:
477: l_item_key hxc_timecard_summary.approval_item_key%type;
478: l_dummy varchar2(1);
479:
480: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
481: is

Line 480: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)

476:
477: l_item_key hxc_timecard_summary.approval_item_key%type;
478: l_dummy varchar2(1);
479:
480: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
481: is
482: select 'Y'
483: from wf_item_activity_statuses wias
484: where item_type = 'HXCEMP'

Line 491: from hxc_timecard_summary

487:
488: cursor c_get_item_key(p_timecard_id in number)
489: is
490: select approval_item_key
491: from hxc_timecard_summary
492: where timecard_id = p_timecard_id;
493:
494: Begin
495:

Line 515: UPDATE hxc_timecard_summary

511: end if;
512: end if;
513:
514:
515: UPDATE hxc_timecard_summary
516: SET approval_item_type = p_approval_item_type,
517: approval_process_name = p_approval_process_name,
518: approval_item_key =p_approval_item_key
519: WHERE TIMECARD_ID= p_timecard_id;

Line 528: delete from hxc_timecard_summary where timecard_id = p_timecard_id;

524: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
525:
526: Begin
527:
528: delete from hxc_timecard_summary where timecard_id = p_timecard_id;
529:
530: Exception
531: When others then
532: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');

Line 541: update hxc_timecard_summary

537: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
538:
539: Begin
540:
541: update hxc_timecard_summary
542: set approval_status = hxc_timecard.c_rejected_status
543: where timecard_id = p_timecard_id;
544:
545: End reject_timecard;

Line 551: update hxc_timecard_summary

547: Procedure approve_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
548:
549: Begin
550:
551: update hxc_timecard_summary
552: set approval_status = hxc_timecard.c_approved_status
553: where timecard_id = p_timecard_id;
554:
555: End approve_timecard;

Line 561: update hxc_timecard_summary

557: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
558:
559: Begin
560:
561: update hxc_timecard_summary
562: set approval_status = hxc_timecard.c_submitted_status
563: where timecard_id = p_timecard_id;
564:
565: End submit_timecard;

Line 567: end hxc_timecard_summary_pkg;

563: where timecard_id = p_timecard_id;
564:
565: End submit_timecard;
566:
567: end hxc_timecard_summary_pkg;