APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_TIMESLOT_RSLT

Line 1557: l_igs_en_timeslot_rslt_id VARCHAR2(25);

1553: p_length_of_time IN NUMBER) AS
1554:
1555: cnt_4 NUMBER := 0;
1556: l_rowid VARCHAR2(25);
1557: l_igs_en_timeslot_rslt_id VARCHAR2(25);
1558:
1559: BEGIN
1560: -- if the length of time is unlimited
1561: IF p_length_of_time = 0 THEN

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 1565: x_igs_en_timeslot_rslt_id => l_igs_en_timeslot_rslt_id,

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,
1569: x_end_dt_time => p_plsql_5(1).end_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 1578: x_igs_en_timeslot_rslt_id => l_igs_en_timeslot_rslt_id,

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,
1582: x_end_dt_time => p_plsql_5(i).end_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 1597: x_igs_en_timeslot_rslt_id => l_igs_en_timeslot_rslt_id,

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,
1601: x_end_dt_time => NULL,

Line 1695: FROM Igs_En_Timeslot_Rslt tsr

1691: etp.timeslot_calendar = p_timeslot;
1692:
1693: CURSOR cur_rslt(p_igs_en_timeslot_para_id igs_en_timeslot_para.igs_en_timeslot_para_id%TYPE) IS
1694: SELECT tsr.ROWID row_id
1695: FROM Igs_En_Timeslot_Rslt tsr
1696: WHERE tsr.igs_en_timeslot_para_id = p_igs_en_timeslot_para_id;
1697:
1698: p_start_time DATE ;
1699: p_end_time DATE ;

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