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_UNIT

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 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 1023: FROM igf_sp_std_unit

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:
1026: l_c_igf_sp_std_unit c_igf_sp_std_unit%ROWTYPE;
1027:

Line 1026: l_c_igf_sp_std_unit c_igf_sp_std_unit%ROWTYPE;

1022: SELECT *
1023: FROM igf_sp_std_unit
1024: WHERE fee_cls_prg_id = cp_fee_cls_prg_id;
1025:
1026: l_c_igf_sp_std_unit c_igf_sp_std_unit%ROWTYPE;
1027:
1028: l_msg_str_0 VARCHAR2(32767) := NULL;
1029: l_msg_str_1 VARCHAR2(32767) := NULL;
1030: l_message_name VARCHAR2(30) := NULL;

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) ||

Line 1294: l_msg_str_1 := RPAD(l_c_igf_sp_std_unit.unit_cd,12) ||

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) ||
1296: TO_CHAR(l_c_igf_sp_std_unit.max_amount);
1297: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1298: l_fee_cls_unit_id := NULL;

Line 1295: RPAD(l_c_igf_sp_std_unit.version_number,16) ||

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) ||
1296: TO_CHAR(l_c_igf_sp_std_unit.max_amount);
1297: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1298: l_fee_cls_unit_id := NULL;
1299: l_rowid := NULL;

Line 1296: TO_CHAR(l_c_igf_sp_std_unit.max_amount);

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) ||
1296: TO_CHAR(l_c_igf_sp_std_unit.max_amount);
1297: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1298: l_fee_cls_unit_id := NULL;
1299: l_rowid := NULL;
1300: BEGIN

Line 1302: igf_sp_std_unit_pkg.insert_row (

1298: l_fee_cls_unit_id := NULL;
1299: l_rowid := NULL;
1300: BEGIN
1301: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1302: igf_sp_std_unit_pkg.insert_row (
1303: x_mode => 'R',
1304: x_rowid => l_rowid,
1305: x_fee_cls_unit_id => l_fee_cls_unit_id,
1306: x_fee_cls_prg_id => l_fee_cls_prg_id,

Line 1307: x_unit_cd => l_c_igf_sp_std_unit.unit_cd,

1303: x_mode => 'R',
1304: x_rowid => l_rowid,
1305: x_fee_cls_unit_id => l_fee_cls_unit_id,
1306: x_fee_cls_prg_id => l_fee_cls_prg_id,
1307: x_unit_cd => l_c_igf_sp_std_unit.unit_cd,
1308: x_version_number => l_c_igf_sp_std_unit.version_number,
1309: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_unit.max_amount)
1310: );
1311: EXCEPTION

Line 1308: x_version_number => l_c_igf_sp_std_unit.version_number,

1304: x_rowid => l_rowid,
1305: x_fee_cls_unit_id => l_fee_cls_unit_id,
1306: x_fee_cls_prg_id => l_fee_cls_prg_id,
1307: x_unit_cd => l_c_igf_sp_std_unit.unit_cd,
1308: x_version_number => l_c_igf_sp_std_unit.version_number,
1309: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_unit.max_amount)
1310: );
1311: EXCEPTION
1312: WHEN OTHERS THEN

Line 1309: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_unit.max_amount)

1305: x_fee_cls_unit_id => l_fee_cls_unit_id,
1306: x_fee_cls_prg_id => l_fee_cls_prg_id,
1307: x_unit_cd => l_c_igf_sp_std_unit.unit_cd,
1308: x_version_number => l_c_igf_sp_std_unit.version_number,
1309: x_max_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_std_unit.max_amount)
1310: );
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: -- rolls back to the save point