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_SL_LOANS

Line 37: loan_id igf_sl_loans_all.loan_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,
38: loan_number igf_sl_loans_all.loan_number%TYPE,
39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,

Line 38: loan_number igf_sl_loans_all.loan_number%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,
38: loan_number igf_sl_loans_all.loan_number%TYPE,
39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,

Line 39: loan_status igf_sl_loans_all.loan_status%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,
38: loan_number igf_sl_loans_all.loan_number%TYPE,
39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,

Line 40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,

36: award_id igf_aw_award_all.award_id%TYPE,
37: loan_id igf_sl_loans_all.loan_id%TYPE,
38: loan_number igf_sl_loans_all.loan_number%TYPE,
39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,

Line 41: loan_active igf_sl_loans_all.active%TYPE,

37: loan_id igf_sl_loans_all.loan_id%TYPE,
38: loan_number igf_sl_loans_all.loan_number%TYPE,
39: loan_status igf_sl_loans_all.loan_status%TYPE,
40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,

Line 44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,

40: loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE,
41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,
46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,
47: prc_type_code igf_sl_lor_all.prc_type_code%TYPE,
48: cl_version igf_sl_cl_setup_all.cl_version%TYPE

Line 45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,

41: loan_active igf_sl_loans_all.active%TYPE,
42: anticip_compl_date igf_sl_lor_all.anticip_compl_date%TYPE,
43: sch_cert_date igf_sl_lor_all.sch_cert_date%TYPE,
44: loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
45: loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE,
46: cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE,
47: prc_type_code igf_sl_lor_all.prc_type_code%TYPE,
48: cl_version igf_sl_cl_setup_all.cl_version%TYPE
49: );

Line 66: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE

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
69: (
70: p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 81: PROCEDURE proc_update_loan_rec(p_loan_rec igf_sl_loans%ROWTYPE);

77: RETURN hz_parties.party_number%TYPE;
78:
79: FUNCTION validate_cl_lar (p_rec_lorlar lorlar_recTyp) RETURN BOOLEAN;
80:
81: PROCEDURE proc_update_loan_rec(p_loan_rec igf_sl_loans%ROWTYPE);
82:
83: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,
84: p_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,
85: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE ,

Line 83: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,

79: FUNCTION validate_cl_lar (p_rec_lorlar lorlar_recTyp) RETURN BOOLEAN;
80:
81: PROCEDURE proc_update_loan_rec(p_loan_rec igf_sl_loans%ROWTYPE);
82:
83: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,
84: p_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,
85: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE ,
86: p_v_send_record_txt IN igf_sl_clchsn_dtls.send_record_txt%TYPE
87: );

Line 97: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,

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,
98: p_n_dummy_3 IN NUMBER,
99: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
100: p_v_media_type IN igf_lookups_view.lookup_code%TYPE,
101: p_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE,

Line 141: CURSOR c_igf_sl_loans(cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

137: WHERE fmast.fund_id = cp_n_fund_id;
138:
139: rec_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;
140:
141: CURSOR c_igf_sl_loans(cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
142: SELECT lar.loan_number
143: ,lar.award_id
144: FROM igf_sl_loans_all lar
145: WHERE lar.loan_id = cp_n_loan_id;

Line 144: FROM igf_sl_loans_all lar

140:
141: CURSOR c_igf_sl_loans(cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
142: SELECT lar.loan_number
143: ,lar.award_id
144: FROM igf_sl_loans_all lar
145: WHERE lar.loan_id = cp_n_loan_id;
146:
147: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
148:

Line 147: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;

143: ,lar.award_id
144: FROM igf_sl_loans_all lar
145: WHERE lar.loan_id = cp_n_loan_id;
146:
147: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
148:
149: CURSOR c_person_grp (cp_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE) IS
150: SELECT pig.group_cd
151: FROM igs_pe_persid_group_all pig

Line 194: cp_c_loan_chg_status IN igf_sl_loans_all.loan_chg_status%TYPE,

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
198: FROM igf_sl_lor_all lor

Line 199: ,igf_sl_loans_all loans

195: cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE
196: ) IS
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

Line 218: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;

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;
222: l_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE;

Line 232: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

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);
235: l_v_status VARCHAR2(1);
236: l_v_meaning igf_lookups_view.meaning%TYPE;

Line 289: OPEN c_igf_sl_loans (cp_n_loan_id => l_n_loan_id);

285: CLOSE c_igf_aw_fund_mast;
286:
287: l_v_fund_desc := rec_c_igf_aw_fund_mast.fund_desc;
288:
289: OPEN c_igf_sl_loans (cp_n_loan_id => l_n_loan_id);
290: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
291: CLOSE c_igf_sl_loans;
292:
293: l_v_loan_number := rec_c_igf_sl_loans.loan_number;

Line 290: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;

286:
287: l_v_fund_desc := rec_c_igf_aw_fund_mast.fund_desc;
288:
289: OPEN c_igf_sl_loans (cp_n_loan_id => l_n_loan_id);
290: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
291: CLOSE c_igf_sl_loans;
292:
293: l_v_loan_number := rec_c_igf_sl_loans.loan_number;
294:

Line 291: CLOSE c_igf_sl_loans;

287: l_v_fund_desc := rec_c_igf_aw_fund_mast.fund_desc;
288:
289: OPEN c_igf_sl_loans (cp_n_loan_id => l_n_loan_id);
290: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
291: CLOSE c_igf_sl_loans;
292:
293: l_v_loan_number := rec_c_igf_sl_loans.loan_number;
294:
295: OPEN c_person_grp (cp_n_person_id_grp => l_n_person_id_grp);

Line 293: l_v_loan_number := rec_c_igf_sl_loans.loan_number;

289: OPEN c_igf_sl_loans (cp_n_loan_id => l_n_loan_id);
290: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
291: CLOSE c_igf_sl_loans;
292:
293: l_v_loan_number := rec_c_igf_sl_loans.loan_number;
294:
295: OPEN c_person_grp (cp_n_person_id_grp => l_n_person_id_grp);
296: FETCH c_person_grp INTO l_v_group_cd;
297: CLOSE c_person_grp;

Line 971: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE

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: ------------------------------------------------------------------
974: --Created by : Sanil Madathil, Oracle IDC
975: --Date created: 25 October 2004

Line 996: CURSOR c_sl_clchsn_dtls (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

992: -- For validation of Sch cert date > loan end period
993: --mnade 27-Jan-2005 Added 'G' Filter on the c_lor_lar cursor to avoid picking up
994: -- all loans.
995: ------------------------------------------------------------------
996: CURSOR c_sl_clchsn_dtls (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
997: SELECT chdt.ROWID row_id
998: ,chdt.*
999: FROM igf_sl_clchsn_dtls chdt
1000: WHERE chdt.loan_number_txt = cp_v_loan_number

Line 1007: cp_n_loan_id IN igf_sl_loans_all.loan_id%TYPE

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
1010: ,loans.loan_id
1011: ,loans.award_id

Line 1039: ,igf_sl_loans loans

1035: ,fmast.discontinue_fund
1036: ,fcat.fed_fund_code
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

Line 1065: rec_sl_loans igf_sl_loans%ROWTYPE;

1061: AND fabase.ci_sequence_number = fmast.ci_sequence_number
1062: );
1063:
1064: rec_c_lor_lar c_lor_lar%ROWTYPE;
1065: rec_sl_loans igf_sl_loans%ROWTYPE;
1066: l_rec_lorlar lorlar_recTyp;
1067:
1068: l_b_return_status BOOLEAN;
1069: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 1280: PROCEDURE proc_update_loan_rec(p_loan_rec igf_sl_loans%ROWTYPE) AS

1276: END LOOP;
1277: END identify_clchsn_dtls;
1278:
1279:
1280: PROCEDURE proc_update_loan_rec(p_loan_rec igf_sl_loans%ROWTYPE) AS
1281: ------------------------------------------------------------------
1282: --Created by : Sanil Madathil, Oracle IDC
1283: --Date created: 25 October 2004
1284: --

Line 1297: l_loan_rec igf_sl_loans%ROWTYPE;

1293: --
1294: --Change History:
1295: --Who When What
1296: ------------------------------------------------------------------
1297: l_loan_rec igf_sl_loans%ROWTYPE;
1298: BEGIN
1299: log_to_fnd(p_v_module => 'proc_update_loan_rec',
1300: p_v_string => ' Entered Procedure proc_update_loan_rec: The input parameters are '||
1301: ' p_loan_rec.loan_id : ' ||p_loan_rec.loan_id ||

Line 1308: igf_sl_loans_pkg.update_row (

1304: l_loan_rec := p_loan_rec;
1305:
1306: -- parameter x_called_from would not be passed as no change record processing is
1307: -- required while updating the loans table through this process
1308: igf_sl_loans_pkg.update_row (
1309: x_rowid => l_loan_rec.row_id ,
1310: x_loan_id => l_loan_rec.loan_id ,
1311: x_award_id => l_loan_rec.award_id ,
1312: x_seq_num => l_loan_rec.seq_num ,

Line 1341: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,

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,
1344: p_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE,
1345: p_v_sch_non_ed_branch IN igf_sl_school_codes_v.alternate_identifier%TYPE

Line 1381: cp_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,

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,
1384: cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE
1385: ) IS

Line 1383: cp_c_loan_chg_status IN igf_sl_loans_all.loan_chg_status%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,
1384: cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE
1385: ) IS
1386: SELECT recip.rcpt_id
1387: ,recip.lender_id

Line 1529: ,igf_sl_loans_all loans

1525: ,fcat.fed_fund_code
1526: ,fabase.person_id student_id
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

Line 1589: CURSOR c_sl_clchsn_dtls (cp_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) IS

1585: FROM igf_sl_servicer
1586: WHERE servicer_id = cp_n_recipient_id
1587: AND enabled = 'Y';
1588:
1589: CURSOR c_sl_clchsn_dtls (cp_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) IS
1590: SELECT chdt.ROWID row_id
1591: ,chdt.*
1592: FROM igf_sl_clchsn_dtls chdt
1593: WHERE chdt.loan_number_txt = cp_v_loan_number

Line 1635: CURSOR c_sl_lor_loc (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE ,

1631: WHERE awd.base_id = cp_n_base_id
1632: AND awd.award_id <> cp_n_award_id
1633: AND (awd.award_status IN (cp_awd_status_1,cp_awd_status_2));
1634:
1635: CURSOR c_sl_lor_loc (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE ,
1636: cp_n_origination_id igf_sl_lor_all.origination_id%TYPE
1637: ) IS
1638: SELECT lorloc.*, lorloc.ROWID row_id
1639: FROM igf_sl_lor_loc_all lorloc

Line 1648: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;

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;
1652: l_v_media_type igf_lookups_view.lookup_code%TYPE;

Line 1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;

1693: l_v_loan_type igf_aw_fund_cat_all.fed_fund_code%TYPE;
1694: l_v_alt_prog_type_code igf_sl_lor_all.alt_prog_type_code%TYPE;
1695: c_student_dtls igf_sl_gen.person_dtl_cur;
1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1699: l_d_old_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1700: l_d_old_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1701: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;

Line 1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;

1694: l_v_alt_prog_type_code igf_sl_lor_all.alt_prog_type_code%TYPE;
1695: c_student_dtls igf_sl_gen.person_dtl_cur;
1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1699: l_d_old_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1700: l_d_old_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1701: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
1702:

Line 1699: l_d_old_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;

1695: c_student_dtls igf_sl_gen.person_dtl_cur;
1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1699: l_d_old_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1700: l_d_old_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1701: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
1702:
1703: -- variables for (@1-08)

Line 1700: l_d_old_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;

1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1699: l_d_old_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1700: l_d_old_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1701: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
1702:
1703: -- variables for (@1-08)
1704: l_v_chg_01_8_rec VARCHAR2(4000);

Line 2933: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,

2929: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
2930: igs_ge_msg_stack.conc_exception_hndl;
2931: END sub_create_file;
2932:
2933: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,
2934: p_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,
2935: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE ,
2936: p_v_send_record_txt IN igf_sl_clchsn_dtls.send_record_txt%TYPE
2937: ) AS

Line 2956: CURSOR c_sl_clchsn_dtls (cp_v_loan_number IN igf_sl_loans_all.loan_number%TYPE ,

2952: --
2953: --Change History:
2954: --Who When What
2955: ------------------------------------------------------------------
2956: CURSOR c_sl_clchsn_dtls (cp_v_loan_number IN igf_sl_loans_all.loan_number%TYPE ,
2957: cp_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,
2958: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
2959: ) IS
2960: SELECT chdt.ROWID row_id

Line 2971: l_v_loan_number igf_sl_loans.loan_number%TYPE ;

2967: ORDER BY loan_number_txt,change_record_type_txt,disbursement_number;
2968:
2969: rec_c_sl_clchsn_dtls c_sl_clchsn_dtls%ROWTYPE;
2970:
2971: l_v_loan_number igf_sl_loans.loan_number%TYPE ;
2972: l_v_change_record_typ igf_sl_clchsn_dtls.change_record_type_txt%TYPE ;
2973: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE ;
2974: l_v_send_record_txt igf_sl_clchsn_dtls.send_record_txt%TYPE ;
2975: BEGIN