APPS.IGF_SL_GEN dependencies on IGF_AW_FUND_CAT_ALL

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

80: --
81:
82: g_debug_string VARCHAR2(4000) := NULL;
83:
84: FUNCTION chk_dl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
85: RETURN VARCHAR2
86: AS
87: /*************************************************************
88: Created By : venagara

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

105: END chk_dl_fed_fund_code;
106:
107:
108:
109: FUNCTION chk_dl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
110: RETURN VARCHAR2
111: AS
112: /*************************************************************
113: Created By : venagara

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

139: END chk_dl_stafford;
140:
141:
142:
143: FUNCTION chk_dl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
144: RETURN VARCHAR2
145: AS
146: /*************************************************************
147: Created By : venagara

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

174:
175:
176:
177:
178: FUNCTION chk_cl_fed_fund_code(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
179: RETURN VARCHAR2
180: AS
181: /*************************************************************
182: Created By : venagara

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

197:
198: RETURN 'FALSE';
199: END chk_cl_fed_fund_code;
200:
201: FUNCTION chk_cl_gplus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
202: RETURN VARCHAR2
203: AS
204: /*************************************************************
205: Created By : azmohamm

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

229: CLOSE c1;
230: RETURN 'TRUE';
231: END chk_cl_gplus;
232:
233: FUNCTION chk_cl_stafford(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
234: RETURN VARCHAR2
235: AS
236: /*************************************************************
237: Created By : venagara

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

263: END chk_cl_stafford;
264:
265:
266:
267: FUNCTION chk_cl_plus(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
268: RETURN VARCHAR2
269: AS
270: /*************************************************************
271: Created By : venagara

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

296: RETURN 'TRUE';
297: END chk_cl_plus;
298:
299: /* Function to check Alternative Loan */
300: FUNCTION chk_cl_alt(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE)
301: RETURN VARCHAR2
302: AS
303: /*************************************************************
304: Created By : pkpatel

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

372:
373: END base10_to_base36;
374:
375:
376: FUNCTION get_grade_level_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
377: p_grade_level_code igf_sl_lor_all.grade_level_code%TYPE)
378: RETURN VARCHAR2
379: AS
380: /*************************************************************

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

391: RETURN p_grade_level_code||'-'||igf_aw_gen.lookup_desc('IGF_SL_CL_GRADE_LEVEL', p_grade_level_code);
392: END get_grade_level_desc;
393:
394:
395: FUNCTION get_enrollment_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
396: p_enrollment_code igf_sl_lor_all.enrollment_code%TYPE)
397: RETURN VARCHAR2
398: AS
399: /*************************************************************

Line 1196: the rel_code from igf_aw_fund_cat_all

1192: Know limitations, enhancements or remarks
1193: Change History
1194: Who When What
1195: bkkumar 10-apr-04 FACR116 - Added the check to select
1196: the rel_code from igf_aw_fund_cat_all
1197: (reverse chronological order - newest change first)
1198: **************************************************************/
1199:
1200: CURSOR c_chk_rel_code1 (

Line 1226: FROM igf_aw_fund_cat_all

1222: cp_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE
1223: )
1224: IS
1225: SELECT alt_rel_code
1226: FROM igf_aw_fund_cat_all
1227: WHERE alt_rel_code = cp_rel_code
1228: AND ROWNUM = 1;
1229:
1230: l_chk_rel_code3 c_chk_rel_code3%ROWTYPE;

Line 1246: -- cursor to check whether the relationship exists in the igf_aw_fund_cat_all table

1242: FETCH c_chk_rel_code2 INTO l_chk_rel_code2;
1243: CLOSE c_chk_rel_code2;
1244:
1245: l_chk_rel_code3 := NULL;
1246: -- cursor to check whether the relationship exists in the igf_aw_fund_cat_all table
1247: OPEN c_chk_rel_code3(p_rel_code);
1248: FETCH c_chk_rel_code3 INTO l_chk_rel_code3;
1249: CLOSE c_chk_rel_code3;
1250:

Line 1603: RETURN igf_aw_fund_cat_all.fed_fund_code%TYPE AS

1599: END get_stu_fao_code;
1600:
1601: FUNCTION get_fed_fund_code (p_n_award_id IN igf_aw_award_all.award_id%TYPE,
1602: p_v_message_name OUT NOCOPY VARCHAR2)
1603: RETURN igf_aw_fund_cat_all.fed_fund_code%TYPE AS
1604: ------------------------------------------------------------------
1605: --Created by : Sanil Madathil, Oracle IDC
1606: --Date created: 13 October 2004
1607: --

Line 1629: ,igf_aw_fund_cat_all fcat

1625:
1626: CURSOR c_igf_fmast_fcat (cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1627: SELECT fcat.fed_fund_code
1628: FROM igf_aw_fund_mast_all fmast
1629: ,igf_aw_fund_cat_all fcat
1630: WHERE fmast.fund_code = fcat.fund_code
1631: AND fmast.fund_id = cp_n_fund_id;
1632:
1633: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;

Line 1634: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;

1630: WHERE fmast.fund_code = fcat.fund_code
1631: AND fmast.fund_id = cp_n_fund_id;
1632:
1633: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
1634: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
1635:
1636: BEGIN
1637:
1638: IF p_n_award_id IS NULL THEN