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.5 2006/03/29 12:54:44 jdupont noship $ */
3:
4: g_package varchar2(25) := 'hxc_timecard_block_utils.';
5: g_timecard_index number;

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

1: PACKAGE BODY hxc_timecard_block_utils AS
2: /* $Header: hxctcbkut.pkb 120.5 2006/03/29 12:54:44 jdupont noship $ */
3:
4: g_package varchar2(25) := 'hxc_timecard_block_utils.';
5: g_timecard_index number;
6:
7: e_no_existing_block exception;
8:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

556: -- 11. Translation Display Key
557: if(nvl(p_block1.translation_display_key,'NULL') <> nvl(p_block2.translation_display_key,'NULL')) then
558: return true;
559: end if;
560: elsif((p_block1.scope=hxc_timecard.c_timecard_scope)OR(p_block1.scope=hxc_timecard.c_template_scope)) then
561: -- 1. Comment
562: if(nvl(p_block1.comment_text,'NULL') <> nvl(p_block2.comment_text,'NULL')) then
563: return true;
564: end if;

Line 601: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST

597: End blocks_are_different;
598:
599: Procedure sort_blocks
600: (p_blocks in HXC_BLOCK_TABLE_TYPE
601: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
602: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
603: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
604: ) is
605:

Line 602: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST

598:
599: Procedure sort_blocks
600: (p_blocks in HXC_BLOCK_TABLE_TYPE
601: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
602: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
603: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
604: ) is
605:
606: l_block HXC_BLOCK_TYPE;

Line 603: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST

599: Procedure sort_blocks
600: (p_blocks in HXC_BLOCK_TABLE_TYPE
601: ,p_timecard_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
602: ,p_day_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
603: ,p_detail_blocks out nocopy HXC_TIMECARD.BLOCK_LIST
604: ) is
605:
606: l_block HXC_BLOCK_TYPE;
607: l_index NUMBER;

Line 667: END hxc_timecard_block_utils;

663: return (l_bb_id-100);
664:
665: End next_block_id;
666:
667: END hxc_timecard_block_utils;