DBA Data[Home] [Help]

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.4.12010000.3 2008/08/05 12:06:11 ubhat ship $ */
3:
4: g_check_for_reasons varchar2(1) := null;
5:

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

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

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

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

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

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

Line 266: where attribute_category = hxc_timecard.c_reason_attribute;

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

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 332: if(l_approval_status = hxc_timecard.c_working_status) then

328: end if;
329: --
330: -- 4. Submission Date
331: --
332: if(l_approval_status = hxc_timecard.c_working_status) then
333: l_submission_date := null;
334: else
335: --
336: -- 115.5 Change. Submission date for normal process

Line 351: if(l_approval_status = hxc_timecard.c_working_status OR

347: --
348: -- Insert Summary Row
349: --
350:
351: if(l_approval_status = hxc_timecard.c_working_status OR
352: l_approval_status = hxc_timecard.c_error) then
353: l_approval_item_type :=NULL;
354: l_approval_process_name :=NULL;
355: l_approval_item_key :=NULL;

Line 352: l_approval_status = hxc_timecard.c_error) then

348: -- Insert Summary Row
349: --
350:
351: if(l_approval_status = hxc_timecard.c_working_status OR
352: l_approval_status = hxc_timecard.c_error) then
353: l_approval_item_type :=NULL;
354: l_approval_process_name :=NULL;
355: l_approval_item_key :=NULL;
356: Else

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 542: set approval_status = hxc_timecard.c_rejected_status

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

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 552: set approval_status = hxc_timecard.c_approved_status

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

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 562: set approval_status = hxc_timecard.c_submitted_status

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

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;