DBA Data[Home] [Help]

APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_TIMESLOT_RSLT_PKG

Line 1564: Igs_En_Timeslot_Rslt_Pkg.insert_row ( x_rowid => l_rowid,

1560: -- if the length of time is unlimited
1561: IF p_length_of_time = 0 THEN
1562: FOR i IN 1 .. plsql_4.COUNT LOOP
1563: l_rowid := null;
1564: Igs_En_Timeslot_Rslt_Pkg.insert_row ( x_rowid => l_rowid,
1565: x_igs_en_timeslot_rslt_id => l_igs_en_timeslot_rslt_id,
1566: x_igs_en_timeslot_para_id => p_igs_en_timeslot_para_id,
1567: x_person_id => p_plsql_4(i).person_id,
1568: x_start_dt_time => p_plsql_5(1).start_dt_time,

Line 1577: Igs_En_Timeslot_Rslt_Pkg.insert_row ( x_rowid => l_rowid,

1573: FOR i IN 1 .. p_plsql_5.COUNT LOOP
1574: FOR j IN 1 .. p_max_head_count LOOP
1575: cnt_4 := cnt_4 +1;
1576: l_rowid := null;
1577: Igs_En_Timeslot_Rslt_Pkg.insert_row ( x_rowid => l_rowid,
1578: x_igs_en_timeslot_rslt_id => l_igs_en_timeslot_rslt_id,
1579: x_igs_en_timeslot_para_id => p_igs_en_timeslot_para_id,
1580: x_person_id => p_plsql_4(cnt_4).person_id,
1581: x_start_dt_time => p_plsql_5(i).start_dt_time,

Line 1596: Igs_En_Timeslot_Rslt_Pkg.insert_row ( x_rowid => l_rowid,

1592: -- if unassigned students are there, then inserting into result table with NULL start And end date_time
1593: IF cnt_4 < plsql_4.COUNT THEN
1594: FOR i IN cnt_4 + 1 .. plsql_4.COUNT LOOP
1595: l_rowid := null;
1596: Igs_En_Timeslot_Rslt_Pkg.insert_row ( x_rowid => l_rowid,
1597: x_igs_en_timeslot_rslt_id => l_igs_en_timeslot_rslt_id,
1598: x_igs_en_timeslot_para_id => p_igs_en_timeslot_para_id,
1599: x_person_id => p_plsql_4(i).person_id,
1600: x_start_dt_time => NULL,

Line 1809: Igs_En_Timeslot_Rslt_Pkg.delete_row(x_rowid => cur_rslt_rec.row_id);

1805: FETCH cur_mode_check INTO l_rowid ,l_ts_para_id , l_ts_mode;
1806: IF cur_mode_check%FOUND THEN
1807: IF l_ts_mode = 'T' THEN
1808: FOR cur_rslt_rec IN cur_rslt(l_ts_para_id) LOOP
1809: Igs_En_Timeslot_Rslt_Pkg.delete_row(x_rowid => cur_rslt_rec.row_id);
1810: END LOOP;
1811: Igs_En_Timeslot_Para_Pkg.delete_row(x_rowid => l_rowid);
1812: ELSIF l_ts_mode = 'F' THEN
1813: fnd_message.set_name('IGS','IGS_EN_TS_CRI_FINAL_AL');