APPS.OTA_TPC_INS dependencies on OTA_TPC_SHD

Line 54: (p_rec in out nocopy ota_tpc_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy ota_tpc_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 221: ota_tpc_shd.constraint_error

217: Exception
218: When hr_api.check_integrity_violated Then
219: -- A check constraint has been violated
220: --
221: ota_tpc_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: --

Line 226: ota_tpc_shd.constraint_error

222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: --
226: ota_tpc_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: --

Line 231: ota_tpc_shd.constraint_error

227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: --
231: ota_tpc_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When Others Then
234: --
235: Raise;

Line 276: (p_rec in out nocopy ota_tpc_shd.g_rec_type

272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure pre_insert
276: (p_rec in out nocopy ota_tpc_shd.g_rec_type
277: ) is
278: --
279: l_proc varchar2(72) := g_package||'pre_insert';
280: --

Line 330: ,p_rec in ota_tpc_shd.g_rec_type

326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328: Procedure post_insert
329: (p_effective_date in date
330: ,p_rec in ota_tpc_shd.g_rec_type
331: ) is
332: --
333: l_proc varchar2(72) := g_package||'post_insert';
334: --

Line 503: ,p_rec in out nocopy ota_tpc_shd.g_rec_type

499: -- |---------------------------------< ins >----------------------------------|
500: -- ----------------------------------------------------------------------------
501: Procedure ins
502: (p_effective_date in date
503: ,p_rec in out nocopy ota_tpc_shd.g_rec_type
504: ) is
505: --
506: l_proc varchar2(72) := g_package||'ins';
507: --

Line 614: l_rec ota_tpc_shd.g_rec_type;

610: ,p_training_plan_cost_id out nocopy number
611: ,p_object_version_number out nocopy number
612: ) is
613: --
614: l_rec ota_tpc_shd.g_rec_type;
615: l_proc varchar2(72) := g_package||'ins';
616: --
617: Begin
618: hr_utility.set_location('Entering:'||l_proc, 5);

Line 624: ota_tpc_shd.convert_args

620: -- Call conversion function to turn arguments into the
621: -- p_rec structure.
622: --
623: l_rec :=
624: ota_tpc_shd.convert_args
625: (null
626: ,p_tp_measurement_type_id
627: ,p_training_plan_id
628: ,p_booking_id