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.

APPS.IGF_AW_ROLLOVER dependencies on IGF_AP_APPL_SETUP_ALL

Line 1223: FROM igf_ap_appl_setup_all appln

1219: CURSOR c_get_appln_code( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1220: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE
1221: ) IS
1222: SELECT appln.application_code
1223: FROM igf_ap_appl_setup_all appln
1224: WHERE appln.ci_cal_type = cp_frm_cal_type
1225: AND appln.ci_sequence_number = cp_frm_sequence_number
1226: AND NVL(appln.active_flag,'N')= 'Y'
1227: GROUP BY appln.application_code

Line 1234: cp_application_code igf_ap_appl_setup_all.application_code%TYPE

1230:
1231: -- Get the institutional application setup details for the source award year
1232: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
1233: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1234: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1235: ) IS
1236: SELECT appln.*
1237: FROM igf_ap_appl_setup_all appln
1238: WHERE appln.ci_cal_type = cp_frm_cal_type

Line 1237: FROM igf_ap_appl_setup_all appln

1233: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1234: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1235: ) IS
1236: SELECT appln.*
1237: FROM igf_ap_appl_setup_all appln
1238: WHERE appln.ci_cal_type = cp_frm_cal_type
1239: AND appln.ci_sequence_number = cp_frm_sequence_number
1240: AND appln.application_code = cp_application_code
1241: AND NVL(appln.active_flag,'N')= 'Y'

Line 1248: cp_application_code igf_ap_appl_setup_all.application_code%TYPE

1244:
1245: -- Check whether the application exists or not
1246: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
1247: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1248: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1249: ) IS
1250: SELECT 'X' exist
1251: FROM igf_ap_appl_setup_all appln
1252: WHERE appln.ci_cal_type = cp_to_cal_type

Line 1251: FROM igf_ap_appl_setup_all appln

1247: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1248: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
1249: ) IS
1250: SELECT 'X' exist
1251: FROM igf_ap_appl_setup_all appln
1252: WHERE appln.ci_cal_type = cp_to_cal_type
1253: AND appln.ci_sequence_number = cp_to_sequence_number
1254: AND appln.application_code = cp_application_code
1255: AND NVL(appln.active_flag,'N')= 'Y';

Line 2659: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE

2655: FUNCTION rollover_inst_attch_todo ( p_frm_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2656: p_frm_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2657: p_to_cal_type IN igs_ca_inst_all.cal_type%TYPE,
2658: p_to_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
2659: p_application_code IN igf_ap_appl_setup_all.application_code%TYPE
2660: )
2661: RETURN VARCHAR IS
2662: --------------------------------------------------------------------------------
2663: -- Created by : ridas, Oracle India

Line 2674: cp_application_code igf_ap_appl_setup_all.application_code%TYPE

2670:
2671: -- Get the institutional application setup details for the source award year
2672: CURSOR c_inst_appln_setup( cp_frm_cal_type igs_ca_inst_all.cal_type%TYPE,
2673: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2674: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2675: ) IS
2676: SELECT appln.*
2677: FROM igf_ap_appl_setup_all appln
2678: WHERE appln.ci_cal_type = cp_frm_cal_type

Line 2677: FROM igf_ap_appl_setup_all appln

2673: cp_frm_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2674: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2675: ) IS
2676: SELECT appln.*
2677: FROM igf_ap_appl_setup_all appln
2678: WHERE appln.ci_cal_type = cp_frm_cal_type
2679: AND appln.ci_sequence_number = cp_frm_sequence_number
2680: AND appln.application_code = cp_application_code
2681: AND NVL(appln.active_flag,'N')= 'Y'

Line 2688: cp_application_code igf_ap_appl_setup_all.application_code%TYPE

2684:
2685: -- Check whether the application exists or not
2686: CURSOR c_appln_exists( cp_to_cal_type igs_ca_inst_all.cal_type%TYPE,
2687: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2688: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2689: ) IS
2690: SELECT 'X' exist
2691: FROM igf_ap_appl_setup_all appln
2692: WHERE appln.ci_cal_type = cp_to_cal_type

Line 2691: FROM igf_ap_appl_setup_all appln

2687: cp_to_sequence_number igs_ca_inst_all.sequence_number%TYPE,
2688: cp_application_code igf_ap_appl_setup_all.application_code%TYPE
2689: ) IS
2690: SELECT 'X' exist
2691: FROM igf_ap_appl_setup_all appln
2692: WHERE appln.ci_cal_type = cp_to_cal_type
2693: AND appln.ci_sequence_number = cp_to_sequence_number
2694: AND appln.application_code = cp_application_code
2695: AND NVL(appln.active_flag,'N')= 'Y';