APPS.PQH_ASA_INS dependencies on PQH_ASA_SHD

Line 80: (p_rec in out nocopy pqh_asa_shd.g_rec_type

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

90: t.creation_date
91: from pqh_assign_accommodations_f t
92: where t.assignment_acco_id = p_rec.assignment_acco_id
93: and t.effective_start_date =
94: pqh_asa_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_assign_accommodations_f.created_by%TYPE;

Line 338: pqh_asa_shd.constraint_error

334: Exception
335: When hr_api.check_integrity_violated Then
336: -- A check constraint has been violated
337: --
338: pqh_asa_shd.constraint_error
339: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
340: When hr_api.unique_integrity_violated Then
341: -- Unique integrity has been violated
342: --

Line 343: pqh_asa_shd.constraint_error

339: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
340: When hr_api.unique_integrity_violated Then
341: -- Unique integrity has been violated
342: --
343: pqh_asa_shd.constraint_error
344: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
345: When Others Then
346: --
347: Raise;

Line 354: (p_rec in out nocopy pqh_asa_shd.g_rec_type

350: -- ----------------------------------------------------------------------------
351: -- |------------------------------< insert_dml >------------------------------|
352: -- ----------------------------------------------------------------------------
353: Procedure insert_dml
354: (p_rec in out nocopy pqh_asa_shd.g_rec_type
355: ,p_effective_date in date
356: ,p_datetrack_mode in varchar2
357: ,p_validation_start_date in date
358: ,p_validation_end_date in date

Line 417: (p_rec in out nocopy pqh_asa_shd.g_rec_type

413: --
414: -- {End Of Comments}
415: -- ----------------------------------------------------------------------------
416: Procedure pre_insert
417: (p_rec in out nocopy pqh_asa_shd.g_rec_type
418: ,p_effective_date in date
419: ,p_datetrack_mode in varchar2
420: ,p_validation_start_date in date
421: ,p_validation_end_date in date

Line 509: (p_rec in pqh_asa_shd.g_rec_type

505: --
506: -- {End Of Comments}
507: -- ----------------------------------------------------------------------------
508: Procedure post_insert
509: (p_rec in pqh_asa_shd.g_rec_type
510: ,p_effective_date in date
511: ,p_datetrack_mode in varchar2
512: ,p_validation_start_date in date
513: ,p_validation_end_date in date

Line 743: ,p_rec in pqh_asa_shd.g_rec_type

739: -- ----------------------------------------------------------------------------
740: Procedure ins_lck
741: (p_effective_date in date
742: ,p_datetrack_mode in varchar2
743: ,p_rec in pqh_asa_shd.g_rec_type
744: ,p_validation_start_date out nocopy date
745: ,p_validation_end_date out nocopy date
746: ) is
747: --

Line 786: ,p_rec in out nocopy pqh_asa_shd.g_rec_type

782: -- |---------------------------------< ins >----------------------------------|
783: -- ----------------------------------------------------------------------------
784: Procedure ins
785: (p_effective_date in date
786: ,p_rec in out nocopy pqh_asa_shd.g_rec_type
787: ) is
788: --
789: l_proc varchar2(72) := g_package||'ins';
790: l_datetrack_mode varchar2(30) := hr_api.g_insert;

Line 943: l_rec pqh_asa_shd.g_rec_type;

939: ,p_effective_start_date out nocopy date
940: ,p_effective_end_date out nocopy date
941: ) is
942: --
943: l_rec pqh_asa_shd.g_rec_type;
944: l_proc varchar2(72) := g_package||'ins';
945: --
946: Begin
947: hr_utility.set_location('Entering:'||l_proc, 5);

Line 953: pqh_asa_shd.convert_args

949: -- Call conversion function to turn arguments into the
950: -- p_rec structure.
951: --
952: l_rec :=
953: pqh_asa_shd.convert_args
954: (null
955: ,null
956: ,null
957: ,p_business_group_id