92: FND_MSG_PUB.ADD;
93: RAISE FND_API.G_EXC_ERROR;
94: END IF;
95:
96: IF NOT igs_en_su_Attempt_pkg.get_pk_for_validation(x_person_id => new_references.person_id ,
97: x_course_cd => new_references.course_cd,
98: x_uoo_id => new_references.uoo_id)
99: THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
810: CLOSE cur_rowid;
811:
812: END get_fk_igs_as_usec_sessns;
813:
814: PROCEDURE get_fk_igs_en_su_Attempt(
815: x_person_id igs_en_su_attempt.person_id%TYPE,
816: x_course_cd igs_en_su_attempt.course_cd%TYPE,
817: x_uoo_id igs_en_su_attempt.uoo_id%TYPE
818: )
811:
812: END get_fk_igs_as_usec_sessns;
813:
814: PROCEDURE get_fk_igs_en_su_Attempt(
815: x_person_id igs_en_su_attempt.person_id%TYPE,
816: x_course_cd igs_en_su_attempt.course_cd%TYPE,
817: x_uoo_id igs_en_su_attempt.uoo_id%TYPE
818: )
819: AS
812: END get_fk_igs_as_usec_sessns;
813:
814: PROCEDURE get_fk_igs_en_su_Attempt(
815: x_person_id igs_en_su_attempt.person_id%TYPE,
816: x_course_cd igs_en_su_attempt.course_cd%TYPE,
817: x_uoo_id igs_en_su_attempt.uoo_id%TYPE
818: )
819: AS
820: /*
813:
814: PROCEDURE get_fk_igs_en_su_Attempt(
815: x_person_id igs_en_su_attempt.person_id%TYPE,
816: x_course_cd igs_en_su_attempt.course_cd%TYPE,
817: x_uoo_id igs_en_su_attempt.uoo_id%TYPE
818: )
819: AS
820: /*
821: || Created By : manu.srinivasan
847: RETURN;
848: END IF;
849: CLOSE cur_rowid;
850:
851: END get_fk_igs_en_su_Attempt;
852:
853: END igs_as_sua_ses_atts_pkg;