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.

[Home] [Help]

APPS.IGF_SL_LAR_CREATION dependencies on IGF_SL_CL_SETUP

Line 132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;

128: -- FA 134
129:
130: award_rec igf_aw_award_v%ROWTYPE;
131: dl_setup_rec igf_sl_dl_setup_all%ROWTYPE;
132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;

Line 1544: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

1540: lv_anticipated_compl_date DATE;
1541: lv_row_id ROWID;
1542:
1543: ln_cur_loan_id igf_sl_loans.loan_id%TYPE;
1544: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
1545: l_party_id igf_sl_cl_setup.party_id%TYPE;
1546: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
1547: l_loan_status VARCHAR2(30);
1548:

Line 1545: l_party_id igf_sl_cl_setup.party_id%TYPE;

1541: lv_row_id ROWID;
1542:
1543: ln_cur_loan_id igf_sl_loans.loan_id%TYPE;
1544: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
1545: l_party_id igf_sl_cl_setup.party_id%TYPE;
1546: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
1547: l_loan_status VARCHAR2(30);
1548:
1549:

Line 1564: cp_cal_type igf_sl_cl_setup_v.ci_cal_type%TYPE,

1560: l_get_base_id c_get_base_id%ROWTYPE;
1561:
1562: -- cursor to get the loan details from the current FFELP set up used by the student
1563: CURSOR c_clsetup (
1564: cp_cal_type igf_sl_cl_setup_v.ci_cal_type%TYPE,
1565: cp_seq_number igf_sl_cl_setup_v.ci_sequence_number%TYPE,
1566: cp_rel_code igf_sl_cl_setup_v.relationship_cd%TYPE,
1567: cp_party_id igf_sl_cl_setup.party_id%TYPE
1568: ) IS

Line 1565: cp_seq_number igf_sl_cl_setup_v.ci_sequence_number%TYPE,

1561:
1562: -- cursor to get the loan details from the current FFELP set up used by the student
1563: CURSOR c_clsetup (
1564: cp_cal_type igf_sl_cl_setup_v.ci_cal_type%TYPE,
1565: cp_seq_number igf_sl_cl_setup_v.ci_sequence_number%TYPE,
1566: cp_rel_code igf_sl_cl_setup_v.relationship_cd%TYPE,
1567: cp_party_id igf_sl_cl_setup.party_id%TYPE
1568: ) IS
1569: SELECT *

Line 1566: cp_rel_code igf_sl_cl_setup_v.relationship_cd%TYPE,

1562: -- cursor to get the loan details from the current FFELP set up used by the student
1563: CURSOR c_clsetup (
1564: cp_cal_type igf_sl_cl_setup_v.ci_cal_type%TYPE,
1565: cp_seq_number igf_sl_cl_setup_v.ci_sequence_number%TYPE,
1566: cp_rel_code igf_sl_cl_setup_v.relationship_cd%TYPE,
1567: cp_party_id igf_sl_cl_setup.party_id%TYPE
1568: ) IS
1569: SELECT *
1570: FROM igf_sl_cl_setup_all

Line 1567: cp_party_id igf_sl_cl_setup.party_id%TYPE

1563: CURSOR c_clsetup (
1564: cp_cal_type igf_sl_cl_setup_v.ci_cal_type%TYPE,
1565: cp_seq_number igf_sl_cl_setup_v.ci_sequence_number%TYPE,
1566: cp_rel_code igf_sl_cl_setup_v.relationship_cd%TYPE,
1567: cp_party_id igf_sl_cl_setup.party_id%TYPE
1568: ) IS
1569: SELECT *
1570: FROM igf_sl_cl_setup_all
1571: WHERE ci_cal_type = cp_cal_type

Line 1570: FROM igf_sl_cl_setup_all

1566: cp_rel_code igf_sl_cl_setup_v.relationship_cd%TYPE,
1567: cp_party_id igf_sl_cl_setup.party_id%TYPE
1568: ) IS
1569: SELECT *
1570: FROM igf_sl_cl_setup_all
1571: WHERE ci_cal_type = cp_cal_type
1572: AND ci_sequence_number = cp_seq_number
1573: AND relationship_cd = cp_rel_code
1574: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);

Line 1682: -- get the deatils from the igf_sl_cl_setup table for this relationship code and party id

1678: fnd_file.put_line(fnd_file.log,fnd_message.get);
1679: RAISE SKIP_THIS_RECORD;
1680: END IF;
1681:
1682: -- get the deatils from the igf_sl_cl_setup table for this relationship code and party id
1683: -- c_clsetup_rec := NULL;
1684: OPEN c_clsetup(p_cal_type,p_sequence_number,l_rel_code,l_party_id);
1685: FETCH c_clsetup INTO c_clsetup_rec;
1686: CLOSE c_clsetup;

Line 2060: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

2056:
2057: l_cur_borrower_rec cur_borrower_id%ROWTYPE;
2058: l_cur_fa_rec cur_fa_mapping%ROWTYPE;
2059: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
2060: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
2061: l_party_id igf_sl_cl_setup.party_id%TYPE;
2062: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;
2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;

Line 2061: l_party_id igf_sl_cl_setup.party_id%TYPE;

2057: l_cur_borrower_rec cur_borrower_id%ROWTYPE;
2058: l_cur_fa_rec cur_fa_mapping%ROWTYPE;
2059: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
2060: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
2061: l_party_id igf_sl_cl_setup.party_id%TYPE;
2062: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
2063: alien_dtl_cur igf_sl_gen.person_dtl_cur;
2064: alien_dtl_rec igf_sl_gen.person_dtl_rec;
2065:

Line 3187: FROM igf_sl_cl_setup_all

3183: AND ci_sequence_number = p_ci_sequence_number;
3184:
3185: CURSOR cur_cl_setup IS
3186: SELECT *
3187: FROM igf_sl_cl_setup_all
3188: WHERE ci_cal_type = p_ci_cal_type
3189: AND ci_sequence_number = p_ci_sequence_number;
3190:
3191: --Cursor to get the alternate code for the calendar instance