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_OSV_INS dependencies on PER_OSV_SHD

Line 76: (p_rec in out nocopy per_osv_shd.g_rec_type

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

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

Line 120: per_osv_shd.g_api_dml := false; -- Unset the api dml status

116: ,p_rec.object_version_number
117: ,p_rec.topnode_pos_ctrl_enabled_flag
118: );
119: --
120: per_osv_shd.g_api_dml := false; -- Unset the api dml status
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: Exception
124: When hr_api.check_integrity_violated Then

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

122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: per_osv_shd.g_api_dml := false; -- Unset the api dml status
127: per_osv_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated

Line 127: per_osv_shd.constraint_error

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

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

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

Line 132: per_osv_shd.constraint_error

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

Line 136: per_osv_shd.g_api_dml := false; -- Unset the api dml status

132: per_osv_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_osv_shd.g_api_dml := false; -- Unset the api dml status
137: per_osv_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_osv_shd.g_api_dml := false; -- Unset the api dml status

Line 137: per_osv_shd.constraint_error

133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_osv_shd.g_api_dml := false; -- Unset the api dml status
137: per_osv_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_osv_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;

Line 140: per_osv_shd.g_api_dml := false; -- Unset the api dml status

136: per_osv_shd.g_api_dml := false; -- Unset the api dml status
137: per_osv_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_osv_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;
142: End insert_dml;
143: --
144: -- ----------------------------------------------------------------------------

Line 182: (p_rec in out nocopy per_osv_shd.g_rec_type

178: --
179: -- {End Of Comments}
180: -- ----------------------------------------------------------------------------
181: Procedure pre_insert
182: (p_rec in out nocopy per_osv_shd.g_rec_type
183: ) is
184: --
185: Cursor C_Sel1 is select per_org_structure_versions_s.nextval from sys.dual;
186: --

Line 271: ,p_rec in per_osv_shd.g_rec_type

267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure post_insert
270: (p_effective_date in date
271: ,p_rec in per_osv_shd.g_rec_type
272: ) is
273: --
274: l_proc varchar2(72) := g_package||'post_insert';
275: --

Line 328: ,p_rec in out nocopy per_osv_shd.g_rec_type

324: -- |---------------------------------< ins >----------------------------------|
325: -- ----------------------------------------------------------------------------
326: Procedure ins
327: (p_effective_date in date
328: ,p_rec in out nocopy per_osv_shd.g_rec_type
329: ,p_gap_warning out nocopy boolean
330: ) is
331: --
332: l_proc varchar2(72) := g_package||'ins';

Line 381: l_rec per_osv_shd.g_rec_type;

377: ,p_org_structure_version_id out nocopy number
378: ,p_object_version_number out nocopy number
379: ,p_gap_warning out nocopy boolean) is
380: --
381: l_rec per_osv_shd.g_rec_type;
382: l_proc varchar2(72) := g_package||'ins';
383: l_business_group_id number;
384: --
385: Begin

Line 397: per_osv_shd.convert_args

393: (p_organization_structure_id => p_organization_structure_id
394: ,p_business_group_id => l_business_group_id);
395:
396: l_rec :=
397: per_osv_shd.convert_args
398: (null
399: ,l_business_group_id
400: ,p_organization_structure_id
401: ,p_date_from