DBA Data[Home] [Help]

APPS.HXC_HTR_UPD dependencies on HXC_HTR_SHD

Line 57: (p_rec in out nocopy hxc_htr_shd.g_rec_type

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

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

Line 96: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 106: hxc_htr_shd.constraint_error

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

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

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

Line 111: hxc_htr_shd.constraint_error

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

Line 115: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 116: hxc_htr_shd.constraint_error

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

Line 119: hxc_htr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 156: (p_rec in hxc_htr_shd.g_rec_type

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

Line 208: ,p_rec in hxc_htr_shd.g_rec_type

204: -- {End Of Comments}
205: -- ----------------------------------------------------------------------------
206: Procedure post_update
207: (p_effective_date in date
208: ,p_rec in hxc_htr_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72);
212: --

Line 247: => hxc_htr_shd.g_old_rec.name

243: => p_rec.application_id
244: ,p_object_version_number
245: => p_rec.object_version_number
246: ,p_name_o
247: => hxc_htr_shd.g_old_rec.name
248: ,p_appl_retrieval_function_o
249: => hxc_htr_shd.g_old_rec.application_retrieval_function
250: ,p_appl_update_process_o
251: => hxc_htr_shd.g_old_rec.application_update_process

Line 249: => hxc_htr_shd.g_old_rec.application_retrieval_function

245: => p_rec.object_version_number
246: ,p_name_o
247: => hxc_htr_shd.g_old_rec.name
248: ,p_appl_retrieval_function_o
249: => hxc_htr_shd.g_old_rec.application_retrieval_function
250: ,p_appl_update_process_o
251: => hxc_htr_shd.g_old_rec.application_update_process
252: ,p_appl_validation_process_o
253: => hxc_htr_shd.g_old_rec.appl_validation_process

Line 251: => hxc_htr_shd.g_old_rec.application_update_process

247: => hxc_htr_shd.g_old_rec.name
248: ,p_appl_retrieval_function_o
249: => hxc_htr_shd.g_old_rec.application_retrieval_function
250: ,p_appl_update_process_o
251: => hxc_htr_shd.g_old_rec.application_update_process
252: ,p_appl_validation_process_o
253: => hxc_htr_shd.g_old_rec.appl_validation_process
254: ,p_appl_period_function_o
255: => hxc_htr_shd.g_old_rec.application_period_function

Line 253: => hxc_htr_shd.g_old_rec.appl_validation_process

249: => hxc_htr_shd.g_old_rec.application_retrieval_function
250: ,p_appl_update_process_o
251: => hxc_htr_shd.g_old_rec.application_update_process
252: ,p_appl_validation_process_o
253: => hxc_htr_shd.g_old_rec.appl_validation_process
254: ,p_appl_period_function_o
255: => hxc_htr_shd.g_old_rec.application_period_function
256: ,p_appl_dyn_template_process_o
257: => hxc_htr_shd.g_old_rec.appl_dynamic_template_process

Line 255: => hxc_htr_shd.g_old_rec.application_period_function

251: => hxc_htr_shd.g_old_rec.application_update_process
252: ,p_appl_validation_process_o
253: => hxc_htr_shd.g_old_rec.appl_validation_process
254: ,p_appl_period_function_o
255: => hxc_htr_shd.g_old_rec.application_period_function
256: ,p_appl_dyn_template_process_o
257: => hxc_htr_shd.g_old_rec.appl_dynamic_template_process
258: ,p_extension_function1_o
259: => hxc_htr_shd.g_old_rec.extension_function1

Line 257: => hxc_htr_shd.g_old_rec.appl_dynamic_template_process

253: => hxc_htr_shd.g_old_rec.appl_validation_process
254: ,p_appl_period_function_o
255: => hxc_htr_shd.g_old_rec.application_period_function
256: ,p_appl_dyn_template_process_o
257: => hxc_htr_shd.g_old_rec.appl_dynamic_template_process
258: ,p_extension_function1_o
259: => hxc_htr_shd.g_old_rec.extension_function1
260: ,p_extension_function2_o
261: => hxc_htr_shd.g_old_rec.extension_function2

Line 259: => hxc_htr_shd.g_old_rec.extension_function1

255: => hxc_htr_shd.g_old_rec.application_period_function
256: ,p_appl_dyn_template_process_o
257: => hxc_htr_shd.g_old_rec.appl_dynamic_template_process
258: ,p_extension_function1_o
259: => hxc_htr_shd.g_old_rec.extension_function1
260: ,p_extension_function2_o
261: => hxc_htr_shd.g_old_rec.extension_function2
262: ,p_application_id_o
263: => hxc_htr_shd.g_old_rec.application_id

Line 261: => hxc_htr_shd.g_old_rec.extension_function2

257: => hxc_htr_shd.g_old_rec.appl_dynamic_template_process
258: ,p_extension_function1_o
259: => hxc_htr_shd.g_old_rec.extension_function1
260: ,p_extension_function2_o
261: => hxc_htr_shd.g_old_rec.extension_function2
262: ,p_application_id_o
263: => hxc_htr_shd.g_old_rec.application_id
264: ,p_object_version_number_o
265: => hxc_htr_shd.g_old_rec.object_version_number

Line 263: => hxc_htr_shd.g_old_rec.application_id

259: => hxc_htr_shd.g_old_rec.extension_function1
260: ,p_extension_function2_o
261: => hxc_htr_shd.g_old_rec.extension_function2
262: ,p_application_id_o
263: => hxc_htr_shd.g_old_rec.application_id
264: ,p_object_version_number_o
265: => hxc_htr_shd.g_old_rec.object_version_number
266: );
267: --

Line 265: => hxc_htr_shd.g_old_rec.object_version_number

261: => hxc_htr_shd.g_old_rec.extension_function2
262: ,p_application_id_o
263: => hxc_htr_shd.g_old_rec.application_id
264: ,p_object_version_number_o
265: => hxc_htr_shd.g_old_rec.object_version_number
266: );
267: --
268: exception
269: --

Line 327: (p_rec in out nocopy hxc_htr_shd.g_rec_type

323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure convert_defs
327: (p_rec in out nocopy hxc_htr_shd.g_rec_type
328: ) is
329: --
330: Begin
331: --

Line 339: hxc_htr_shd.g_old_rec.name;

335: -- is being used then we must set to the 'current' argument value.
336: --
337: If (p_rec.name = hr_api.g_varchar2) then
338: p_rec.name :=
339: hxc_htr_shd.g_old_rec.name;
340: End If;
341: If (p_rec.application_id = hr_api.g_number) then
342: p_rec.application_id :=
343: hxc_htr_shd.g_old_rec.application_id;

Line 343: hxc_htr_shd.g_old_rec.application_id;

339: hxc_htr_shd.g_old_rec.name;
340: End If;
341: If (p_rec.application_id = hr_api.g_number) then
342: p_rec.application_id :=
343: hxc_htr_shd.g_old_rec.application_id;
344: End If;
345: --
346: End convert_defs;
347: --

Line 353: ,p_rec in out nocopy hxc_htr_shd.g_rec_type

349: -- |---------------------------------< upd >----------------------------------|
350: -- ----------------------------------------------------------------------------
351: Procedure upd
352: (p_effective_date in date
353: ,p_rec in out nocopy hxc_htr_shd.g_rec_type
354: ) is
355: --
356: l_proc varchar2(72);
357: --

Line 368: hxc_htr_shd.lck

364: end if;
365: --
366: -- We must lock the row which we need to update.
367: --
368: hxc_htr_shd.lck
369: (p_rec.time_recipient_id
370: ,p_rec.object_version_number
371: );
372: --

Line 419: l_rec hxc_htr_shd.g_rec_type;

415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_application_id in number default hr_api.g_number
417: ) is
418: --
419: l_rec hxc_htr_shd.g_rec_type;
420: l_proc varchar2(72);
421: --
422: Begin
423: g_debug := hr_utility.debug_enabled;

Line 434: hxc_htr_shd.convert_args

430: -- Call conversion function to turn arguments into the
431: -- l_rec structure.
432: --
433: l_rec :=
434: hxc_htr_shd.convert_args
435: (p_time_recipient_id
436: ,p_name
437: ,p_appl_retrieval_function
438: ,p_appl_update_process