APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OFR_UNIT_SET

Line 710: FROM IGS_PS_OFR_UNIT_SET cous

706: coous.location_cd = gv_coo_rec.location_cd AND
707: coous.attendance_mode = gv_coo_rec.attendance_mode AND
708: coous.attendance_type = gv_coo_rec.attendance_type AND
709: EXISTS (SELECT 'X'
710: FROM IGS_PS_OFR_UNIT_SET cous
711: WHERE cous.course_cd = p_new_course_cd AND
712: cous.crv_version_number = p_new_version_number AND
713: cous.cal_type = coous.cal_type AND
714: cous.unit_set_cd = coous.unit_set_cd AND

Line 1100: FROM IGS_PS_OFR_UNIT_SET cous

1096: cous.us_version_number,
1097: cous.override_title,
1098: cous.only_as_sub_ind,
1099: cous.show_on_official_ntfctn_ind
1100: FROM IGS_PS_OFR_UNIT_SET cous
1101: WHERE cous.course_cd = p_old_course_cd AND
1102: cous.crv_version_number = p_old_version_number AND
1103: cous.cal_type = gv_co_rec.cal_type;
1104: CURSOR c_cousr IS

Line 1111: IGS_PS_OFR_UNIT_SET cous_sup,

1107: cousr.sup_us_version_number,
1108: cousr.sub_unit_set_cd,
1109: cousr.sub_us_version_number
1110: FROM IGS_PS_OF_UNT_SET_RL cousr,
1111: IGS_PS_OFR_UNIT_SET cous_sup,
1112: IGS_PS_OFR_UNIT_SET cous_sub
1113: WHERE cousr.course_cd = p_old_course_cd AND
1114: cousr.crv_version_number = p_old_version_number AND
1115: cousr.cal_type = gv_co_rec.cal_type AND

Line 1112: IGS_PS_OFR_UNIT_SET cous_sub

1108: cousr.sub_unit_set_cd,
1109: cousr.sub_us_version_number
1110: FROM IGS_PS_OF_UNT_SET_RL cousr,
1111: IGS_PS_OFR_UNIT_SET cous_sup,
1112: IGS_PS_OFR_UNIT_SET cous_sub
1113: WHERE cousr.course_cd = p_old_course_cd AND
1114: cousr.crv_version_number = p_old_version_number AND
1115: cousr.cal_type = gv_co_rec.cal_type AND
1116: cousr.cal_type = cous_sub.cal_type AND

Line 1127: FROM IGS_PS_OFR_UNIT_SET cous

1123: cousr.course_cd = cous_sup.course_cd AND
1124: cousr.crv_version_number = cous_sup.crv_version_number AND
1125: cousr.cal_type = cous_sup.cal_type AND
1126: EXISTS (SELECT 'X'
1127: FROM IGS_PS_OFR_UNIT_SET cous
1128: WHERE cous.course_cd = p_new_course_cd AND
1129: cous.crv_version_number = p_new_version_number AND
1130: cous.cal_type = cous_sup.cal_type AND
1131: cous.unit_set_cd = cous_sup.unit_set_cd AND

Line 1134: FROM IGS_PS_OFR_UNIT_SET cous

1130: cous.cal_type = cous_sup.cal_type AND
1131: cous.unit_set_cd = cous_sup.unit_set_cd AND
1132: cous.us_version_number = cous_sup.us_version_number) AND
1133: EXISTS (SELECT 'X'
1134: FROM IGS_PS_OFR_UNIT_SET cous
1135: WHERE cous.course_cd = p_new_course_cd AND
1136: cous.crv_version_number = p_new_version_number AND
1137: cous.cal_type = cous_sub.cal_type AND
1138: cous.unit_set_cd = cous_sub.unit_set_cd AND

Line 1145: IGS_PS_OFR_UNIT_SET_PKG.INSERT_ROW(

1141: BEGIN
1142: FOR v_cous_rec IN c_cous LOOP
1143: BEGIN
1144: x_rowid := NULL;
1145: IGS_PS_OFR_UNIT_SET_PKG.INSERT_ROW(
1146: X_ROWID => x_rowid,
1147: X_COURSE_CD => p_new_course_cd,
1148: X_CRV_VERSION_NUMBER => p_new_version_number,
1149: X_CAL_TYPE => v_cous_rec.cal_type,

Line 1238: -- calling procedure to insert IGS_PS_OFR_UNIT_SET records

1234: X_ATTRIBUTE20 => gv_co_rec.attribute20,
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

Line 1883: -- IGS_PS_OFR_UNIT_SET and IGS_PS_OFR_OPT populated first.

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