APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_CVSCH_INTS

Line 955: FROM igs_uc_cvsch_ints cvs

951: -- Get new interface records
952: CURSOR int_cvschool_cur IS
953: SELECT cvs.rowid,
954: cvs.*
955: FROM igs_uc_cvsch_ints cvs
956: WHERE cvs.record_status = 'N';
957:
958: -- check whether corresponding record already exists.
959: CURSOR old_school_cur (p_school_id igs_uc_cvsch_ints.school%TYPE) IS

Line 959: CURSOR old_school_cur (p_school_id igs_uc_cvsch_ints.school%TYPE) IS

955: FROM igs_uc_cvsch_ints cvs
956: WHERE cvs.record_status = 'N';
957:
958: -- check whether corresponding record already exists.
959: CURSOR old_school_cur (p_school_id igs_uc_cvsch_ints.school%TYPE) IS
960: SELECT csh.rowid,
961: csh.*
962: FROM igs_uc_com_sch csh
963: WHERE csh.school = p_school_id ;

Line 967: CURSOR chk_sch_type (p_sch_type igs_uc_cvsch_ints.schooltype%TYPE) IS

963: WHERE csh.school = p_school_id ;
964:
965:
966: -- check for school type in Lookups
967: CURSOR chk_sch_type (p_sch_type igs_uc_cvsch_ints.schooltype%TYPE) IS
968: SELECT 'X'
969: FROM igs_uc_ref_codes
970: WHERE code_type = 'ST'
971: AND code = p_sch_type;

Line 1210: UPDATE igs_uc_cvsch_ints

1206: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1207: -- while processing the record.
1208: IF g_error_code IS NOT NULL THEN
1209:
1210: UPDATE igs_uc_cvsch_ints
1211: SET error_code = g_error_code
1212: WHERE rowid = new_school_rec.rowid;
1213:
1214: -- log error message/meaning.

Line 1222: UPDATE igs_uc_cvsch_ints

1218: g_error_rec_cnt := g_error_rec_cnt + 1;
1219:
1220: ELSE
1221:
1222: UPDATE igs_uc_cvsch_ints
1223: SET record_status = 'D',
1224: error_code = NULL
1225: WHERE rowid = new_school_rec.rowid;
1226: