APPS.OTA_ACI_INS dependencies on OTA_ACI_SHD

Line 79: (p_rec in out nocopy ota_aci_shd.g_rec_type

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

Line 88: ota_aci_shd.g_api_dml := true; -- Set the api dml status

84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: ota_aci_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ota_act_cat_inclusions
91: --
92: insert into ota_act_cat_inclusions

Line 157: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

153: ,p_rec.primary_flag
154: ,p_rec.category_usage_id
155: );
156: --
157: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: Exception
161: When hr_api.check_integrity_violated Then

Line 163: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
164: ota_aci_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated

Line 164: ota_aci_shd.constraint_error

160: Exception
161: When hr_api.check_integrity_violated Then
162: -- A check constraint has been violated
163: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
164: ota_aci_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

Line 168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

164: ota_aci_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
169: ota_aci_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated

Line 169: ota_aci_shd.constraint_error

165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.parent_integrity_violated Then
167: -- Parent integrity has been violated
168: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
169: ota_aci_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

Line 173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

169: ota_aci_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
174: ota_aci_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When Others Then
177: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

Line 174: ota_aci_shd.constraint_error

170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.unique_integrity_violated Then
172: -- Unique integrity has been violated
173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
174: ota_aci_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When Others Then
177: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
178: Raise;

Line 177: ota_aci_shd.g_api_dml := false; -- Unset the api dml status

173: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
174: ota_aci_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When Others Then
177: ota_aci_shd.g_api_dml := false; -- Unset the api dml status
178: Raise;
179: End insert_dml;
180: --
181: -- ----------------------------------------------------------------------------

Line 219: (p_rec in out nocopy ota_aci_shd.g_rec_type

215: --
216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure pre_insert
219: (p_rec in out nocopy ota_aci_shd.g_rec_type
220: ) is
221:
222: /*
223: --

Line 318: ,p_rec in ota_aci_shd.g_rec_type

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

Line 409: ,p_rec in out nocopy ota_aci_shd.g_rec_type

405: -- |---------------------------------< ins >----------------------------------|
406: -- ----------------------------------------------------------------------------
407: Procedure ins
408: (p_effective_date in date
409: ,p_rec in out nocopy ota_aci_shd.g_rec_type
410: ) is
411: --
412: l_proc varchar2(72) := g_package||'ins';
413: l_activity_version_id ota_act_cat_inclusions.activity_version_id%TYPE;

Line 501: l_rec ota_aci_shd.g_rec_type;

497: -- ,p_category_usage_id out nocopy number
498: ,p_object_version_number out nocopy number
499: ) is
500: --
501: l_rec ota_aci_shd.g_rec_type;
502: l_proc varchar2(72) := g_package||'ins';
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);

Line 511: ota_aci_shd.convert_args

507: -- Call conversion function to turn arguments into the
508: -- p_rec structure.
509: --
510: l_rec :=
511: ota_aci_shd.convert_args
512: (--null
513: p_activity_version_id
514: ,p_activity_category
515: ,null