APPS.OTA_LCI_INS dependencies on OTA_LCI_SHD

Line 79: (p_rec in out nocopy ota_lci_shd.g_rec_type

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

Line 158: ota_lci_shd.constraint_error

154: Exception
155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: --
158: ota_lci_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.parent_integrity_violated Then
161: -- Parent integrity has been violated
162: --

Line 163: ota_lci_shd.constraint_error

159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.parent_integrity_violated Then
161: -- Parent integrity has been violated
162: --
163: ota_lci_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: --

Line 168: ota_lci_shd.constraint_error

164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When hr_api.unique_integrity_violated Then
166: -- Unique integrity has been violated
167: --
168: ota_lci_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: --
172: Raise;

Line 213: (p_rec in out nocopy ota_lci_shd.g_rec_type

209: --
210: -- {End Of Comments}
211: -- ----------------------------------------------------------------------------
212: Procedure pre_insert
213: (p_rec in out nocopy ota_lci_shd.g_rec_type
214: ) is
215: --
216: /*
217: Cursor C_Sel1 is select ota_lp_cat_inclusions_s.nextval from sys.dual;

Line 320: ,p_rec in ota_lci_shd.g_rec_type

316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure post_insert
319: (p_effective_date in date
320: ,p_rec in ota_lci_shd.g_rec_type
321: ) is
322: --
323: l_proc varchar2(72) := g_package||'post_insert';
324: --

Line 405: ,p_rec in out nocopy ota_lci_shd.g_rec_type

401: -- |---------------------------------< ins >----------------------------------|
402: -- ----------------------------------------------------------------------------
403: Procedure ins
404: (p_effective_date in date
405: ,p_rec in out nocopy ota_lci_shd.g_rec_type
406: ) is
407: --
408: l_proc varchar2(72) := g_package||'ins';
409: l_learning_path_id OTA_LP_CAT_INCLUSIONS.learning_path_id%TYPE;

Line 498: l_rec ota_lci_shd.g_rec_type;

494: -- ,p_category_usage_id out nocopy number
495: ,p_object_version_number out nocopy number
496: ) is
497: --
498: l_rec ota_lci_shd.g_rec_type;
499: l_proc varchar2(72) := g_package||'ins';
500:
501: --
502: Begin

Line 510: ota_lci_shd.convert_args

506: -- Call conversion function to turn arguments into the
507: -- p_rec structure.
508: --
509: l_rec :=
510: ota_lci_shd.convert_args
511: (p_learning_path_id
512: ,p_category_usage_id
513: ,p_primary_flag
514: ,p_start_date_active