APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OF_OPT_UNT_ST

Line 702: FROM IGS_PS_OF_OPT_UNT_ST coous

698: coous.attendance_mode,
699: coous.attendance_type,
700: coous.unit_set_cd,
701: coous.us_version_number
702: FROM IGS_PS_OF_OPT_UNT_ST coous
703: WHERE coous.course_cd = p_old_course_cd AND
704: coous.crv_version_number = p_old_version_number AND
705: coous.cal_type = gv_coo_rec.cal_type AND
706: coous.location_cd = gv_coo_rec.location_cd AND

Line 791: IGS_PS_OF_OPT_UNT_ST_PKG.INSERT_ROW(

787: END LOOP;
788: CLOSE gc_ceprcd_rec;
789: FOR v_coous_rec IN c_coous LOOP
790: x_rowid := NULL;
791: IGS_PS_OF_OPT_UNT_ST_PKG.INSERT_ROW(
792: X_ROWID => x_rowid,
793: X_COURSE_CD => p_new_course_cd,
794: X_LOCATION_CD => v_coous_rec.location_cd,
795: X_ATTENDANCE_MODE => v_coous_rec.attendance_mode,

Line 1239: -- and its child tables IGS_PS_OF_OPT_UNT_ST and

1235: X_MODE => 'R' ,
1236: X_ORG_ID => l_org_id
1237: );
1238: -- calling procedure to insert IGS_PS_OFR_UNIT_SET records
1239: -- and its child tables IGS_PS_OF_OPT_UNT_ST and
1240: -- IGS_PS_OF_UNT_SET_RL
1241: crspl_ins_cous_rec;
1242: -- calling procedure to insert IGS_PS_OFR_OPT records
1243: -- associated with each IGS_PS_OFR record

Line 1882: -- (For example, IGS_PS_OF_OPT_UNT_ST relies on

1878: -- within this range, it will be raised by standard exception handling.
1879: -- If the insertion of a IGS_PS_COURSE IGS_GE_NOTE fails, the associated IGS_GE_NOTE is removed.
1880: -- IGS_GE_NOTE: If any tables to be added, be careful to ensure relational integrity
1881: -- is preserved. Please check that all foreign keys are catered for.
1882: -- (For example, IGS_PS_OF_OPT_UNT_ST relies on
1883: -- IGS_PS_OFR_UNIT_SET and IGS_PS_OFR_OPT populated first.
1884: -- Only then can the records be created for the new version provided
1885: -- the parent records exist.)
1886: -- This checks if the specified new IGS_PS_COURSE version exists