APPS.PQP_EXR_INS dependencies on PQP_EXR_SHD

Line 103: (p_rec in out nocopy pqp_exr_shd.g_rec_type

99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure insert_dml
103: (p_rec in out nocopy pqp_exr_shd.g_rec_type
104: ) is
105: --
106: l_proc varchar2(72) := g_package||'insert_dml';
107: --

Line 112: pqp_exr_shd.g_api_dml := true; -- Set the api dml status

108: Begin
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: p_rec.object_version_number := 1; -- Initialise the object version
111: --
112: pqp_exr_shd.g_api_dml := true; -- Set the api dml status
113: --
114: -- Insert the row into: pqp_exception_reports
115: --
116:

Line 197: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

193:
194: END IF;
195:
196: --
197: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: Exception
201: When hr_api.check_integrity_violated Then

Line 203: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: Exception
201: When hr_api.check_integrity_violated Then
202: -- A check constraint has been violated
203: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
204: pqp_exr_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.parent_integrity_violated Then
207: -- Parent integrity has been violated

Line 204: pqp_exr_shd.constraint_error

200: Exception
201: When hr_api.check_integrity_violated Then
202: -- A check constraint has been violated
203: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
204: pqp_exr_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.parent_integrity_violated Then
207: -- Parent integrity has been violated
208: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

Line 208: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

204: pqp_exr_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.parent_integrity_violated Then
207: -- Parent integrity has been violated
208: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
209: pqp_exr_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When hr_api.unique_integrity_violated Then
212: -- Unique integrity has been violated

Line 209: pqp_exr_shd.constraint_error

205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.parent_integrity_violated Then
207: -- Parent integrity has been violated
208: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
209: pqp_exr_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When hr_api.unique_integrity_violated Then
212: -- Unique integrity has been violated
213: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

Line 213: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

209: pqp_exr_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When hr_api.unique_integrity_violated Then
212: -- Unique integrity has been violated
213: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
214: pqp_exr_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When Others Then
217: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

Line 214: pqp_exr_shd.constraint_error

210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When hr_api.unique_integrity_violated Then
212: -- Unique integrity has been violated
213: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
214: pqp_exr_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When Others Then
217: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
218: Raise;

Line 217: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

213: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
214: pqp_exr_shd.constraint_error
215: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
216: When Others Then
217: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
218: Raise;
219: End insert_dml;
220: --
221: -- ----------------------------------------------------------------------------

Line 259: (p_rec in out nocopy pqp_exr_shd.g_rec_type

255: --
256: -- {End Of Comments}
257: -- ----------------------------------------------------------------------------
258: Procedure pre_insert
259: (p_rec in out nocopy pqp_exr_shd.g_rec_type
260: ) is
261: --
262: l_proc varchar2(72) := g_package||'pre_insert';
263: --

Line 312: (p_rec in pqp_exr_shd.g_rec_type

308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure post_insert
312: (p_rec in pqp_exr_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'post_insert';
316: --

Line 373: (p_rec in out nocopy pqp_exr_shd.g_rec_type

369: -- ----------------------------------------------------------------------------
370: -- |---------------------------------< ins >----------------------------------|
371: -- ----------------------------------------------------------------------------
372: Procedure ins
373: (p_rec in out nocopy pqp_exr_shd.g_rec_type
374: ) is
375: --
376: l_proc varchar2(72) := g_package||'ins';
377: --

Line 429: l_rec pqp_exr_shd.g_rec_type;

425: ,p_output_format_type in varchar2
426: ,p_variance_operator in varchar2
427: ) is
428: --
429: l_rec pqp_exr_shd.g_rec_type;
430: l_proc varchar2(72) := g_package||'ins';
431: --
432: Begin
433: hr_utility.set_location('Entering:'||l_proc, 5);

Line 441: pqp_exr_shd.convert_args

437: --
438:
439:
440: l_rec :=
441: pqp_exr_shd.convert_args
442: (null
443: ,p_exception_report_name
444: ,p_legislation_code
445: ,p_business_group_id