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_OSE_INS dependencies on PER_OSE_SHD

Line 75: (p_rec in out nocopy per_ose_shd.g_rec_type

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

Line 84: per_ose_shd.g_api_dml := true; -- Set the api dml status

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

Line 115: per_ose_shd.g_api_dml := false; -- Unset the api dml status

111: ,p_rec.object_version_number
112: ,p_rec.position_control_enabled_flag
113: );
114: --
115: per_ose_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: Exception
119: When hr_api.check_integrity_violated Then

Line 121: per_ose_shd.g_api_dml := false; -- Unset the api dml status

117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: per_ose_shd.g_api_dml := false; -- Unset the api dml status
122: per_ose_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated

Line 122: per_ose_shd.constraint_error

118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: per_ose_shd.g_api_dml := false; -- Unset the api dml status
122: per_ose_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: per_ose_shd.g_api_dml := false; -- Unset the api dml status

Line 126: per_ose_shd.g_api_dml := false; -- Unset the api dml status

122: per_ose_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: per_ose_shd.g_api_dml := false; -- Unset the api dml status
127: per_ose_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated

Line 127: per_ose_shd.constraint_error

123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: per_ose_shd.g_api_dml := false; -- Unset the api dml status
127: per_ose_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: per_ose_shd.g_api_dml := false; -- Unset the api dml status

Line 131: per_ose_shd.g_api_dml := false; -- Unset the api dml status

127: per_ose_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: per_ose_shd.g_api_dml := false; -- Unset the api dml status
132: per_ose_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: per_ose_shd.g_api_dml := false; -- Unset the api dml status

Line 132: per_ose_shd.constraint_error

128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: per_ose_shd.g_api_dml := false; -- Unset the api dml status
132: per_ose_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: per_ose_shd.g_api_dml := false; -- Unset the api dml status
136: Raise;

Line 135: per_ose_shd.g_api_dml := false; -- Unset the api dml status

131: per_ose_shd.g_api_dml := false; -- Unset the api dml status
132: per_ose_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: per_ose_shd.g_api_dml := false; -- Unset the api dml status
136: Raise;
137: End insert_dml;
138: --
139: -- ----------------------------------------------------------------------------

Line 177: (p_rec in out nocopy per_ose_shd.g_rec_type

173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure pre_insert
177: (p_rec in out nocopy per_ose_shd.g_rec_type
178: ) is
179: --
180: l_proc varchar2(72) := g_package||'pre_insert';
181: --

Line 230: (p_rec in per_ose_shd.g_rec_type

226: --
227: -- {End Of Comments}
228: -- ----------------------------------------------------------------------------
229: Procedure post_insert
230: (p_rec in per_ose_shd.g_rec_type
231: ) is
232: --
233: l_proc varchar2(72) := g_package||'post_insert';
234: --

Line 281: (p_rec in out nocopy per_ose_shd.g_rec_type

277: -- ----------------------------------------------------------------------------
278: -- |---------------------------------< ins >----------------------------------|
279: -- ----------------------------------------------------------------------------
280: Procedure ins
281: (p_rec in out nocopy per_ose_shd.g_rec_type
282: ,p_effective_date in date
283: ) is
284: --
285: l_proc varchar2(72) := g_package||'ins';

Line 332: l_rec per_ose_shd.g_rec_type;

328: ,p_org_structure_element_id out nocopy number
329: ,p_object_version_number out nocopy number
330: ) is
331: --
332: l_rec per_ose_shd.g_rec_type;
333: l_proc varchar2(72) := g_package||'ins';
334: --
335: Begin
336: hr_utility.set_location('Entering:'||l_proc, 5);

Line 342: per_ose_shd.convert_args

338: -- Call conversion function to turn arguments into the
339: -- p_rec structure.
340: --
341: l_rec :=
342: per_ose_shd.convert_args
343: (null
344: ,p_business_group_id
345: ,p_organization_id_parent
346: ,p_org_structure_version_id