APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_SL_SCHOOL_CODES_V

Line 2739: CURSOR c_valid_fed_school(cp_fed_school igf_sl_school_codes_v.alternate_identifier%TYPE,

2735: */
2736:
2737:
2738: -- cursor to check whether the school code is valid or not
2739: CURSOR c_valid_fed_school(cp_fed_school igf_sl_school_codes_v.alternate_identifier%TYPE,
2740: cp_system_id_type igf_sl_school_codes_v.system_id_type%TYPE)
2741: IS
2742: SELECT 'X'
2743: FROM igf_sl_school_codes_v

Line 2740: cp_system_id_type igf_sl_school_codes_v.system_id_type%TYPE)

2736:
2737:
2738: -- cursor to check whether the school code is valid or not
2739: CURSOR c_valid_fed_school(cp_fed_school igf_sl_school_codes_v.alternate_identifier%TYPE,
2740: cp_system_id_type igf_sl_school_codes_v.system_id_type%TYPE)
2741: IS
2742: SELECT 'X'
2743: FROM igf_sl_school_codes_v
2744: WHERE system_id_type= cp_system_id_type

Line 2743: FROM igf_sl_school_codes_v

2739: CURSOR c_valid_fed_school(cp_fed_school igf_sl_school_codes_v.alternate_identifier%TYPE,
2740: cp_system_id_type igf_sl_school_codes_v.system_id_type%TYPE)
2741: IS
2742: SELECT 'X'
2743: FROM igf_sl_school_codes_v
2744: WHERE system_id_type= cp_system_id_type
2745: AND alternate_identifier = cp_fed_school;
2746:
2747:

Line 2779: l_college_code igf_sl_school_codes_v.alternate_identifier%TYPE;

2775: l_transaction_num CHAR(13);
2776: l_ow_id NUMBER;
2777: l_message VARCHAR2(100);
2778: l_send_workflow BOOLEAN;
2779: l_college_code igf_sl_school_codes_v.alternate_identifier%TYPE;
2780: l_chk_valid VARCHAR2(1);
2781:
2782: BEGIN
2783: