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.PER_ORS_INS dependencies on PER_ORS_SHD

Line 76: (p_rec in out nocopy per_ors_shd.g_rec_type

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

Line 85: per_ors_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: per_ors_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_organization_structures
88: --
89: insert into per_organization_structures

Line 158: per_ors_shd.g_api_dml := false; -- Unset the api dml status

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

Line 164: per_ors_shd.g_api_dml := false; -- Unset the api dml status

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

Line 165: per_ors_shd.constraint_error

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

Line 169: per_ors_shd.g_api_dml := false; -- Unset the api dml status

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

Line 170: per_ors_shd.constraint_error

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

Line 174: per_ors_shd.g_api_dml := false; -- Unset the api dml status

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

Line 175: per_ors_shd.constraint_error

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

Line 178: per_ors_shd.g_api_dml := false; -- Unset the api dml status

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

Line 220: (p_rec in out nocopy per_ors_shd.g_rec_type

216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure pre_insert
220: (p_rec in out nocopy per_ors_shd.g_rec_type
221: ) is
222: --
223: Cursor C_Sel1 is select per_organization_structures_s.nextval from sys.dual;
224: --

Line 308: ,p_rec in per_ors_shd.g_rec_type

304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure post_insert
307: (p_effective_date in date
308: ,p_rec in per_ors_shd.g_rec_type
309: ) is
310: --
311: l_proc varchar2(72) := g_package||'post_insert';
312: --

Line 403: ,p_rec in out nocopy per_ors_shd.g_rec_type

399: -- |---------------------------------< ins >----------------------------------|
400: -- ----------------------------------------------------------------------------
401: Procedure ins
402: (p_effective_date in date
403: ,p_rec in out nocopy per_ors_shd.g_rec_type
404: ) is
405: --
406: l_proc varchar2(72) := g_package||'ins';
407: --

Line 475: l_rec per_ors_shd.g_rec_type;

471: ,p_organization_structure_id out nocopy number
472: ,p_object_version_number out nocopy number
473: ) is
474: --
475: l_rec per_ors_shd.g_rec_type;
476: l_proc varchar2(72) := g_package||'ins';
477: --
478: Begin
479: hr_utility.set_location('Entering:'||l_proc, 5);

Line 485: per_ors_shd.convert_args

481: -- Call conversion function to turn arguments into the
482: -- p_rec structure.
483: --
484: l_rec :=
485: per_ors_shd.convert_args
486: (null
487: ,p_business_group_id
488: ,p_name
489: ,p_comments