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_STDNT_REL

Line 958: --sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igf_sp_stdnt_rel, igf_sp_std_fc,

954: --gurprsin 31-May-2006 Bug 5213852, Logged the new message 'IGF_SP_NO_STDREL_TERM_MAP' and removed the code logic to
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

Line 987: CURSOR c_igf_sp_stdnt_rel(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS

983: WHERE ftp.fund_id = cp_fund_id;
984:
985: l_c_igf_aw_fund_tp c_igf_aw_fund_tp%ROWTYPE;
986:
987: CURSOR c_igf_sp_stdnt_rel(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
988: SELECT *
989: FROM igf_sp_stdnt_rel_v
990: WHERE fund_id = cp_fund_id ;
991:

Line 989: FROM igf_sp_stdnt_rel_v

985: l_c_igf_aw_fund_tp c_igf_aw_fund_tp%ROWTYPE;
986:
987: CURSOR c_igf_sp_stdnt_rel(cp_fund_id igf_aw_fund_mast.fund_id%TYPE) IS
988: SELECT *
989: FROM igf_sp_stdnt_rel_v
990: WHERE fund_id = cp_fund_id ;
991:
992: l_c_igf_sp_stdnt_rel c_igf_sp_stdnt_rel%ROWTYPE;
993:

Line 992: l_c_igf_sp_stdnt_rel c_igf_sp_stdnt_rel%ROWTYPE;

988: SELECT *
989: FROM igf_sp_stdnt_rel_v
990: WHERE fund_id = cp_fund_id ;
991:
992: l_c_igf_sp_stdnt_rel c_igf_sp_stdnt_rel%ROWTYPE;
993:
994:
995: CURSOR c_igf_ap_fa_base_rec(cp_person_id igs_pe_person.person_id%TYPE,
996: cp_cal_type igs_ca_inst.cal_type%TYPE,

Line 1007: CURSOR c_igf_sp_std_fc(cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE) IS

1003: AND ci_sequence_number = cp_seq_num;
1004:
1005: l_c_igf_ap_fa_base_rec c_igf_ap_fa_base_rec%ROWTYPE;
1006:
1007: CURSOR c_igf_sp_std_fc(cp_spnsr_stdnt_id igf_sp_stdnt_rel.spnsr_stdnt_id%TYPE) IS
1008: SELECT *
1009: FROM igf_sp_std_fc_v
1010: WHERE spnsr_stdnt_id = cp_spnsr_stdnt_id;
1011:

Line 1035: l_spnsr_stdnt_id igf_sp_stdnt_rel_all.spnsr_stdnt_id%TYPE;

1031: l_err_exception EXCEPTION;
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;

Line 1109: FOR l_c_igf_sp_stdnt_rel IN c_igf_sp_stdnt_rel(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)

1105: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1106: fnd_file.put_line(fnd_file.log,' ');
1107:
1108: -- rolling over sponsor student relation for fund and term calendar for the succeeding award year
1109: FOR l_c_igf_sp_stdnt_rel IN c_igf_sp_stdnt_rel(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
1110: LOOP
1111: BEGIN
1112: -- declare a save point
1113: SAVEPOINT sp_spnsr_student;

Line 1116: OPEN c_igf_ap_fa_base_rec(cp_person_id => l_c_igf_sp_stdnt_rel.person_id,

1112: -- declare a save point
1113: SAVEPOINT sp_spnsr_student;
1114:
1115: -- checks if record exists in fa base record table for the student and award year
1116: OPEN c_igf_ap_fa_base_rec(cp_person_id => l_c_igf_sp_stdnt_rel.person_id,
1117: cp_cal_type => p_sc_cal_type,
1118: cp_seq_num => p_sc_seq_num);
1119: FETCH c_igf_ap_fa_base_rec INTO l_c_igf_ap_fa_base_rec;
1120:

Line 1132: fnd_file.put_line(fnd_file.log,l_c_igf_sp_stdnt_rel.person_number||' '||fnd_message.get);

1128: igs_ge_msg_stack.add;
1129:
1130: -- log the error message
1131: fnd_file.put_line(fnd_file.log,' ');
1132: fnd_file.put_line(fnd_file.log,l_c_igf_sp_stdnt_rel.person_number||' '||fnd_message.get);
1133:
1134: -- skips the current student
1135: RAISE l_stud_exception;
1136: END IF;

Line 1142: OPEN c_igf_aw_cal_rel(cp_cal_type => l_c_igf_sp_stdnt_rel.ld_cal_type,

1138: l_base_id := l_c_igf_ap_fa_base_rec.base_id ;
1139: CLOSE c_igf_ap_fa_base_rec;
1140: -- Check if succeeding terms are present for the current term passed as
1141: -- parameter to the process
1142: OPEN c_igf_aw_cal_rel(cp_cal_type => l_c_igf_sp_stdnt_rel.ld_cal_type,
1143: cp_seq_num => l_c_igf_sp_stdnt_rel.ld_sequence_number);
1144: FETCH c_igf_aw_cal_rel INTO l_c_igf_aw_cal_rel;
1145: IF c_igf_aw_cal_rel%NOTFOUND THEN
1146:

Line 1143: cp_seq_num => l_c_igf_sp_stdnt_rel.ld_sequence_number);

1139: CLOSE c_igf_ap_fa_base_rec;
1140: -- Check if succeeding terms are present for the current term passed as
1141: -- parameter to the process
1142: OPEN c_igf_aw_cal_rel(cp_cal_type => l_c_igf_sp_stdnt_rel.ld_cal_type,
1143: cp_seq_num => l_c_igf_sp_stdnt_rel.ld_sequence_number);
1144: FETCH c_igf_aw_cal_rel INTO l_c_igf_aw_cal_rel;
1145: IF c_igf_aw_cal_rel%NOTFOUND THEN
1146:
1147: -- rolls back to the save point

Line 1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);

1152: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
1153: fnd_message.set_name('IGF','IGF_SP_NO_STDREL_TERM_MAP');
1154: fnd_message.set_token('TERM_ALT_CD',l_c_igf_aw_fund_tp.tp_alternate_code);
1155: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);
1157: fnd_message.set_token('SPONSOR_CD',l_c_igf_aw_fund_tp.fund_code);
1158:
1159: igs_ge_msg_stack.add;
1160:

Line 1170: l_msg_str_1 := RPAD(l_c_igf_sp_stdnt_rel.person_number,32)||

1166: END IF;
1167: CLOSE c_igf_aw_cal_rel;
1168:
1169: -- log the relavant details
1170: l_msg_str_1 := RPAD(l_c_igf_sp_stdnt_rel.person_number,32)||
1171: RPAD(l_c_igf_aw_cal_rel.sc_alternate_code,12) ||
1172: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_start_dt),22) ||
1173: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_end_dt),22) ||
1174: NVL(RPAD(TO_CHAR(l_c_igf_sp_stdnt_rel.min_credit_points),19),' ') ||

Line 1174: NVL(RPAD(TO_CHAR(l_c_igf_sp_stdnt_rel.min_credit_points),19),' ') ||

1170: l_msg_str_1 := RPAD(l_c_igf_sp_stdnt_rel.person_number,32)||
1171: RPAD(l_c_igf_aw_cal_rel.sc_alternate_code,12) ||
1172: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_start_dt),22) ||
1173: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_end_dt),22) ||
1174: NVL(RPAD(TO_CHAR(l_c_igf_sp_stdnt_rel.min_credit_points),19),' ') ||
1175: NVL(RPAD(l_c_igf_sp_stdnt_rel.min_attendance_type,32),' ' )||
1176: TO_CHAR(l_c_igf_sp_stdnt_rel.tot_spnsr_amount);
1177:
1178: fnd_file.put_line(fnd_file.log,l_msg_str_1);

Line 1175: NVL(RPAD(l_c_igf_sp_stdnt_rel.min_attendance_type,32),' ' )||

1171: RPAD(l_c_igf_aw_cal_rel.sc_alternate_code,12) ||
1172: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_start_dt),22) ||
1173: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_end_dt),22) ||
1174: NVL(RPAD(TO_CHAR(l_c_igf_sp_stdnt_rel.min_credit_points),19),' ') ||
1175: NVL(RPAD(l_c_igf_sp_stdnt_rel.min_attendance_type,32),' ' )||
1176: TO_CHAR(l_c_igf_sp_stdnt_rel.tot_spnsr_amount);
1177:
1178: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1179: l_spnsr_stdnt_id := NULL;

Line 1176: TO_CHAR(l_c_igf_sp_stdnt_rel.tot_spnsr_amount);

1172: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_start_dt),22) ||
1173: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_end_dt),22) ||
1174: NVL(RPAD(TO_CHAR(l_c_igf_sp_stdnt_rel.min_credit_points),19),' ') ||
1175: NVL(RPAD(l_c_igf_sp_stdnt_rel.min_attendance_type,32),' ' )||
1176: TO_CHAR(l_c_igf_sp_stdnt_rel.tot_spnsr_amount);
1177:
1178: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1179: l_spnsr_stdnt_id := NULL;
1180: l_rowid := NULL;

Line 1183: igf_sp_stdnt_rel_pkg.insert_row (

1179: l_spnsr_stdnt_id := NULL;
1180: l_rowid := NULL;
1181: BEGIN
1182: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
1183: igf_sp_stdnt_rel_pkg.insert_row (
1184: x_mode => 'R',
1185: x_rowid => l_rowid,
1186: x_spnsr_stdnt_id => l_spnsr_stdnt_id,
1187: x_fund_id => l_c_fund_mast.fund_id,

Line 1189: x_person_id => l_c_igf_sp_stdnt_rel.person_id,

1185: x_rowid => l_rowid,
1186: x_spnsr_stdnt_id => l_spnsr_stdnt_id,
1187: x_fund_id => l_c_fund_mast.fund_id,
1188: x_base_id => l_base_id,
1189: x_person_id => l_c_igf_sp_stdnt_rel.person_id,
1190: x_ld_cal_type => l_c_igf_aw_cal_rel.sc_cal_type,
1191: x_ld_sequence_number => l_c_igf_aw_cal_rel.sc_sequence_number,
1192: x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),
1193: x_min_credit_points => l_c_igf_sp_stdnt_rel.min_credit_points,

Line 1192: x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),

1188: x_base_id => l_base_id,
1189: x_person_id => l_c_igf_sp_stdnt_rel.person_id,
1190: x_ld_cal_type => l_c_igf_aw_cal_rel.sc_cal_type,
1191: x_ld_sequence_number => l_c_igf_aw_cal_rel.sc_sequence_number,
1192: x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),
1193: x_min_credit_points => l_c_igf_sp_stdnt_rel.min_credit_points,
1194: x_min_attendance_type => l_c_igf_sp_stdnt_rel.min_attendance_type
1195: );
1196: EXCEPTION

Line 1193: x_min_credit_points => l_c_igf_sp_stdnt_rel.min_credit_points,

1189: x_person_id => l_c_igf_sp_stdnt_rel.person_id,
1190: x_ld_cal_type => l_c_igf_aw_cal_rel.sc_cal_type,
1191: x_ld_sequence_number => l_c_igf_aw_cal_rel.sc_sequence_number,
1192: x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),
1193: x_min_credit_points => l_c_igf_sp_stdnt_rel.min_credit_points,
1194: x_min_attendance_type => l_c_igf_sp_stdnt_rel.min_attendance_type
1195: );
1196: EXCEPTION
1197: WHEN OTHERS THEN

Line 1194: x_min_attendance_type => l_c_igf_sp_stdnt_rel.min_attendance_type

1190: x_ld_cal_type => l_c_igf_aw_cal_rel.sc_cal_type,
1191: x_ld_sequence_number => l_c_igf_aw_cal_rel.sc_sequence_number,
1192: x_tot_spnsr_amount => igs_fi_gen_gl.get_formatted_amount(l_c_igf_sp_stdnt_rel.tot_spnsr_amount),
1193: x_min_credit_points => l_c_igf_sp_stdnt_rel.min_credit_points,
1194: x_min_attendance_type => l_c_igf_sp_stdnt_rel.min_attendance_type
1195: );
1196: EXCEPTION
1197: WHEN OTHERS THEN
1198: -- rolls back to the save point

Line 1214: FOR l_c_igf_sp_std_fc IN c_igf_sp_std_fc(cp_spnsr_stdnt_id => l_c_igf_sp_stdnt_rel.spnsr_stdnt_id)

1210: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1211: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1212: fnd_file.put_line(fnd_file.log,' ');
1213: -- rolling over fee class details
1214: FOR l_c_igf_sp_std_fc IN c_igf_sp_std_fc(cp_spnsr_stdnt_id => l_c_igf_sp_stdnt_rel.spnsr_stdnt_id)
1215: LOOP
1216: -- log relevant details
1217: l_msg_str_1 := RPAD(l_c_igf_sp_std_fc.fee_class,32) ||
1218: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_fc.fee_percent),10),' ' )||