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_NAA_INS dependencies on PER_NAA_SHD

Line 76: (p_rec in out nocopy per_naa_shd.g_rec_type

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

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

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

116: ,p_rec.object_version_number
117: ,p_rec.enabled
118: );
119: --
120: per_naa_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_naa_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_naa_shd.g_api_dml := false; -- Unset the api dml status
127: per_naa_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_naa_shd.constraint_error

123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: per_naa_shd.g_api_dml := false; -- Unset the api dml status
127: per_naa_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_naa_shd.g_api_dml := false; -- Unset the api dml status

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

127: per_naa_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_naa_shd.g_api_dml := false; -- Unset the api dml status
132: per_naa_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_naa_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_naa_shd.g_api_dml := false; -- Unset the api dml status
132: per_naa_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_naa_shd.g_api_dml := false; -- Unset the api dml status

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

132: per_naa_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_naa_shd.g_api_dml := false; -- Unset the api dml status
137: per_naa_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_naa_shd.g_api_dml := false; -- Unset the api dml status

Line 137: per_naa_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_naa_shd.g_api_dml := false; -- Unset the api dml status
137: per_naa_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_naa_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;

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

136: per_naa_shd.g_api_dml := false; -- Unset the api dml status
137: per_naa_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_naa_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_naa_shd.g_rec_type

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

Line 269: (p_rec in per_naa_shd.g_rec_type

265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure post_insert
269: (p_rec in per_naa_shd.g_rec_type
270: ) is
271: --
272: l_proc varchar2(72) := g_package||'post_insert';
273: --

Line 322: (p_rec in out nocopy per_naa_shd.g_rec_type

318: -- ----------------------------------------------------------------------------
319: -- |---------------------------------< ins >----------------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure ins
322: (p_rec in out nocopy per_naa_shd.g_rec_type
323: ) is
324: --
325: l_proc varchar2(72) := g_package||'ins';
326: --

Line 377: l_rec per_naa_shd.g_rec_type;

373: ,p_object_version_number out nocopy number
374: ,p_enabled in varchar2
375: ) is
376: --
377: l_rec per_naa_shd.g_rec_type;
378: l_proc varchar2(72) := g_package||'ins';
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);

Line 387: per_naa_shd.convert_args

383: -- Call conversion function to turn arguments into the
384: -- p_rec structure.
385: --
386: l_rec :=
387: per_naa_shd.convert_args
388: (null
389: ,p_absence_attendance_id
390: ,p_expected_date
391: ,p_description