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_ORIG dependencies on IGF_SL_GEN

Line 43: -- derived from igf_sl_gen.get_person_details.

39: ---------------------------------------------------------------------------------
40: -- veramach 04-May-2004 bug 3603289
41: -- Modified cursor cur_student_licence to select
42: -- dependency_status from ISIR. other details are
43: -- derived from igf_sl_gen.get_person_details.
44: -----------------------------------------------------------------------------------
45: -- ugummall 29-OCT-2003 Bug 3102439. FA 126 - Multiple FA Offices.
46: -- 1. Added 4 new parameters to cl_originate and 3 to sub_cl_originate
47: -- 2. Changed the cursor cur_loan_dtls to include two extra parameters

Line 73: -- derived using igf_sl_gen.get_person_dtls

69: -- chg_batch_id from igf_sl_lor_loc
70: -- 3. Changed cur_recip_dts to take p_loan_status,p_active,p_lookup_type,p_enabled_flag
71: -- as parameters
72: -- 4. Changed cursor cur_loan_dtls not to select student/borrower information. This is
73: -- derived using igf_sl_gen.get_person_dtls
74: ------------------------------------------------------------------------------------------------------------------------------
75: ---------------------------------------------------------------------------------
76: -- gmuralid 03-07-2003 Bug 2995944 - Legacy Part 3 - FFELP Import
77: -- Added legacy record flag as parameter to

Line 362: student_dtl_rec igf_sl_gen.person_dtl_rec;

358: AND lor.relationship_cd = recip.relationship_cd
359: AND lor.relationship_cd = NVL (p_relationship_cd, lor.relationship_cd);
360:
361: loan_rec cur_loan_dtls%ROWTYPE;
362: student_dtl_rec igf_sl_gen.person_dtl_rec;
363: parent_dtl_rec igf_sl_gen.person_dtl_rec;
364:
365: -- Main Procedure starts here and is a Concurrent Program
366:

Line 363: parent_dtl_rec igf_sl_gen.person_dtl_rec;

359: AND lor.relationship_cd = NVL (p_relationship_cd, lor.relationship_cd);
360:
361: loan_rec cur_loan_dtls%ROWTYPE;
362: student_dtl_rec igf_sl_gen.person_dtl_rec;
363: parent_dtl_rec igf_sl_gen.person_dtl_rec;
364:
365: -- Main Procedure starts here and is a Concurrent Program
366:
367: PROCEDURE cl_originate( errbuf OUT NOCOPY VARCHAR2,

Line 1342: student_dtl_cur igf_sl_gen.person_dtl_cur;

1338:
1339: -- Get OPE_ID for the School
1340: -- The cursor here cur_ope_id is removed as we can use parameter p_school_id
1341:
1342: student_dtl_cur igf_sl_gen.person_dtl_cur;
1343: parent_dtl_cur igf_sl_gen.person_dtl_cur;
1344:
1345: -- Cursor to fetch Student License No.,State and Citizenship Status
1346:

Line 1343: parent_dtl_cur igf_sl_gen.person_dtl_cur;

1339: -- Get OPE_ID for the School
1340: -- The cursor here cur_ope_id is removed as we can use parameter p_school_id
1341:
1342: student_dtl_cur igf_sl_gen.person_dtl_cur;
1343: parent_dtl_cur igf_sl_gen.person_dtl_cur;
1344:
1345: -- Cursor to fetch Student License No.,State and Citizenship Status
1346:
1347: CURSOR cur_isir_depend_status

Line 1645: lv_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type, p_ci_sequence_number,loan_rec.relationship_cd,p_base_id);

1641: END IF;
1642:
1643: -- museshad(Bug# 4346258) - Added the parameter p_base_id due to change in the
1644: -- signature of the function 'get_cl_version()'
1645: lv_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type, p_ci_sequence_number,loan_rec.relationship_cd,p_base_id);
1646: lv_file_ident_code := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-CODE');
1647: lv_file_ident_name := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-NAME');
1648:
1649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN

Line 1646: lv_file_ident_code := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-CODE');

1642:
1643: -- museshad(Bug# 4346258) - Added the parameter p_base_id due to change in the
1644: -- signature of the function 'get_cl_version()'
1645: lv_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type, p_ci_sequence_number,loan_rec.relationship_cd,p_base_id);
1646: lv_file_ident_code := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-CODE');
1647: lv_file_ident_name := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-NAME');
1648:
1649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_code:' || lv_file_ident_code);

Line 1647: lv_file_ident_name := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-NAME');

1643: -- museshad(Bug# 4346258) - Added the parameter p_base_id due to change in the
1644: -- signature of the function 'get_cl_version()'
1645: lv_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type, p_ci_sequence_number,loan_rec.relationship_cd,p_base_id);
1646: lv_file_ident_code := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-CODE');
1647: lv_file_ident_name := igf_sl_gen.get_cl_file_type(lv_cl_version, 'CL_ORIG_SEND', 'FILE-IDENT-NAME');
1648:
1649: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1650: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_code:' || lv_file_ident_code);
1651: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'lv_file_ident_name:' || lv_file_ident_name);

Line 1803: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);

1799: CLOSE cur_isir_depend_status;
1800: END IF;
1801:
1802: --Fetch details of student and parent
1803: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
1804: FETCH student_dtl_cur INTO student_dtl_rec;
1805: CLOSE student_dtl_cur;
1806: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
1807: FETCH parent_dtl_cur INTO parent_dtl_rec;

Line 1806: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);

1802: --Fetch details of student and parent
1803: igf_sl_gen.get_person_details(loan_rec.student_id,student_dtl_cur);
1804: FETCH student_dtl_cur INTO student_dtl_rec;
1805: CLOSE student_dtl_cur;
1806: igf_sl_gen.get_person_details(loan_rec.p_person_id,parent_dtl_cur);
1807: FETCH parent_dtl_cur INTO parent_dtl_rec;
1808: CLOSE parent_dtl_cur;
1809:
1810: --FA 161 - Due to the introduction of a new mapping form, we don't use the lookup tag but rather require the lookup_code itself to

Line 1891: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);

1887: lv_p_permt_phone := NULL;
1888: l_phone := NULL;
1889:
1890: --Whether Student or Parent get the Phone Number
1891: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
1892: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
1893:
1894: l_coa := NULL;
1895: l_efc := NULL;

Line 1892: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);

1888: l_phone := NULL;
1889:
1890: --Whether Student or Parent get the Phone Number
1891: lv_s_permt_phone := igf_sl_gen.get_person_phone(loan_rec.student_id);
1892: lv_p_permt_phone := igf_sl_gen.get_person_phone(loan_rec.p_person_id);
1893:
1894: l_coa := NULL;
1895: l_efc := NULL;
1896: l_est_fin := NULL;

Line 2152: IF igf_sl_gen.chk_cl_plus(loan_rec.fed_fund_code)='TRUE' OR igf_sl_gen.chk_cl_gplus(loan_rec.fed_fund_code)='TRUE' THEN

2148: --Based on Federal fund Code Need to Send the information
2149: -- as per the Send File
2150:
2151: --Check if its FLP
2152: IF igf_sl_gen.chk_cl_plus(loan_rec.fed_fund_code)='TRUE' OR igf_sl_gen.chk_cl_gplus(loan_rec.fed_fund_code)='TRUE' THEN
2153:
2154: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2155: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a plus loan');
2156: END IF;

Line 2165: ELSIF igf_sl_gen.chk_cl_alt(loan_rec.fed_fund_code)='TRUE' THEN

2161: l_tot_alt_debt := NULL;
2162: l_borw_ind_code := ' ';
2163: lv_borw_interest_ind := NULL;
2164:
2165: ELSIF igf_sl_gen.chk_cl_alt(loan_rec.fed_fund_code)='TRUE' THEN
2166:
2167: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
2168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.sub_cl_originate.debug', 'Current loan is a alternate loan');
2169: END IF;

Line 2416: IF igf_sl_gen.chk_cl_alt(loan_rec.fed_fund_code) = 'TRUE' THEN

2412: ||lv_seventh_part_trans_rec));
2413: -- Increment the counter for the Number of @1 records in this file
2414: lv_trans_count := lv_trans_count+1;
2415:
2416: IF igf_sl_gen.chk_cl_alt(loan_rec.fed_fund_code) = 'TRUE' THEN
2417: alter_rec := NULL; -- mnade 7-Feb-2005 Bug 4133414
2418: OPEN cur_get_alternate;
2419: FETCH cur_get_alternate INTO alter_rec;
2420: CLOSE cur_get_alternate;