[Home] [Help]
577: appl_rec old_appl_cur%ROWTYPE;
578:
579: -- Get the system to which the APplication belongs
580: -- Cursor to fetch the Application Number Range of all the Systems supported by UCAS
581: CURSOR cur_ucas_control (p_appno igs_uc_ucas_control.appno_maximum%TYPE) IS
582: SELECT system_code
583: FROM igs_uc_ucas_control
584: WHERE ucas_cycle = (2000 + TO_NUMBER(SUBSTR(LPAD(TO_CHAR(p_appno),8,'0'),0,2)))
585: AND p_appno BETWEEN appno_first AND appno_maximum;
579: -- Get the system to which the APplication belongs
580: -- Cursor to fetch the Application Number Range of all the Systems supported by UCAS
581: CURSOR cur_ucas_control (p_appno igs_uc_ucas_control.appno_maximum%TYPE) IS
582: SELECT system_code
583: FROM igs_uc_ucas_control
584: WHERE ucas_cycle = (2000 + TO_NUMBER(SUBSTR(LPAD(TO_CHAR(p_appno),8,'0'),0,2)))
585: AND p_appno BETWEEN appno_first AND appno_maximum;
586:
587:
624: FROM DUAL;
625:
626: old_starn_rec old_starn_cur%ROWTYPE;
627: l_oss_title igs_pe_person_base_v.title%TYPE;
628: l_system_code igs_uc_ucas_control.system_code%TYPE;
629: l_invoke_adm_import_Proc_flag VARCHAR2(1) ; -- Flag to identify atleast one new rec imported
630: l_new_rec_flag VARCHAR2(1); -- flag to check whether a new record (i.e. insert) or old record(i.e.update)
631: l_recs_inserted NUMBER := 0;
632: l_alt_pers_id_type igs_ad_api_int.person_id_type%TYPE;
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;
2555:
2556: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
2591: get_appl_dets_rec get_appl_dets%ROWTYPE; -- Holds the Application details from UC_Applicants
2592: curr_inst_rec curr_inst_cur%ROWTYPE;
2593: old_starc_9_rec old_starc_cur%ROWTYPE;-- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
2594:
2595: l_entry_year igs_uc_ucas_control.entry_year%TYPE;
2596: l_deferred igs_uc_app_choices.deferred%TYPE;
2597: l_entrymonth igs_uc_app_choices.entry_month%TYPE;
2598: l_app_choice_id igs_uc_app_choices.app_choice_id%TYPE; -- Place holder for App CHoice ID - Seq gen value.
2599: l_valid VARCHAR2(1); -- for holding fetch from cursors for rec exists check.
2703: FETCH get_control_entry_year INTO l_entry_year ;
2704: CLOSE get_control_entry_year;
2705:
2706: -- DEFERRED value derivation
2707: -- If ivstarc.entry_year > igs_uc_ucas_control.entry_year then deferred='Y' else 'N'.
2708: IF new_ivstarc_rec.entryyear > l_entry_year THEN
2709: l_deferred := 'Y' ;
2710: ELSE
2711: l_deferred := 'N' ;
3285:
3286: -- get entry year from UCAS Control.
3287: CURSOR get_control_entry_year (p_system igs_uc_applicants.system_code%TYPE, p_cycle igs_uc_istarg_ints.ucas_cycle%TYPE) IS
3288: SELECT entry_year
3289: FROM igs_uc_ucas_control
3290: WHERE system_code = p_system
3291: AND ucas_cycle = p_cycle;
3292:
3293: -- Cursor to get the OSS Program details for the UCAS course from Course details table.
3324: get_appl_dets_rec get_appl_dets%ROWTYPE; -- Holds the Application details from UC_Applicants
3325: curr_inst_rec curr_inst_cur%ROWTYPE;
3326: old_starg_99_rec old_starg_cur%ROWTYPE; -- arvsrini uccr008
3327:
3328: l_entry_year igs_uc_ucas_control.entry_year%TYPE;
3329: l_deferred igs_uc_app_choices.deferred%TYPE;
3330: l_entrymonth igs_uc_app_choices.entry_month%TYPE;
3331: l_app_choice_id igs_uc_app_choices.app_choice_id%TYPE; -- Place holder for App CHoice ID - Seq gen value.
3332: l_valid VARCHAR2(1); -- for holding fetch from cursors for rec exists check.
3558: FETCH get_control_entry_year INTO l_entry_year ;
3559: CLOSE get_control_entry_year;
3560:
3561: -- DEFERRED value derivation
3562: -- If ivstarc.entry_year > igs_uc_ucas_control.entry_year then deferred='Y' else 'N'.
3563: IF new_ivstarg_rec.entryyear > l_entry_year THEN
3564: l_deferred := 'Y' ;
3565: ELSE
3566: l_deferred := 'N' ;