APPS.PQP_VRE_INS dependencies on PQP_VRE_SHD

Line 80: (p_rec IN out nocopy pqp_vre_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: PROCEDURE dt_insert_dml
80: (p_rec IN out nocopy pqp_vre_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_vre_shd.g_old_rec.effective_start_date

90: t.creation_date
91: FROM pqp_vehicle_repository_f t
92: WHERE t.vehicle_repository_id = p_rec.vehicle_repository_id
93: AND t.effective_start_date =
94: pqp_vre_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_repository_f.created_by%TYPE;

Line 342: pqp_vre_shd.constraint_error

338: EXCEPTION
339: WHEN hr_api.check_integrity_violated THEN
340: -- A check constraint has been violated
341: --
342: pqp_vre_shd.constraint_error
343: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
344: WHEN hr_api.unique_integrity_violated THEN
345: -- Unique integrity has been violated
346: --

Line 347: pqp_vre_shd.constraint_error

343: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
344: WHEN hr_api.unique_integrity_violated THEN
345: -- Unique integrity has been violated
346: --
347: pqp_vre_shd.constraint_error
348: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
349: WHEN OTHERS THEN
350: --
351: RAISE;

Line 358: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

354: -- ----------------------------------------------------------------------------
355: -- |------------------------------< insert_dml >------------------------------|
356: -- ----------------------------------------------------------------------------
357: PROCEDURE insert_dml
358: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
359: ,p_effective_date IN DATE
360: ,p_datetrack_mode IN VARCHAR2
361: ,p_validation_start_date IN DATE
362: ,p_validation_end_date IN DATE

Line 421: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

417: --
418: -- {End Of Comments}
419: -- ----------------------------------------------------------------------------
420: PROCEDURE pre_insert
421: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
422: ,p_effective_date IN DATE
423: ,p_datetrack_mode IN VARCHAR2
424: ,p_validation_start_date IN DATE
425: ,p_validation_end_date IN DATE

Line 513: (p_rec IN pqp_vre_shd.g_rec_type

509: --
510: -- {End Of Comments}
511: -- ----------------------------------------------------------------------------
512: PROCEDURE post_insert
513: (p_rec IN pqp_vre_shd.g_rec_type
514: ,p_effective_date IN DATE
515: ,p_datetrack_mode IN VARCHAR2
516: ,p_validation_start_date IN DATE
517: ,p_validation_end_date IN DATE

Line 666: ,p_rec IN pqp_vre_shd.g_rec_type

662: -- ----------------------------------------------------------------------------
663: PROCEDURE ins_lck
664: (p_effective_date IN DATE
665: ,p_datetrack_mode IN VARCHAR2
666: ,p_rec IN pqp_vre_shd.g_rec_type
667: ,p_validation_start_date OUT NOCOPY DATE
668: ,p_validation_end_date OUT NOCOPY DATE
669: ) IS
670: --

Line 706: ,p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

702: -- |---------------------------------< ins >----------------------------------|
703: -- ----------------------------------------------------------------------------
704: PROCEDURE ins
705: (p_effective_date IN DATE
706: ,p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
707: ) IS
708: --
709: l_proc varchar2(72) := g_package||'ins';
710: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 865: l_rec pqp_vre_shd.g_rec_type;

861: ,p_effective_start_date OUT NOCOPY DATE
862: ,p_effective_end_date OUT NOCOPY DATE
863: ) IS
864: --
865: l_rec pqp_vre_shd.g_rec_type;
866: l_proc VARCHAR2(72) := g_package||'ins';
867: --
868: BEGIN
869: hr_utility.set_location('Entering:'||l_proc, 5);

Line 875: pqp_vre_shd.convert_args

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