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

Line 16: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,

12:
13: TYPE translated_message_info IS RECORD (
14: message_name fnd_new_messages.message_name%TYPE,
15: MESSAGE_TEXT VARCHAR2 (4000),
16: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
17: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
18: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
19: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE
20: );

Line 17: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,

13: TYPE translated_message_info IS RECORD (
14: message_name fnd_new_messages.message_name%TYPE,
15: MESSAGE_TEXT VARCHAR2 (4000),
16: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE,
17: time_building_block_ovn hxc_time_building_blocks.object_version_number%TYPE,
18: time_attribute_id hxc_time_attributes.time_attribute_id%TYPE,
19: time_attribute_ovn hxc_time_attributes.object_version_number%TYPE
20: );
21:

Line 36: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

32: )
33: RETURN hxc_approval_styles.approval_style_id%TYPE;
34:
35: PROCEDURE begin_approval (
36: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
37: p_blocks IN hxc_block_table_type
38: );
39:
40: PROCEDURE save_timecard (

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

40: PROCEDURE save_timecard (
41: p_blocks IN OUT NOCOPY hxc_block_table_type,
42: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
43: p_messages IN OUT NOCOPY hxc_message_table_type,
44: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
45: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
46: );
47:
48: PROCEDURE submit_timecard (

Line 45: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

41: p_blocks IN OUT NOCOPY hxc_block_table_type,
42: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
43: p_messages IN OUT NOCOPY hxc_message_table_type,
44: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
45: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
46: );
47:
48: PROCEDURE submit_timecard (
49: p_item_type IN wf_items.item_type%TYPE,

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

54: DEFAULT NULL,
55: p_blocks IN OUT NOCOPY hxc_block_table_type,
56: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
57: p_messages IN OUT NOCOPY hxc_message_table_type,
58: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
59: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
60: );
61:
62: FUNCTION convert_new_trans_info_to_old (

Line 59: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

55: p_blocks IN OUT NOCOPY hxc_block_table_type,
56: p_attributes IN OUT NOCOPY hxc_attribute_table_type,
57: p_messages IN OUT NOCOPY hxc_message_table_type,
58: p_timecard_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
59: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
60: );
61:
62: FUNCTION convert_new_trans_info_to_old (
63: p_transaction_info IN hxc_timecard.transaction_info

Line 89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

85: FUNCTION get_approval_status (p_mode IN VARCHAR2)
86: RETURN VARCHAR2;
87:
88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_block_table_type,

Line 90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

86: RETURN VARCHAR2;
87:
88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_block_table_type,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

87:
88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_block_table_type,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

88: PROCEDURE find_parent_building_block (
89: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_block_table_type,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96: );

Line 94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

90: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_block_table_type,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96: );
97:
98: PROCEDURE find_parent_building_block (

Line 95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

91: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
92: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
93: p_app_blocks IN hxc_block_table_type,
94: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96: );
97:
98: PROCEDURE find_parent_building_block (
99: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

Line 99: p_start_time IN hxc_time_building_blocks.start_time%TYPE,

95: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
96: );
97:
98: PROCEDURE find_parent_building_block (
99: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
100: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,

Line 100: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

96: );
97:
98: PROCEDURE find_parent_building_block (
99: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
100: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

Line 101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

97:
98: PROCEDURE find_parent_building_block (
99: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
100: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

Line 102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,

98: PROCEDURE find_parent_building_block (
99: p_start_time IN hxc_time_building_blocks.start_time%TYPE,
100: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106: );

Line 104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

100: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106: );
107:
108: PROCEDURE set_new_change_flags (

Line 105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

101: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
102: p_scope IN hxc_time_building_blocks.SCOPE%TYPE,
103: p_app_blocks IN hxc_self_service_time_deposit.timecard_info,
104: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
105: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
106: );
107:
108: PROCEDURE set_new_change_flags (
109: p_attributes IN OUT NOCOPY hxc_attribute_table_type

Line 113: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

109: p_attributes IN OUT NOCOPY hxc_attribute_table_type
110: );
111:
112: PROCEDURE get_timecard_bb_id (
113: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
114: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
115: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
116: );
117:

Line 114: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,

110: );
111:
112: PROCEDURE get_timecard_bb_id (
113: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
114: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
115: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
116: );
117:
118: FUNCTION get_index_in_bb_table (

Line 115: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE

111:
112: PROCEDURE get_timecard_bb_id (
113: p_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
114: p_timecard_bb_id OUT NOCOPY hxc_time_building_blocks.time_building_block_id%TYPE,
115: p_timecard_ovn OUT NOCOPY hxc_time_building_blocks.object_version_number%TYPE
116: );
117:
118: FUNCTION get_index_in_bb_table (
119: p_bb_table IN hxc_block_table_type,

Line 120: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE

116: );
117:
118: FUNCTION get_index_in_bb_table (
119: p_bb_table IN hxc_block_table_type,
120: p_bb_id_to_find IN hxc_time_building_blocks.time_building_block_id%TYPE
121: )
122: RETURN PLS_INTEGER;
123:
124: FUNCTION get_deposit_process_id (

Line 137: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

133: )
134: RETURN PLS_INTEGER;
135: -- ARR: Next two procedures add p_clear_mapping_cache for update case
136: PROCEDURE get_timecard_tables (
137: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
138: -- p_time_recipient_id IN NUMBER,
139: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
140: p_clear_mapping_cache IN BOOLEAN default false,
141: p_app_blocks OUT NOCOPY hxc_block_table_type,

Line 146: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

142: p_app_attributes OUT NOCOPY hxc_self_service_time_deposit.app_attributes_info
143: );
144:
145: PROCEDURE get_timecard_tables (
146: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
147: -- p_time_recipient_id IN NUMBER,
148: p_deposit_process IN hxc_deposit_processes.NAME%TYPE,
149: p_clear_mapping_cache IN BOOLEAN default false,
150: p_app_blocks OUT NOCOPY hxc_self_service_time_deposit.timecard_info,

Line 209: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

205: )
206: RETURN translated_message_table;
207:
208: PROCEDURE find_current_period (
209: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
210: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
211: p_day IN hxc_time_building_blocks.start_time%TYPE,
212: p_start_time OUT NOCOPY DATE,
213: p_stop_time OUT NOCOPY DATE

Line 210: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,

206: RETURN translated_message_table;
207:
208: PROCEDURE find_current_period (
209: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
210: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
211: p_day IN hxc_time_building_blocks.start_time%TYPE,
212: p_start_time OUT NOCOPY DATE,
213: p_stop_time OUT NOCOPY DATE
214: );

Line 211: p_day IN hxc_time_building_blocks.start_time%TYPE,

207:
208: PROCEDURE find_current_period (
209: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
210: p_resource_type IN hxc_time_building_blocks.resource_type%TYPE,
211: p_day IN hxc_time_building_blocks.start_time%TYPE,
212: p_start_time OUT NOCOPY DATE,
213: p_stop_time OUT NOCOPY DATE
214: );
215:

Line 217: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

213: p_stop_time OUT NOCOPY DATE
214: );
215:
216: FUNCTION cla_enabled (
217: p_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
218: )
219: RETURN BOOLEAN;
220:
221: -- Procedure added for bug 8900783

Line 223: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

219: RETURN BOOLEAN;
220:
221: -- Procedure added for bug 8900783
222: PROCEDURE get_past_future_limits (
223: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
224: p_timecard_start_time IN date,
225: p_timecard_stop_time IN date,
226: p_messages IN OUT NOCOPY hxc_message_table_type
227: );