APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CTARIFF_INTS

Line 1257: FROM igs_uc_ctariff_ints

1253: SELECT rowid,
1254: examlevel,
1255: examgrade,
1256: tariffscore
1257: FROM igs_uc_ctariff_ints
1258: WHERE record_status = 'N';
1259:
1260: -- check whether corresponding record already exists.
1261: CURSOR old_reftariff_cur (p_examlevel igs_uc_ctariff_ints.examlevel%TYPE,

Line 1261: CURSOR old_reftariff_cur (p_examlevel igs_uc_ctariff_ints.examlevel%TYPE,

1257: FROM igs_uc_ctariff_ints
1258: WHERE record_status = 'N';
1259:
1260: -- check whether corresponding record already exists.
1261: CURSOR old_reftariff_cur (p_examlevel igs_uc_ctariff_ints.examlevel%TYPE,
1262: p_examgrade igs_uc_ctariff_ints.examgrade%TYPE) IS
1263: SELECT rtrf.rowid,
1264: rtrf.*
1265: FROM igs_uc_ref_tariff rtrf

Line 1262: p_examgrade igs_uc_ctariff_ints.examgrade%TYPE) IS

1258: WHERE record_status = 'N';
1259:
1260: -- check whether corresponding record already exists.
1261: CURSOR old_reftariff_cur (p_examlevel igs_uc_ctariff_ints.examlevel%TYPE,
1262: p_examgrade igs_uc_ctariff_ints.examgrade%TYPE) IS
1263: SELECT rtrf.rowid,
1264: rtrf.*
1265: FROM igs_uc_ref_tariff rtrf
1266: WHERE rtrf.exam_level = p_examlevel

Line 1365: UPDATE igs_uc_ctariff_ints

1361:
1362: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1363: -- while processing the record.
1364: IF g_error_code IS NOT NULL THEN
1365: UPDATE igs_uc_ctariff_ints
1366: SET error_code = g_error_code
1367: WHERE rowid = new_reftariff_rec.rowid;
1368:
1369: -- log error message/meaning.

Line 1376: UPDATE igs_uc_ctariff_ints

1372: -- update error count
1373: g_error_rec_cnt := g_error_rec_cnt + 1;
1374:
1375: ELSE
1376: UPDATE igs_uc_ctariff_ints
1377: SET record_status = 'D',
1378: error_code = NULL
1379: WHERE rowid = new_reftariff_rec.rowid;
1380: