APPS.HR_PSF_INS dependencies on HR_PSF_SHD

Line 79: (p_rec in out nocopy hr_psf_shd.g_rec_type,

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

Line 93: hr_psf_shd.g_old_rec.effective_start_date

89: t.creation_date
90: from hr_all_positions_f t
91: where t.position_id = p_rec.position_id
92: and t.effective_start_date =
93: hr_psf_shd.g_old_rec.effective_start_date
94: and t.effective_end_date = (p_validation_start_date - 1);
95: --
96: l_proc varchar2(72) ;
97: l_created_by hr_all_positions_f.created_by%TYPE;

Line 442: hr_psf_shd.constraint_error

438: --
439: Exception
440: When hr_api.check_integrity_violated Then
441: -- A check constraint has been violated
442: hr_psf_shd.constraint_error
443: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
444: When hr_api.unique_integrity_violated Then
445: -- Unique integrity has been violated
446: hr_psf_shd.constraint_error

Line 446: hr_psf_shd.constraint_error

442: hr_psf_shd.constraint_error
443: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
444: When hr_api.unique_integrity_violated Then
445: -- Unique integrity has been violated
446: hr_psf_shd.constraint_error
447: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
448: When Others Then
449: Raise;
450: End dt_insert_dml;

Line 456: (p_rec in out nocopy hr_psf_shd.g_rec_type,

452: -- ----------------------------------------------------------------------------
453: -- |------------------------------< insert_dml >------------------------------|
454: -- ----------------------------------------------------------------------------
455: Procedure insert_dml
456: (p_rec in out nocopy hr_psf_shd.g_rec_type,
457: p_effective_date in date,
458: p_datetrack_mode in varchar2,
459: p_validation_start_date in date,
460: p_validation_end_date in date) is

Line 522: (p_rec in out nocopy hr_psf_shd.g_rec_type,

518: --
519: -- {End Of Comments}
520: -- ----------------------------------------------------------------------------
521: Procedure pre_insert
522: (p_rec in out nocopy hr_psf_shd.g_rec_type,
523: p_effective_date in date,
524: p_datetrack_mode in varchar2,
525: p_validation_start_date in date,
526: p_validation_end_date in date) is

Line 585: (p_rec in hr_psf_shd.g_rec_type,

581: --
582: -- {End Of Comments}
583: -- ----------------------------------------------------------------------------
584: Procedure post_insert
585: (p_rec in hr_psf_shd.g_rec_type,
586: p_effective_date in date,
587: p_datetrack_mode in varchar2,
588: p_validation_start_date in date,
589: p_validation_end_date in date) is

Line 741: hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);

737: ,p_hook_type => 'AI'
738: );
739: End ;
740: --
741: hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);
742: --
743: if g_debug then
744: hr_utility.set_location(' Leaving:'||l_proc, 10);
745: end if;

Line 788: p_rec in hr_psf_shd.g_rec_type,

784: -- ----------------------------------------------------------------------------
785: Procedure ins_lck
786: (p_effective_date in date,
787: p_datetrack_mode in varchar2,
788: p_rec in hr_psf_shd.g_rec_type,
789: p_validation_start_date out nocopy date,
790: p_validation_end_date out nocopy date) is
791: --
792: l_proc varchar2(72) ;

Line 865: p_rec in out nocopy hr_psf_shd.g_rec_type,

861: -- |---------------------------------< ins >----------------------------------|
862: -- ----------------------------------------------------------------------------
863: Procedure ins
864: (
865: p_rec in out nocopy hr_psf_shd.g_rec_type,
866: p_effective_date in date,
867: p_validate in boolean default false
868: ) is
869: --

Line 1112: l_rec hr_psf_shd.g_rec_type;

1108: p_validate in boolean default false,
1109: p_security_profile_id in number default hr_security.get_security_profile
1110: ) is
1111: --
1112: l_rec hr_psf_shd.g_rec_type;
1113: l_proc varchar2(72) ;
1114: --
1115: Begin
1116: g_debug := hr_utility.debug_enabled;

Line 1126: hr_psf_shd.convert_args

1122: -- Call conversion function to turn arguments into the
1123: -- p_rec structure.
1124: --
1125: l_rec :=
1126: hr_psf_shd.convert_args
1127: (
1128: null,
1129: null,
1130: null,