APPS.OTA_CUS_INS dependencies on OTA_CUS_SHD

Line 82: (p_rec in out nocopy ota_cus_shd.g_rec_type

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

Line 119: ota_cus_shd.constraint_error

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

Line 124: ota_cus_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: --
124: ota_cus_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --

Line 129: ota_cus_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --
129: ota_cus_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: --
133: Raise;

Line 174: (p_rec in out nocopy ota_cus_shd.g_rec_type

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure pre_insert
174: (p_rec in out nocopy ota_cus_shd.g_rec_type
175: ) is
176: --
177: -- Cursor C_Sel1 is select ota_chat_users_s.nextval from sys.dual;
178: --

Line 274: ,p_rec in ota_cus_shd.g_rec_type

270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure post_insert
273: (p_effective_date in date
274: ,p_rec in ota_cus_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'post_insert';
278: --

Line 317: ,p_rec in out nocopy ota_cus_shd.g_rec_type

313: -- |---------------------------------< ins >----------------------------------|
314: -- ----------------------------------------------------------------------------
315: Procedure ins
316: (p_effective_date in date
317: ,p_rec in out nocopy ota_cus_shd.g_rec_type
318: ) is
319: --
320: l_proc varchar2(72) := g_package||'ins';
321: l_chat_id number;

Line 381: l_rec ota_cus_shd.g_rec_type;

377: ,p_login_date in date
378: ,p_object_version_number out nocopy number
379: ) is
380: --
381: l_rec ota_cus_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'ins';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);

Line 391: ota_cus_shd.convert_args

387: -- Call conversion function to turn arguments into the
388: -- p_rec structure.
389: --
390: l_rec :=
391: ota_cus_shd.convert_args
392: (p_chat_id
393: ,p_business_group_id
394: ,p_person_id
395: ,p_contact_id