eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_NHS_INS dependencies on OTA_NHS_SHD

Line 77: Procedure insert_dml(p_rec in out nocopy ota_nhs_shd.g_rec_type) is

73: -- Internal Row Handler Use Only.
74: --
75: -- {End Of Comments}
76: -- ----------------------------------------------------------------------------
77: Procedure insert_dml(p_rec in out nocopy ota_nhs_shd.g_rec_type) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin

Line 85: ota_nhs_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: ota_nhs_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: ota_notrng_histories
88: --
89: insert into ota_notrng_histories

Line 176: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

172: p_rec.customer_id,
173: p_rec.organization_id
174: );
175: --
176: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: Exception
180: When hr_api.check_integrity_violated Then

Line 182: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: Exception
180: When hr_api.check_integrity_violated Then
181: -- A check constraint has been violated
182: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
183: ota_nhs_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Parent integrity has been violated

Line 183: ota_nhs_shd.constraint_error

179: Exception
180: When hr_api.check_integrity_violated Then
181: -- A check constraint has been violated
182: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
183: ota_nhs_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Parent integrity has been violated
187: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

Line 187: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

183: ota_nhs_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Parent integrity has been violated
187: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
188: ota_nhs_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.unique_integrity_violated Then
191: -- Unique integrity has been violated

Line 188: ota_nhs_shd.constraint_error

184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Parent integrity has been violated
187: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
188: ota_nhs_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.unique_integrity_violated Then
191: -- Unique integrity has been violated
192: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

Line 192: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

188: ota_nhs_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.unique_integrity_violated Then
191: -- Unique integrity has been violated
192: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
193: ota_nhs_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When Others Then
196: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

Line 193: ota_nhs_shd.constraint_error

189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.unique_integrity_violated Then
191: -- Unique integrity has been violated
192: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
193: ota_nhs_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When Others Then
196: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
197: Raise;

Line 196: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

192: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
193: ota_nhs_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When Others Then
196: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
197: Raise;
198: End insert_dml;
199: --
200: -- ----------------------------------------------------------------------------

Line 237: Procedure pre_insert(p_rec in out nocopy ota_nhs_shd.g_rec_type) is

233: -- Internal Row Handler Use Only.
234: --
235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: Procedure pre_insert(p_rec in out nocopy ota_nhs_shd.g_rec_type) is
238: --
239: Cursor C_Sel1 is select ota_notrng_histories_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is

Line 323: p_rec in ota_nhs_shd.g_rec_type) is

319: --
320: -- {End Of Comments}
321: -- ----------------------------------------------------------------------------
322: Procedure post_insert(p_effective_date in date,
323: p_rec in ota_nhs_shd.g_rec_type) is
324: --
325: l_proc varchar2(72) := g_package||'post_insert';
326: --
327: Begin

Line 436: p_rec in out nocopy ota_nhs_shd.g_rec_type

432: -- |---------------------------------< ins >----------------------------------|
433: -- ----------------------------------------------------------------------------
434: Procedure ins
435: (p_effective_date in date,
436: p_rec in out nocopy ota_nhs_shd.g_rec_type
437: ) is
438: --
439: l_proc varchar2(72) := g_package||'ins';
440: --

Line 511: l_rec ota_nhs_shd.g_rec_type;

507: p_customer_id in number default null,
508: p_organization_id in number default null
509: ) is
510: --
511: l_rec ota_nhs_shd.g_rec_type;
512: l_proc varchar2(72) := g_package||'ins';
513: --
514: Begin
515: hr_utility.set_location('Entering:'||l_proc, 5);

Line 521: ota_nhs_shd.convert_args

517: -- Call conversion function to turn arguments into the
518: -- p_rec structure.
519: --
520: l_rec :=
521: ota_nhs_shd.convert_args
522: (
523: null,
524: p_person_id,
525: p_contact_id,