DBA Data[Home] [Help]

APPS.SSP_MAT_BUS dependencies on SSP_MAT_SHD

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

672: -- Check that the a
673: --date entered is within the MPP/APP periods
674: -- and if MA type, also check that it is 2 weeks after Birth Date
675: --
676: Procedure check_kit_days(p_rec in ssp_mat_shd.g_rec_type) is
677:
678: cursor c_get_ma_end_date is /* Bug 6003570 */
679: select max(date_end) end_date
680: from per_absence_attendances

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

751: --------------------------------------------------------------------------------
752: -- ----------------------------------------------------------------------------
753: -- |---------------------------< insert_validate >----------------------------|
754: -- ----------------------------------------------------------------------------
755: Procedure insert_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
756: --
757: l_proc varchar2(72) := g_package||'insert_validate';
758: l_earliest_mpp_start date;
759: --

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

813: --
814: -- ----------------------------------------------------------------------------
815: -- |---------------------------< update_validate >----------------------------|
816: -- ----------------------------------------------------------------------------
817: Procedure update_validate(p_rec in out nocopy ssp_mat_shd.g_rec_type) is
818: --
819: l_proc varchar2(72) := g_package||'update_validate';
820: l_earliest_mpp_start date;
821: --

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

865: --
866: -- ----------------------------------------------------------------------------
867: -- |---------------------------< delete_validate >----------------------------|
868: -- ----------------------------------------------------------------------------
869: Procedure delete_validate(p_rec in ssp_mat_shd.g_rec_type) is
870: --
871: l_proc varchar2(72) := g_package||'delete_validate';
872: --
873: Begin