118: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
119: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
120: RETURN VARCHAR2;
121:
122: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,
123: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
124: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,
125: p_return_type VARCHAR2)
126: RETURN VARCHAR2;
119: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
120: RETURN VARCHAR2;
121:
122: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,
123: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
124: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,
125: p_return_type VARCHAR2)
126: RETURN VARCHAR2;
127:
120: RETURN VARCHAR2;
121:
122: FUNCTION get_dl_file_type(p_dl_version igf_sl_dl_file_type.dl_version%TYPE,
123: p_dl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
124: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,
125: p_return_type VARCHAR2)
126: RETURN VARCHAR2;
127:
128: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
124: p_dl_loan_catg igf_sl_dl_file_type.dl_loan_catg%TYPE,
125: p_return_type VARCHAR2)
126: RETURN VARCHAR2;
127:
128: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
129: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
130: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
131: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
132: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE);
125: p_return_type VARCHAR2)
126: RETURN VARCHAR2;
127:
128: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
129: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
130: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
131: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
132: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE);
133:
126: RETURN VARCHAR2;
127:
128: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
129: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
130: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
131: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
132: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE);
133:
134: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,
127:
128: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
129: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
130: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
131: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
132: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE);
133:
134: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,
135: p_cl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
128: PROCEDURE get_dl_batch_details(p_message_class IN igf_sl_dl_file_type.message_class%TYPE,
129: p_batch_type IN igf_sl_dl_file_type.batch_type%TYPE,
130: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
131: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
132: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE);
133:
134: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,
135: p_cl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
136: p_return_type VARCHAR2)
130: p_dl_version OUT NOCOPY igf_sl_dl_file_type.dl_version%TYPE,
131: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
132: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE);
133:
134: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,
135: p_cl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
136: p_return_type VARCHAR2)
137: RETURN VARCHAR2;
138:
131: p_dl_file_type OUT NOCOPY igf_sl_dl_file_type.dl_file_type%TYPE,
132: p_dl_loan_catg OUT NOCOPY igf_sl_dl_file_type.dl_loan_catg%TYPE);
133:
134: FUNCTION get_cl_file_type(p_cl_version igf_sl_dl_file_type.dl_version%TYPE,
135: p_cl_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
136: p_return_type VARCHAR2)
137: RETURN VARCHAR2;
138:
139: PROCEDURE get_cl_batch_details(p_file_ident_code IN igf_sl_cl_file_type.file_ident_code%TYPE,