APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_COM_EBL_SUBJ

Line 758: FROM igs_uc_com_ebl_subj ces

754: -- check whether corresponding record already exists.
755: CURSOR old_eblsubj_cur (p_sub_id igs_uc_ceblsbj_ints.subjectid%TYPE) IS
756: SELECT ces.rowid,
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,

Line 835: igs_uc_com_ebl_subj_pkg.insert_row -- IGSXI08B.pls

831: IF old_eblsubj_rec.rowid IS NULL THEN
832:
833: BEGIN
834: -- insert a new record in the main table
835: igs_uc_com_ebl_subj_pkg.insert_row -- IGSXI08B.pls
836: (
837: x_rowid => old_eblsubj_rec.rowid
838: ,x_subject_id => new_eblsubj_rec.subjectid
839: ,x_year => new_eblsubj_rec.year

Line 860: igs_uc_com_ebl_subj_pkg.update_row -- IGSXI08B.pls

856: ELSE -- update
857:
858: BEGIN
859: -- update a new record in the main table
860: igs_uc_com_ebl_subj_pkg.update_row -- IGSXI08B.pls
861: (
862: x_rowid => old_eblsubj_rec.rowid
863: ,x_subject_id => old_eblsubj_rec.subject_id
864: ,x_year => new_eblsubj_rec.year