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_TCSUMMARY_MIGRATE dependencies on HXC_TIME_BUILDING_BLOCKS

Line 11: from hxc_time_building_blocks tbb

7: select ts.timecard_id
8: ,ts.timecard_ovn
9: from hxc_timecard_summary ts
10: where not exists (select 'Y'
11: from hxc_time_building_blocks tbb
12: where tbb.time_building_block_id = ts.timecard_id and
13: tbb.object_version_number = ts.timecard_ovn and
14: tbb.scope = 'TIMECARD' and
15: tbb.date_to = hr_general.end_of_time);

Line 22: from hxc_time_building_blocks tbb

18: select ts.timecard_id
19: ,ts.timecard_ovn
20: from hxc_timecard_summary ts
21: where exists (select 'Y'
22: from hxc_time_building_blocks tbb
23: where tbb.time_building_block_id = ts.timecard_id and
24: tbb.object_version_number = ts.timecard_ovn and
25: tbb.scope = 'TIMECARD' and
26: tbb.date_to <> hr_general.end_of_time);

Line 54: from hxc_time_building_blocks tbb

50: select ts.template_id
51: ,ts.template_ovn
52: from hxc_template_summary ts
53: where not exists (select 'Y'
54: from hxc_time_building_blocks tbb
55: where tbb.time_building_block_id = ts.template_id and
56: tbb.object_version_number = ts.template_ovn and
57: tbb.scope = 'TIMECARD_TEMPLATE' and
58: tbb.date_to = hr_general.end_of_time);

Line 65: from hxc_time_building_blocks tbb

61: select ts.template_id
62: ,ts.template_ovn
63: from hxc_template_summary ts
64: where exists (select 'Y'
65: from hxc_time_building_blocks tbb
66: where tbb.time_building_block_id = ts.template_id and
67: tbb.object_version_number = ts.template_ovn and
68: tbb.scope = 'TIMECARD_TEMPLATE' and
69: tbb.date_to <> hr_general.end_of_time);

Line 89: procedure timecard_summary(p_resource_id in hxc_time_building_blocks.resource_id%type) is

85: end loop;
86:
87: End delete_templates;
88:
89: procedure timecard_summary(p_resource_id in hxc_time_building_blocks.resource_id%type) is
90:
91: cursor c_timecards(p_rid in number) is
92: select tbb.time_building_block_id
93: ,tbb.object_version_number

Line 94: from hxc_time_building_blocks tbb

90:
91: cursor c_timecards(p_rid in number) is
92: select tbb.time_building_block_id
93: ,tbb.object_version_number
94: from hxc_time_building_blocks tbb
95: where tbb.resource_id = p_rid and
96: tbb.date_to = hr_general.end_of_time and
97: tbb.scope = 'TIMECARD' and
98: not exists

Line 124: procedure template_summary(p_resource_id in hxc_time_building_blocks.resource_id%type) is

120: end loop;
121:
122: End timecard_summary;
123:
124: procedure template_summary(p_resource_id in hxc_time_building_blocks.resource_id%type) is
125:
126: cursor c_templates(p_rid in number) is
127: select tbb.time_building_block_id
128: ,tbb.object_version_number

Line 129: from hxc_time_building_blocks tbb

125:
126: cursor c_templates(p_rid in number) is
127: select tbb.time_building_block_id
128: ,tbb.object_version_number
129: from hxc_time_building_blocks tbb
130: where tbb.resource_id = p_rid and
131: tbb.date_to = hr_general.end_of_time and
132: tbb.scope = 'TIMECARD_TEMPLATE'
133: and resource_id <>-1 and

Line 153: Procedure application_period_summary(p_resource_id in hxc_time_building_blocks.resource_id%type) is

149: end loop;
150:
151: End template_summary;
152:
153: Procedure application_period_summary(p_resource_id in hxc_time_building_blocks.resource_id%type) is
154:
155:
156: type app_period_list is table of hxc_time_building_blocks.time_building_block_id%type;
157:

Line 156: type app_period_list is table of hxc_time_building_blocks.time_building_block_id%type;

152:
153: Procedure application_period_summary(p_resource_id in hxc_time_building_blocks.resource_id%type) is
154:
155:
156: type app_period_list is table of hxc_time_building_blocks.time_building_block_id%type;
157:
158: l_app_periods app_period_list;
159:
160: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type) is

Line 160: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type) is

156: type app_period_list is table of hxc_time_building_blocks.time_building_block_id%type;
157:
158: l_app_periods app_period_list;
159:
160: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type) is
161: select distinct tbb.time_building_block_id
162: from hxc_time_building_blocks tbb
163: ,hxc_time_attribute_usages tau
164: ,hxc_time_attributes ta

Line 162: from hxc_time_building_blocks tbb

158: l_app_periods app_period_list;
159:
160: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type) is
161: select distinct tbb.time_building_block_id
162: from hxc_time_building_blocks tbb
163: ,hxc_time_attribute_usages tau
164: ,hxc_time_attributes ta
165: where tbb.scope = 'APPLICATION_PERIOD' and
166: tbb.date_to = hr_general.end_of_time and

Line 204: from hxc_time_building_blocks tbb

200: procedure run_migration is
201:
202: cursor c_valid_resources is
203: select distinct resource_id
204: from hxc_time_building_blocks tbb
205: where tbb.scope = 'TIMECARD' and
206: tbb.date_to = hr_general.end_of_time and
207: not exists
208: (select 'Y'

Line 223: from hxc_time_building_blocks tbb

219: where exists ( select 'x' from hxc_template_summary);
220:
221: cursor c_valid_template_resources is
222: select distinct resource_id
223: from hxc_time_building_blocks tbb
224: where tbb.scope = 'TIMECARD_TEMPLATE' and
225: tbb.date_to = hr_general.end_of_time and
226: not exists
227: (select 'Y'

Line 322: PROCEDURE update_appl_set_id(p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type

318: return false;
319: end if;
320: end;
321:
322: PROCEDURE update_appl_set_id(p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
323: ,p_start_date in date
324: ,p_end_date in date
325: ,p_resource_id in hxc_time_building_blocks.resource_id%type
326: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type

Line 325: ,p_resource_id in hxc_time_building_blocks.resource_id%type

321:
322: PROCEDURE update_appl_set_id(p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
323: ,p_start_date in date
324: ,p_end_date in date
325: ,p_resource_id in hxc_time_building_blocks.resource_id%type
326: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type
327: ,p_upg_count out nocopy number) IS
328:
329: CURSOR C_Time_BB_Ids(p_Building_Block_Id number, p_Object_Version_Number number) is

Line 326: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type

322: PROCEDURE update_appl_set_id(p_time_building_block_id in hxc_time_building_blocks.time_building_block_id%type
323: ,p_start_date in date
324: ,p_end_date in date
325: ,p_resource_id in hxc_time_building_blocks.resource_id%type
326: ,p_object_version_number in hxc_time_building_blocks.object_version_number%type
327: ,p_upg_count out nocopy number) IS
328:
329: CURSOR C_Time_BB_Ids(p_Building_Block_Id number, p_Object_Version_Number number) is
330: SELECT tbb1.time_building_block_id

Line 333: FROM hxc_time_building_blocks tbb1

329: CURSOR C_Time_BB_Ids(p_Building_Block_Id number, p_Object_Version_Number number) is
330: SELECT tbb1.time_building_block_id
331: ,tbb1.object_version_number
332: ,tbb1.scope
333: FROM hxc_time_building_blocks tbb1
334: WHERE scope IN ('TIMECARD', 'DAY', 'DETAIL') AND
335: application_set_id IS NULL
336: START WITH ((tbb1.time_building_block_id = p_building_block_id) AND
337: (tbb1.object_version_number = p_object_version_number))

Line 356: FROM hxc_time_building_blocks htb2

352: (SELECT time_attribute_id
353: FROM hxc_time_attribute_usages
354: WHERE time_building_block_id IN
355: (SELECT htb2.time_building_block_id
356: FROM hxc_time_building_blocks htb2
357: WHERE htb2.scope = 'APPLICATION_PERIOD' AND
358: htb2.resource_id = p_rec_id AND
359: TRUNC(htb2.start_time) =
360: p_start_time AND

Line 365: FROM hxc_time_building_blocks hb

361: TRUNC(htb2.stop_time) =
362: TRUNC(p_stop_time) AND
363: htb2.object_version_number =
364: (SELECT MAX(hb.object_version_number)
365: FROM hxc_time_building_blocks hb
366: WHERE hb.time_building_block_id =
367: htb2.time_building_block_id AND
368: hb.start_time =
369: htb2.start_time AND

Line 386: FROM hxc_time_building_blocks htb2

382: (SELECT time_attribute_id
383: FROM hxc_time_attribute_usages
384: WHERE time_building_block_id IN
385: (SELECT htb2.time_building_block_id
386: FROM hxc_time_building_blocks htb2
387: WHERE htb2.scope = 'APPLICATION_PERIOD' AND
388: htb2.resource_id = p_rec_id AND
389: TRUNC(htb2.start_time) = p_start_time AND
390: TRUNC(htb2.stop_time) =

Line 394: FROM hxc_time_building_blocks hb

390: TRUNC(htb2.stop_time) =
391: TRUNC(p_stop_time) AND
392: htb2.object_version_number =
393: (SELECT MAX(hb.object_version_number)
394: FROM hxc_time_building_blocks hb
395: WHERE hb.time_building_block_id =
396: htb2.time_building_block_id AND
397: hb.start_time = htb2.start_time AND
398: hb.stop_time = htb2.stop_time AND

Line 413: FROM hxc_time_building_blocks htb2

409: (SELECT time_attribute_id
410: FROM hxc_time_attribute_usages
411: WHERE time_building_block_id IN
412: (SELECT htb2.time_building_block_id
413: FROM hxc_time_building_blocks htb2
414: WHERE htb2.scope = 'APPLICATION_PERIOD' AND
415: htb2.resource_id = p_rec_id AND
416: TRUNC(htb2.start_time) =
417: p_start_time AND

Line 422: FROM hxc_time_building_blocks hb

418: TRUNC(htb2.stop_time) =
419: TRUNC(p_stop_time) AND
420: htb2.object_version_number =
421: (SELECT MAX(hb.object_version_number)
422: FROM hxc_time_building_blocks hb
423: WHERE hb.time_building_block_id =
424: htb2.time_building_block_id AND
425: hb.start_time =
426: htb2.start_time AND

Line 435: l_application_set_id hxc_time_building_blocks.APPLICATION_SET_ID%TYPE;

431: hb.scope =
432: 'APPLICATION_PERIOD'))) AND
433: attribute_category = 'APPROVAL'));
434:
435: l_application_set_id hxc_time_building_blocks.APPLICATION_SET_ID%TYPE;
436: Begin
437:
438: OPEN C_get_Appl_Set_Id(p_resource_id, p_start_date, p_end_date);
439: FETCH C_get_Appl_Set_Id into l_application_set_id;

Line 448: update hxc_time_building_blocks

444: FOR C2 in C_Time_BB_Ids(p_time_building_block_id
445: ,p_object_version_number) LOOP
446:
447: BEGIN
448: update hxc_time_building_blocks
449: set application_set_id = l_application_set_id
450: where time_building_block_id = C2.time_building_block_id and
451: object_version_number = C2.object_version_number;
452:

Line 514: FROM hxc_time_building_blocks htb

510: ,htb.start_time
511: ,htb.stop_time
512: ,htb.resource_id
513: ,htb.object_version_number
514: FROM hxc_time_building_blocks htb
515: WHERE htb.scope = 'TIMECARD' AND
516: htb.application_set_id IS NULL AND
517: htb.object_version_number =
518: (SELECT MAX(hb.object_version_number)

Line 519: FROM hxc_time_building_blocks hb

515: WHERE htb.scope = 'TIMECARD' AND
516: htb.application_set_id IS NULL AND
517: htb.object_version_number =
518: (SELECT MAX(hb.object_version_number)
519: FROM hxc_time_building_blocks hb
520: WHERE hb.time_building_block_id = htb.time_building_block_id AND
521: hb.start_time = htb.start_time AND
522: hb.stop_time = htb.stop_time AND
523: hb.resource_id = htb.resource_id AND

Line 539: FROM hxc_time_building_blocks htb

535: ,htb.start_time
536: ,htb.stop_time
537: ,htb.resource_id
538: ,htb.object_version_number
539: FROM hxc_time_building_blocks htb
540: WHERE htb.scope = 'TIMECARD' AND
541: htb.application_set_id IS NULL AND
542: htb.object_version_number =
543: (SELECT MAX(hb.object_version_number)

Line 544: FROM hxc_time_building_blocks hb

540: WHERE htb.scope = 'TIMECARD' AND
541: htb.application_set_id IS NULL AND
542: htb.object_version_number =
543: (SELECT MAX(hb.object_version_number)
544: FROM hxc_time_building_blocks hb
545: WHERE hb.time_building_block_id = htb.time_building_block_id AND
546: hb.start_time = htb.start_time AND
547: hb.stop_time = htb.stop_time AND
548: hb.resource_id = htb.resource_id AND

Line 620: FROM hxc_time_building_blocks tbb

616: ,tbb.resource_type
617: ,tbb.comment_text
618: ,tbb_day.start_time
619: ,tbb_day.stop_time
620: FROM hxc_time_building_blocks tbb
621: ,hxc_time_building_Blocks tbb_day
622: WHERE tbb.scope = 'DETAIL' AND
623: tbb.object_Version_number =
624: (SELECT /*+ no_unnest */

Line 621: ,hxc_time_building_Blocks tbb_day

617: ,tbb.comment_text
618: ,tbb_day.start_time
619: ,tbb_day.stop_time
620: FROM hxc_time_building_blocks tbb
621: ,hxc_time_building_Blocks tbb_day
622: WHERE tbb.scope = 'DETAIL' AND
623: tbb.object_Version_number =
624: (SELECT /*+ no_unnest */
625: MAX(dovn.object_version_number)

Line 626: FROM hxc_time_building_blocks dovn

622: WHERE tbb.scope = 'DETAIL' AND
623: tbb.object_Version_number =
624: (SELECT /*+ no_unnest */
625: MAX(dovn.object_version_number)
626: FROM hxc_time_building_blocks dovn
627: WHERE dovn.time_building_block_id =
628: tbb.time_building_block_id) AND
629: tbb_day.time_building_block_id = tbb.parent_building_block_id AND
630: NOT EXISTS

Line 637: FROM hxc_time_building_blocks dovn1

633: WHERE hld.time_building_block_id = tbb.time_building_block_id) AND
634: tbb_day.object_Version_number =
635: (SELECT /*+ no_unnest */
636: MAX(dovn1.object_version_number)
637: FROM hxc_time_building_blocks dovn1
638: WHERE dovn1.time_building_block_id =
639: tbb_day.time_building_block_id) and
640: tbb_day.start_time >= nvl(p_start_date, tbb_day.start_time) and
641: tbb_day.stop_time <= nvl(p_end_date, tbb_day.stop_time) and

Line 644: FROM hxc_time_building_blocks tbb_timecard

640: tbb_day.start_time >= nvl(p_start_date, tbb_day.start_time) and
641: tbb_day.stop_time <= nvl(p_end_date, tbb_day.stop_time) and
642: EXISTS
643: ( SELECT 'x'
644: FROM hxc_time_building_blocks tbb_timecard
645: WHERE tbb_timecard.time_building_block_id = tbb_day.parent_building_block_id
646: AND scope = 'TIMECARD' );
647:
648:

Line 651: TYPE resource_id_tab IS TABLE OF hxc_time_building_blocks.resource_id%TYPE INDEX BY BINARY_INTEGER;

647:
648:
649:
650:
651: TYPE resource_id_tab IS TABLE OF hxc_time_building_blocks.resource_id%TYPE INDEX BY BINARY_INTEGER;
652: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;

Line 652: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;

648:
649:
650:
651: TYPE resource_id_tab IS TABLE OF hxc_time_building_blocks.resource_id%TYPE INDEX BY BINARY_INTEGER;
652: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;

Line 653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;

649:
650:
651: TYPE resource_id_tab IS TABLE OF hxc_time_building_blocks.resource_id%TYPE INDEX BY BINARY_INTEGER;
652: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;

Line 654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;

650:
651: TYPE resource_id_tab IS TABLE OF hxc_time_building_blocks.resource_id%TYPE INDEX BY BINARY_INTEGER;
652: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;
658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;

Line 655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;

651: TYPE resource_id_tab IS TABLE OF hxc_time_building_blocks.resource_id%TYPE INDEX BY BINARY_INTEGER;
652: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;
658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
659: TYPE start_time_tab IS TABLE OF hxc_time_building_blocks.start_time%TYPE INDEX BY BINARY_INTEGER;

Line 656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;

652: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;
658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
659: TYPE start_time_tab IS TABLE OF hxc_time_building_blocks.start_time%TYPE INDEX BY BINARY_INTEGER;
660: TYPE stop_time_tab IS TABLE OF hxc_time_building_blocks.stop_time%TYPE INDEX BY BINARY_INTEGER;

Line 657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;

653: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;
658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
659: TYPE start_time_tab IS TABLE OF hxc_time_building_blocks.start_time%TYPE INDEX BY BINARY_INTEGER;
660: TYPE stop_time_tab IS TABLE OF hxc_time_building_blocks.stop_time%TYPE INDEX BY BINARY_INTEGER;
661:

Line 658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;

654: TYPE approval_status_tab IS TABLE OF hxc_time_building_blocks.approval_status%TYPE INDEX BY BINARY_INTEGER;
655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;
658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
659: TYPE start_time_tab IS TABLE OF hxc_time_building_blocks.start_time%TYPE INDEX BY BINARY_INTEGER;
660: TYPE stop_time_tab IS TABLE OF hxc_time_building_blocks.stop_time%TYPE INDEX BY BINARY_INTEGER;
661:
662: t_resource_id resource_id_tab;

Line 659: TYPE start_time_tab IS TABLE OF hxc_time_building_blocks.start_time%TYPE INDEX BY BINARY_INTEGER;

655: TYPE application_set_id_tab IS TABLE OF hxc_time_building_blocks.application_set_id%TYPE INDEX BY BINARY_INTEGER;
656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;
658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
659: TYPE start_time_tab IS TABLE OF hxc_time_building_blocks.start_time%TYPE INDEX BY BINARY_INTEGER;
660: TYPE stop_time_tab IS TABLE OF hxc_time_building_blocks.stop_time%TYPE INDEX BY BINARY_INTEGER;
661:
662: t_resource_id resource_id_tab;
663: t_tbb_id tbb_id_tab;

Line 660: TYPE stop_time_tab IS TABLE OF hxc_time_building_blocks.stop_time%TYPE INDEX BY BINARY_INTEGER;

656: TYPE last_update_date_tab IS TABLE OF hxc_time_building_blocks.last_update_date%TYPE INDEX BY BINARY_INTEGER;
657: TYPE resource_type_tab IS TABLE OF hxc_time_building_blocks.resource_type%TYPE INDEX BY BINARY_INTEGER;
658: TYPE comment_text_tab IS TABLE OF hxc_time_building_blocks.comment_text%TYPE INDEX BY BINARY_INTEGER;
659: TYPE start_time_tab IS TABLE OF hxc_time_building_blocks.start_time%TYPE INDEX BY BINARY_INTEGER;
660: TYPE stop_time_tab IS TABLE OF hxc_time_building_blocks.stop_time%TYPE INDEX BY BINARY_INTEGER;
661:
662: t_resource_id resource_id_tab;
663: t_tbb_id tbb_id_tab;
664: t_ovn ovn_tab;

Line 764: from hxc_time_building_blocks tbb

760:
761: cursor c_templates(p_start_date date, p_end_date date) is
762: select tbb.time_building_block_id
763: ,tbb.object_version_number
764: from hxc_time_building_blocks tbb
765: where tbb.date_to = hr_general.end_of_time and
766: tbb.scope = 'TIMECARD_TEMPLATE'
767: and resource_id <>-1 and
768: not exists

Line 783: from hxc_time_building_blocks tbb

779:
780: cursor c_templates_bg(p_start_date date, p_end_date date) is
781: select tbb.time_building_block_id
782: ,tbb.object_version_number
783: from hxc_time_building_blocks tbb
784: where tbb.date_to = hr_general.end_of_time and
785: tbb.scope = 'TIMECARD_TEMPLATE'
786: and resource_id <>-1 and
787: not exists

Line 801: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;

797: where tbb.resource_id = per.person_id and
798: per.business_group_id = p_business_group_id);
799:
800:
801: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
802: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
803: l_tbb_id_tab tbb_id_tab;
804: l_ovn_tab ovn_tab;
805: l_app_bb_id_tab tbb_id_tab;

Line 802: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;

798: per.business_group_id = p_business_group_id);
799:
800:
801: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
802: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
803: l_tbb_id_tab tbb_id_tab;
804: l_ovn_tab ovn_tab;
805: l_app_bb_id_tab tbb_id_tab;
806:

Line 985: from hxc_time_building_blocks tbb

981:
982: cursor c_timecards(p_start_date date, p_end_date date) is
983: select tbb.time_building_block_id
984: ,tbb.object_version_number
985: from hxc_time_building_blocks tbb
986: where tbb.date_to = hr_general.end_of_time and
987: tbb.scope = 'TIMECARD' and
988: not exists
989: (select 'Y'

Line 1003: from hxc_time_building_blocks tbb

999:
1000: cursor c_timecards_bg(p_start_date date, p_end_date date) is
1001: select tbb.time_building_block_id
1002: ,tbb.object_version_number
1003: from hxc_time_building_blocks tbb
1004: where tbb.date_to = hr_general.end_of_time and
1005: tbb.scope = 'TIMECARD' and
1006: not exists
1007: (select 'Y'

Line 1021: from hxc_time_building_blocks tbb

1017: per.business_group_id = p_business_group_id);
1018:
1019: cursor c_app_periods(p_start_date date, p_end_date date) is
1020: select distinct tbb.time_building_block_id
1021: from hxc_time_building_blocks tbb
1022: ,hxc_time_attribute_usages tau
1023: ,hxc_time_attributes ta
1024: where tbb.scope = 'APPLICATION_PERIOD' and
1025: tbb.date_to = hr_general.end_of_time and

Line 1045: from hxc_time_building_blocks tbb

1041: order by 1;
1042:
1043: cursor c_app_periods_bg(p_start_date date, p_end_date date) is
1044: select distinct tbb.time_building_block_id
1045: from hxc_time_building_blocks tbb
1046: ,hxc_time_attribute_usages tau
1047: ,hxc_time_attributes ta
1048: where tbb.scope = 'APPLICATION_PERIOD' and
1049: tbb.date_to = hr_general.end_of_time and

Line 1070: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;

1066: p_business_group_id)
1067: order by 1;
1068:
1069:
1070: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
1071: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
1072: l_tbb_id_tab tbb_id_tab;
1073: l_ovn_tab ovn_tab;
1074: l_app_bb_id_tab tbb_id_tab;

Line 1071: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;

1067: order by 1;
1068:
1069:
1070: TYPE tbb_id_tab IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
1071: TYPE ovn_tab IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE INDEX BY BINARY_INTEGER;
1072: l_tbb_id_tab tbb_id_tab;
1073: l_ovn_tab ovn_tab;
1074: l_app_bb_id_tab tbb_id_tab;
1075: