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

Line 1: package body hxc_timecard_summary_pkg as

1: package body hxc_timecard_summary_pkg as
2: /* $Header: hxctcsum.pkb 120.12.12020000.4 2013/02/11 12:35:11 asrajago ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_check_for_reasons varchar2(1) := null;

Line 14: return hxc_timecard_search_pkg.get_timecard_status_code(p_timecard_id,p_timecard_ovn,c_migration_mode);

10: ) return varchar2 is
11:
12: begin
13:
14: return hxc_timecard_search_pkg.get_timecard_status_code(p_timecard_id,p_timecard_ovn,c_migration_mode);
15:
16: end get_migration_apr_status;
17:
18: procedure get_recorded_hours

Line 127: if(det_rec.type=hxc_timecard.c_range_type) then

123:
124: p_details(l_index).time_building_block_id := det_rec.time_building_block_id;
125: p_details(l_index).time_building_block_ovn := det_rec.object_version_number;
126: p_details(l_index).creation_date := det_rec.creation_date;
127: if(det_rec.type=hxc_timecard.c_range_type) then
128: p_hours := p_hours + hxc_find_notify_aprs_pkg.apply_round_rule(
129: l_rounding_rule,
130: l_precision,
131: nvl((det_rec.stop_time - det_rec.start_time)*24,0)

Line 162: and ta.attribute_category = hxc_timecard.c_reason_attribute;

158: select 'Y'
159: from hxc_time_attribute_usages tau, hxc_time_attributes ta
160: where tau.time_building_block_id = p_id
161: and tau.time_Attribute_id = ta.time_attribute_Id
162: and ta.attribute_category = hxc_timecard.c_reason_attribute;
163:
164: l_index number;
165: l_found boolean := false;
166: l_result varchar2(1) := 'N';

Line 267: where attribute_category = hxc_timecard.c_reason_attribute;

263:
264: cursor c_check_for_reasons is
265: select 'Y'
266: from hxc_time_attributes
267: where attribute_category = hxc_timecard.c_reason_attribute;
268:
269: l_approval_status hxc_time_building_blocks.approval_status%type;
270: l_resource_id hxc_time_building_blocks.resource_id%type;
271: l_start_time hxc_time_building_blocks.start_time%type;

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

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

Line 281: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;

277: l_recorded_hours hxc_timecard_summary.recorded_hours%type :=0;
278: l_details details;
279: l_data_set_id hxc_time_building_blocks.data_set_id%type;
280:
281: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
282: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
283: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;
284:
285: l_abs_days NUMBER := 0; -- Added as part of OTL ABS Integration

Line 282: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;

278: l_details details;
279: l_data_set_id hxc_time_building_blocks.data_set_id%type;
280:
281: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
282: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
283: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;
284:
285: l_abs_days NUMBER := 0; -- Added as part of OTL ABS Integration
286: l_abs_hours NUMBER := 0; -- Added as part of OTL ABS Integration

Line 283: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;

279: l_data_set_id hxc_time_building_blocks.data_set_id%type;
280:
281: l_approval_item_type hxc_timecard_summary.approval_item_type%TYPE;
282: l_approval_process_name hxc_timecard_summary.approval_process_name%TYPE;
283: l_approval_item_key hxc_timecard_summary.approval_item_key%TYPE;
284:
285: l_abs_days NUMBER := 0; -- Added as part of OTL ABS Integration
286: l_abs_hours NUMBER := 0; -- Added as part of OTL ABS Integration
287:

Line 341: if(l_approval_status = hxc_timecard.c_working_status OR

337: --
338: -- Insert Summary Row
339: --
340:
341: if(l_approval_status = hxc_timecard.c_working_status OR
342: l_approval_status = hxc_timecard.c_error) then
343: l_approval_item_type :=NULL;
344: l_approval_process_name :=NULL;
345: l_approval_item_key :=NULL;

Line 342: l_approval_status = hxc_timecard.c_error) then

338: -- Insert Summary Row
339: --
340:
341: if(l_approval_status = hxc_timecard.c_working_status OR
342: l_approval_status = hxc_timecard.c_error) then
343: l_approval_item_type :=NULL;
344: l_approval_process_name :=NULL;
345: l_approval_item_key :=NULL;
346: Else

Line 358: hr_utility.trace('ABS> In hxc_timecard_summary_pkg.insert_summary_row');

354: IF (NVL(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y')
355: THEN
356:
357: IF g_debug THEN
358: hr_utility.trace('ABS> In hxc_timecard_summary_pkg.insert_summary_row');
359: hr_utility.trace('ABS> initial value of recorded hours ::'||l_recorded_hours);
360: END IF;
361:
362: BEGIN

Line 401: hr_utility.trace('ABS> In hxc_timecard_summary_pkg.insert_summary_row');

397: END IF;
398:
399: -- clear absence summary rows
400: IF g_debug THEN
401: hr_utility.trace('ABS> In hxc_timecard_summary_pkg.insert_summary_row');
402: hr_utility.trace('ABS> clear absence summary rows');
403: END IF;
404:
405: hxc_retrieve_absences.clear_absence_summary_rows;

Line 410: insert into hxc_timecard_summary

406:
407: END IF;
408: -- OTL-ABS END
409:
410: insert into hxc_timecard_summary
411: (timecard_id
412: ,timecard_ovn
413: ,approval_status
414: ,resource_id

Line 524: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type

520:
521: End insert_summary_row;
522:
523: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
524: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
525: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
526: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
527: ) is
528:

Line 525: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type

521: End insert_summary_row;
522:
523: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
524: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
525: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
526: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
527: ) is
528:
529: l_item_key hxc_timecard_summary.approval_item_key%type;

Line 526: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type

522:
523: procedure update_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
524: ,p_approval_item_type in hxc_timecard_summary.approval_item_type%type
525: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
526: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
527: ) is
528:
529: l_item_key hxc_timecard_summary.approval_item_key%type;
530: l_dummy varchar2(1);

Line 529: l_item_key hxc_timecard_summary.approval_item_key%type;

525: ,p_approval_process_name in hxc_timecard_summary.approval_process_name%type
526: ,p_approval_item_key in hxc_timecard_summary.approval_item_key%type
527: ) is
528:
529: l_item_key hxc_timecard_summary.approval_item_key%type;
530: l_dummy varchar2(1);
531:
532: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
533: is

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

528:
529: l_item_key hxc_timecard_summary.approval_item_key%type;
530: l_dummy varchar2(1);
531:
532: cursor c_is_wf_deferred(p_item_key in hxc_timecard_summary.approval_item_key%type)
533: is
534: select 'Y'
535: from wf_item_activity_statuses wias
536: where item_type = 'HXCEMP'

Line 543: from hxc_timecard_summary

539:
540: cursor c_get_item_key(p_timecard_id in number)
541: is
542: select approval_item_key
543: from hxc_timecard_summary
544: where timecard_id = p_timecard_id;
545:
546: Begin
547:

Line 567: UPDATE hxc_timecard_summary

563: end if;
564: end if;
565:
566:
567: UPDATE hxc_timecard_summary
568: SET approval_item_type = p_approval_item_type,
569: approval_process_name = p_approval_process_name,
570: approval_item_key =p_approval_item_key
571: WHERE TIMECARD_ID= p_timecard_id;

Line 580: delete from hxc_timecard_summary where timecard_id = p_timecard_id;

576: procedure delete_summary_row(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
577:
578: Begin
579:
580: delete from hxc_timecard_summary where timecard_id = p_timecard_id;
581:
582: Exception
583: When others then
584: FND_MESSAGE.set_name('HXC','HXC_NO_TIMECARD_ID');

Line 593: update hxc_timecard_summary

589: procedure reject_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
590:
591: Begin
592:
593: update hxc_timecard_summary
594: set approval_status = hxc_timecard.c_rejected_status
595: where timecard_id = p_timecard_id;
596:
597: End reject_timecard;

Line 594: set approval_status = hxc_timecard.c_rejected_status

590:
591: Begin
592:
593: update hxc_timecard_summary
594: set approval_status = hxc_timecard.c_rejected_status
595: where timecard_id = p_timecard_id;
596:
597: End reject_timecard;
598:

Line 607: FROM hxc_timecard_summary

603: SELECT resource_id,
604: start_time,
605: stop_time,
606: approval_status
607: FROM hxc_timecard_summary
608: WHERE timecard_id = c_timecard_id;
609:
610: l_messages hxc_message_table_type := hxc_message_table_type();
611:

Line 619: update hxc_timecard_summary

615: l_approval_status VARCHAR2(20);
616:
617: Begin
618:
619: update hxc_timecard_summary
620: set approval_status = hxc_timecard.c_approved_status
621: where timecard_id = p_timecard_id;
622:
623: -- OTL-Absences Integration (Bug 8779478)

Line 620: set approval_status = hxc_timecard.c_approved_status

616:
617: Begin
618:
619: update hxc_timecard_summary
620: set approval_status = hxc_timecard.c_approved_status
621: where timecard_id = p_timecard_id;
622:
623: -- OTL-Absences Integration (Bug 8779478)
624: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN

Line 626: hr_utility.trace('Initiated Online Retrieval from HXC_TIMECARD_SUMMARY_PKG.APPROVE_TIMECARD');

622:
623: -- OTL-Absences Integration (Bug 8779478)
624: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
625: IF g_debug THEN
626: hr_utility.trace('Initiated Online Retrieval from HXC_TIMECARD_SUMMARY_PKG.APPROVE_TIMECARD');
627: END IF;
628:
629: OPEN c_timecard_details(p_timecard_id);
630: FETCH c_timecard_details INTO l_resource_id,

Line 643: hr_utility.trace('Completed Online Retrieval from HXC_TIMECARD_SUMMARY_PKG.APPROVE_TIMECARD');

639: l_approval_status,
640: l_messages);
641:
642: IF g_debug THEN
643: hr_utility.trace('Completed Online Retrieval from HXC_TIMECARD_SUMMARY_PKG.APPROVE_TIMECARD');
644: END IF;
645:
646: IF (l_messages.COUNT > 0) THEN
647: IF g_debug THEN

Line 663: update hxc_timecard_summary

659: Procedure submit_timecard(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
660:
661: Begin
662:
663: update hxc_timecard_summary
664: set approval_status = hxc_timecard.c_submitted_status
665: where timecard_id = p_timecard_id;
666:
667: End submit_timecard;

Line 664: set approval_status = hxc_timecard.c_submitted_status

660:
661: Begin
662:
663: update hxc_timecard_summary
664: set approval_status = hxc_timecard.c_submitted_status
665: where timecard_id = p_timecard_id;
666:
667: End submit_timecard;
668:

Line 683: FROM hxc_timecard_summary sum,

679: CURSOR get_details( p_timecard_id IN NUMBER,
680: p_timecard_ovn IN NUMBER,
681: p_process_id IN NUMBER )
682: IS SELECT 1
683: FROM hxc_timecard_summary sum,
684: hxc_time_building_blocks day,
685: hxc_time_building_blocks det,
686: hxc_latest_details hld
687: WHERE sum.timecard_id = p_timecard_id

Line 784: UPDATE hxc_timecard_summary

780: -- Update the transferred to column.
781: -- Do an LTRIM and RTRIM to avoid leading and trailing zeros.
782: -- Bug 16294903
783: -- Added a construct inside the NVL to remove showing up the same application twice.
784: UPDATE hxc_timecard_summary
785: SET transferred_to = RTRIM(LTRIM((NVL(REPLACE(transferred_to,l_recipient_name),',')||','||l_recipient_name),','),',')
786: WHERE timecard_id = p_timecard_id
787: AND timecard_ovn = p_timecard_ovn;
788:

Line 794: FROM hxc_timecard_summary

790: IF g_debug
791: THEN
792: SELECT transferred_to
793: INTO l_recipient_name
794: FROM hxc_timecard_summary
795: WHERE timecard_id = p_timecard_id
796: AND timecard_ovn = p_timecard_ovn;
797:
798: hr_utility.trace('New value is '||l_recipient_name);

Line 811: end hxc_timecard_summary_pkg;

807: hr_utility.trace(dbms_utility.format_error_backtrace);
808:
809: END update_transferred_to;
810:
811: end hxc_timecard_summary_pkg;
812: