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 IGS_CA_INST_ALL

Line 30: cal_type igs_ca_inst_all.cal_type%TYPE,

26: -------------------------------------------------------------------
27: */
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,

Line 31: sequence_number igs_ca_inst_all.sequence_number%TYPE,

27: */
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,

Line 62: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

58: ) ;
59:
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

Line 63: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

59:
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: );

Line 70: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

66: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE
67: );
68: FUNCTION get_base_id
69: (
70: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
71: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
72: p_n_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
73: )
74: RETURN igf_ap_fa_base_rec_all.base_id%TYPE;

Line 71: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

67: );
68: FUNCTION get_base_id
69: (
70: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
71: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
72: p_n_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
73: )
74: RETURN igf_ap_fa_base_rec_all.base_id%TYPE;
75:

Line 156: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,

152: WHERE pig.group_id = cp_n_person_id_grp;
153:
154: CURSOR c_aw_lookups_view (cp_v_lookup_type igf_lookups_view.lookup_type%TYPE,
155: cp_v_lookup_code igf_lookups_view.lookup_code%TYPE,
156: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
157: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE
158: ) IS
159: SELECT lkups.meaning
160: FROM igf_aw_lookups_view lkups

Line 157: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE

153:
154: CURSOR c_aw_lookups_view (cp_v_lookup_type igf_lookups_view.lookup_type%TYPE,
155: cp_v_lookup_code igf_lookups_view.lookup_code%TYPE,
156: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
157: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE
158: ) IS
159: SELECT lkups.meaning
160: FROM igf_aw_lookups_view lkups
161: WHERE lkups.lookup_type = cp_v_lookup_type

Line 192: CURSOR c_recip_dtls( cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

188: AND alternate_identifier = cp_v_alt_identifier
189: ORDER BY alternate_identifier;
190:
191:
192: CURSOR c_recip_dtls( cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
193: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
194: cp_c_loan_chg_status IN igf_sl_loans_all.loan_chg_status%TYPE,
195: cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE
196: ) IS

Line 193: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

189: ORDER BY alternate_identifier;
190:
191:
192: CURSOR c_recip_dtls( cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
193: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
194: cp_c_loan_chg_status IN igf_sl_loans_all.loan_chg_status%TYPE,
195: cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE
196: ) IS
197: SELECT DISTINCT lor.relationship_cd

Line 216: l_v_cal_type igs_ca_inst_all.cal_type%TYPE;

212:
213: TYPE ref_CurpersongrpTyp IS REF CURSOR;
214: c_dyn_person_grp ref_CurpersongrpTyp;
215:
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;

Line 217: l_n_sequence_number igs_ca_inst_all.sequence_number%TYPE;

213: TYPE ref_CurpersongrpTyp IS REF CURSOR;
214: c_dyn_person_grp ref_CurpersongrpTyp;
215:
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;

Line 229: l_v_alt_code igs_ca_inst_all.alternate_code%TYPE;

225: l_v_sch_non_ed_branch igf_sl_school_codes_v.alternate_identifier%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);

Line 724: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

720: END log_parameters;
721:
722: FUNCTION get_base_id
723: (
724: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
725: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
726: p_n_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
727: ) RETURN igf_ap_fa_base_rec_all.base_id%TYPE AS
728: ------------------------------------------------------------------

Line 725: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

721:
722: FUNCTION get_base_id
723: (
724: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
725: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
726: p_n_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
727: ) RETURN igf_ap_fa_base_rec_all.base_id%TYPE AS
728: ------------------------------------------------------------------
729: --Created by : Sanil Madathil, Oracle IDC

Line 747: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,

743: --Change History:
744: --Who When What
745: ------------------------------------------------------------------
746: CURSOR c_ap_fa_base_rec (cp_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
747: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
748: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE
749: ) IS
750: SELECT base_id
751: FROM igf_ap_fa_base_rec_all fabase

Line 748: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE

744: --Who When What
745: ------------------------------------------------------------------
746: CURSOR c_ap_fa_base_rec (cp_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
747: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
748: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE
749: ) IS
750: SELECT base_id
751: FROM igf_ap_fa_base_rec_all fabase
752: WHERE fabase.person_id = cp_n_person_id

Line 967: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

963: END validate_cl_lar;
964:
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

Line 968: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

964:
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

Line 1003: CURSOR c_lor_lar (cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

999: FROM igf_sl_clchsn_dtls chdt
1000: WHERE chdt.loan_number_txt = cp_v_loan_number
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

Line 1004: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1000: WHERE chdt.loan_number_txt = cp_v_loan_number
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

Line 1337: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1333:
1334: PROCEDURE sub_create_file(
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,

Line 1338: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1334: PROCEDURE sub_create_file(
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,

Line 1377: CURSOR c_recip_dtls( cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1373: -- this function has been changed so that it takes
1374: -- into account any overriding CL version for a
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,

Line 1378: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1374: -- into account any overriding CL version for a
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,

Line 1646: l_v_cal_type igs_ca_inst_all.cal_type%TYPE;

1642:
1643: rec_c_sl_lor_loc c_sl_lor_loc%ROWTYPE;
1644:
1645: -- input variables for this procedure
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;

Line 1647: l_n_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1643: rec_c_sl_lor_loc c_sl_lor_loc%ROWTYPE;
1644:
1645: -- input variables for this procedure
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;

Line 1656: l_v_alt_code igs_ca_inst_all.alternate_code%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;
1655:
1656: l_v_alt_code igs_ca_inst_all.alternate_code%TYPE;
1657:
1658: -- variables for change send header record
1659: l_v_chg_header_rec VARCHAR2(1000);
1660: l_v_file_ident_code igf_sl_cl_file_type.file_ident_code%TYPE;