eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_UC_DEFAULTS

Line 33: CURSOR cur_ucas_setup( cp_system_code igs_uc_defaults.system_code%TYPE) IS

29: ******************************************************************/
30:
31: -- Cursor to find the details of default UCAS setup defined in the SYSTEM.
32: -- smaddali modified this cursor to add check for system_code , for bug 2643048 UCFD102 build
33: CURSOR cur_ucas_setup( cp_system_code igs_uc_defaults.system_code%TYPE) IS
34: SELECT *
35: FROM igs_uc_defaults
36: WHERE system_code = NVL(cp_system_code,system_code) ;
37: cur_ucas_setup_rec cur_ucas_setup%ROWTYPE;

Line 35: FROM igs_uc_defaults

31: -- Cursor to find the details of default UCAS setup defined in the SYSTEM.
32: -- smaddali modified this cursor to add check for system_code , for bug 2643048 UCFD102 build
33: CURSOR cur_ucas_setup( cp_system_code igs_uc_defaults.system_code%TYPE) IS
34: SELECT *
35: FROM igs_uc_defaults
36: WHERE system_code = NVL(cp_system_code,system_code) ;
37: cur_ucas_setup_rec cur_ucas_setup%ROWTYPE;
38:
39: -- Cursor to fetch the UCAS Application choices

Line 47: igs_uc_defaults ud

43: -- smaddali modified this cursor to add the where clause of System_code check , bug 2643048 UCFD102 build
44: CURSOR cur_ucas_app_choice IS
45: SELECT uac.*,uac.ROWID
46: FROM igs_uc_app_choices uac,
47: igs_uc_defaults ud
48: WHERE uac.app_no = NVL(p_app_no,uac.app_no)
49: AND uac.choice_no = NVL( p_choice_number,uac.choice_no )
50: AND uac.export_to_oss_status = 'AC'
51: AND ud.system_code = uac.system_code

Line 70: IGS_UC_DEFAULTS UD,

66: APLINST.ATTENDANCE_MODE, APLINST.ATTENDANCE_TYPE, APLINST.UNIT_SET_CD,
67: APLINST.US_VERSION_NUMBER, APL.ACAD_CAL_TYPE, UAC.POINT_OF_ENTRY
68: FROM IGS_UC_APP_CHOICES UAC,
69: IGS_UC_APPLICANTS UA,
70: IGS_UC_DEFAULTS UD,
71: IGS_AD_SS_APPL_TYP AAT,
72: IGS_AD_APPL_ALL APL,
73: IGS_AD_PS_APPL_INST_ALL APLINST,
74: IGS_UC_SYS_CALNDRS USC

Line 238: igs_uc_defaults ud

234: -- smaddali modified this cursor to add the where clause of System_code check , bug 2643048 UCFD102 build
235: CURSOR cur_dp_app_choice IS
236: SELECT uac.*,uac.ROWID
237: FROM igs_uc_app_choices uac,
238: igs_uc_defaults ud
239: WHERE uac.app_no = NVL( p_app_no,uac.app_no)
240: AND uac.choice_no = NVL( p_choice_number,uac.choice_no )
241: AND uac.batch_id IS NOT NULL
242: AND uac.export_to_oss_status = 'DP'

Line 296: igs_uc_defaults ud

292: -- to get all the distinct system_codes belonging to the passed application choice parameter
293: CURSOR c_ch_system IS
294: SELECT DISTINCT a.system_code, a.entry_year, a.entry_month
295: FROM igs_uc_app_choices a,
296: igs_uc_defaults ud
297: WHERE a.app_no = NVL(p_app_no, a.app_no)
298: AND a.choice_no = NVL(p_choice_number,a.choice_no)
299: AND a.export_to_oss_status = 'AC'
300: AND ud.system_code = a.system_code

Line 320: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS

316: l_sys_entry_cal_det_rec cur_sys_entry_cal_det%ROWTYPE;
317:
318: --Cursor to get the Admission Process Category and Admission Process Type for the
319: --Admission Application Type defined for the System in UCAS Setup.
320: CURSOR cur_apc_det ( cp_application_type igs_uc_defaults.application_type%TYPE) IS
321: SELECT admission_cat, s_admission_process_type
322: FROM igs_ad_ss_appl_typ
323: WHERE admission_application_type = cp_application_type
324: AND closed_ind = 'N';

Line 1461: CURSOR cur_ucas_setup( cp_system_code igs_uc_defaults.system_code%TYPE) IS

1457: l_exp_reply_flag BOOLEAN ;
1458:
1459: -- Cursor to find the details of default UCAS setup defined in the SYSTEM.
1460: -- smaddali modified this cursor to add the where clause of System_code check , bug 2643048 UCFD102 build
1461: CURSOR cur_ucas_setup( cp_system_code igs_uc_defaults.system_code%TYPE) IS
1462: SELECT *
1463: FROM igs_uc_defaults
1464: WHERE system_code = cp_system_code ;
1465: cur_ucas_setup_rec cur_ucas_setup%ROWTYPE;

Line 1463: FROM igs_uc_defaults

1459: -- Cursor to find the details of default UCAS setup defined in the SYSTEM.
1460: -- smaddali modified this cursor to add the where clause of System_code check , bug 2643048 UCFD102 build
1461: CURSOR cur_ucas_setup( cp_system_code igs_uc_defaults.system_code%TYPE) IS
1462: SELECT *
1463: FROM igs_uc_defaults
1464: WHERE system_code = cp_system_code ;
1465: cur_ucas_setup_rec cur_ucas_setup%ROWTYPE;
1466:
1467: -- Cursor to fetch the UCAS Application choices

Line 1475: igs_uc_defaults ud

1471: -- smaddali modified this cursor to add the where clause of System_code check , bug 2643048 UCFD102 build
1472: CURSOR cur_ucas_app_choice IS
1473: SELECT uac.*,uac.ROWID
1474: FROM IGS_UC_APP_CHOICES uac,
1475: igs_uc_defaults ud
1476: WHERE uac.app_no = NVL(p_app_no,uac.app_no)
1477: AND uac.choice_no = NVL( p_choice_number,uac.choice_no )
1478: AND uac.export_to_oss_status = 'DC'
1479: AND uac.institute_code = ud.current_inst_code

Line 1499: IGS_UC_DEFAULTS UD,

1495: APLINST.ATTENDANCE_MODE, APLINST.ATTENDANCE_TYPE, APLINST.UNIT_SET_CD,
1496: APLINST.US_VERSION_NUMBER, APL.ACAD_CAL_TYPE, UAC.POINT_OF_ENTRY
1497: FROM IGS_UC_APP_CHOICES UAC,
1498: IGS_UC_APPLICANTS UA,
1499: IGS_UC_DEFAULTS UD,
1500: IGS_AD_SS_APPL_TYP AAT,
1501: IGS_AD_APPL_ALL APL,
1502: IGS_AD_PS_APPL_INST_ALL APLINST,
1503: IGS_UC_SYS_CALNDRS USC

Line 1619: igs_uc_defaults ud

1615: -- smaddali modified this cursor to add the where clause of System_code check , bug 2643048 UCFD102 build
1616: CURSOR cur_rp_app_choice IS
1617: SELECT uac.*,uac.ROWID
1618: FROM igs_uc_app_choices uac,
1619: igs_uc_defaults ud
1620: WHERE uac.app_no = NVL(p_app_no,uac.app_no)
1621: AND uac.choice_no = NVL( p_choice_number,uac.choice_no )
1622: AND uac.export_to_oss_status = 'RP'
1623: AND uac.institute_code = ud.current_inst_code