APPS.HXC_TIMECARD_BLOCK_UTILS dependencies on HXC_TIMECARD

Line 1: PACKAGE BODY hxc_timecard_block_utils AS

1: PACKAGE BODY hxc_timecard_block_utils AS
2: /* $Header: hxctcbkut.pkb 120.8 2011/08/23 13:11:26 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:

Line 6: g_package varchar2(25) := 'hxc_timecard_block_utils.';

2: /* $Header: hxctcbkut.pkb 120.8 2011/08/23 13:11:26 bbayragi ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: g_package varchar2(25) := 'hxc_timecard_block_utils.';
7: g_timecard_index number;
8:
9: e_no_existing_block exception;
10:

Line 66: if(p_blocks(g_timecard_index).scope in (hxc_timecard.c_timecard_scope, hxc_timecard.c_template_scope))then

62: BEGIN
63:
64: if(g_timecard_index is not null) then
65: if(p_blocks.exists(g_timecard_index)) then
66: if(p_blocks(g_timecard_index).scope in (hxc_timecard.c_timecard_scope, hxc_timecard.c_template_scope))then
67: l_tc_index := g_timecard_index;
68: else
69: g_timecard_index := null;
70: end if;

Line 84: (p_blocks(l_index).scope in (hxc_timecard.c_timecard_scope, hxc_timecard.c_template_scope))

80: LOOP
81: EXIT WHEN ((NOT p_blocks.exists(l_index)) OR (l_tc_index is NOT NULL));
82:
83: if(
84: (p_blocks(l_index).scope in (hxc_timecard.c_timecard_scope, hxc_timecard.c_template_scope))
85: AND
86: (date_value(p_blocks(l_index).date_to) = hr_general.end_of_time)
87: ) then
88:

Line 113: if(p_blocks(l_index).scope in (hxc_timecard.c_timecard_scope, hxc_timecard.c_template_scope))then

109:
110: LOOP
111: EXIT WHEN ((NOT p_blocks.exists(l_index)) OR (l_tc_index is NOT NULL));
112:
113: if(p_blocks(l_index).scope in (hxc_timecard.c_timecard_scope, hxc_timecard.c_template_scope))then
114:
115: l_tc_index := l_index;
116:
117: end if;

Line 210: (p_block.scope = hxc_timecard.c_timecard_scope)

206: return BOOLEAN is
207: Begin
208:
209: if(
210: (p_block.scope = hxc_timecard.c_timecard_scope)
211: OR
212: (p_block.scope = hxc_timecard.c_template_scope)
213: )then
214: return true;

Line 212: (p_block.scope = hxc_timecard.c_template_scope)

208:
209: if(
210: (p_block.scope = hxc_timecard.c_timecard_scope)
211: OR
212: (p_block.scope = hxc_timecard.c_template_scope)
213: )then
214: return true;
215: else
216: return false;

Line 226: if(p_block.scope = hxc_timecard.c_day_scope) then

222: (p_block in HXC_BLOCK_TYPE)
223: return BOOLEAN is
224: Begin
225:
226: if(p_block.scope = hxc_timecard.c_day_scope) then
227: return true;
228: else
229: return false;
230: end if;

Line 268: if(p_block.scope = hxc_timecard.c_detail_scope)then

264: (p_block in HXC_BLOCK_TYPE)
265: return BOOLEAN is
266: Begin
267:
268: if(p_block.scope = hxc_timecard.c_detail_scope)then
269: return true;
270: else
271: return false;
272: end if;

Line 379: if(p_block.process = hxc_timecard.c_process) then

375: ) return BOOLEAN is
376:
377: Begin
378:
379: if(p_block.process = hxc_timecard.c_process) then
380: return true;
381: else
382: return false;
383: end if;

Line 495: hr_utility.trace(' In hxc_timecard_block_utilis.blocks_are_different ..');

491:
492: Begin
493:
494: IF g_debug THEN
495: hr_utility.trace(' In hxc_timecard_block_utilis.blocks_are_different ..');
496: END IF;
497:
498: if(p_block1.scope = 'DETAIL') then
499:

Line 588: hr_utility.trace('OTL: HXC_TIMECARD_BLOCK_UTILS:FALSE');

584: then
585: -- Bug 9448458
586: -- blocks are same. Translation display key is null when initially created from API/TK
587: -- when resubmitted from ss translation display key is not null
588: hr_utility.trace('OTL: HXC_TIMECARD_BLOCK_UTILS:FALSE');
589:
590: -- Added for Bug 12774447
591: hr_utility.trace(' hxc_block_attribute_update.g_tc_api_flag ::'||hxc_block_attribute_update.g_tc_api_flag);
592:

Line 604: hr_utility.trace('OTL: HXC_TIMECARD_BLOCK_UTILS:TRUE');

600:
601: return true;
602: else
603: hxc_block_attribute_update.g_tc_api_flag := 'N';
604: hr_utility.trace('OTL: HXC_TIMECARD_BLOCK_UTILS:TRUE');
605: return true;
606: end if;
607: end if;
608: elsif((p_block1.scope=hxc_timecard.c_timecard_scope)OR(p_block1.scope=hxc_timecard.c_template_scope)) then

Line 608: elsif((p_block1.scope=hxc_timecard.c_timecard_scope)OR(p_block1.scope=hxc_timecard.c_template_scope)) then

604: hr_utility.trace('OTL: HXC_TIMECARD_BLOCK_UTILS:TRUE');
605: return true;
606: end if;
607: end if;
608: elsif((p_block1.scope=hxc_timecard.c_timecard_scope)OR(p_block1.scope=hxc_timecard.c_template_scope)) then
609: -- 1. Comment
610: if(nvl(p_block1.comment_text,'NULL') <> nvl(p_block2.comment_text,'NULL')) then
611: hxc_block_attribute_update.g_tc_api_flag := 'N';
612: return true;

Line 656: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST

652: End blocks_are_different;
653:
654: Procedure sort_blocks
655: (p_blocks in HXC_BLOCK_TABLE_TYPE
656: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
657: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
658: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
659: ) is
660:

Line 657: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST

653:
654: Procedure sort_blocks
655: (p_blocks in HXC_BLOCK_TABLE_TYPE
656: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
657: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
658: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
659: ) is
660:
661: l_block HXC_BLOCK_TYPE;

Line 658: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST

654: Procedure sort_blocks
655: (p_blocks in HXC_BLOCK_TABLE_TYPE
656: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
657: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
658: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
659: ) is
660:
661: l_block HXC_BLOCK_TYPE;
662: l_index NUMBER;

Line 722: END hxc_timecard_block_utils;

718: return (l_bb_id-100);
719:
720: End next_block_id;
721:
722: END hxc_timecard_block_utils;