APPS.IGS_UC_EXT_MARVIN dependencies on IGS_UC_CRSE_DETS

Line 324: || igs_uc_mv_uvofr_abv with igs_uc_crse_dets, igs_uc_crse_vac_ops and

320: || Entry Year and Entry month , Point of Entry, Sumary of Conditions
321: || and Comments in Offer elements, for bug# 2711416
322: || ayedubat 02-JUL-2003 Changed as part of Multiple Cycles Enhancement, 2669208
323: || Replaced the tables igs_uc_mv_uvcrs_vacm, igs_uc_mv_uvcrs_vop and
324: || igs_uc_mv_uvofr_abv with igs_uc_crse_dets, igs_uc_crse_vac_ops and
325: || igs_uc_ref_off_abrv to fecth the Transactions.
326: ||
327: || (reverse chronological order - newest change first)
328: */

Line 382: CURSOR cur_uv_crs_vac(cp_system_code igs_uc_crse_dets.system_code%TYPE) IS

378: FROM DUAL;
379: l_cur_get_mon cur_get_mon%ROWTYPE;
380:
381: -- Fetching Course Vacancy Records to be exported
382: CURSOR cur_uv_crs_vac(cp_system_code igs_uc_crse_dets.system_code%TYPE) IS
383: SELECT
384: crse.ROWID,
385: REPLACE(crse.ucas_program_code,'*',' ') course,
386: REPLACE(crse.ucas_campus, '*', ' ') campus,

Line 392: FROM igs_uc_crse_dets crse

388: crse.no_of_vacancy,
389: crse.score,
390: crse.rb_full,
391: crse.scot_vac
392: FROM igs_uc_crse_dets crse
393: WHERE crse.system_code = cp_system_code AND
394: crse.institute = p_current_inst_code AND
395: crse.sent_to_ucas = 'N' AND
396: NVL(crse.imported,'Y') = 'Y'

Line 405: FROM igs_uc_crse_dets crse

401: CURSOR upd_crs_vac_cur (cp_rowid VARCHAR2) IS
402: SELECT
403: crse.ROWID,
404: crse.*
405: FROM igs_uc_crse_dets crse
406: WHERE crse.ROWID = cp_rowid;
407:
408: -- Fetching Course Vacancy Option Records to be exported
409: CURSOR cur_uv_crs_vac_opt(cp_system_code igs_uc_crse_dets.system_code%TYPE,

Line 409: CURSOR cur_uv_crs_vac_opt(cp_system_code igs_uc_crse_dets.system_code%TYPE,

405: FROM igs_uc_crse_dets crse
406: WHERE crse.ROWID = cp_rowid;
407:
408: -- Fetching Course Vacancy Option Records to be exported
409: CURSOR cur_uv_crs_vac_opt(cp_system_code igs_uc_crse_dets.system_code%TYPE,
410: cp_course IGS_UC_MV_UVCRS_VOP.course%TYPE,
411: cp_campus IGS_UC_MV_UVCRS_VOP.campus%TYPE) IS
412: SELECT
413: crsevac.ROWID,

Line 969: igs_uc_crse_dets_pkg.update_row (

965:
966: -- Updating the Course Vacancy Record with sent_to_ucas as 'Y'
967: FOR upd_crs_vac_rec IN upd_crs_vac_cur(l_cur_uv_crs_vac.ROWID) LOOP
968:
969: igs_uc_crse_dets_pkg.update_row (
970: x_mode => 'R',
971: x_rowid => upd_crs_vac_rec.rowid,
972: x_ucas_program_code => upd_crs_vac_rec.ucas_program_code,
973: x_oss_program_code => upd_crs_vac_rec.oss_program_code,

Line 1124: CURSOR cur_uv_crs_vac_exist(cp_system_code IGS_UC_CRSE_DETS.system_code%TYPE,

1120: hold_flag = 'N' AND
1121: transaction_type NOT IN ('XA','XD');
1122:
1123: -- Cursor to find whether any couse vacancy transactiions exist to send to UCAS
1124: CURSOR cur_uv_crs_vac_exist(cp_system_code IGS_UC_CRSE_DETS.system_code%TYPE,
1125: cp_current_inst IGS_UC_CRSE_DETS.institute%TYPE)IS
1126: SELECT 'X'
1127: FROM igs_uc_crse_dets crse
1128: WHERE

Line 1125: cp_current_inst IGS_UC_CRSE_DETS.institute%TYPE)IS

1121: transaction_type NOT IN ('XA','XD');
1122:
1123: -- Cursor to find whether any couse vacancy transactiions exist to send to UCAS
1124: CURSOR cur_uv_crs_vac_exist(cp_system_code IGS_UC_CRSE_DETS.system_code%TYPE,
1125: cp_current_inst IGS_UC_CRSE_DETS.institute%TYPE)IS
1126: SELECT 'X'
1127: FROM igs_uc_crse_dets crse
1128: WHERE
1129: ((cp_system_code IS NOT NULL AND system_code = cp_system_code) OR

Line 1127: FROM igs_uc_crse_dets crse

1123: -- Cursor to find whether any couse vacancy transactiions exist to send to UCAS
1124: CURSOR cur_uv_crs_vac_exist(cp_system_code IGS_UC_CRSE_DETS.system_code%TYPE,
1125: cp_current_inst IGS_UC_CRSE_DETS.institute%TYPE)IS
1126: SELECT 'X'
1127: FROM igs_uc_crse_dets crse
1128: WHERE
1129: ((cp_system_code IS NOT NULL AND system_code = cp_system_code) OR
1130: (cp_system_code IS NULL AND system_code IN ('U','S'))) AND
1131: crse.institute = cp_current_inst AND