APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_FAC_TCFT_TMP

Line 212: SELECT 'x' FROM igs_ps_fac_tcft_tmp

208: --check if the conflicting record already exists in the temp table before inserting it.
209: -- here if we r trying to insert usec_occur_id1 and 2 then we check to see if
210: -- usec_occur2 , 1 already exists ,because order doesn't matter
211: CURSOR cur_tmp_exists(cp_usec_occur_id2 igs_ps_usec_occurs.unit_section_occurrence_id%TYPE) IS
212: SELECT 'x' FROM igs_ps_fac_tcft_tmp
213: WHERE person_id = p_person_id AND
214: usec_occur_id1 = cp_usec_occur_id2 AND
215: usec_occur_id2 = p_unit_section_occurrence_id ;
216: cur_tmp_exists_rec cur_tmp_exists%ROWTYPE ;

Line 267: igs_ps_fac_tcft_tmp_pkg.insert_row (

263: OPEN cur_tmp_exists(cur_time_conflct_rec.unit_section_occurrence_id ) ;
264: FETCH cur_tmp_exists INTO cur_tmp_exists_rec ;
265: IF cur_tmp_exists%NOTFOUND THEN
266:
267: igs_ps_fac_tcft_tmp_pkg.insert_row (
268: x_rowid => l_rowid ,
269: x_person_id => p_person_id ,
270: x_usec_occur_id1 => p_unit_section_occurrence_id ,
271: x_usec_occur_id2 => cur_time_conflct_rec.unit_section_occurrence_id ,

Line 330: FROM igs_ps_fac_tcft_tmp ;

326:
327: --select all the records in the temp table for deletion
328: CURSOR cur_tmp IS
329: SELECT rowid
330: FROM igs_ps_fac_tcft_tmp ;
331:
332:
333: TYPE teach_cal_rec IS RECORD(
334: cal_type igs_ca_inst_all.cal_type%TYPE,

Line 413: IGS_PS_FAC_TCFT_TMP_PKG.DELETE_ROW (X_ROWID => cur_tmp_rec.rowid) ;

409:
410: -- delete all the records from the temp table before inserting new records
411: --
412: FOR cur_tmp_rec IN cur_tmp LOOP
413: IGS_PS_FAC_TCFT_TMP_PKG.DELETE_ROW (X_ROWID => cur_tmp_rec.rowid) ;
414: END LOOP ;
415:
416: --for all the unit section occurrences for the passed instructor or all instructors check
417: --if any of them conflict with each other and insert those records