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

Line 147: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

143: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_hold_rel_ind.debug','The value pick_setup returned party_id: '||l_party_id);
144: END IF;
145:
146:
147: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN
148: OPEN c_clsetup(g_rel_code,g_party_id);
149: FETCH c_clsetup INTO l_hold_rel_ind;
150: CLOSE c_clsetup;
151: END IF;

Line 225: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

221: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
222: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_cl_auto_late_ind.debug','The value pick_setup returned party_id: '||l_party_id);
223: END IF;
224:
225: IF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN
226: OPEN c_clsetup(g_rel_code,g_party_id);
227: FETCH c_clsetup INTO l_auto_late_disb_ind;
228: CLOSE c_clsetup;
229: END IF;

Line 289: IF igf_sl_gen.chk_dl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

285: BEGIN
286:
287: l_dl_int_rebate := NULL;
288:
289: IF igf_sl_gen.chk_dl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN
290:
291: OPEN c_dlsetup(p_ci_cal_type,p_ci_seq_num);
292: FETCH c_dlsetup INTO l_dl_fee1_staf, l_dl_fee1_plus,l_dl_int_rebate;
293: CLOSE c_dlsetup;

Line 297: IF igf_sl_gen.chk_dl_stafford(p_fed_fund_code) = 'TRUE' THEN

293: CLOSE c_dlsetup;
294:
295: l_dl_int_rebate := NVL(l_dl_int_rebate,0);
296:
297: IF igf_sl_gen.chk_dl_stafford(p_fed_fund_code) = 'TRUE' THEN
298: RETURN NVL(l_dl_fee1_staf,0);
299: ELSIF igf_sl_gen.chk_dl_plus(p_fed_fund_code) = 'TRUE' THEN
300: RETURN NVL(l_dl_fee1_plus,0);
301: END IF;

Line 299: ELSIF igf_sl_gen.chk_dl_plus(p_fed_fund_code) = 'TRUE' THEN

295: l_dl_int_rebate := NVL(l_dl_int_rebate,0);
296:
297: IF igf_sl_gen.chk_dl_stafford(p_fed_fund_code) = 'TRUE' THEN
298: RETURN NVL(l_dl_fee1_staf,0);
299: ELSIF igf_sl_gen.chk_dl_plus(p_fed_fund_code) = 'TRUE' THEN
300: RETURN NVL(l_dl_fee1_plus,0);
301: END IF;
302:
303: ELSIF igf_sl_gen.chk_cl_alt(p_fed_fund_code) = 'TRUE' THEN

Line 303: ELSIF igf_sl_gen.chk_cl_alt(p_fed_fund_code) = 'TRUE' THEN

299: ELSIF igf_sl_gen.chk_dl_plus(p_fed_fund_code) = 'TRUE' THEN
300: RETURN NVL(l_dl_fee1_plus,0);
301: END IF;
302:
303: ELSIF igf_sl_gen.chk_cl_alt(p_fed_fund_code) = 'TRUE' THEN
304:
305: l_rel_code := NULL;
306: l_party_id := NULL;
307: l_person_id := NULL;

Line 333: ELSIF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

329: CLOSE c_clsetup;
330:
331: RETURN NVL(l_cl_alt_fee1,0);
332:
333: ELSIF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN
334:
335: l_rel_code := NULL;
336: l_party_id := NULL;
337: l_person_id := NULL;

Line 454: IF igf_sl_gen.chk_cl_alt(p_fed_fund_code) = 'TRUE' THEN

450: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.get_loan_fee2.debug','The value pick_setup returned party_id: '||l_party_id);
451: END IF;
452:
453:
454: IF igf_sl_gen.chk_cl_alt(p_fed_fund_code) = 'TRUE' THEN
455:
456: OPEN c_clsetup(g_rel_code,g_party_id);
457: FETCH c_clsetup INTO l_cl_fee2,l_cl_alt_fee2;
458: CLOSE c_clsetup;

Line 461: ELSIF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN

457: FETCH c_clsetup INTO l_cl_fee2,l_cl_alt_fee2;
458: CLOSE c_clsetup;
459: RETURN NVL(l_cl_alt_fee2,0);
460:
461: ELSIF igf_sl_gen.chk_cl_fed_fund_code(p_fed_fund_code) = 'TRUE' THEN
462:
463: OPEN c_clsetup(g_rel_code,g_party_id);
464: FETCH c_clsetup INTO l_cl_fee2,l_cl_alt_fee2;
465: CLOSE c_clsetup;

Line 622: IF igf_sl_gen.chk_dl_fed_fund_code(l_get_fed_fund_code.fed_fund_code) = 'TRUE' THEN

618: l_get_fed_fund_code := NULL;
619: OPEN c_get_fed_fund_code(p_award_id);
620: FETCH c_get_fed_fund_code INTO l_get_fed_fund_code;
621: CLOSE c_get_fed_fund_code;
622: IF igf_sl_gen.chk_dl_fed_fund_code(l_get_fed_fund_code.fed_fund_code) = 'TRUE' THEN
623: IF l_loan_status = 'S' OR NVL(l_loan_chg_status,'*') = 'S' THEN
624: RETURN 'TRUE';
625: END IF;
626: RETURN 'FALSE';

Line 628: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_get_fed_fund_code.fed_fund_code) = 'TRUE' THEN

624: RETURN 'TRUE';
625: END IF;
626: RETURN 'FALSE';
627: -- for FFELP loans
628: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_get_fed_fund_code.fed_fund_code) = 'TRUE' THEN
629: -- if the common line release version is 'RELEASE-4' and either of loan
630: -- status or loan change status in Sent or cancelled, NO DML operation should
631: -- be allowed
632: -- if the common line release version is 'RELEASE-5' and loan status

Line 1039: igf_sl_gen.get_associated_org(g_base_id, lv_party_number, g_party_id, lv_module, lv_return_status, lv_msg_data);

1035:
1036: BEGIN
1037:
1038: g_base_id := p_base_id;
1039: igf_sl_gen.get_associated_org(g_base_id, lv_party_number, g_party_id, lv_module, lv_return_status, lv_msg_data);
1040:
1041: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1042: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_award.pick_setup.debug','The value select_org returned : '||g_party_id);
1043: END IF;

Line 1519: l_n_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type => l_v_ci_cal_type,

1515: l_n_ci_sequence_number, l_v_relationship_cd;
1516: CLOSE c_get_loan_details;
1517:
1518: -- Get CL Version#
1519: l_n_cl_version := igf_sl_gen.get_cl_version(p_ci_cal_type => l_v_ci_cal_type,
1520: p_ci_seq_num => l_n_ci_sequence_number,
1521: p_relationship_cd => l_v_relationship_cd,
1522: p_base_id => l_n_base_id);
1523: RETURN l_n_cl_version;