APPS.PAY_APR_INS dependencies on PAY_APR_SHD

Line 127: (p_rec in out nocopy pay_apr_shd.g_rec_type

123: --
124: -- {End Of Comments}
125: -- ----------------------------------------------------------------------------
126: Procedure insert_dml
127: (p_rec in out nocopy pay_apr_shd.g_rec_type
128: ) is
129: --
130: l_proc varchar2(72);
131: --

Line 139: pay_apr_shd.g_api_dml := true; -- Set the api dml status

135: --
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: p_rec.object_version_number := 1; -- Initialise the object version
138: --
139: pay_apr_shd.g_api_dml := true; -- Set the api dml status
140: --
141: -- Insert the row into: pay_au_processes
142: --
143: insert into pay_au_processes

Line 166: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

162: ,p_rec.accrual_category
163: ,p_rec.object_version_number
164: );
165: --
166: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
167: --
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: Exception
170: When hr_api.check_integrity_violated Then

Line 172: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

168: hr_utility.set_location(' Leaving:'||l_proc, 10);
169: Exception
170: When hr_api.check_integrity_violated Then
171: -- A check constraint has been violated
172: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
173: pay_apr_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated

Line 173: pay_apr_shd.constraint_error

169: Exception
170: When hr_api.check_integrity_violated Then
171: -- A check constraint has been violated
172: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
173: pay_apr_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

Line 177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

173: pay_apr_shd.constraint_error
174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
178: pay_apr_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated

Line 178: pay_apr_shd.constraint_error

174: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
175: When hr_api.parent_integrity_violated Then
176: -- Parent integrity has been violated
177: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
178: pay_apr_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

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

178: pay_apr_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
183: pay_apr_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

Line 183: pay_apr_shd.constraint_error

179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
183: pay_apr_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
187: Raise;

Line 186: pay_apr_shd.g_api_dml := false; -- Unset the api dml status

182: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
183: pay_apr_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
187: Raise;
188: End insert_dml;
189: --
190: -- ----------------------------------------------------------------------------

Line 228: (p_rec in out nocopy pay_apr_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_insert
228: (p_rec in out nocopy pay_apr_shd.g_rec_type
229: ) is
230: --
231: Cursor C_Sel1 is select pay_au_processes_s.nextval from sys.dual;
232: --

Line 318: (p_rec in pay_apr_shd.g_rec_type

314: --
315: -- {End Of Comments}
316: -- ----------------------------------------------------------------------------
317: Procedure post_insert
318: (p_rec in pay_apr_shd.g_rec_type
319: ) is
320: --
321: l_proc varchar2(72);
322: --

Line 345: (p_rec in out nocopy pay_apr_shd.g_rec_type

341: -- ----------------------------------------------------------------------------
342: -- |---------------------------------< ins >----------------------------------|
343: -- ----------------------------------------------------------------------------
344: Procedure ins
345: (p_rec in out nocopy pay_apr_shd.g_rec_type
346: ) is
347: --
348: l_proc varchar2(72);
349: --

Line 399: l_rec pay_apr_shd.g_rec_type;

395: ,p_process_id out nocopy number
396: ,p_object_version_number out nocopy number
397: ) is
398: --
399: l_rec pay_apr_shd.g_rec_type;
400: l_proc varchar2(72);
401: --
402: Begin
403: l_proc := g_package||'ins';

Line 411: pay_apr_shd.convert_args

407: -- Call conversion function to turn arguments into the
408: -- p_rec structure.
409: --
410: l_rec :=
411: pay_apr_shd.convert_args
412: (null
413: ,p_short_name
414: ,p_name
415: ,p_enabled_flag