APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CRSUBJ_INTS

Line 1100: FROM igs_uc_crsubj_ints

1096: subjcode,
1097: subjtext,
1098: subjabbrev,
1099: ebl_subj
1100: FROM igs_uc_crsubj_ints
1101: WHERE record_status = 'N';
1102:
1103: -- check whether corresponding record already exists.
1104: CURSOR old_refsubj_cur (p_subject igs_uc_crsubj_ints.subjcode%TYPE) IS

Line 1104: CURSOR old_refsubj_cur (p_subject igs_uc_crsubj_ints.subjcode%TYPE) IS

1100: FROM igs_uc_crsubj_ints
1101: WHERE record_status = 'N';
1102:
1103: -- check whether corresponding record already exists.
1104: CURSOR old_refsubj_cur (p_subject igs_uc_crsubj_ints.subjcode%TYPE) IS
1105: SELECT rowid
1106: FROM igs_uc_ref_subj
1107: WHERE SUBJ_CODE = p_subject ;
1108:

Line 1206: UPDATE igs_uc_crsubj_ints

1202:
1203: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1204: -- while processing the record.
1205: IF g_error_code IS NOT NULL THEN
1206: UPDATE igs_uc_crsubj_ints
1207: SET error_code = g_error_code
1208: WHERE rowid = new_refsubj_rec.rowid;
1209:
1210: -- log error message/meaning.

Line 1216: UPDATE igs_uc_crsubj_ints

1212: -- update error count
1213: g_error_rec_cnt := g_error_rec_cnt + 1;
1214:
1215: ELSE
1216: UPDATE igs_uc_crsubj_ints
1217: SET record_status = 'D',
1218: error_code = NULL
1219: WHERE rowid = new_refsubj_rec.rowid;
1220: