APPS.PQH_ACC_INS dependencies on PQH_ACC_SHD

Line 80: (p_rec in out nocopy pqh_acc_shd.g_rec_type

76: --
77: -- {End Of Comments}
78: -- ----------------------------------------------------------------------------
79: Procedure dt_insert_dml
80: (p_rec in out nocopy pqh_acc_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: pqh_acc_shd.g_old_rec.effective_start_date

90: t.creation_date
91: from pqh_accommodations_f t
92: where t.accommodation_id = p_rec.accommodation_id
93: and t.effective_start_date =
94: pqh_acc_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 pqh_accommodations_f.created_by%TYPE;

Line 366: pqh_acc_shd.constraint_error

362: Exception
363: When hr_api.check_integrity_violated Then
364: -- A check constraint has been violated
365: --
366: pqh_acc_shd.constraint_error
367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
370: --

Line 371: pqh_acc_shd.constraint_error

367: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
368: When hr_api.unique_integrity_violated Then
369: -- Unique integrity has been violated
370: --
371: pqh_acc_shd.constraint_error
372: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
373: When Others Then
374: --
375: Raise;

Line 382: (p_rec in out nocopy pqh_acc_shd.g_rec_type

378: -- ----------------------------------------------------------------------------
379: -- |------------------------------< insert_dml >------------------------------|
380: -- ----------------------------------------------------------------------------
381: Procedure insert_dml
382: (p_rec in out nocopy pqh_acc_shd.g_rec_type
383: ,p_effective_date in date
384: ,p_datetrack_mode in varchar2
385: ,p_validation_start_date in date
386: ,p_validation_end_date in date

Line 445: (p_rec in out nocopy pqh_acc_shd.g_rec_type

441: --
442: -- {End Of Comments}
443: -- ----------------------------------------------------------------------------
444: Procedure pre_insert
445: (p_rec in out nocopy pqh_acc_shd.g_rec_type
446: ,p_effective_date in date
447: ,p_datetrack_mode in varchar2
448: ,p_validation_start_date in date
449: ,p_validation_end_date in date

Line 537: (p_rec in pqh_acc_shd.g_rec_type

533: --
534: -- {End Of Comments}
535: -- ----------------------------------------------------------------------------
536: Procedure post_insert
537: (p_rec in pqh_acc_shd.g_rec_type
538: ,p_effective_date in date
539: ,p_datetrack_mode in varchar2
540: ,p_validation_start_date in date
541: ,p_validation_end_date in date

Line 799: ,p_rec in pqh_acc_shd.g_rec_type

795: -- ----------------------------------------------------------------------------
796: Procedure ins_lck
797: (p_effective_date in date
798: ,p_datetrack_mode in varchar2
799: ,p_rec in pqh_acc_shd.g_rec_type
800: ,p_validation_start_date out nocopy date
801: ,p_validation_end_date out nocopy date
802: ) is
803: --

Line 839: ,p_rec in out nocopy pqh_acc_shd.g_rec_type

835: -- |---------------------------------< ins >----------------------------------|
836: -- ----------------------------------------------------------------------------
837: Procedure ins
838: (p_effective_date in date
839: ,p_rec in out nocopy pqh_acc_shd.g_rec_type
840: ) is
841: --
842: l_proc varchar2(72) := g_package||'ins';
843: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 1010: l_rec pqh_acc_shd.g_rec_type;

1006: ,p_effective_start_date out nocopy date
1007: ,p_effective_end_date out nocopy date
1008: ) is
1009: --
1010: l_rec pqh_acc_shd.g_rec_type;
1011: l_proc varchar2(72) := g_package||'ins';
1012: --
1013: Begin
1014: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1020: pqh_acc_shd.convert_args

1016: -- Call conversion function to turn arguments into the
1017: -- p_rec structure.
1018: --
1019: l_rec :=
1020: pqh_acc_shd.convert_args
1021: (null
1022: ,p_accommodation_name
1023: ,null
1024: ,null