APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_DEFAULTS

Line 7: g_crnt_institute igs_uc_defaults.current_inst_code%TYPE;

3:
4: g_success_rec_cnt NUMBER;
5: g_error_rec_cnt NUMBER;
6: g_error_code igs_uc_istark_ints.error_code%TYPE;
7: g_crnt_institute igs_uc_defaults.current_inst_code%TYPE;
8:
9: --JCHAKRAB made the config_cycle variable global for UCFD308 - UCAS 2005 Changes
10: g_config_cycle igs_uc_defaults.configured_cycle%TYPE;
11:

Line 10: g_config_cycle igs_uc_defaults.configured_cycle%TYPE;

6: g_error_code igs_uc_istark_ints.error_code%TYPE;
7: g_crnt_institute igs_uc_defaults.current_inst_code%TYPE;
8:
9: --JCHAKRAB made the config_cycle variable global for UCFD308 - UCAS 2005 Changes
10: g_config_cycle igs_uc_defaults.configured_cycle%TYPE;
11:
12: PROCEDURE appl_data_setup (errbuf OUT NOCOPY VARCHAR2,
13: retcode OUT NOCOPY NUMBER)
14: IS

Line 30: FROM igs_uc_defaults

26:
27: -- Get the current institution code set in UCAS Setup for FTUG as all systems have the same.
28: CURSOR crnt_inst_cur IS
29: SELECT DISTINCT current_inst_code
30: FROM igs_uc_defaults
31: WHERE current_inst_code IS NOT NULL;
32:
33: -- Get the Configured cycle value
34: CURSOR get_config_cycle_cur IS

Line 36: FROM igs_uc_defaults ;

32:
33: -- Get the Configured cycle value
34: CURSOR get_config_cycle_cur IS
35: SELECT MAX(configured_cycle) configured_cycle
36: FROM igs_uc_defaults ;
37:
38: BEGIN
39:
40: OPEN crnt_inst_cur;

Line 2575: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS

2571:
2572:
2573:
2574:
2575: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS
2576: SELECT current_inst_code
2577: FROM igs_uc_defaults
2578: WHERE system_code = p_sys_code;
2579:

Line 2577: FROM igs_uc_defaults

2573:
2574:
2575: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS
2576: SELECT current_inst_code
2577: FROM igs_uc_defaults
2578: WHERE system_code = p_sys_code;
2579:
2580: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
2581: CURSOR uc_transaction_9_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS

Line 3309: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS

3305: AND ucas_program_code = p_course
3306: AND ucas_campus = p_campus
3307: AND Institute = p_inst;
3308:
3309: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS
3310: SELECT current_inst_code
3311: FROM igs_uc_defaults
3312: WHERE system_code = p_sys_code;
3313:

Line 3311: FROM igs_uc_defaults

3307: AND Institute = p_inst;
3308:
3309: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS
3310: SELECT current_inst_code
3311: FROM igs_uc_defaults
3312: WHERE system_code = p_sys_code;
3313:
3314: CURSOR uc_transaction_cur(p_app_no igs_uc_transactions.app_no%TYPE) IS
3315: SELECT trans.rowid,

Line 5739: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS

5735: WHERE app_no = p_appno;
5736:
5737:
5738:
5739: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS
5740: SELECT current_inst_code
5741: FROM igs_uc_defaults
5742: WHERE system_code = p_sys_code;
5743:

Line 5741: FROM igs_uc_defaults

5737:
5738:
5739: CURSOR curr_inst_cur(p_sys_code igs_uc_defaults.system_code%type) IS
5740: SELECT current_inst_code
5741: FROM igs_uc_defaults
5742: WHERE system_code = p_sys_code;
5743:
5744: -- 02-AUG-2006 anwest Bug #5440216 URGENT - UCAS CLEARING 2006 - PART 2 - CLEARING CHOICE NUMBER NULL
5745: CURSOR uc_app_choices_cur(p_appno igs_uc_app_choices.app_no%TYPE) IS