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

Line 5: actual_bb_id hxc_time_building_blocks.time_building_block_id%TYPE);

1: PACKAGE hxc_self_service_time_deposit AUTHID CURRENT_USER AS
2: /* $Header: hxctcdpwr.pkh 120.2 2005/12/05 14:18:50 arundell noship $ */
3:
4: TYPE translate_bb_ids_rec IS RECORD (
5: actual_bb_id hxc_time_building_blocks.time_building_block_id%TYPE);
6:
7: TYPE translate_bb_ids_tab IS TABLE OF translate_bb_ids_rec
8: INDEX BY BINARY_INTEGER;
9:

Line 26: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

22: message_level VARCHAR2 (30),
23: message_field VARCHAR2(2000),
24: message_tokens VARCHAR2 (4000), -- Bug 3036930
25: application_short_name fnd_application.application_short_name%TYPE,
26: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
27: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
28: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
29: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE,
30: on_oa_msg_stack BOOLEAN := FALSE, --AI5

Line 27: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,

23: message_field VARCHAR2(2000),
24: message_tokens VARCHAR2 (4000), -- Bug 3036930
25: application_short_name fnd_application.application_short_name%TYPE,
26: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
27: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
28: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
29: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE,
30: on_oa_msg_stack BOOLEAN := FALSE, --AI5
31: message_extent VARCHAR2 (20) --Bug#2873563

Line 39: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

35: INDEX BY BINARY_INTEGER;
36:
37: TYPE attribute_info IS RECORD (
38: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
39: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
40: bld_blk_info_type hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
41: attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE,
42: attribute1 hxc_time_attributes.attribute1%TYPE,
43: attribute2 hxc_time_attributes.attribute2%TYPE,

Line 83: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

79: INDEX BY BINARY_INTEGER;
80:
81: TYPE app_attributes IS RECORD (
82: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
83: building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
84: attribute_name hxc_mapping_components.field_name%TYPE,
85: attribute_value hxc_time_attributes.attribute1%TYPE,
86: attribute_index number,
87: segment hxc_mapping_components.segment%type,

Line 98: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

94: TYPE app_attributes_info IS TABLE OF app_attributes
95: INDEX BY BINARY_INTEGER;
96:
97: TYPE building_block_info IS RECORD (
98: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
99: TYPE hxc_time_building_blocks.TYPE%TYPE,
100: measure hxc_time_building_blocks.measure%TYPE,
101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
102: start_time hxc_time_building_blocks.start_time%TYPE,

Line 99: TYPE hxc_time_building_blocks.TYPE%TYPE,

95: INDEX BY BINARY_INTEGER;
96:
97: TYPE building_block_info IS RECORD (
98: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
99: TYPE hxc_time_building_blocks.TYPE%TYPE,
100: measure hxc_time_building_blocks.measure%TYPE,
101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
102: start_time hxc_time_building_blocks.start_time%TYPE,
103: stop_time hxc_time_building_blocks.stop_time%TYPE,

Line 100: measure hxc_time_building_blocks.measure%TYPE,

96:
97: TYPE building_block_info IS RECORD (
98: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
99: TYPE hxc_time_building_blocks.TYPE%TYPE,
100: measure hxc_time_building_blocks.measure%TYPE,
101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
102: start_time hxc_time_building_blocks.start_time%TYPE,
103: stop_time hxc_time_building_blocks.stop_time%TYPE,
104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,

Line 101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,

97: TYPE building_block_info IS RECORD (
98: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
99: TYPE hxc_time_building_blocks.TYPE%TYPE,
100: measure hxc_time_building_blocks.measure%TYPE,
101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
102: start_time hxc_time_building_blocks.start_time%TYPE,
103: stop_time hxc_time_building_blocks.stop_time%TYPE,
104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
105: parent_is_new VARCHAR2 (1),

Line 102: start_time hxc_time_building_blocks.start_time%TYPE,

98: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
99: TYPE hxc_time_building_blocks.TYPE%TYPE,
100: measure hxc_time_building_blocks.measure%TYPE,
101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
102: start_time hxc_time_building_blocks.start_time%TYPE,
103: stop_time hxc_time_building_blocks.stop_time%TYPE,
104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
105: parent_is_new VARCHAR2 (1),
106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,

Line 103: stop_time hxc_time_building_blocks.stop_time%TYPE,

99: TYPE hxc_time_building_blocks.TYPE%TYPE,
100: measure hxc_time_building_blocks.measure%TYPE,
101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
102: start_time hxc_time_building_blocks.start_time%TYPE,
103: stop_time hxc_time_building_blocks.stop_time%TYPE,
104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
105: parent_is_new VARCHAR2 (1),
106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,
107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,

Line 104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,

100: measure hxc_time_building_blocks.measure%TYPE,
101: unit_of_measure hxc_time_building_blocks.unit_of_measure%TYPE,
102: start_time hxc_time_building_blocks.start_time%TYPE,
103: stop_time hxc_time_building_blocks.stop_time%TYPE,
104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
105: parent_is_new VARCHAR2 (1),
106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,
107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,
108: approval_status hxc_time_building_blocks.approval_status%TYPE,

Line 106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,

102: start_time hxc_time_building_blocks.start_time%TYPE,
103: stop_time hxc_time_building_blocks.stop_time%TYPE,
104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
105: parent_is_new VARCHAR2 (1),
106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,
107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,
108: approval_status hxc_time_building_blocks.approval_status%TYPE,
109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,

Line 107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,

103: stop_time hxc_time_building_blocks.stop_time%TYPE,
104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
105: parent_is_new VARCHAR2 (1),
106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,
107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,
108: approval_status hxc_time_building_blocks.approval_status%TYPE,
109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,

Line 108: approval_status hxc_time_building_blocks.approval_status%TYPE,

104: parent_building_block_id hxc_time_building_blocks.parent_building_block_id%TYPE,
105: parent_is_new VARCHAR2 (1),
106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,
107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,
108: approval_status hxc_time_building_blocks.approval_status%TYPE,
109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,

Line 109: resource_id hxc_time_building_blocks.resource_id%TYPE,

105: parent_is_new VARCHAR2 (1),
106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,
107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,
108: approval_status hxc_time_building_blocks.approval_status%TYPE,
109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,
113: date_to hxc_time_building_blocks.date_to%TYPE,

Line 110: resource_type hxc_time_building_blocks.resource_type%TYPE,

106: SCOPE hxc_time_building_blocks.SCOPE%TYPE,
107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,
108: approval_status hxc_time_building_blocks.approval_status%TYPE,
109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,
113: date_to hxc_time_building_blocks.date_to%TYPE,
114: comment_text hxc_time_building_blocks.comment_text%TYPE,

Line 111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,

107: object_version_number hxc_time_building_blocks.object_version_number%TYPE,
108: approval_status hxc_time_building_blocks.approval_status%TYPE,
109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,
113: date_to hxc_time_building_blocks.date_to%TYPE,
114: comment_text hxc_time_building_blocks.comment_text%TYPE,
115: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,

Line 112: date_from hxc_time_building_blocks.date_from%TYPE,

108: approval_status hxc_time_building_blocks.approval_status%TYPE,
109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,
113: date_to hxc_time_building_blocks.date_to%TYPE,
114: comment_text hxc_time_building_blocks.comment_text%TYPE,
115: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,
116: NEW VARCHAR2 (30),

Line 113: date_to hxc_time_building_blocks.date_to%TYPE,

109: resource_id hxc_time_building_blocks.resource_id%TYPE,
110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,
113: date_to hxc_time_building_blocks.date_to%TYPE,
114: comment_text hxc_time_building_blocks.comment_text%TYPE,
115: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,
116: NEW VARCHAR2 (30),
117: changed VARCHAR2 (30),

Line 114: comment_text hxc_time_building_blocks.comment_text%TYPE,

110: resource_type hxc_time_building_blocks.resource_type%TYPE,
111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,
113: date_to hxc_time_building_blocks.date_to%TYPE,
114: comment_text hxc_time_building_blocks.comment_text%TYPE,
115: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,
116: NEW VARCHAR2 (30),
117: changed VARCHAR2 (30),
118: process varchar2 (30),

Line 115: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,

111: approval_style_id hxc_time_building_blocks.approval_style_id%TYPE,
112: date_from hxc_time_building_blocks.date_from%TYPE,
113: date_to hxc_time_building_blocks.date_to%TYPE,
114: comment_text hxc_time_building_blocks.comment_text%TYPE,
115: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,
116: NEW VARCHAR2 (30),
117: changed VARCHAR2 (30),
118: process varchar2 (30),
119: application_set_id hxc_time_building_blocks.application_set_id%type,

Line 119: application_set_id hxc_time_building_blocks.application_set_id%type,

115: parent_building_block_ovn hxc_time_building_blocks.parent_building_block_ovn%TYPE,
116: NEW VARCHAR2 (30),
117: changed VARCHAR2 (30),
118: process varchar2 (30),
119: application_set_id hxc_time_building_blocks.application_set_id%type,
120: translation_display_key hxc_time_building_blocks.translation_display_key%type);
121:
122: TYPE timecard_info IS TABLE OF building_block_info
123: INDEX BY BINARY_INTEGER;

Line 120: translation_display_key hxc_time_building_blocks.translation_display_key%type);

116: NEW VARCHAR2 (30),
117: changed VARCHAR2 (30),
118: process varchar2 (30),
119: application_set_id hxc_time_building_blocks.application_set_id%type,
120: translation_display_key hxc_time_building_blocks.translation_display_key%type);
121:
122: TYPE timecard_info IS TABLE OF building_block_info
123: INDEX BY BINARY_INTEGER;
124:

Line 273: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

269:
270: PROCEDURE alias_translation;
271:
272: PROCEDURE deposit_blocks (
273: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
274: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
275: p_mode VARCHAR2,
276: p_deposit_process VARCHAR2,
277: p_retrieval_process VARCHAR2 DEFAULT NULL,

Line 274: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,

270: PROCEDURE alias_translation;
271:
272: PROCEDURE deposit_blocks (
273: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
274: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE,
275: p_mode VARCHAR2,
276: p_deposit_process VARCHAR2,
277: p_retrieval_process VARCHAR2 DEFAULT NULL,
278: p_validate_session BOOLEAN DEFAULT TRUE,

Line 353: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

349: RETURN NUMBER;
350:
351: FUNCTION attribute_check (
352: p_to_check IN VARCHAR2,
353: p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
354: )
355: RETURN BOOLEAN;
356:
357: FUNCTION get_bld_blk_type_id (p_type IN VARCHAR2)