APPS.IGS_PS_RLOVR_FAC_TSK dependencies on IGS_PS_FAC_TCFT_TMP_PKG

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 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