DBA Data[Home] [Help]

APPS.IGF_SL_GEN dependencies on IGF_SL_CL_SETUP_ALL

Line 69: p_rel_code IN igf_sl_cl_setup_all.relationship_cd%TYPE,

65:
66: PROCEDURE get_person_details ( p_person_id IN igf_sl_cl_pref_lenders.person_id%TYPE,
67: p_person_dtl_rec IN OUT NOCOPY person_dtl_cur);
68: PROCEDURE check_rel (
69: p_rel_code IN igf_sl_cl_setup_all.relationship_cd%TYPE,
70: p_flag OUT NOCOPY VARCHAR2
71: );
72:
73: FUNCTION chk_dl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

Line 116: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,

112:
113: -- museshad. Bug# 4346258 - Added extra parameter p_base_id. This is needed to
114: -- arrive at the correct CL version# by taking into account any CL version#
115: -- override for any particular Organization Unit.
116: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
117: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
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;

Line 117: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,

113: -- museshad. Bug# 4346258 - Added extra parameter p_base_id. This is needed to
114: -- arrive at the correct CL version# by taking into account any CL version#
115: -- override for any particular Organization Unit.
116: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
117: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
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:

Line 118: p_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,

114: -- arrive at the correct CL version# by taking into account any CL version#
115: -- override for any particular Organization Unit.
116: FUNCTION get_cl_version(p_ci_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
117: p_ci_seq_num igf_sl_cl_setup_all.ci_sequence_number%TYPE,
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,

Line 175: FUNCTION check_prc_chg (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,

171: FUNCTION get_fed_fund_code (p_n_award_id IN igf_aw_award_all.award_id%TYPE,
172: p_v_message_name OUT NOCOPY VARCHAR2)
173: RETURN igf_aw_fund_cat_all.fed_fund_code%TYPE;
174:
175: FUNCTION check_prc_chg (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
176: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
177: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
178: )
179: RETURN BOOLEAN;

Line 181: FUNCTION check_prc_chgm (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,

177: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
178: )
179: RETURN BOOLEAN;
180:
181: FUNCTION check_prc_chgm (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
182: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
183: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
184: )
185: RETURN BOOLEAN;