APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_ISTARC_INTS

Line 2510: If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.CHOICENO. Also if there exists records

2506: Change History
2507: Who When What
2508: arvsrini 05-MAR-04 Added code to check before inserting records to IGS_UC_APP_CHOICES whether there exists record with
2509: same institution code and system code but having choice number as 99.If there exists no records, then insert is performed
2510: If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.CHOICENO. Also if there exists records
2511: in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated. Bug#3239860
2512: jchakrab 23-AUG-04 Modified for Bug# 3837871 - Update system_code of existing app_choice records in
2513: IGS_UC_APP_CHOICES with current cycle's system_code in IGS_UC_APLICANTS
2514: jbaber 15-Sep-05 Entryyear defaults if NULL for all systems

Line 2521: FROM igs_uc_istarc_ints ivstk

2517:
2518: CURSOR new_ivstarc_cur IS
2519: SELECT ivstk.rowid,
2520: ivstk.*
2521: FROM igs_uc_istarc_ints ivstk
2522: WHERE record_status = 'N';
2523:
2524:
2525: CURSOR old_starc_cur(p_appno igs_uc_app_choices.app_no%TYPE,

Line 2550: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarc_ints.ucas_cycle%TYPE) IS

2546: FROM igs_uc_com_inst
2547: WHERE inst = p_inst;
2548:
2549: -- get entry year from UCAS Control.
2550: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarc_ints.ucas_cycle%TYPE) IS
2551: SELECT entry_year
2552: FROM igs_uc_ucas_control
2553: WHERE system_code = p_system
2554: AND ucas_cycle = p_cycle;

Line 2915: --the record is to be updated using choice number as IGS_UC_ISTARC_INTS.CHOICENO. Also if there exists records

2911: oss_prog_rec.oss_location := old_starc_9_rec.oss_location ;
2912:
2913: END IF;
2914:
2915: --the record is to be updated using choice number as IGS_UC_ISTARC_INTS.CHOICENO. Also if there exists records
2916: --in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated. Bug#3239860
2917:
2918:
2919: BEGIN

Line 3204: UPDATE igs_uc_istarc_ints

3200: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
3201: -- while processing the record.
3202: IF g_error_code IS NOT NULL THEN
3203:
3204: UPDATE igs_uc_istarc_ints
3205: SET error_code = g_error_code
3206: WHERE rowid = new_ivstarc_rec.rowid;
3207:
3208: -- log error message/meaning.

Line 3216: UPDATE igs_uc_istarc_ints

3212: g_error_rec_cnt := g_error_rec_cnt + 1;
3213:
3214: ELSE
3215:
3216: UPDATE igs_uc_istarc_ints
3217: SET record_status = 'D',
3218: error_code = NULL
3219: WHERE rowid = new_ivstarc_rec.rowid;
3220:

Line 3251: If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.ROUNDNO. Also if there exists records

3247: Change History
3248: Who When What
3249: arvsrini 08-MAR-04 Added code to check before inserting records to IGS_UC_APP_CHOICES whether there exists record with
3250: same institution code and system code but having choice number as 99.If there exists no records, then insert is performed
3251: If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.ROUNDNO. Also if there exists records
3252: in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated.Bug#3239860
3253: ******************************************************************/
3254:
3255: CURSOR new_ivstarg_cur IS

Line 3727: --If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.ROUNDNO. Also if there exists records

3723:
3724: END IF;
3725:
3726:
3727: --If it exists, the record is updated using choice number as IGS_UC_ISTARC_INTS.ROUNDNO. Also if there exists records
3728: --in IGS_UC_TRANSACTIONS with choice_no = 99 then those records are also updated.Bug#3239860
3729:
3730:
3731: BEGIN