APPS.IGF_SL_DL_VALIDATION dependencies on FND_LOOKUPS

Line 88: lv_err_type fnd_lookups.lookup_type%TYPE;

84: (reverse chronological order - newest change first)
85: ***************************************************************/
86:
87: lv_complete BOOLEAN := TRUE;
88: lv_err_type fnd_lookups.lookup_type%TYPE;
89: lv_data_reqd fnd_lookups.lookup_code%TYPE;
90: lv_data_recomm fnd_lookups.lookup_code%TYPE;
91:
92: CURSOR cur_reqd IS

Line 89: lv_data_reqd fnd_lookups.lookup_code%TYPE;

85: ***************************************************************/
86:
87: lv_complete BOOLEAN := TRUE;
88: lv_err_type fnd_lookups.lookup_type%TYPE;
89: lv_data_reqd fnd_lookups.lookup_code%TYPE;
90: lv_data_recomm fnd_lookups.lookup_code%TYPE;
91:
92: CURSOR cur_reqd IS
93: SELECT status from igf_sl_reqd_fields lrf

Line 90: lv_data_recomm fnd_lookups.lookup_code%TYPE;

86:
87: lv_complete BOOLEAN := TRUE;
88: lv_err_type fnd_lookups.lookup_type%TYPE;
89: lv_data_reqd fnd_lookups.lookup_code%TYPE;
90: lv_data_recomm fnd_lookups.lookup_code%TYPE;
91:
92: CURSOR cur_reqd IS
93: SELECT status from igf_sl_reqd_fields lrf
94: WHERE lrf.spec_version = p_dl_version

Line 300: p_loan_catg fnd_lookups.lookup_code%TYPE,

296:
297: /* MAIN PROCEDURE */
298: FUNCTION dl_lar_validate(p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
299: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
300: p_loan_catg fnd_lookups.lookup_code%TYPE,
301: p_loan_number igf_sl_loans_all.loan_number%TYPE,
302: p_call_mode VARCHAR2,
303: p_school_code VARCHAR2 )
304: RETURN BOOLEAN