DBA Data[Home] [Help]

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: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id
743: , p_effective_date => p_validation_start_date
744: , p_action => 'INSERT'
745: , p_eff_start_date => p_rec.effective_start_date

Line 742: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id

738: );
739: End ;
740: --
741: --hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);
742: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id
743: , p_effective_date => p_validation_start_date
744: , p_action => 'INSERT'
745: , p_eff_start_date => p_rec.effective_start_date
746: , p_eff_end_date => p_rec.effective_end_date );

Line 793: p_rec in hr_psf_shd.g_rec_type,

789: -- ----------------------------------------------------------------------------
790: Procedure ins_lck
791: (p_effective_date in date,
792: p_datetrack_mode in varchar2,
793: p_rec in hr_psf_shd.g_rec_type,
794: p_validation_start_date out nocopy date,
795: p_validation_end_date out nocopy date) is
796: --
797: l_proc varchar2(72) ;

Line 870: p_rec in out nocopy hr_psf_shd.g_rec_type,

866: -- |---------------------------------< ins >----------------------------------|
867: -- ----------------------------------------------------------------------------
868: Procedure ins
869: (
870: p_rec in out nocopy hr_psf_shd.g_rec_type,
871: p_effective_date in date,
872: p_validate in boolean default false
873: ) is
874: --

Line 1117: l_rec hr_psf_shd.g_rec_type;

1113: p_validate in boolean default false,
1114: p_security_profile_id in number default hr_security.get_security_profile
1115: ) is
1116: --
1117: l_rec hr_psf_shd.g_rec_type;
1118: l_proc varchar2(72) ;
1119: --
1120: Begin
1121: g_debug := hr_utility.debug_enabled;

Line 1131: hr_psf_shd.convert_args

1127: -- Call conversion function to turn arguments into the
1128: -- p_rec structure.
1129: --
1130: l_rec :=
1131: hr_psf_shd.convert_args
1132: (
1133: null,
1134: null,
1135: null,