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_PRG

Line 512: -- igf_sp_prg, igf_sp_unit are now rounded off to currency precision

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.
516: -- Modified TBH call due to the addition of new

Line 534: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;

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
538: SELECT *

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 555: FROM igf_sp_prg

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;
558:
559: l_c_igf_sp_prg c_igf_sp_prg%ROWTYPE;

Line 559: l_c_igf_sp_prg c_igf_sp_prg%ROWTYPE;

555: FROM igf_sp_prg
556: WHERE fee_cls_id = cp_fee_cls_id
557: ORDER BY fee_cls_prg_id;
558:
559: l_c_igf_sp_prg c_igf_sp_prg%ROWTYPE;
560:
561: CURSOR c_igf_sp_unit(cp_fee_cls_prg_id igf_sp_prg.fee_cls_prg_id%TYPE) IS
562: SELECT *
563: FROM igf_sp_unit

Line 561: CURSOR c_igf_sp_unit(cp_fee_cls_prg_id igf_sp_prg.fee_cls_prg_id%TYPE) IS

557: ORDER BY fee_cls_prg_id;
558:
559: l_c_igf_sp_prg c_igf_sp_prg%ROWTYPE;
560:
561: CURSOR c_igf_sp_unit(cp_fee_cls_prg_id igf_sp_prg.fee_cls_prg_id%TYPE) IS
562: SELECT *
563: FROM igf_sp_unit
564: WHERE fee_cls_prg_id = cp_fee_cls_prg_id
565: ORDER BY fee_cls_unit_id;

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 856: l_msg_str_1 := RPAD(l_c_igf_sp_prg.course_cd,12) ||

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) ||
858: NVL(RPAD(TO_CHAR(l_c_igf_sp_prg.fee_percent),10),' ') ||
859: TO_CHAR(l_c_igf_sp_prg.max_amount);
860: fnd_file.put_line(fnd_file.log,l_msg_str_1);

Line 857: RPAD(l_c_igf_sp_prg.version_number,16) ||

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) ||
858: NVL(RPAD(TO_CHAR(l_c_igf_sp_prg.fee_percent),10),' ') ||
859: TO_CHAR(l_c_igf_sp_prg.max_amount);
860: fnd_file.put_line(fnd_file.log,l_msg_str_1);
861: l_rowid := NULL;

Line 858: NVL(RPAD(TO_CHAR(l_c_igf_sp_prg.fee_percent),10),' ') ||

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) ||
858: NVL(RPAD(TO_CHAR(l_c_igf_sp_prg.fee_percent),10),' ') ||
859: TO_CHAR(l_c_igf_sp_prg.max_amount);
860: fnd_file.put_line(fnd_file.log,l_msg_str_1);
861: l_rowid := NULL;
862: l_fee_cls_prg_id := NULL;

Line 859: TO_CHAR(l_c_igf_sp_prg.max_amount);

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) ||
858: NVL(RPAD(TO_CHAR(l_c_igf_sp_prg.fee_percent),10),' ') ||
859: TO_CHAR(l_c_igf_sp_prg.max_amount);
860: fnd_file.put_line(fnd_file.log,l_msg_str_1);
861: l_rowid := NULL;
862: l_fee_cls_prg_id := NULL;
863: BEGIN

Line 865: igf_sp_prg_pkg.insert_row (

861: l_rowid := NULL;
862: l_fee_cls_prg_id := NULL;
863: BEGIN
864: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
865: igf_sp_prg_pkg.insert_row (
866: x_mode => 'R',
867: x_rowid => l_rowid,
868: x_fee_cls_prg_id => l_fee_cls_prg_id,
869: x_fee_cls_id => l_fee_cls_id,

Line 870: x_course_cd => l_c_igf_sp_prg.course_cd,

866: x_mode => 'R',
867: x_rowid => l_rowid,
868: x_fee_cls_prg_id => l_fee_cls_prg_id,
869: x_fee_cls_id => l_fee_cls_id,
870: x_course_cd => l_c_igf_sp_prg.course_cd,
871: x_version_number => l_c_igf_sp_prg.version_number,
872: x_fee_percent => l_c_igf_sp_prg.fee_percent,
873: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)
874: );

Line 871: x_version_number => l_c_igf_sp_prg.version_number,

867: x_rowid => l_rowid,
868: x_fee_cls_prg_id => l_fee_cls_prg_id,
869: x_fee_cls_id => l_fee_cls_id,
870: x_course_cd => l_c_igf_sp_prg.course_cd,
871: x_version_number => l_c_igf_sp_prg.version_number,
872: x_fee_percent => l_c_igf_sp_prg.fee_percent,
873: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)
874: );
875: EXCEPTION

Line 872: x_fee_percent => l_c_igf_sp_prg.fee_percent,

868: x_fee_cls_prg_id => l_fee_cls_prg_id,
869: x_fee_cls_id => l_fee_cls_id,
870: x_course_cd => l_c_igf_sp_prg.course_cd,
871: x_version_number => l_c_igf_sp_prg.version_number,
872: x_fee_percent => l_c_igf_sp_prg.fee_percent,
873: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)
874: );
875: EXCEPTION
876: WHEN OTHERS THEN

Line 873: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)

869: x_fee_cls_id => l_fee_cls_id,
870: x_course_cd => l_c_igf_sp_prg.course_cd,
871: x_version_number => l_c_igf_sp_prg.version_number,
872: x_fee_percent => l_c_igf_sp_prg.fee_percent,
873: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_prg.max_amount)
874: );
875: EXCEPTION
876: WHEN OTHERS THEN
877: -- rolls back to the save point

Line 892: FOR l_c_igf_sp_unit IN c_igf_sp_unit(cp_fee_cls_prg_id => l_c_igf_sp_prg.fee_cls_prg_id)

888: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
889: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
890: fnd_file.put_line(fnd_file.log,l_msg_str_0);
891: fnd_file.put_line(fnd_file.log,' ');
892: FOR l_c_igf_sp_unit IN c_igf_sp_unit(cp_fee_cls_prg_id => l_c_igf_sp_prg.fee_cls_prg_id)
893: LOOP
894: -- log relevant details
895: l_msg_str_1 := RPAD(l_c_igf_sp_unit.unit_cd,12) ||
896: RPAD(l_c_igf_sp_unit.version_number,16) ||

Line 1021: CURSOR c_igf_sp_std_unit(cp_fee_cls_prg_id igf_sp_prg.fee_cls_prg_id%TYPE) IS

1017: WHERE fee_cls_id = cp_fee_cls_id;
1018:
1019: l_c_igf_sp_std_prg c_igf_sp_std_prg%ROWTYPE;
1020:
1021: CURSOR c_igf_sp_std_unit(cp_fee_cls_prg_id igf_sp_prg.fee_cls_prg_id%TYPE) IS
1022: SELECT *
1023: FROM igf_sp_std_unit
1024: WHERE fee_cls_prg_id = cp_fee_cls_prg_id;
1025:

Line 1037: l_fee_cls_prg_id igf_sp_prg_all.fee_cls_prg_id%TYPE;

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;
1041: l_ans BOOLEAN := TRUE;