DBA Data[Home] [Help]

APPS.SSP_MAT_BUS dependencies on SSP_MAT_SHD

Line 775: Procedure check_kit_days(p_rec in ssp_mat_shd.g_rec_type) is

771: -- Check that the a
772: --date entered is within the MPP/APP periods
773: -- and if MA type, also check that it is 2 weeks after Birth Date
774: --
775: Procedure check_kit_days(p_rec in ssp_mat_shd.g_rec_type) is
776:
777: cursor c_get_ma_end_date is /* Bug 6003570 */
778: select max(date_end) end_date
779: from per_absence_attendances

Line 854: Procedure insert_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is

850: --------------------------------------------------------------------------------
851: -- ----------------------------------------------------------------------------
852: -- |---------------------------< insert_validate >----------------------------|
853: -- ----------------------------------------------------------------------------
854: Procedure insert_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
855: --
856: l_proc varchar2(72) := g_package||'insert_validate';
857: l_earliest_mpp_start date;
858: --

Line 924: Procedure update_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is

920: --
921: -- ----------------------------------------------------------------------------
922: -- |---------------------------< update_validate >----------------------------|
923: -- ----------------------------------------------------------------------------
924: Procedure update_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
925: --
926: l_proc varchar2(72) := g_package||'update_validate';
927: l_earliest_mpp_start date;
928: --

Line 980: Procedure delete_validate(p_rec in ssp_mat_shd.g_rec_type) is

976: --
977: -- ----------------------------------------------------------------------------
978: -- |---------------------------< delete_validate >----------------------------|
979: -- ----------------------------------------------------------------------------
980: Procedure delete_validate(p_rec in ssp_mat_shd.g_rec_type) is
981: --
982: l_proc varchar2(72) := g_package||'delete_validate';
983: --
984: Begin