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_SP_ROLLOVER dependencies on IGF_SP_FC

Line 511: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_fund_mast, igf_sp_fc,

507: --gurprsin 31-May-2006 Bug 5213852, Logged the new message 'IGF_SP_NO_FUND_TERM_MAP' and removed the code logic to
508: -- log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted. This new message
509: -- will be logged when user tries to rollover Sponsor setup and the associated term
510: -- calendar mapping does not exist for the destination award year.
511: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_aw_fund_mast, igf_sp_fc,
512: -- igf_sp_prg, igf_sp_unit are now rounded off to currency precision
513: --akandreg 29-Mar-2006 Bug 4765537. Passed appropriate values to parameters x_lock_award_flag,
514: -- x_donot_repkg_if_code ,x_re_pkg_verif_flag of igf_aw_fund_mast_pkg.insert_row
515: --museshad 14-Jul-2005 Build FA 140.

Line 533: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;

529: l_message_name VARCHAR2(30) := NULL;
530: l_err_exception EXCEPTION;
531: l_rowid VARCHAR2(25);
532: l_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
533: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;
534: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;
535: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;
536:
537: CURSOR c_igf_aw_fund_tp( cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

Line 545: CURSOR c_igf_sp_fc(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

541: ORDER BY tp_cal_type,tp_sequence_number;
542:
543: l_c_igf_aw_fund_tp c_igf_aw_fund_tp%ROWTYPE;
544:
545: CURSOR c_igf_sp_fc(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
546: SELECT *
547: FROM igf_sp_fc_v
548: WHERE fund_id = cp_fund_id
549: ORDER BY fee_cls_id;

Line 547: FROM igf_sp_fc_v

543: l_c_igf_aw_fund_tp c_igf_aw_fund_tp%ROWTYPE;
544:
545: CURSOR c_igf_sp_fc(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
546: SELECT *
547: FROM igf_sp_fc_v
548: WHERE fund_id = cp_fund_id
549: ORDER BY fee_cls_id;
550:
551: l_c_igf_sp_fc c_igf_sp_fc%ROWTYPE;

Line 551: l_c_igf_sp_fc c_igf_sp_fc%ROWTYPE;

547: FROM igf_sp_fc_v
548: WHERE fund_id = cp_fund_id
549: ORDER BY fee_cls_id;
550:
551: l_c_igf_sp_fc c_igf_sp_fc%ROWTYPE;
552:
553: CURSOR c_igf_sp_prg(cp_fee_cls_id igf_sp_fc.fee_cls_id%TYPE) IS
554: SELECT *
555: FROM igf_sp_prg

Line 553: CURSOR c_igf_sp_prg(cp_fee_cls_id igf_sp_fc.fee_cls_id%TYPE) IS

549: ORDER BY fee_cls_id;
550:
551: l_c_igf_sp_fc c_igf_sp_fc%ROWTYPE;
552:
553: CURSOR c_igf_sp_prg(cp_fee_cls_id igf_sp_fc.fee_cls_id%TYPE) IS
554: SELECT *
555: FROM igf_sp_prg
556: WHERE fee_cls_id = cp_fee_cls_id
557: ORDER BY fee_cls_prg_id;

Line 813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)

809: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
810: fnd_file.put_line(fnd_file.log,l_msg_str_0);
811: fnd_file.put_line(fnd_file.log,' ');
812: -- rolling over pays only fee class details
813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
814: LOOP
815: -- log relevant details
816: l_msg_str_1 := RPAD(l_c_igf_sp_fc.fee_class,32) ||
817: NVL(RPAD(TO_CHAR(l_c_igf_sp_fc.fee_percent),10),' ' )||

Line 816: l_msg_str_1 := RPAD(l_c_igf_sp_fc.fee_class,32) ||

812: -- rolling over pays only fee class details
813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
814: LOOP
815: -- log relevant details
816: l_msg_str_1 := RPAD(l_c_igf_sp_fc.fee_class,32) ||
817: NVL(RPAD(TO_CHAR(l_c_igf_sp_fc.fee_percent),10),' ' )||
818: TO_CHAR(l_c_igf_sp_fc.max_amount);
819: fnd_file.put_line(fnd_file.log,l_msg_str_1);
820: l_rowid := NULL;

Line 817: NVL(RPAD(TO_CHAR(l_c_igf_sp_fc.fee_percent),10),' ' )||

813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
814: LOOP
815: -- log relevant details
816: l_msg_str_1 := RPAD(l_c_igf_sp_fc.fee_class,32) ||
817: NVL(RPAD(TO_CHAR(l_c_igf_sp_fc.fee_percent),10),' ' )||
818: TO_CHAR(l_c_igf_sp_fc.max_amount);
819: fnd_file.put_line(fnd_file.log,l_msg_str_1);
820: l_rowid := NULL;
821: l_fee_cls_id := NULL;

Line 818: TO_CHAR(l_c_igf_sp_fc.max_amount);

814: LOOP
815: -- log relevant details
816: l_msg_str_1 := RPAD(l_c_igf_sp_fc.fee_class,32) ||
817: NVL(RPAD(TO_CHAR(l_c_igf_sp_fc.fee_percent),10),' ' )||
818: TO_CHAR(l_c_igf_sp_fc.max_amount);
819: fnd_file.put_line(fnd_file.log,l_msg_str_1);
820: l_rowid := NULL;
821: l_fee_cls_id := NULL;
822: BEGIN

Line 824: igf_sp_fc_pkg.insert_row (

820: l_rowid := NULL;
821: l_fee_cls_id := NULL;
822: BEGIN
823: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
824: igf_sp_fc_pkg.insert_row (
825: x_mode => 'R',
826: x_rowid => l_rowid,
827: x_fee_cls_id => l_fee_cls_id,
828: x_fund_id => l_fund_id,

Line 829: x_fee_class => l_c_igf_sp_fc.fee_class,

825: x_mode => 'R',
826: x_rowid => l_rowid,
827: x_fee_cls_id => l_fee_cls_id,
828: x_fund_id => l_fund_id,
829: x_fee_class => l_c_igf_sp_fc.fee_class,
830: x_fee_percent => l_c_igf_sp_fc.fee_percent,
831: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_fc.max_amount)
832: );
833: EXCEPTION

Line 830: x_fee_percent => l_c_igf_sp_fc.fee_percent,

826: x_rowid => l_rowid,
827: x_fee_cls_id => l_fee_cls_id,
828: x_fund_id => l_fund_id,
829: x_fee_class => l_c_igf_sp_fc.fee_class,
830: x_fee_percent => l_c_igf_sp_fc.fee_percent,
831: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_fc.max_amount)
832: );
833: EXCEPTION
834: WHEN OTHERS THEN

Line 831: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_fc.max_amount)

827: x_fee_cls_id => l_fee_cls_id,
828: x_fund_id => l_fund_id,
829: x_fee_class => l_c_igf_sp_fc.fee_class,
830: x_fee_percent => l_c_igf_sp_fc.fee_percent,
831: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_fc.max_amount)
832: );
833: EXCEPTION
834: WHEN OTHERS THEN
835: -- rolls back to the save point

Line 843: IF l_c_igf_sp_fc.fee_class = 'TUITION' THEN

839: fnd_file.put_line(fnd_file.log,fnd_message.get);
840: -- raises user defined exception so as to skip the record
841: RAISE l_err_exception;
842: END;
843: IF l_c_igf_sp_fc.fee_class = 'TUITION' THEN
844: -- rolling over pays program details
845: fnd_file.put_line(fnd_file.log,' ');
846: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','COURSE_CD'),12) ||
847: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||

Line 853: FOR l_c_igf_sp_prg IN c_igf_sp_prg(cp_fee_cls_id => l_c_igf_sp_fc.fee_cls_id)

849: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
850: fnd_file.put_line(fnd_file.log,l_msg_str_0);
851: fnd_file.put_line(fnd_file.log,' ');
852:
853: FOR l_c_igf_sp_prg IN c_igf_sp_prg(cp_fee_cls_id => l_c_igf_sp_fc.fee_cls_id)
854: LOOP
855: -- log relevant details
856: l_msg_str_1 := RPAD(l_c_igf_sp_prg.course_cd,12) ||
857: RPAD(l_c_igf_sp_prg.version_number,16) ||

Line 1014: CURSOR c_igf_sp_std_prg(cp_fee_cls_id igf_sp_fc.fee_cls_id%TYPE) IS

1010: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
1011:
1012: l_c_igf_sp_std_fc c_igf_sp_std_fc%ROWTYPE;
1013:
1014: CURSOR c_igf_sp_std_prg(cp_fee_cls_id igf_sp_fc.fee_cls_id%TYPE) IS
1015: SELECT *
1016: FROM igf_sp_std_prg
1017: WHERE fee_cls_id = cp_fee_cls_id;
1018:

Line 1036: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;

1032: l_stud_exception EXCEPTION;
1033: l_rowid VARCHAR2(25);
1034: l_fund_id igf_aw_fund_mast.fund_id%TYPE;
1035: l_spnsr_stdnt_id igf_sp_stdnt_rel_all.spnsr_stdnt_id%TYPE;
1036: l_fee_cls_id igf_sp_fc_all.fee_cls_id%TYPE;
1037: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;
1038: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;
1039: l_message VARCHAR2(2000) := NULL;
1040: l_base_id igf_ap_fa_base_rec.base_id%TYPE;