APPS.IGS_UC_EXT_MARVIN dependencies on IGS_UC_CRSE_VAC_OPS

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 417: FROM igs_uc_crse_vac_ops crsevac

413: crsevac.ROWID,
414: REPLACE(crsevac.ucas_program_code, '*', ' ') course,
415: REPLACE(crsevac.ucas_campus, '*', ' ') campus,
416: REPLACE(crsevac.option_code, '*', ' ') option_code
417: FROM igs_uc_crse_vac_ops crsevac
418: WHERE crsevac.system_code = cp_system_code AND
419: REPLACE(crsevac.ucas_program_code,'*',' ') = cp_course AND
420: REPLACE(crsevac.ucas_campus, '*', ' ') = cp_campus AND
421: crsevac.institute = p_current_inst_code AND

Line 431: FROM igs_uc_crse_vac_ops crsevac

427: CURSOR upd_crs_vac_opt_cur (cp_rowid VARCHAR2) IS
428: SELECT
429: crsevac.ROWID,
430: crsevac.*
431: FROM igs_uc_crse_vac_ops crsevac
432: WHERE crsevac.ROWID = cp_rowid;
433:
434: -- Fetching Offer Abbreviations records to deleted and to be exported
435: CURSOR cur_uv_offr_abb IS

Line 903: igs_uc_crse_vac_ops_pkg.update_row (

899:
900: -- Updating the Course Vacancy Option Record with sent_to_ucas as 'Y'
901: FOR upd_crs_vac_opt_rec IN upd_crs_vac_opt_cur(l_cur_uv_crs_vac_opt.rowid) LOOP
902:
903: igs_uc_crse_vac_ops_pkg.update_row (
904: x_mode => 'R',
905: x_rowid => upd_crs_vac_opt_rec.rowid,
906: x_ucas_program_code => upd_crs_vac_opt_rec.ucas_program_code,
907: x_institute => upd_crs_vac_opt_rec.institute,