DBA Data[Home] [Help]

APPS.IGS_UC_EXT_MARVIN dependencies on IGS_UC_MV_UVCRS_VOP

Line 323: || Replaced the tables igs_uc_mv_uvcrs_vacm, igs_uc_mv_uvcrs_vop and

319: || ayedubat 13-DEC-2002 Changed the LA and LD transactions to write the Course element,
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)

Line 410: cp_course IGS_UC_MV_UVCRS_VOP.course%TYPE,

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,
414: REPLACE(crsevac.ucas_program_code, '*', ' ') course,

Line 411: cp_campus IGS_UC_MV_UVCRS_VOP.campus%TYPE) IS

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,
414: REPLACE(crsevac.ucas_program_code, '*', ' ') course,
415: REPLACE(crsevac.ucas_campus, '*', ' ') campus,