APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_CEBLSBJ_INTS

Line 751: FROM igs_uc_ceblsbj_ints cves

747: -- Get new interface records
748: CURSOR int_cveblsubj_cur IS
749: SELECT cves.rowid,
750: cves.*
751: FROM igs_uc_ceblsbj_ints cves
752: WHERE cves.record_status = 'N';
753:
754: -- check whether corresponding record already exists.
755: CURSOR old_eblsubj_cur (p_sub_id igs_uc_ceblsbj_ints.subjectid%TYPE) IS

Line 755: CURSOR old_eblsubj_cur (p_sub_id igs_uc_ceblsbj_ints.subjectid%TYPE) IS

751: FROM igs_uc_ceblsbj_ints cves
752: WHERE cves.record_status = 'N';
753:
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 ;

Line 903: UPDATE igs_uc_ceblsbj_ints

899: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
900: -- while processing the record.
901: IF g_error_code IS NOT NULL THEN
902:
903: UPDATE igs_uc_ceblsbj_ints
904: SET error_code = g_error_code
905: WHERE rowid = new_eblsubj_rec.rowid;
906:
907: -- log error message/meaning.

Line 915: UPDATE igs_uc_ceblsbj_ints

911: g_error_rec_cnt := g_error_rec_cnt + 1;
912:
913: ELSE
914:
915: UPDATE igs_uc_ceblsbj_ints
916: SET record_status = 'D',
917: error_code = NULL
918: WHERE rowid = new_eblsubj_rec.rowid;
919: