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_TCC_DEL dependencies on HXC_TCC_SHD

Line 54: (p_rec in hxc_tcc_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure delete_dml
54: (p_rec in hxc_tcc_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72);
58: --

Line 67: hxc_tcc_shd.g_api_dml := true; -- Set the api dml status

63: l_proc := g_package||'delete_dml';
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: end if;
66: --
67: hxc_tcc_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the hxc_time_category_comps row.
70: --
71: delete from hxc_time_category_comps

Line 74: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

70: --
71: delete from hxc_time_category_comps
72: where time_category_comp_id = p_rec.time_category_comp_id;
73: --
74: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
75: --
76: if g_debug then
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: end if;

Line 83: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

79: --
80: Exception
81: When hr_api.child_integrity_violated then
82: -- Child integrity has been violated
83: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_tcc_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

Line 84: hxc_tcc_shd.constraint_error

80: Exception
81: When hr_api.child_integrity_violated then
82: -- Child integrity has been violated
83: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_tcc_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
88: Raise;

Line 87: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

83: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_tcc_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
88: Raise;
89: End delete_dml;
90: --
91: -- ----------------------------------------------------------------------------

Line 123: Procedure pre_delete(p_rec in hxc_tcc_shd.g_rec_type) is

119: -- Internal Row Handler Use Only.
120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure pre_delete(p_rec in hxc_tcc_shd.g_rec_type) is
124: --
125: l_proc varchar2(72);
126: --
127: Begin

Line 170: Procedure post_delete(p_rec in hxc_tcc_shd.g_rec_type) is

166: -- Internal Row Handler Use Only.
167: --
168: -- {End Of Comments}
169: -- -----------------------------------------------------------------------------
170: Procedure post_delete(p_rec in hxc_tcc_shd.g_rec_type) is
171: --
172: l_proc varchar2(72);
173: --
174: Begin

Line 185: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id

181: begin
182:
183: hxc_tcc_rkd.after_delete (
184: p_time_category_comp_id => p_rec.time_category_comp_id
185: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
186: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id

Line 186: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id

182:
183: hxc_tcc_rkd.after_delete (
184: p_time_category_comp_id => p_rec.time_category_comp_id
185: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
186: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null

Line 187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id

183: hxc_tcc_rkd.after_delete (
184: p_time_category_comp_id => p_rec.time_category_comp_id
185: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
186: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to

Line 188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id

184: p_time_category_comp_id => p_rec.time_category_comp_id
185: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
186: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
192: ,p_type_o => hxc_tcc_shd.g_old_rec.type

Line 189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id

185: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
186: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
192: ,p_type_o => hxc_tcc_shd.g_old_rec.type
193: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );

Line 190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null

186: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
192: ,p_type_o => hxc_tcc_shd.g_old_rec.type
193: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
194:

Line 191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to

187: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
192: ,p_type_o => hxc_tcc_shd.g_old_rec.type
193: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
194:
195:

Line 192: ,p_type_o => hxc_tcc_shd.g_old_rec.type

188: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
192: ,p_type_o => hxc_tcc_shd.g_old_rec.type
193: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
194:
195:
196: IF ( hxc_tcc_shd.g_old_rec.type = 'MC' )

Line 193: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );

189: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
190: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
191: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
192: ,p_type_o => hxc_tcc_shd.g_old_rec.type
193: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
194:
195:
196: IF ( hxc_tcc_shd.g_old_rec.type = 'MC' )
197: THEN

Line 196: IF ( hxc_tcc_shd.g_old_rec.type = 'MC' )

192: ,p_type_o => hxc_tcc_shd.g_old_rec.type
193: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
194:
195:
196: IF ( hxc_tcc_shd.g_old_rec.type = 'MC' )
197: THEN
198: hxc_time_category_api.set_dynamic_sql_string ( p_time_category_id => hxc_tcc_shd.g_old_rec.time_category_id );
199: END IF;
200:

Line 198: hxc_time_category_api.set_dynamic_sql_string ( p_time_category_id => hxc_tcc_shd.g_old_rec.time_category_id );

194:
195:
196: IF ( hxc_tcc_shd.g_old_rec.type = 'MC' )
197: THEN
198: hxc_time_category_api.set_dynamic_sql_string ( p_time_category_id => hxc_tcc_shd.g_old_rec.time_category_id );
199: END IF;
200:
201: exception
202:

Line 220: (p_rec in hxc_tcc_shd.g_rec_type

216: -- ----------------------------------------------------------------------------
217: -- |---------------------------------< del >----------------------------------|
218: -- ----------------------------------------------------------------------------
219: Procedure del
220: (p_rec in hxc_tcc_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72);
224: --

Line 235: hxc_tcc_shd.lck

231: end if;
232: --
233: -- We must lock the row which we need to delete.
234: --
235: hxc_tcc_shd.lck
236: (p_rec.time_category_comp_id
237: ,p_rec.object_version_number
238: );
239: --

Line 266: l_rec hxc_tcc_shd.g_rec_type;

262: (p_time_category_comp_id in number
263: ,p_object_version_number in number
264: ) is
265: --
266: l_rec hxc_tcc_shd.g_rec_type;
267: l_proc varchar2(72);
268: --
269: Begin
270: g_debug := hr_utility.debug_enabled;