DBA Data[Home] [Help]

APPS.IGF_SP_ROLLOVER dependencies on IGS_GE_DATE

Line 780: RPAD(igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_start_dt),22) ||

776: END IF;
777: CLOSE c_igf_aw_cal_rel;
778: -- log relevant details
779: l_msg_str_1 := RPAD(l_c_igf_aw_cal_rel.sc_alternate_code,12) ||
780: RPAD(igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_start_dt),22) ||
781: igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_end_dt);
782: fnd_file.put_line(fnd_file.log,l_msg_str_1);
783: l_rowid := NULL;
784: BEGIN

Line 781: igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_end_dt);

777: CLOSE c_igf_aw_cal_rel;
778: -- log relevant details
779: l_msg_str_1 := RPAD(l_c_igf_aw_cal_rel.sc_alternate_code,12) ||
780: RPAD(igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_start_dt),22) ||
781: igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_end_dt);
782: fnd_file.put_line(fnd_file.log,l_msg_str_1);
783: l_rowid := NULL;
784: BEGIN
785: igf_aw_fund_tp_pkg.insert_row (

Line 1172: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_start_dt),22) ||

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),' ') ||
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);

Line 1173: RPAD(IGS_GE_DATE.IGSCHARDT(l_c_igf_aw_cal_rel.sc_end_dt),22) ||

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),' ') ||
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: