APPS.PQP_VAL_INS dependencies on PQP_VAL_SHD

Line 80: (p_rec in out nocopy pqp_val_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pqp_val_shd.g_rec_type
81: ,p_effective_date in date
82: ,p_datetrack_mode in varchar2
83: ,p_validation_start_date in date
84: ,p_validation_end_date in date

Line 94: pqp_val_shd.g_old_rec.effective_start_date

90: t.creation_date
91: FROM pqp_vehicle_allocations_f t
92: WHERE t.vehicle_allocation_id = p_rec.vehicle_allocation_id
93: AND t.effective_start_date =
94: pqp_val_shd.g_old_rec.effective_start_date
95: AND t.effective_end_date = (p_validation_start_date - 1);
96: --
97: l_proc varchar2(72) := g_package||'dt_insert_dml';
98: l_created_by pqp_vehicle_allocations_f.created_by%TYPE;

Line 306: pqp_val_shd.constraint_error

302: Exception
303: When hr_api.check_integrity_violated Then
304: -- A check constraint has been violated
305: --
306: pqp_val_shd.constraint_error
307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308: When hr_api.unique_integrity_violated Then
309: -- Unique integrity has been violated
310: --

Line 311: pqp_val_shd.constraint_error

307: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
308: When hr_api.unique_integrity_violated Then
309: -- Unique integrity has been violated
310: --
311: pqp_val_shd.constraint_error
312: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
313: When Others Then
314: --
315: Raise;

Line 322: (p_rec in out nocopy pqp_val_shd.g_rec_type

318: -- ----------------------------------------------------------------------------
319: -- |------------------------------< insert_dml >------------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure insert_dml
322: (p_rec in out nocopy pqp_val_shd.g_rec_type
323: ,p_effective_date in date
324: ,p_datetrack_mode in varchar2
325: ,p_validation_start_date in date
326: ,p_validation_end_date in date

Line 385: (p_rec in out nocopy pqp_val_shd.g_rec_type

381: --
382: -- {End Of Comments}
383: -- ----------------------------------------------------------------------------
384: Procedure pre_insert
385: (p_rec in out nocopy pqp_val_shd.g_rec_type
386: ,p_effective_date in date
387: ,p_datetrack_mode in varchar2
388: ,p_validation_start_date in date
389: ,p_validation_end_date in date

Line 477: (p_rec in pqp_val_shd.g_rec_type

473: --
474: -- {End Of Comments}
475: -- ----------------------------------------------------------------------------
476: Procedure post_insert
477: (p_rec in pqp_val_shd.g_rec_type
478: ,p_effective_date in date
479: ,p_datetrack_mode in varchar2
480: ,p_validation_start_date in date
481: ,p_validation_end_date in date

Line 679: ,p_rec in pqp_val_shd.g_rec_type

675: -- ----------------------------------------------------------------------------
676: Procedure ins_lck
677: (p_effective_date in date
678: ,p_datetrack_mode in varchar2
679: ,p_rec in pqp_val_shd.g_rec_type
680: ,p_validation_start_date out nocopy date
681: ,p_validation_end_date out nocopy date
682: ) is
683: --

Line 725: ,p_rec in out nocopy pqp_val_shd.g_rec_type

721: -- |---------------------------------< ins >----------------------------------|
722: -- ----------------------------------------------------------------------------
723: Procedure ins
724: (p_effective_date in date
725: ,p_rec in out nocopy pqp_val_shd.g_rec_type
726: ) is
727: --
728: l_proc varchar2(72) := g_package||'ins';
729: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 866: l_rec pqp_val_shd.g_rec_type;

862: ,p_effective_start_date out nocopy date
863: ,p_effective_end_date out nocopy date
864: ) is
865: --
866: l_rec pqp_val_shd.g_rec_type;
867: l_proc varchar2(72) := g_package||'ins';
868: --
869: Begin
870: hr_utility.set_location('Entering:'||l_proc, 5);

Line 876: pqp_val_shd.convert_args

872: -- Call conversion function to turn arguments into the
873: -- p_rec structure.
874: --
875: l_rec :=
876: pqp_val_shd.convert_args
877: (null
878: ,null
879: ,null
880: ,p_assignment_id