APPS.IGS_UC_EXT_MARVIN dependencies on IGS_UC_REF_OFF_ABRV

Line 325: || igs_uc_ref_off_abrv to fecth the Transactions.

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: */
329:

Line 443: FROM igs_uc_ref_off_abrv roa

439: roa.abbrev_text ,
440: REPLACE(roa.letter_format, '*', ' ') letter_format,
441: REPLACE(roa.summary_char, '*', ' ') summary_char,
442: roa.deleted
443: FROM igs_uc_ref_off_abrv roa
444: WHERE roa.sent_to_ucas = 'N' AND roa.deleted = 'N';
445: l_cur_uv_offr_abb cur_uv_offr_abb%ROWTYPE;
446:
447: -- Fetching Offer Abbreviations record for Update

Line 452: FROM igs_uc_ref_off_abrv roa

448: CURSOR upd_offr_abb_cur(cp_rowid VARCHAR2) IS
449: SELECT
450: roa.ROWID,
451: roa.*
452: FROM igs_uc_ref_off_abrv roa
453: WHERE roa.ROWID = cp_rowid;
454:
455: l_record VARCHAR2(1000);
456: l_from NUMBER(3);

Line 1055: igs_uc_ref_off_abrv_pkg.update_row (

1051:
1052: -- Update the Offer Abbreviations Record
1053: FOR upd_offr_abb_rec IN upd_offr_abb_cur(l_cur_uv_offr_abb.ROWID) LOOP
1054:
1055: igs_uc_ref_off_abrv_pkg.update_row (
1056: x_mode => 'R',
1057: x_rowid => upd_offr_abb_rec.rowid,
1058: x_abbrev_code => upd_offr_abb_rec.abbrev_code,
1059: x_uv_updater => upd_offr_abb_rec.uv_updater,

Line 1138: FROM igs_uc_ref_off_abrv roa

1134:
1135: -- Cursor to find whether any offer abbreviations exist to send to UCAS
1136: CURSOR cur_uv_offr_abb_exist IS
1137: SELECT 'X'
1138: FROM igs_uc_ref_off_abrv roa
1139: WHERE roa.sent_to_ucas = 'N' AND roa.deleted = 'N';
1140:
1141: l_dummy VARCHAR2(1);
1142: l_status BOOLEAN := FALSE;