APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_REF_AWRDBDY

Line 743: of parent records in igs_uc_ref_awrdbdy.

739: Known limitations,enhancements,remarks:
740: Change History
741: Who When What
742: dsridhar 06-JUL-2003 Bug No:3083850. Validation added to check the existance
743: of parent records in igs_uc_ref_awrdbdy.
744: ******************************************************************/
745: l_rowid VARCHAR2(26) ;
746:
747: -- Get new interface records

Line 761: -- check for existance of a record in igs_uc_ref_awrdbdy

757: ces.*
758: FROM igs_uc_com_ebl_subj ces
759: WHERE ces.subject_id = p_sub_id ;
760:
761: -- check for existance of a record in igs_uc_ref_awrdbdy
762: CURSOR chk_awd_body (p_year igs_uc_ref_awrdbdy.year%TYPE,
763: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
764: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
765: SELECT 'X'

Line 762: CURSOR chk_awd_body (p_year igs_uc_ref_awrdbdy.year%TYPE,

758: FROM igs_uc_com_ebl_subj ces
759: WHERE ces.subject_id = p_sub_id ;
760:
761: -- check for existance of a record in igs_uc_ref_awrdbdy
762: CURSOR chk_awd_body (p_year igs_uc_ref_awrdbdy.year%TYPE,
763: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
764: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
765: SELECT 'X'
766: FROM igs_uc_ref_awrdbdy

Line 763: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,

759: WHERE ces.subject_id = p_sub_id ;
760:
761: -- check for existance of a record in igs_uc_ref_awrdbdy
762: CURSOR chk_awd_body (p_year igs_uc_ref_awrdbdy.year%TYPE,
763: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
764: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
765: SELECT 'X'
766: FROM igs_uc_ref_awrdbdy
767: WHERE year = p_year AND

Line 764: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS

760:
761: -- check for existance of a record in igs_uc_ref_awrdbdy
762: CURSOR chk_awd_body (p_year igs_uc_ref_awrdbdy.year%TYPE,
763: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
764: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
765: SELECT 'X'
766: FROM igs_uc_ref_awrdbdy
767: WHERE year = p_year AND
768: sitting = p_sitting AND

Line 766: FROM igs_uc_ref_awrdbdy

762: CURSOR chk_awd_body (p_year igs_uc_ref_awrdbdy.year%TYPE,
763: p_sitting igs_uc_ref_awrdbdy.sitting%TYPE,
764: p_awd_body igs_uc_ref_awrdbdy.awarding_body%TYPE) IS
765: SELECT 'X'
766: FROM igs_uc_ref_awrdbdy
767: WHERE year = p_year AND
768: sitting = p_sitting AND
769: awarding_body = p_awd_body;
770:

Line 809: -- validate for a record in igs_uc_ref_awrdbdy

805:
806: g_error_code := '1037';
807: END IF;
808:
809: -- validate for a record in igs_uc_ref_awrdbdy
810: IF g_error_code IS NULL THEN
811:
812: OPEN chk_awd_body (new_eblsubj_rec.year, new_eblsubj_rec.sitting, new_eblsubj_rec.awardingbody);
813: FETCH chk_awd_body INTO l_awd_body_flag;