APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OF_UNT_SET_RL

Line 1110: FROM IGS_PS_OF_UNT_SET_RL cousr,

1106: cousr.sup_unit_set_cd,
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

Line 1169: IGS_PS_OF_UNT_SET_RL_PKG.INSERT_ROW(

1165: END;
1166: END LOOP; -- c_cous
1167: FOR v_cousr_rec IN c_cousr LOOP
1168: X_ROWID := NULL;
1169: IGS_PS_OF_UNT_SET_RL_PKG.INSERT_ROW(
1170: X_ROWID => x_rowid,
1171: X_COURSE_CD => p_new_course_cd,
1172: X_CRV_VERSION_NUMBER => p_new_version_number,
1173: X_SUP_US_VERSION_NUMBER => v_cousr_rec.sup_us_version_number,

Line 1240: -- IGS_PS_OF_UNT_SET_RL

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
1244: OPEN gc_coo_rec;