DBA Data[Home] [Help]

APPS.HXC_HTC_UPD dependencies on HXC_HTC_SHD

Line 57: (p_rec in out nocopy hxc_htc_shd.g_rec_type

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

Line 73: hxc_htc_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_htc_shd.g_api_dml := true; -- Set the api dml status
74: --
75: -- Update the hxc_time_categories Row
76: --
77: update hxc_time_categories

Line 91: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

87: ,last_update_login = fnd_global.login_id
88:
89: where time_category_id = p_rec.time_category_id;
90: --
91: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status
92: --
93: if g_debug then
94: hr_utility.set_location(' Leaving:'||l_proc, 10);
95: end if;

Line 100: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 101: hxc_htc_shd.constraint_error

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

Line 105: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 106: hxc_htc_shd.constraint_error

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

Line 110: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 111: hxc_htc_shd.constraint_error

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

Line 114: hxc_htc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 151: (p_rec in hxc_htc_shd.g_rec_type

147: --
148: -- {End Of Comments}
149: -- ----------------------------------------------------------------------------
150: Procedure pre_update
151: (p_rec in hxc_htc_shd.g_rec_type
152: ) is
153: --
154: l_proc varchar2(72);
155: --

Line 198: (p_rec in hxc_htc_shd.g_rec_type

194: --
195: -- {End Of Comments}
196: -- ----------------------------------------------------------------------------
197: Procedure post_update
198: (p_rec in hxc_htc_shd.g_rec_type
199: ) is
200: --
201: l_proc varchar2(72);
202: --

Line 223: => hxc_htc_shd.g_old_rec.time_category_name

219: ,p_display => p_rec.display
220: ,p_object_version_number
221: => p_rec.object_version_number
222: ,p_time_category_name_o
223: => hxc_htc_shd.g_old_rec.time_category_name
224: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
225: ,p_description_o => hxc_htc_shd.g_old_rec.description
226: ,p_display_o => hxc_htc_shd.g_old_rec.display
227: ,p_object_version_number_o

Line 224: ,p_operator_o => hxc_htc_shd.g_old_rec.operator

220: ,p_object_version_number
221: => p_rec.object_version_number
222: ,p_time_category_name_o
223: => hxc_htc_shd.g_old_rec.time_category_name
224: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
225: ,p_description_o => hxc_htc_shd.g_old_rec.description
226: ,p_display_o => hxc_htc_shd.g_old_rec.display
227: ,p_object_version_number_o
228: => hxc_htc_shd.g_old_rec.object_version_number

Line 225: ,p_description_o => hxc_htc_shd.g_old_rec.description

221: => p_rec.object_version_number
222: ,p_time_category_name_o
223: => hxc_htc_shd.g_old_rec.time_category_name
224: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
225: ,p_description_o => hxc_htc_shd.g_old_rec.description
226: ,p_display_o => hxc_htc_shd.g_old_rec.display
227: ,p_object_version_number_o
228: => hxc_htc_shd.g_old_rec.object_version_number
229: );

Line 226: ,p_display_o => hxc_htc_shd.g_old_rec.display

222: ,p_time_category_name_o
223: => hxc_htc_shd.g_old_rec.time_category_name
224: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
225: ,p_description_o => hxc_htc_shd.g_old_rec.description
226: ,p_display_o => hxc_htc_shd.g_old_rec.display
227: ,p_object_version_number_o
228: => hxc_htc_shd.g_old_rec.object_version_number
229: );
230: --

Line 228: => hxc_htc_shd.g_old_rec.object_version_number

224: ,p_operator_o => hxc_htc_shd.g_old_rec.operator
225: ,p_description_o => hxc_htc_shd.g_old_rec.description
226: ,p_display_o => hxc_htc_shd.g_old_rec.display
227: ,p_object_version_number_o
228: => hxc_htc_shd.g_old_rec.object_version_number
229: );
230: --
231: exception
232: --

Line 290: (p_rec in out nocopy hxc_htc_shd.g_rec_type

286: --
287: -- {End Of Comments}
288: -- ----------------------------------------------------------------------------
289: Procedure convert_defs
290: (p_rec in out nocopy hxc_htc_shd.g_rec_type
291: ) is
292: --
293: Begin
294: --

Line 302: hxc_htc_shd.g_old_rec.time_category_name;

298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.time_category_name = hr_api.g_varchar2) then
301: p_rec.time_category_name :=
302: hxc_htc_shd.g_old_rec.time_category_name;
303: End If;
304: --
305: End convert_defs;
306: --

Line 311: (p_rec in out nocopy hxc_htc_shd.g_rec_type

307: -- ----------------------------------------------------------------------------
308: -- |---------------------------------< upd >----------------------------------|
309: -- ----------------------------------------------------------------------------
310: Procedure upd
311: (p_rec in out nocopy hxc_htc_shd.g_rec_type
312: ) is
313: --
314: l_proc varchar2(72);
315: --

Line 326: hxc_htc_shd.lck

322: end if;
323: --
324: -- We must lock the row which we need to update.
325: --
326: hxc_htc_shd.lck
327: (p_rec.time_category_id
328: ,p_rec.object_version_number
329: );
330: --

Line 373: l_rec hxc_htc_shd.g_rec_type;

369: ,p_description in varchar2
370: ,p_display in varchar2
371: ) is
372: --
373: l_rec hxc_htc_shd.g_rec_type;
374: l_proc varchar2(72);
375: --
376: Begin
377: g_debug := hr_utility.debug_enabled;

Line 388: hxc_htc_shd.convert_args

384: -- Call conversion function to turn arguments into the
385: -- l_rec structure.
386: --
387: l_rec :=
388: hxc_htc_shd.convert_args
389: (p_time_category_id
390: ,p_time_category_name
391: ,p_operator
392: ,p_description