APPS.PQH_CPD_INS dependencies on PQH_CPD_SHD

Line 83: (p_rec in out nocopy pqh_cpd_shd.g_rec_type

79: --
80: -- {End Of Comments}
81: -- ----------------------------------------------------------------------------
82: Procedure insert_dml
83: (p_rec in out nocopy pqh_cpd_shd.g_rec_type
84: ) is
85: --
86: l_proc varchar2(72) ;
87: --

Line 95: pqh_cpd_shd.g_api_dml := true; -- Set the api dml status

91: hr_utility.set_location('Entering:'||l_proc, 5);
92: end if;
93: p_rec.object_version_number := 1; -- Initialise the object version
94: --
95: pqh_cpd_shd.g_api_dml := true; -- Set the api dml status
96: --
97: -- Insert the row into: pqh_corps_definitions
98: --
99: insert into pqh_corps_definitions

Line 214: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

210: ,p_rec.probation_period
211: ,p_rec.probation_units
212: );
213: --
214: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
215: --
216: if g_debug then
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: end if;

Line 222: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

218: end if;
219: Exception
220: When hr_api.check_integrity_violated Then
221: -- A check constraint has been violated
222: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
223: pqh_cpd_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated

Line 223: pqh_cpd_shd.constraint_error

219: Exception
220: When hr_api.check_integrity_violated Then
221: -- A check constraint has been violated
222: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
223: pqh_cpd_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated
227: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

Line 227: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

223: pqh_cpd_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated
227: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
228: pqh_cpd_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated

Line 228: pqh_cpd_shd.constraint_error

224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.parent_integrity_violated Then
226: -- Parent integrity has been violated
227: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
228: pqh_cpd_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

Line 232: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

228: pqh_cpd_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
233: pqh_cpd_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When Others Then
236: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

Line 233: pqh_cpd_shd.constraint_error

229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.unique_integrity_violated Then
231: -- Unique integrity has been violated
232: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
233: pqh_cpd_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When Others Then
236: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
237: Raise;

Line 236: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status

232: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
233: pqh_cpd_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When Others Then
236: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
237: Raise;
238: End insert_dml;
239: --
240: -- ----------------------------------------------------------------------------

Line 278: (p_rec in out nocopy pqh_cpd_shd.g_rec_type

274: --
275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: Procedure pre_insert
278: (p_rec in out nocopy pqh_cpd_shd.g_rec_type
279: ) is
280: --
281: Cursor C_Sel1 is select pqh_corps_definitions_s.nextval from sys.dual;
282: --

Line 371: ,p_rec in pqh_cpd_shd.g_rec_type

367: -- {End Of Comments}
368: -- ----------------------------------------------------------------------------
369: Procedure post_insert
370: (p_effective_date in date
371: ,p_rec in pqh_cpd_shd.g_rec_type
372: ) is
373: --
374: l_proc varchar2(72);
375: --

Line 517: ,p_rec in out nocopy pqh_cpd_shd.g_rec_type

513: -- |---------------------------------< ins >----------------------------------|
514: -- ----------------------------------------------------------------------------
515: Procedure ins
516: (p_effective_date in date
517: ,p_rec in out nocopy pqh_cpd_shd.g_rec_type
518: ) is
519: --
520: l_proc varchar2(72);
521: --

Line 623: l_rec pqh_cpd_shd.g_rec_type;

619: ,p_corps_definition_id out nocopy number
620: ,p_object_version_number out nocopy number
621: ) is
622: --
623: l_rec pqh_cpd_shd.g_rec_type;
624: l_proc varchar2(72);
625: --
626: Begin
627: g_debug := hr_utility.debug_enabled;

Line 637: pqh_cpd_shd.convert_args

633: -- Call conversion function to turn arguments into the
634: -- p_rec structure.
635: --
636: l_rec :=
637: pqh_cpd_shd.convert_args
638: (null
639: ,p_business_group_id
640: ,p_name
641: ,p_status_cd