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_UNIT

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 535: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;

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 *
539: FROM igf_aw_fund_tp_v ftp

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 563: FROM igf_sp_unit

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;
566:
567: l_c_igf_sp_unit c_igf_sp_unit%ROWTYPE;

Line 567: l_c_igf_sp_unit c_igf_sp_unit%ROWTYPE;

563: FROM igf_sp_unit
564: WHERE fee_cls_prg_id = cp_fee_cls_prg_id
565: ORDER BY fee_cls_unit_id;
566:
567: l_c_igf_sp_unit c_igf_sp_unit%ROWTYPE;
568: -- cursor variable for c_igf_aw_cal_rel
569: l_c_igf_aw_cal_rel c_igf_aw_cal_rel%ROWTYPE;
570: -- cursor variable for c_igf_aw_fund_mast
571: l_c_igf_aw_fund_mast c_igf_aw_fund_mast%ROWTYPE;

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 895: l_msg_str_1 := RPAD(l_c_igf_sp_unit.unit_cd,12) ||

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) ||
897: TO_CHAR(l_c_igf_sp_unit.max_amount);
898: fnd_file.put_line(fnd_file.log,l_msg_str_1);
899: l_rowid := NULL;

Line 896: RPAD(l_c_igf_sp_unit.version_number,16) ||

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) ||
897: TO_CHAR(l_c_igf_sp_unit.max_amount);
898: fnd_file.put_line(fnd_file.log,l_msg_str_1);
899: l_rowid := NULL;
900: l_fee_cls_unit_id := NULL;

Line 897: TO_CHAR(l_c_igf_sp_unit.max_amount);

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) ||
897: TO_CHAR(l_c_igf_sp_unit.max_amount);
898: fnd_file.put_line(fnd_file.log,l_msg_str_1);
899: l_rowid := NULL;
900: l_fee_cls_unit_id := NULL;
901: BEGIN

Line 903: igf_sp_unit_pkg.insert_row (

899: l_rowid := NULL;
900: l_fee_cls_unit_id := NULL;
901: BEGIN
902: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
903: igf_sp_unit_pkg.insert_row (
904: x_mode => 'R',
905: x_rowid => l_rowid,
906: x_fee_cls_unit_id => l_fee_cls_unit_id,
907: x_fee_cls_prg_id => l_fee_cls_prg_id,

Line 908: x_unit_cd => l_c_igf_sp_unit.unit_cd,

904: x_mode => 'R',
905: x_rowid => l_rowid,
906: x_fee_cls_unit_id => l_fee_cls_unit_id,
907: x_fee_cls_prg_id => l_fee_cls_prg_id,
908: x_unit_cd => l_c_igf_sp_unit.unit_cd,
909: x_version_number => l_c_igf_sp_unit.version_number,
910: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_unit.max_amount)
911: );
912: EXCEPTION

Line 909: x_version_number => l_c_igf_sp_unit.version_number,

905: x_rowid => l_rowid,
906: x_fee_cls_unit_id => l_fee_cls_unit_id,
907: x_fee_cls_prg_id => l_fee_cls_prg_id,
908: x_unit_cd => l_c_igf_sp_unit.unit_cd,
909: x_version_number => l_c_igf_sp_unit.version_number,
910: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_unit.max_amount)
911: );
912: EXCEPTION
913: WHEN OTHERS THEN

Line 910: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_unit.max_amount)

906: x_fee_cls_unit_id => l_fee_cls_unit_id,
907: x_fee_cls_prg_id => l_fee_cls_prg_id,
908: x_unit_cd => l_c_igf_sp_unit.unit_cd,
909: x_version_number => l_c_igf_sp_unit.version_number,
910: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_unit.max_amount)
911: );
912: EXCEPTION
913: WHEN OTHERS THEN
914: -- rolls back to the save point

Line 1038: l_fee_cls_unit_id igf_sp_unit_all.fee_cls_unit_id%TYPE;

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;
1042: -- cursor variable for c_igf_aw_cal_rel