APPS.IGS_PS_GEN_001 dependencies on IGS_PS_COO_AD_UNIT_S

Line 610: FROM IGS_PS_COO_AD_UNIT_S cacus

606: cacus.attendance_type,
607: cacus.admission_cat,
608: cacus.unit_set_cd,
609: cacus.us_version_number
610: FROM IGS_PS_COO_AD_UNIT_S cacus
611: WHERE cacus.course_cd = p_old_course_cd AND
612: cacus.crv_version_number = p_old_version_number AND
613: cacus.cal_type = cp_cooac_cal_type AND
614: cacus.location_cd = cp_cooac_location_cd AND

Line 643: IGS_PS_COO_AD_UNIT_S_PKG.INSERT_ROW(

639: v_cooac_rec.attendance_type,
640: v_cooac_rec.admission_cat) LOOP
641:
642: x_rowid := NULL;
643: IGS_PS_COO_AD_UNIT_S_PKG.INSERT_ROW(
644: X_ROWID => x_rowid,
645: X_COURSE_CD => p_new_course_cd,
646: X_CRV_VERSION_NUMBER => p_new_version_number,
647: X_CAL_TYPE => v_cacus_rec.cal_type,

Line 806: -- and its child table IGS_PS_COO_AD_UNIT_S

802: X_MODE => 'R'
803: );
804: END LOOP; -- coous
805: -- calling procedure to insert IGS_PS_OF_OPT_AD_CAT records
806: -- and its child table IGS_PS_COO_AD_UNIT_S
807: crspl_ins_cooac_rec;
808: EXCEPTION
809: WHEN OTHERS THEN
810: IF ( gc_coo_seq_num%ISOPEN) THEN