APPS.IGS_EN_SPA_LGCY_PUB dependencies on IGS_RE_CANDIDATURE_PKG

Line 448: igs_re_candidature_pkg.check_constraints(column_name => 'ATTENDANCE_PERCENTAGE',

444: END IF;
445:
446: IF p_sca_re_rec.re_attendance_percentage IS NOT NULL THEN
447: BEGIN
448: igs_re_candidature_pkg.check_constraints(column_name => 'ATTENDANCE_PERCENTAGE',
449: column_value => igs_ge_number.to_cann(p_sca_re_rec.re_attendance_percentage));
450: EXCEPTION
451: WHEN OTHERS THEN
452: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 462: igs_re_candidature_pkg.check_constraints(column_name => 'GOVT_TYPE_OF_ACTIVITY_CD',

458: END IF;
459:
460: IF p_sca_re_rec.re_govt_type_of_activity_cd IS NOT NULL THEN
461: BEGIN
462: igs_re_candidature_pkg.check_constraints(column_name => 'GOVT_TYPE_OF_ACTIVITY_CD',
463: column_value => p_sca_re_rec.re_govt_type_of_activity_cd);
464: EXCEPTION
465: WHEN OTHERS THEN
466: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 751: igs_re_candidature_pkg.get_fk_igs_en_stdnt_ps_att(x_person_id =>p_person_id,

747: l_result_flag := 'S';
748: --Check whether research candidature record is already exist in the database or not.
749: --If exist set the warning message and terminate the function
750: BEGIN
751: igs_re_candidature_pkg.get_fk_igs_en_stdnt_ps_att(x_person_id =>p_person_id,
752: x_course_cd =>p_sca_re_rec.program_cd);
753: EXCEPTION
754: WHEN OTHERS THEN
755: l_count :=FND_MSG_PUB.COUNT_MSG;