APPS.IGS_AS_SUA_SES_ATTS_PKG dependencies on IGS_AS_USEC_SESSNS

Line 87: IF NOT igs_as_usec_sessns_pkg.get_pk_for_validation (

83: || (reverse chronological order - newest change first)
84: */
85: BEGIN
86:
87: IF NOT igs_as_usec_sessns_pkg.get_pk_for_validation (
88: x_session_name => new_references.session_name,
89: x_uoo_id => new_references.uoo_id
90: ) THEN
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

Line 778: PROCEDURE get_fk_igs_as_usec_sessns(

774: RETURN;
775:
776: END delete_row;
777:
778: PROCEDURE get_fk_igs_as_usec_sessns(
779: x_session_name igs_as_usec_sessns.session_name%TYPE,
780: x_uoo_id igs_as_usec_sessns.uoo_id%TYPE
781: )
782: AS

Line 779: x_session_name igs_as_usec_sessns.session_name%TYPE,

775:
776: END delete_row;
777:
778: PROCEDURE get_fk_igs_as_usec_sessns(
779: x_session_name igs_as_usec_sessns.session_name%TYPE,
780: x_uoo_id igs_as_usec_sessns.uoo_id%TYPE
781: )
782: AS
783: /*

Line 780: x_uoo_id igs_as_usec_sessns.uoo_id%TYPE

776: END delete_row;
777:
778: PROCEDURE get_fk_igs_as_usec_sessns(
779: x_session_name igs_as_usec_sessns.session_name%TYPE,
780: x_uoo_id igs_as_usec_sessns.uoo_id%TYPE
781: )
782: AS
783: /*
784: || Created By : manu.srinivasan

Line 812: END get_fk_igs_as_usec_sessns;

808: RETURN;
809: END IF;
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,