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

Line 6: type block_id_list is table of hxc_time_building_blocks.time_building_block_id%type;

2: /* $Header: hxcbkcout.pkb 120.6 2006/06/13 23:38:00 arundell noship $ */
3:
4: C_END_OF_DAY CONSTANT NUMBER := .999988426;
5:
6: type block_id_list is table of hxc_time_building_blocks.time_building_block_id%type;
7: type block_ovn_list is table of hxc_time_building_blocks.object_version_number%type;
8:
9: Procedure append_to_list
10: (p_list1 in block_id_list,

Line 7: type block_ovn_list is table of hxc_time_building_blocks.object_version_number%type;

3:
4: C_END_OF_DAY CONSTANT NUMBER := .999988426;
5:
6: type block_id_list is table of hxc_time_building_blocks.time_building_block_id%type;
7: type block_ovn_list is table of hxc_time_building_blocks.object_version_number%type;
8:
9: Procedure append_to_list
10: (p_list1 in block_id_list,
11: p_list2 in out nocopy block_id_list,

Line 38: (p_block_id in hxc_time_building_blocks.time_building_block_id%type,

34: p_attributes in out NOCOPY hxc_attribute_table_type
35: ) is
36:
37: cursor c_attribute_type_info
38: (p_block_id in hxc_time_building_blocks.time_building_block_id%type,
39: p_block_ovn in hxc_time_building_blocks.object_version_number%type,
40: p_load_template_attributes in varchar2) is
41: select hxc_attribute_type
42: (ta.TIME_ATTRIBUTE_ID,

Line 39: p_block_ovn in hxc_time_building_blocks.object_version_number%type,

35: ) is
36:
37: cursor c_attribute_type_info
38: (p_block_id in hxc_time_building_blocks.time_building_block_id%type,
39: p_block_ovn in hxc_time_building_blocks.object_version_number%type,
40: p_load_template_attributes in varchar2) is
41: select hxc_attribute_type
42: (ta.TIME_ATTRIBUTE_ID,
43: p_block_id,

Line 124: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,

120:
121: End load_attributes;
122:
123: Procedure load_top_level_block
124: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
125: p_blocks in out nocopy hxc_block_table_type,
126: p_top_level_start_date in out nocopy date,
127: p_top_level_stop_date in out nocopy date
128: ) is

Line 131: (p_block_id in hxc_time_building_blocks.time_building_block_id%type) is

127: p_top_level_stop_date in out nocopy date
128: ) is
129:
130: CURSOR c_block_type_info
131: (p_block_id in hxc_time_building_blocks.time_building_block_id%type) is
132: select hxc_block_type
133: (time_building_block_id,
134: type,
135: measure,

Line 157: from hxc_time_building_blocks

153: 'N',
154: application_set_id,
155: translation_display_key
156: )
157: from hxc_time_building_blocks
158: where time_building_block_id = p_block_id
159: and date_to = hr_general.end_of_time;
160:
161: Begin

Line 178: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,

174: close c_block_type_info;
175: End load_top_level_block;
176:
177: Procedure load_app_period_days
178: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
179: p_top_level_block_ovn in hxc_time_building_blocks.object_version_number%type,
180: p_start_time in date,
181: p_stop_time in date,
182: p_day_id_list out nocopy block_id_list,

Line 179: p_top_level_block_ovn in hxc_time_building_blocks.object_version_number%type,

175: End load_top_level_block;
176:
177: Procedure load_app_period_days
178: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
179: p_top_level_block_ovn in hxc_time_building_blocks.object_version_number%type,
180: p_start_time in date,
181: p_stop_time in date,
182: p_day_id_list out nocopy block_id_list,
183: p_day_ovn_list out nocopy block_ovn_list,

Line 215: from hxc_time_building_blocks days,

211: days.application_set_id,
212: days.translation_display_key),
213: days.time_building_block_id,
214: days.object_version_number
215: from hxc_time_building_blocks days,
216: hxc_time_building_blocks top_level
217: where top_level.time_building_block_id = p_top_level_block_id
218: and top_level.object_version_number = p_top_level_block_ovn
219: and days.resource_id = top_level.resource_id

Line 216: hxc_time_building_blocks top_level

212: days.translation_display_key),
213: days.time_building_block_id,
214: days.object_version_number
215: from hxc_time_building_blocks days,
216: hxc_time_building_blocks top_level
217: where top_level.time_building_block_id = p_top_level_block_id
218: and top_level.object_version_number = p_top_level_block_ovn
219: and days.resource_id = top_level.resource_id
220: and trunc(days.start_time) between trunc(top_level.start_time) and trunc(top_level.stop_time)

Line 227: from hxc_time_building_blocks timecard_check

223: and days.start_time >= p_start_time
224: and days.stop_time <= p_stop_time
225: and exists
226: (select 'Y'
227: from hxc_time_building_blocks timecard_check
228: where timecard_check.scope = 'TIMECARD'
229: and timecard_check.resource_id = days.resource_id
230: and timecard_check.date_to = hr_general.end_of_time
231: and timecard_check.time_building_block_id = days.parent_building_block_id

Line 256: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,

252:
253: End load_app_period_days;
254:
255: Procedure load_days
256: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
257: p_top_level_block_ovn in hxc_time_building_blocks.object_version_number%type,
258: p_day_id_list out nocopy block_id_list,
259: p_day_ovn_list out nocopy block_ovn_list,
260: p_blocks in out nocopy hxc_block_table_type,

Line 257: p_top_level_block_ovn in hxc_time_building_blocks.object_version_number%type,

253: End load_app_period_days;
254:
255: Procedure load_days
256: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
257: p_top_level_block_ovn in hxc_time_building_blocks.object_version_number%type,
258: p_day_id_list out nocopy block_id_list,
259: p_day_ovn_list out nocopy block_ovn_list,
260: p_blocks in out nocopy hxc_block_table_type,
261: p_attributes in out nocopy hxc_attribute_table_type

Line 291: from hxc_time_building_blocks days,

287: days.application_set_id,
288: days.translation_display_key),
289: days.time_building_block_id,
290: days.object_version_number
291: from hxc_time_building_blocks days,
292: hxc_time_building_blocks top_level
293: where top_level.time_building_block_id = p_top_level_block_id
294: and top_level.object_version_number = p_top_level_block_ovn
295: and days.parent_building_block_id = top_level.time_building_block_Id

Line 292: hxc_time_building_blocks top_level

288: days.translation_display_key),
289: days.time_building_block_id,
290: days.object_version_number
291: from hxc_time_building_blocks days,
292: hxc_time_building_blocks top_level
293: where top_level.time_building_block_id = p_top_level_block_id
294: and top_level.object_version_number = p_top_level_block_ovn
295: and days.parent_building_block_id = top_level.time_building_block_Id
296: and days.parent_building_block_ovn = top_level.object_version_number

Line 298: from hxc_time_building_blocks days_ovn

294: and top_level.object_version_number = p_top_level_block_ovn
295: and days.parent_building_block_id = top_level.time_building_block_Id
296: and days.parent_building_block_ovn = top_level.object_version_number
297: and days.object_version_number = (select max(object_version_number)
298: from hxc_time_building_blocks days_ovn
299: where days_ovn.time_building_block_id = days.time_building_block_id
300: and days_ovn.parent_building_block_id = top_level.time_building_block_Id
301: and days_ovn.parent_building_block_ovn = top_level.object_version_number)
302: order by days.start_time;

Line 392: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,

388: end if;
389: End add_missing_days;
390:
391: Procedure load_app_period_details
392: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
393: p_start_time in date,
394: p_stop_time in date,
395: p_detail_id_list in out nocopy block_id_list,
396: p_detail_ovn_list in out nocopy block_ovn_list,

Line 403: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type)

399: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
400: p_missing_rows in out NOCOPY boolean) is
401:
402: CURSOR c_block_type_info
403: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type)
404: is
405: select hxc_block_type
406: (details.time_building_block_id,
407: details.type,

Line 431: from hxc_time_building_blocks details,

427: details.application_set_id,
428: details.translation_display_key),
429: details.time_building_block_id,
430: details.object_version_number
431: from hxc_time_building_blocks details,
432: hxc_time_building_blocks days,
433: hxc_ap_detail_links adl
434: where details.time_building_block_id = adl.time_building_block_id
435: and details.object_version_number = adl.time_building_block_ovn

Line 432: hxc_time_building_blocks days,

428: details.translation_display_key),
429: details.time_building_block_id,
430: details.object_version_number
431: from hxc_time_building_blocks details,
432: hxc_time_building_blocks days,
433: hxc_ap_detail_links adl
434: where details.time_building_block_id = adl.time_building_block_id
435: and details.object_version_number = adl.time_building_block_ovn
436: and days.start_time >= p_start_time

Line 483: (p_day_id in hxc_time_building_blocks.time_building_block_id%type,

479: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
480: p_missing_rows in out NOCOPY boolean) is
481:
482: CURSOR c_block_type_info
483: (p_day_id in hxc_time_building_blocks.time_building_block_id%type,
484: p_day_ovn in hxc_time_building_blocks.object_version_number%type)
485: is
486: select hxc_block_type
487: (details.time_building_block_id,

Line 484: p_day_ovn in hxc_time_building_blocks.object_version_number%type)

480: p_missing_rows in out NOCOPY boolean) is
481:
482: CURSOR c_block_type_info
483: (p_day_id in hxc_time_building_blocks.time_building_block_id%type,
484: p_day_ovn in hxc_time_building_blocks.object_version_number%type)
485: is
486: select hxc_block_type
487: (details.time_building_block_id,
488: details.type,

Line 510: from hxc_time_building_blocks details

506: 'N',
507: 'N',
508: details.application_set_id,
509: details.translation_display_key)
510: from hxc_time_building_blocks details
511: where details.parent_building_block_id = p_day_id
512: and details.parent_building_block_ovn = p_day_ovn
513: and details.date_to = hr_general.end_of_time;
514:

Line 557: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,

553: end if;
554: End load_details;
555:
556: PROCEDURE load_collection
557: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
558: p_load_template_attributes in varchar2,
559: p_blocks out NOCOPY hxc_block_table_type,
560: p_attributes out NOCOPY hxc_attribute_table_type,
561: p_top_level_start_date out NOCOPY date,

Line 612: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,

608: end if;
609: End load_collection;
610:
611: PROCEDURE load_collection
612: (p_top_level_block_id in hxc_time_building_blocks.time_building_block_id%type,
613: p_blocks out NOCOPY hxc_block_table_type,
614: p_attributes out NOCOPY hxc_attribute_table_type,
615: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
616: p_missing_rows in out NOCOPY boolean

Line 644: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,

640: -- |----------------------< get_application_period >--------------------------|
641: -- +--------------------------------------------------------------------------+
642: --
643: PROCEDURE get_application_period
644: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
645: p_blocks out NOCOPY hxc_block_table_type,
646: p_attributes out NOCOPY hxc_attribute_table_type
647: ) is
648:

Line 678: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,

674:
675: End get_application_period;
676:
677: PROCEDURE get_application_period
678: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
679: p_start_time in date,
680: p_stop_time in date,
681: p_blocks out NOCOPY hxc_block_table_type,
682: p_attributes out NOCOPY hxc_attribute_table_type

Line 686: (p_app_period_id hxc_time_building_blocks.time_building_block_id%type) is

682: p_attributes out NOCOPY hxc_attribute_table_type
683: ) is
684:
685: cursor c_app_attribute
686: (p_app_period_id hxc_time_building_blocks.time_building_block_id%type) is
687: select hxc_attribute_type
688: (-2,
689: p_blocks(1).time_building_block_id,
690: 'APPROVAL',

Line 852: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

848: -- |------------------------< get_timecard >--------------------------|
849: -- +--------------------------------------------------------------------------+
850: --
851: PROCEDURE get_timecard
852: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
853: p_blocks out NOCOPY hxc_block_table_type,
854: p_attributes out NOCOPY hxc_attribute_table_type
855: ) is
856: l_row_data hxc_trans_display_key_utils.translation_row_used;

Line 876: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,

872: -- |------------------------< get_timecard >--------------------------|
873: -- +--------------------------------------------------------------------------+
874: --
875: PROCEDURE get_timecard
876: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type,
877: p_blocks out NOCOPY hxc_block_table_type,
878: p_attributes out NOCOPY hxc_attribute_table_type,
879: p_row_data out NOCOPY hxc_trans_display_key_utils.translation_row_used,
880: p_missing_rows in out NOCOPY boolean

Line 900: (p_template_id in hxc_time_building_blocks.time_building_block_id%type,

896: -- |------------------------< get_template >--------------------------|
897: -- +--------------------------------------------------------------------------+
898: --
899: PROCEDURE get_template
900: (p_template_id in hxc_time_building_blocks.time_building_block_id%type,
901: p_blocks out NOCOPY hxc_block_table_type,
902: p_attributes out NOCOPY hxc_attribute_table_type,
903: p_template_start_time out NOCOPY date,
904: p_template_stop_time out NOCOPY date