APPS.OTA_CPR_INS dependencies on OTA_CPR_SHD

Line 79: (p_rec in out nocopy ota_cpr_shd.g_rec_type

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

Line 116: ota_cpr_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ota_cpr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --

Line 121: ota_cpr_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cpr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --

Line 126: ota_cpr_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cpr_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;

Line 171: (p_rec in out nocopy ota_cpr_shd.g_rec_type

167: --
168: -- {End Of Comments}
169: -- ----------------------------------------------------------------------------
170: Procedure pre_insert
171: (p_rec in out nocopy ota_cpr_shd.g_rec_type
172: ) is
173: --
174: --
175: /*

Line 270: ,p_rec in ota_cpr_shd.g_rec_type

266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure post_insert
269: (p_effective_date in date
270: ,p_rec in ota_cpr_shd.g_rec_type
271: ) is
272: --
273: l_proc varchar2(72) := g_package||'post_insert';
274: --

Line 313: ,p_rec in out nocopy ota_cpr_shd.g_rec_type

309: -- |---------------------------------< ins >----------------------------------|
310: -- ----------------------------------------------------------------------------
311: Procedure ins
312: (p_effective_date in date
313: ,p_rec in out nocopy ota_cpr_shd.g_rec_type
314: ) is
315: --
316: l_proc varchar2(72) := g_package||'ins';
317: l_activity_version_id OTA_COURSE_PREREQUISITES.activity_version_id%TYPE;

Line 375: l_rec ota_cpr_shd.g_rec_type;

371: -- ,p_prerequisite_course_id out nocopy number
372: ,p_object_version_number out nocopy number
373: ) is
374: --
375: l_rec ota_cpr_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'ins';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);

Line 385: ota_cpr_shd.convert_args

381: -- Call conversion function to turn arguments into the
382: -- p_rec structure.
383: --
384: l_rec :=
385: ota_cpr_shd.convert_args
386: (p_activity_version_id
387: ,p_prerequisite_course_id
388: ,p_business_group_id
389: ,p_prerequisite_type