APPS.HXC_TBB_SHD dependencies on HXC_TIME_BUILDING_BLOCKS

Line 23: if (p_constraint_name = 'HXC_TIME_BUILDING_BLOCKS_FK1') Then

19: l_proc varchar2(72) := g_package||'constraint_error';
20: --
21: begin
22: --
23: if (p_constraint_name = 'HXC_TIME_BUILDING_BLOCKS_FK1') Then
24: fnd_message.set_name('HXC', 'HXC_NO_APPROVAL_STYLE');
25: fnd_message.set_token('procedure', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;

Line 71: from hxc_time_building_blocks

67: ,comment_text
68: ,application_set_id
69: ,data_set_id
70: ,translation_display_key
71: from hxc_time_building_blocks
72: where time_building_block_id = p_time_building_block_id;
73:
74: l_fct_ret boolean;
75:

Line 167: from hxc_time_building_blocks

163: ,comment_text
164: ,application_set_id
165: ,data_set_id
166: ,translation_display_key
167: from hxc_time_building_blocks
168: where time_building_block_id = p_time_building_block_id
169: and object_version_number = (select max(object_version_number)
170: from hxc_time_building_blocks
171: where time_building_block_id = p_time_building_block_id)

Line 170: from hxc_time_building_blocks

166: ,translation_display_key
167: from hxc_time_building_blocks
168: where time_building_block_id = p_time_building_block_id
169: and object_version_number = (select max(object_version_number)
170: from hxc_time_building_blocks
171: where time_building_block_id = p_time_building_block_id)
172: for update nowait;
173:
174: l_proc varchar2(72);

Line 222: fnd_message.set_token('TABLE_NAME', 'hxc_time_building_blocks');

218: -- the object is locked therefore we need to supply a meaningful
219: -- error message.
220:
221: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
222: fnd_message.set_token('TABLE_NAME', 'hxc_time_building_blocks');
223: fnd_message.raise_error;
224:
225: end lck;
226: