DBA Data[Home] [Help]

APPS.PQP_PCV_INS dependencies on PQP_PCV_SHD

Line 124: (p_rec in out nocopy pqp_pcv_shd.g_rec_type

120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure insert_dml
124: (p_rec in out nocopy pqp_pcv_shd.g_rec_type
125: ) is
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --

Line 243: pqp_pcv_shd.constraint_error

239: Exception
240: When hr_api.check_integrity_violated Then
241: -- A check constraint has been violated
242: --
243: pqp_pcv_shd.constraint_error
244: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
245: When hr_api.parent_integrity_violated Then
246: -- Parent integrity has been violated
247: --

Line 248: pqp_pcv_shd.constraint_error

244: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
245: When hr_api.parent_integrity_violated Then
246: -- Parent integrity has been violated
247: --
248: pqp_pcv_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.unique_integrity_violated Then
251: -- Unique integrity has been violated
252: --

Line 253: pqp_pcv_shd.constraint_error

249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.unique_integrity_violated Then
251: -- Unique integrity has been violated
252: --
253: pqp_pcv_shd.constraint_error
254: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255: When Others Then
256: --
257: Raise;

Line 298: (p_rec in out nocopy pqp_pcv_shd.g_rec_type

294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure pre_insert
298: (p_rec in out nocopy pqp_pcv_shd.g_rec_type
299: ) is
300: --
301: Cursor C_Sel1 is select pqp_configuration_values_s.nextval from sys.dual;
302: --

Line 386: ,p_rec in pqp_pcv_shd.g_rec_type

382: -- {End Of Comments}
383: -- ----------------------------------------------------------------------------
384: Procedure post_insert
385: (p_effective_date in date
386: ,p_rec in pqp_pcv_shd.g_rec_type
387: ) is
388: --
389: l_proc varchar2(72) := g_package||'post_insert';
390: --

Line 517: ,p_rec in out nocopy pqp_pcv_shd.g_rec_type

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

Line 610: l_rec pqp_pcv_shd.g_rec_type;

606: ,p_object_version_number out nocopy number
607: ,p_configuration_name in varchar2
608: ) is
609: --
610: l_rec pqp_pcv_shd.g_rec_type;
611: l_proc varchar2(72) := g_package||'ins';
612: --
613: Begin
614: hr_utility.set_location('Entering:'||l_proc, 5);

Line 620: pqp_pcv_shd.convert_args

616: -- Call conversion function to turn arguments into the
617: -- p_rec structure.
618: --
619: l_rec :=
620: pqp_pcv_shd.convert_args
621: (null
622: ,p_business_group_id
623: ,p_legislation_code
624: ,p_pcv_attribute_category