eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_AW_FUND_MAST_ALL

Line 32: fund_id igf_aw_fund_mast_all.fund_id%TYPE,

28:
29: TYPE lorlar_recTyp IS RECORD (
30: cal_type igs_ca_inst_all.cal_type%TYPE,
31: sequence_number igs_ca_inst_all.sequence_number%TYPE,
32: fund_id igf_aw_fund_mast_all.fund_id%TYPE,
33: discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE,
34: fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
35: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
36: award_id igf_aw_award_all.award_id%TYPE,

Line 33: discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE,

29: TYPE lorlar_recTyp IS RECORD (
30: cal_type igs_ca_inst_all.cal_type%TYPE,
31: sequence_number igs_ca_inst_all.sequence_number%TYPE,
32: fund_id igf_aw_fund_mast_all.fund_id%TYPE,
33: discontinue_fund igf_aw_fund_mast_all.discontinue_fund%TYPE,
34: fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
35: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
36: award_id igf_aw_award_all.award_id%TYPE,
37: loan_id igf_sl_loans_all.loan_id%TYPE,

Line 64: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

60: PROCEDURE identify_clchsn_dtls
61: (
62: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
63: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
64: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
65: p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
66: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE
67: );
68: FUNCTION get_base_id

Line 93: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

89: PROCEDURE create_file (
90: errbuf OUT NOCOPY VARCHAR2,
91: retcode OUT NOCOPY NUMBER,
92: p_v_award_year IN VARCHAR2,
93: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
94: p_n_dummy_1 IN NUMBER,
95: p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
96: p_n_dummy_2 IN NUMBER,
97: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,

Line 132: CURSOR c_igf_aw_fund_mast(cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

128: --Change History:
129: --Who When What
130: --ridas 07-Feb-2006 Bug #5021084. Replaced function IGS_GET_DYNAMIC_SQL with GET_DYNAMIC_SQL
131: ------------------------------------------------------------------
132: CURSOR c_igf_aw_fund_mast(cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
133: SELECT fmast.description fund_desc
134: ,fmast.ci_cal_type
135: ,fmast.ci_sequence_number
136: FROM igf_aw_fund_mast_all fmast

Line 136: FROM igf_aw_fund_mast_all fmast

132: CURSOR c_igf_aw_fund_mast(cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
133: SELECT fmast.description fund_desc
134: ,fmast.ci_cal_type
135: ,fmast.ci_sequence_number
136: FROM igf_aw_fund_mast_all fmast
137: WHERE fmast.fund_id = cp_n_fund_id;
138:
139: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
140:

Line 201: ,igf_aw_fund_mast_all fmast

197: SELECT DISTINCT lor.relationship_cd
198: FROM igf_sl_lor_all lor
199: ,igf_sl_loans_all loans
200: ,igf_aw_award_all awd
201: ,igf_aw_fund_mast_all fmast
202: ,igf_sl_cl_recipient recip
203: WHERE loans.loan_id = lor.loan_id
204: AND loans.loan_chg_status = cp_c_loan_chg_status
205: AND awd.award_id = loans.award_id

Line 220: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;

216: l_v_cal_type igs_ca_inst_all.cal_type%TYPE;
217: l_n_sequence_number igs_ca_inst_all.sequence_number%TYPE;
218: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
219: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
220: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
221: l_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
222: l_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE;
223: l_v_school_id igf_sl_school_codes_v.alternate_identifier%TYPE;
224: l_v_media_type igf_lookups_view.lookup_code%TYPE;

Line 230: l_v_fund_desc igf_aw_fund_mast_all.description%TYPE;

226: l_v_non_ed_branch igf_lookups_view.lookup_code%TYPE;
227:
228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
229: l_v_alt_code igs_ca_inst_all.alternate_code%TYPE;
230: l_v_fund_desc igf_aw_fund_mast_all.description%TYPE;
231: l_v_group_cd igs_pe_persid_group_all.group_cd%TYPE;
232: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
233: l_c_flag VARCHAR2(1);
234: l_v_sql VARCHAR2(32767);

Line 969: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

965: PROCEDURE identify_clchsn_dtls
966: (
967: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
968: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
969: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
970: p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
971: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE
972: ) AS
973: ------------------------------------------------------------------

Line 1005: cp_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

1001: AND chdt.status_code ='R';
1002:
1003: CURSOR c_lor_lar (cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1004: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1005: cp_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1006: cp_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1007: cp_n_loan_id IN igf_sl_loans_all.loan_id%TYPE
1008: ) IS
1009: SELECT loans.row_id

Line 1041: ,igf_aw_fund_mast_all fmast

1037: ,clset.cl_version
1038: FROM igf_sl_lor_all lor
1039: ,igf_sl_loans loans
1040: ,igf_aw_award_all awd
1041: ,igf_aw_fund_mast_all fmast
1042: ,igf_aw_fund_cat_all fcat
1043: ,igf_sl_cl_setup_all clset
1044: WHERE ((lor.loan_id = cp_n_loan_id) OR cp_n_loan_id IS NULL)
1045: AND loans.loan_id = lor.loan_id

Line 1339: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

1335: errbuf OUT NOCOPY VARCHAR2,
1336: retcode OUT NOCOPY NUMBER,
1337: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1338: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1339: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1340: p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1341: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
1342: p_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,
1343: p_v_media_type IN igf_lookups_view.lookup_code%TYPE,

Line 1379: cp_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,

1375: -- specific Organization Unit in FFELP Setup override.--
1376: ------------------------------------------------------------------
1377: CURSOR c_recip_dtls( cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1378: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1379: cp_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1380: cp_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1381: cp_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
1382: cp_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,
1383: cp_c_loan_chg_status IN igf_sl_loans_all.loan_chg_status%TYPE,

Line 1531: ,igf_aw_fund_mast_all fmast

1527: ,TRUNC(fabase.coa_f) coa_f
1528: FROM igf_sl_lor_all lor
1529: ,igf_sl_loans_all loans
1530: ,igf_aw_award_all awd
1531: ,igf_aw_fund_mast_all fmast
1532: ,igf_aw_fund_cat_all fcat
1533: ,igf_sl_cl_recipient recip
1534: ,igf_ap_fa_base_rec_all fabase
1535: WHERE lor.relationship_cd = cp_v_relationship_cd

Line 1650: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;

1646: l_v_cal_type igs_ca_inst_all.cal_type%TYPE;
1647: l_n_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1648: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
1649: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1650: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
1651: l_v_school_id igf_sl_school_codes_v.alternate_identifier%TYPE;
1652: l_v_media_type igf_lookups_view.lookup_code%TYPE;
1653: l_v_sch_non_ed_branch igf_sl_school_codes_v.alternate_identifier%TYPE;
1654: l_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE;