DBA Data[Home] [Help]

APPS.IGF_SL_GEN dependencies on IGF_AW_FUND_CAT_ALL

Line 73: FUNCTION chk_dl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

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)
74: RETURN VARCHAR2;
75:
76: FUNCTION chk_dl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
77: RETURN VARCHAR2;

Line 76: FUNCTION chk_dl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

72:
73: FUNCTION chk_dl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
74: RETURN VARCHAR2;
75:
76: FUNCTION chk_dl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
77: RETURN VARCHAR2;
78:
79:
80: FUNCTION chk_dl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

Line 80: FUNCTION chk_dl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

76: FUNCTION chk_dl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
77: RETURN VARCHAR2;
78:
79:
80: FUNCTION chk_dl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
81: RETURN VARCHAR2;
82:
83: FUNCTION chk_cl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
84: RETURN VARCHAR2;

Line 83: FUNCTION chk_cl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

79:
80: FUNCTION chk_dl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
81: RETURN VARCHAR2;
82:
83: FUNCTION chk_cl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
84: RETURN VARCHAR2;
85:
86: FUNCTION chk_cl_gplus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
87: RETURN VARCHAR2;

Line 86: FUNCTION chk_cl_gplus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

82:
83: FUNCTION chk_cl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
84: RETURN VARCHAR2;
85:
86: FUNCTION chk_cl_gplus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
87: RETURN VARCHAR2;
88:
89: FUNCTION chk_cl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
90: RETURN VARCHAR2;

Line 89: FUNCTION chk_cl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

85:
86: FUNCTION chk_cl_gplus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
87: RETURN VARCHAR2;
88:
89: FUNCTION chk_cl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
90: RETURN VARCHAR2;
91:
92: FUNCTION chk_cl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
93: RETURN VARCHAR2;

Line 92: FUNCTION chk_cl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

88:
89: FUNCTION chk_cl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
90: RETURN VARCHAR2;
91:
92: FUNCTION chk_cl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
93: RETURN VARCHAR2;
94: /* Function to check for Alternative Loan */
95: FUNCTION chk_cl_alt(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
96: RETURN VARCHAR2;

Line 95: FUNCTION chk_cl_alt(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)

91:
92: FUNCTION chk_cl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
93: RETURN VARCHAR2;
94: /* Function to check for Alternative Loan */
95: FUNCTION chk_cl_alt(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
96: RETURN VARCHAR2;
97:
98: FUNCTION base10_to_base36(p_base_10 NUMBER)
99: RETURN VARCHAR;

Line 101: FUNCTION get_grade_level_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,

97:
98: FUNCTION base10_to_base36(p_base_10 NUMBER)
99: RETURN VARCHAR;
100:
101: FUNCTION get_grade_level_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
102: p_grade_level_code igf_sl_lor_all.grade_level_code%TYPE)
103: RETURN VARCHAR2;
104:
105: FUNCTION get_enrollment_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,

Line 105: FUNCTION get_enrollment_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,

101: FUNCTION get_grade_level_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
102: p_grade_level_code igf_sl_lor_all.grade_level_code%TYPE)
103: RETURN VARCHAR2;
104:
105: FUNCTION get_enrollment_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
106: p_enrollment_code igf_sl_lor_all.enrollment_code%TYPE)
107: RETURN VARCHAR2;
108:
109: FUNCTION get_dl_version(p_ci_cal_type igf_sl_dl_setup_all.ci_cal_type%TYPE,

Line 173: RETURN igf_aw_fund_cat_all.fed_fund_code%TYPE;

169: x_msg_data OUT NOCOPY VARCHAR2);
170:
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