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_STD_PRG

Line 959: -- igf_sp_std_prg, igf_sp_std_unit are now rounded off to currency precision

955: -- log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted. This new message
956: -- will be logged when user tries to rollover Sponsor-student relation and the
957: -- associated term calendar mapping does not exist for the destination award year.
958: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_sp_stdnt_rel, igf_sp_std_fc,
959: -- igf_sp_std_prg, igf_sp_std_unit are now rounded off to currency precision
960: --vvutukur 07-Mar-2003 Bug#2822725. Removed parameters p_cal_type,p_sequence_number and from the cursor c_igf_aw_fund_mast usage also.
961: ------------------------------------------------------------------
962: -- cursor to select fund code from igf_aw_fund_mast to get fund code for fund id parameter
963: CURSOR c_fund_mast(cp_fund_code igf_aw_fund_mast.fund_code%TYPE,

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 1016: FROM igf_sp_std_prg

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:
1019: l_c_igf_sp_std_prg c_igf_sp_std_prg%ROWTYPE;
1020:

Line 1019: l_c_igf_sp_std_prg c_igf_sp_std_prg%ROWTYPE;

1015: SELECT *
1016: FROM igf_sp_std_prg
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

Line 1253: FOR l_c_igf_sp_std_prg IN c_igf_sp_std_prg(cp_fee_cls_id => l_c_igf_sp_std_fc.fee_cls_id)

1249: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1250: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1251: fnd_file.put_line(fnd_file.log,' ');
1252: -- rolling over program details
1253: FOR l_c_igf_sp_std_prg IN c_igf_sp_std_prg(cp_fee_cls_id => l_c_igf_sp_std_fc.fee_cls_id)
1254: LOOP
1255: -- log relevant details
1256: l_msg_str_1 := RPAD(l_c_igf_sp_std_prg.course_cd,12) ||
1257: RPAD(l_c_igf_sp_std_prg.version_number,16) ||

Line 1256: l_msg_str_1 := RPAD(l_c_igf_sp_std_prg.course_cd,12) ||

1252: -- rolling over program details
1253: FOR l_c_igf_sp_std_prg IN c_igf_sp_std_prg(cp_fee_cls_id => l_c_igf_sp_std_fc.fee_cls_id)
1254: LOOP
1255: -- log relevant details
1256: l_msg_str_1 := RPAD(l_c_igf_sp_std_prg.course_cd,12) ||
1257: RPAD(l_c_igf_sp_std_prg.version_number,16) ||
1258: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_prg.fee_percent),10),' ') ||
1259: TO_CHAR(l_c_igf_sp_std_prg.max_amount);
1260: fnd_file.put_line(fnd_file.log,l_msg_str_1);

Line 1257: RPAD(l_c_igf_sp_std_prg.version_number,16) ||

1253: FOR l_c_igf_sp_std_prg IN c_igf_sp_std_prg(cp_fee_cls_id => l_c_igf_sp_std_fc.fee_cls_id)
1254: LOOP
1255: -- log relevant details
1256: l_msg_str_1 := RPAD(l_c_igf_sp_std_prg.course_cd,12) ||
1257: RPAD(l_c_igf_sp_std_prg.version_number,16) ||
1258: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_prg.fee_percent),10),' ') ||
1259: TO_CHAR(l_c_igf_sp_std_prg.max_amount);
1260: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1261: l_fee_cls_prg_id := NULL;

Line 1258: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_prg.fee_percent),10),' ') ||

1254: LOOP
1255: -- log relevant details
1256: l_msg_str_1 := RPAD(l_c_igf_sp_std_prg.course_cd,12) ||
1257: RPAD(l_c_igf_sp_std_prg.version_number,16) ||
1258: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_prg.fee_percent),10),' ') ||
1259: TO_CHAR(l_c_igf_sp_std_prg.max_amount);
1260: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1261: l_fee_cls_prg_id := NULL;
1262: l_rowid := NULL;

Line 1259: TO_CHAR(l_c_igf_sp_std_prg.max_amount);

1255: -- log relevant details
1256: l_msg_str_1 := RPAD(l_c_igf_sp_std_prg.course_cd,12) ||
1257: RPAD(l_c_igf_sp_std_prg.version_number,16) ||
1258: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_prg.fee_percent),10),' ') ||
1259: TO_CHAR(l_c_igf_sp_std_prg.max_amount);
1260: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1261: l_fee_cls_prg_id := NULL;
1262: l_rowid := NULL;
1263: BEGIN

Line 1265: igf_sp_std_prg_pkg.insert_row (

1261: l_fee_cls_prg_id := NULL;
1262: l_rowid := NULL;
1263: BEGIN
1264: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1265: igf_sp_std_prg_pkg.insert_row (
1266: x_mode => 'R',
1267: x_rowid => l_rowid,
1268: x_fee_cls_prg_id => l_fee_cls_prg_id,
1269: x_fee_cls_id => l_fee_cls_id,

Line 1270: x_course_cd => l_c_igf_sp_std_prg.course_cd,

1266: x_mode => 'R',
1267: x_rowid => l_rowid,
1268: x_fee_cls_prg_id => l_fee_cls_prg_id,
1269: x_fee_cls_id => l_fee_cls_id,
1270: x_course_cd => l_c_igf_sp_std_prg.course_cd,
1271: x_version_number => l_c_igf_sp_std_prg.version_number,
1272: x_fee_percent => l_c_igf_sp_std_prg.fee_percent,
1273: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)
1274: );

Line 1271: x_version_number => l_c_igf_sp_std_prg.version_number,

1267: x_rowid => l_rowid,
1268: x_fee_cls_prg_id => l_fee_cls_prg_id,
1269: x_fee_cls_id => l_fee_cls_id,
1270: x_course_cd => l_c_igf_sp_std_prg.course_cd,
1271: x_version_number => l_c_igf_sp_std_prg.version_number,
1272: x_fee_percent => l_c_igf_sp_std_prg.fee_percent,
1273: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)
1274: );
1275: EXCEPTION

Line 1272: x_fee_percent => l_c_igf_sp_std_prg.fee_percent,

1268: x_fee_cls_prg_id => l_fee_cls_prg_id,
1269: x_fee_cls_id => l_fee_cls_id,
1270: x_course_cd => l_c_igf_sp_std_prg.course_cd,
1271: x_version_number => l_c_igf_sp_std_prg.version_number,
1272: x_fee_percent => l_c_igf_sp_std_prg.fee_percent,
1273: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)
1274: );
1275: EXCEPTION
1276: WHEN OTHERS THEN

Line 1273: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)

1269: x_fee_cls_id => l_fee_cls_id,
1270: x_course_cd => l_c_igf_sp_std_prg.course_cd,
1271: x_version_number => l_c_igf_sp_std_prg.version_number,
1272: x_fee_percent => l_c_igf_sp_std_prg.fee_percent,
1273: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_prg.max_amount)
1274: );
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: -- rolls back to the save point

Line 1291: FOR l_c_igf_sp_std_unit IN c_igf_sp_std_unit(cp_fee_cls_prg_id => l_c_igf_sp_std_prg.fee_cls_prg_id)

1287: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1288: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1289: fnd_file.put_line(fnd_file.log,' ');
1290: -- rolling over unit details
1291: FOR l_c_igf_sp_std_unit IN c_igf_sp_std_unit(cp_fee_cls_prg_id => l_c_igf_sp_std_prg.fee_cls_prg_id)
1292: LOOP
1293: -- log relevant details
1294: l_msg_str_1 := RPAD(l_c_igf_sp_std_unit.unit_cd,12) ||
1295: RPAD(l_c_igf_sp_std_unit.version_number,16) ||