APPS.IGS_UC_PROC_COM_INST_DATA dependencies on IGS_UC_CSCHCNT_INTS

Line 1260: FROM igs_uc_cschcnt_ints csci

1256: -- Get new interface records
1257: CURSOR int_cvschcnt_cur IS
1258: SELECT csci.rowid,
1259: csci.*
1260: FROM igs_uc_cschcnt_ints csci
1261: WHERE csci.record_status = 'N';
1262:
1263: -- check whether corresponding record already exists.
1264: CURSOR old_schsite_cnt_cur (p_school igs_uc_cschcnt_ints.school%TYPE,

Line 1264: CURSOR old_schsite_cnt_cur (p_school igs_uc_cschcnt_ints.school%TYPE,

1260: FROM igs_uc_cschcnt_ints csci
1261: WHERE csci.record_status = 'N';
1262:
1263: -- check whether corresponding record already exists.
1264: CURSOR old_schsite_cnt_cur (p_school igs_uc_cschcnt_ints.school%TYPE,
1265: p_site_code igs_uc_cschcnt_ints.sitecode%TYPE,
1266: p_contact_cd igs_uc_cschcnt_ints.contactcode%TYPE) IS
1267: SELECT csscn.rowid,
1268: csscn.*

Line 1265: p_site_code igs_uc_cschcnt_ints.sitecode%TYPE,

1261: WHERE csci.record_status = 'N';
1262:
1263: -- check whether corresponding record already exists.
1264: CURSOR old_schsite_cnt_cur (p_school igs_uc_cschcnt_ints.school%TYPE,
1265: p_site_code igs_uc_cschcnt_ints.sitecode%TYPE,
1266: p_contact_cd igs_uc_cschcnt_ints.contactcode%TYPE) IS
1267: SELECT csscn.rowid,
1268: csscn.*
1269: FROM igs_uc_com_scsicnts csscn

Line 1266: p_contact_cd igs_uc_cschcnt_ints.contactcode%TYPE) IS

1262:
1263: -- check whether corresponding record already exists.
1264: CURSOR old_schsite_cnt_cur (p_school igs_uc_cschcnt_ints.school%TYPE,
1265: p_site_code igs_uc_cschcnt_ints.sitecode%TYPE,
1266: p_contact_cd igs_uc_cschcnt_ints.contactcode%TYPE) IS
1267: SELECT csscn.rowid,
1268: csscn.*
1269: FROM igs_uc_com_scsicnts csscn
1270: WHERE csscn.school = p_school

Line 1275: CURSOR chk_school (p_school igs_uc_cschcnt_ints.school%TYPE) IS

1271: AND csscn.sitecode = p_site_code
1272: AND csscn.contact_code = p_contact_cd;
1273:
1274: -- validate school
1275: CURSOR chk_school (p_school igs_uc_cschcnt_ints.school%TYPE) IS
1276: SELECT 'X'
1277: FROM igs_uc_com_sch
1278: WHERE school = p_school;
1279:

Line 1281: CURSOR chk_schsite (p_school igs_uc_cschcnt_ints.school%TYPE, p_site_code igs_uc_cschcnt_ints.sitecode%TYPE) IS

1277: FROM igs_uc_com_sch
1278: WHERE school = p_school;
1279:
1280: -- validate school site details
1281: CURSOR chk_schsite (p_school igs_uc_cschcnt_ints.school%TYPE, p_site_code igs_uc_cschcnt_ints.sitecode%TYPE) IS
1282: SELECT 'X'
1283: FROM igs_uc_com_schsites
1284: WHERE school = p_school
1285: AND sitecode = p_site_code;

Line 1460: UPDATE igs_uc_cschcnt_ints

1456: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1457: -- while processing the record.
1458: IF g_error_code IS NOT NULL THEN
1459:
1460: UPDATE igs_uc_cschcnt_ints
1461: SET error_code = g_error_code
1462: WHERE rowid = new_schcntct_rec.rowid;
1463:
1464: -- log error message/meaning.

Line 1472: UPDATE igs_uc_cschcnt_ints

1468: g_error_rec_cnt := g_error_rec_cnt + 1;
1469:
1470: ELSE
1471:
1472: UPDATE igs_uc_cschcnt_ints
1473: SET record_status = 'D',
1474: error_code = NULL
1475: WHERE rowid = new_schcntct_rec.rowid;
1476: