APPS.OTA_RUD_INS dependencies on OTA_RUD_SHD

Line 76: (p_rec in out nocopy ota_rud_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy ota_rud_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 169: ota_rud_shd.constraint_error

165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: --
169: ota_rud_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: --

Line 174: ota_rud_shd.constraint_error

170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: --
174: ota_rud_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: --

Line 179: ota_rud_shd.constraint_error

175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: --
179: ota_rud_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: --
183: Raise;

Line 224: (p_rec in out nocopy ota_rud_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure pre_insert
224: (p_rec in out nocopy ota_rud_shd.g_rec_type
225: ) is
226: --
227: Cursor C_Sel1 is select ota_resource_usages_s.nextval from sys.dual;
228: --

Line 312: ,p_rec in ota_rud_shd.g_rec_type

308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure post_insert
311: (p_effective_date in date
312: ,p_rec in ota_rud_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'post_insert';
316: --

Line 411: ,p_rec in out nocopy ota_rud_shd.g_rec_type

407: -- |---------------------------------< ins >----------------------------------|
408: -- ----------------------------------------------------------------------------
409: Procedure ins
410: (p_effective_date in date
411: ,p_rec in out nocopy ota_rud_shd.g_rec_type
412: ) is
413: --
414: l_proc varchar2(72) := g_package||'ins';
415: --

Line 491: l_rec ota_rud_shd.g_rec_type;

487: ,p_object_version_number out nocopy number
488: ,p_offering_id in number default null
489: ) is
490: --
491: l_rec ota_rud_shd.g_rec_type;
492: l_proc varchar2(72) := g_package||'ins';
493: --
494: Begin
495: hr_utility.set_location('Entering:'||l_proc, 5);

Line 501: ota_rud_shd.convert_args

497: -- Call conversion function to turn arguments into the
498: -- p_rec structure.
499: --
500: l_rec :=
501: ota_rud_shd.convert_args
502: (null
503: ,p_supplied_resource_id
504: ,p_activity_version_id
505: ,null