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

Line 57: (p_rec in out nocopy hxc_tcc_shd.g_rec_type

53: --
54: -- {End Of Comments}
55: -- ----------------------------------------------------------------------------
56: Procedure update_dml
57: (p_rec in out nocopy hxc_tcc_shd.g_rec_type
58: ) is
59: --
60: l_proc varchar2(72);
61: --

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

69: --
70: -- Increment the object version
71: p_rec.object_version_number := p_rec.object_version_number + 1;
72: --
73: hxc_tcc_shd.g_api_dml := true; -- Set the api dml status
74: --
75: -- Update the hxc_time_category_comps Row
76: --
77: update hxc_time_category_comps

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

90: ,last_update_login = fnd_global.login_id
91:
92: where time_category_comp_id = p_rec.time_category_comp_id;
93:
94: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
95:
96: if g_debug then
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: end if;

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

99:
100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
104: hxc_tcc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated

Line 104: hxc_tcc_shd.constraint_error

100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
104: hxc_tcc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

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

104: hxc_tcc_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
109: hxc_tcc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated

Line 109: hxc_tcc_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
109: hxc_tcc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

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

109: hxc_tcc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_tcc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status

Line 114: hxc_tcc_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_tcc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
118: Raise;

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

113: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_tcc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_tcc_shd.g_api_dml := false; -- Unset the api dml status
118: Raise;
119: End update_dml;
120: --
121: -- ----------------------------------------------------------------------------

Line 154: (p_rec in hxc_tcc_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure pre_update
154: (p_rec in hxc_tcc_shd.g_rec_type
155: ) is
156: --
157: l_proc varchar2(72);
158: --

Line 203: (p_rec in hxc_tcc_shd.g_rec_type

199: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_update
203: (p_rec in hxc_tcc_shd.g_rec_type
204: ) is
205: --
206: l_proc varchar2(72);
207: --

Line 228: ,p_time_category_comp_id_o=> hxc_tcc_shd.g_old_rec.time_category_comp_id

224: ,p_is_null => p_rec.is_null
225: ,p_equal_to => p_rec.equal_to
226: ,p_type => p_rec.type
227: ,p_object_version_number => p_rec.object_version_number
228: ,p_time_category_comp_id_o=> hxc_tcc_shd.g_old_rec.time_category_comp_id
229: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
230: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id

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

225: ,p_equal_to => p_rec.equal_to
226: ,p_type => p_rec.type
227: ,p_object_version_number => p_rec.object_version_number
228: ,p_time_category_comp_id_o=> hxc_tcc_shd.g_old_rec.time_category_comp_id
229: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
230: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id

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

226: ,p_type => p_rec.type
227: ,p_object_version_number => p_rec.object_version_number
228: ,p_time_category_comp_id_o=> hxc_tcc_shd.g_old_rec.time_category_comp_id
229: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
230: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null

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

227: ,p_object_version_number => p_rec.object_version_number
228: ,p_time_category_comp_id_o=> hxc_tcc_shd.g_old_rec.time_category_comp_id
229: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
230: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
235: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to

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

228: ,p_time_category_comp_id_o=> hxc_tcc_shd.g_old_rec.time_category_comp_id
229: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
230: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
235: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
236: ,p_type_o => hxc_tcc_shd.g_old_rec.type

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

229: ,p_time_category_id_o => hxc_tcc_shd.g_old_rec.time_category_id
230: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
235: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
236: ,p_type_o => hxc_tcc_shd.g_old_rec.type
237: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );

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

230: ,p_ref_time_category_id_o => hxc_tcc_shd.g_old_rec.ref_time_category_id
231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
235: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
236: ,p_type_o => hxc_tcc_shd.g_old_rec.type
237: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
238:

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

231: ,p_component_type_id_o => hxc_tcc_shd.g_old_rec.component_type_id
232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
235: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
236: ,p_type_o => hxc_tcc_shd.g_old_rec.type
237: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
238:
239: exception

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

232: ,p_flex_value_set_id_o => hxc_tcc_shd.g_old_rec.flex_value_set_id
233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
235: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
236: ,p_type_o => hxc_tcc_shd.g_old_rec.type
237: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
238:
239: exception
240:

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

233: ,p_value_id_o => hxc_tcc_shd.g_old_rec.value_id
234: ,p_is_null_o => hxc_tcc_shd.g_old_rec.is_null
235: ,p_equal_to_o => hxc_tcc_shd.g_old_rec.equal_to
236: ,p_type_o => hxc_tcc_shd.g_old_rec.type
237: ,p_object_version_number_o=> hxc_tcc_shd.g_old_rec.object_version_number );
238:
239: exception
240:
241: when hr_api.cannot_find_prog_unit then

Line 298: (p_rec in out nocopy hxc_tcc_shd.g_rec_type

294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure convert_defs
298: (p_rec in out nocopy hxc_tcc_shd.g_rec_type
299: ) is
300: --
301: Begin
302:

Line 309: p_rec.time_category_id := hxc_tcc_shd.g_old_rec.time_category_id;

305: -- to see if a system default is being used. If a system default
306: -- is being used then we must set to the 'current' argument value.
307:
308: If (p_rec.time_category_id = hr_api.g_number) then
309: p_rec.time_category_id := hxc_tcc_shd.g_old_rec.time_category_id;
310: End If;
311:
312: If (p_rec.ref_time_category_id = hr_api.g_number) then
313: p_rec.ref_time_category_id := hxc_tcc_shd.g_old_rec.ref_time_category_id;

Line 313: p_rec.ref_time_category_id := hxc_tcc_shd.g_old_rec.ref_time_category_id;

309: p_rec.time_category_id := hxc_tcc_shd.g_old_rec.time_category_id;
310: End If;
311:
312: If (p_rec.ref_time_category_id = hr_api.g_number) then
313: p_rec.ref_time_category_id := hxc_tcc_shd.g_old_rec.ref_time_category_id;
314: End If;
315:
316: If (p_rec.component_type_id = hr_api.g_number) then
317: p_rec.component_type_id := hxc_tcc_shd.g_old_rec.component_type_id;

Line 317: p_rec.component_type_id := hxc_tcc_shd.g_old_rec.component_type_id;

313: p_rec.ref_time_category_id := hxc_tcc_shd.g_old_rec.ref_time_category_id;
314: End If;
315:
316: If (p_rec.component_type_id = hr_api.g_number) then
317: p_rec.component_type_id := hxc_tcc_shd.g_old_rec.component_type_id;
318: End If;
319:
320: If (p_rec.flex_value_set_id = hr_api.g_number) then
321: p_rec.flex_value_set_id := hxc_tcc_shd.g_old_rec.flex_value_set_id;

Line 321: p_rec.flex_value_set_id := hxc_tcc_shd.g_old_rec.flex_value_set_id;

317: p_rec.component_type_id := hxc_tcc_shd.g_old_rec.component_type_id;
318: End If;
319:
320: If (p_rec.flex_value_set_id = hr_api.g_number) then
321: p_rec.flex_value_set_id := hxc_tcc_shd.g_old_rec.flex_value_set_id;
322: End If;
323:
324: If (p_rec.value_id = hr_api.g_varchar2) then
325: p_rec.value_id := hxc_tcc_shd.g_old_rec.value_id;

Line 325: p_rec.value_id := hxc_tcc_shd.g_old_rec.value_id;

321: p_rec.flex_value_set_id := hxc_tcc_shd.g_old_rec.flex_value_set_id;
322: End If;
323:
324: If (p_rec.value_id = hr_api.g_varchar2) then
325: p_rec.value_id := hxc_tcc_shd.g_old_rec.value_id;
326: End If;
327:
328: If (p_rec.is_null = hr_api.g_varchar2) then
329: p_rec.is_null := hxc_tcc_shd.g_old_rec.is_null;

Line 329: p_rec.is_null := hxc_tcc_shd.g_old_rec.is_null;

325: p_rec.value_id := hxc_tcc_shd.g_old_rec.value_id;
326: End If;
327:
328: If (p_rec.is_null = hr_api.g_varchar2) then
329: p_rec.is_null := hxc_tcc_shd.g_old_rec.is_null;
330: End If;
331:
332: If (p_rec.equal_to = hr_api.g_varchar2) then
333: p_rec.equal_to := hxc_tcc_shd.g_old_rec.equal_to;

Line 333: p_rec.equal_to := hxc_tcc_shd.g_old_rec.equal_to;

329: p_rec.is_null := hxc_tcc_shd.g_old_rec.is_null;
330: End If;
331:
332: If (p_rec.equal_to = hr_api.g_varchar2) then
333: p_rec.equal_to := hxc_tcc_shd.g_old_rec.equal_to;
334: End If;
335:
336: If (p_rec.type = hr_api.g_varchar2) then
337: p_rec.type := hxc_tcc_shd.g_old_rec.type;

Line 337: p_rec.type := hxc_tcc_shd.g_old_rec.type;

333: p_rec.equal_to := hxc_tcc_shd.g_old_rec.equal_to;
334: End If;
335:
336: If (p_rec.type = hr_api.g_varchar2) then
337: p_rec.type := hxc_tcc_shd.g_old_rec.type;
338: End If;
339:
340: End convert_defs;
341: --

Line 346: (p_rec in out nocopy hxc_tcc_shd.g_rec_type

342: -- ----------------------------------------------------------------------------
343: -- |---------------------------------< upd >----------------------------------|
344: -- ----------------------------------------------------------------------------
345: Procedure upd
346: (p_rec in out nocopy hxc_tcc_shd.g_rec_type
347: ) is
348: --
349: l_proc varchar2(72);
350:

Line 364: hxc_tcc_shd.lck

360: end if;
361: --
362: -- We must lock the row which we need to update.
363: --
364: hxc_tcc_shd.lck
365: (p_rec.time_category_comp_id
366: ,p_rec.object_version_number
367: );
368: --

Line 400: IF ( p_rec.type = 'MC' OR hxc_tcc_shd.g_old_rec.type = 'MC' )

396: hxc_time_category_utils_pkg.update_time_category_comp_sql ( p_rec );
397:
398: END IF;
399:
400: IF ( p_rec.type = 'MC' OR hxc_tcc_shd.g_old_rec.type = 'MC' )
401: THEN
402: hxc_time_category_api.set_dynamic_sql_string ( p_time_category_id => p_rec.time_category_id );
403:
404: END IF;

Line 425: l_rec hxc_tcc_shd.g_rec_type;

421: ,p_equal_to in varchar2 default hr_api.g_varchar2
422: ,p_type in varchar2 default hr_api.g_varchar2
423: ) is
424: --
425: l_rec hxc_tcc_shd.g_rec_type;
426: l_proc varchar2(72);
427: --
428: Begin
429: g_debug := hr_utility.debug_enabled;

Line 440: hxc_tcc_shd.convert_args (

436: -- Call conversion function to turn arguments into the
437: -- l_rec structure.
438:
439: l_rec :=
440: hxc_tcc_shd.convert_args (
441: p_time_category_comp_id
442: ,p_time_category_id
443: ,p_ref_time_category_id
444: ,p_component_type_id