1163: and sr_instance_id = MSC_CL_COLLECTION.v_instance_id;
1164: Exception
1165: when no_data_found
1166: then
1167: Select MSC_DESIGNATORS_S.Nextval
1168: into v_forecast_set_id
1169: from dual;
1170: End;
1171: Elsif c_rec.forecast_set is null then
1234: LAST_UPDATED_BY,
1235: CREATION_DATE,
1236: CREATED_BY)
1237: VALUES
1238: ( MSC_DESIGNATORS_S.NEXTVAL,
1239: v_forecast_Set_id,
1240: c_rec.DESIGNATOR,
1241: 6,
1242: c_rec.ORGANIZATION_ID,
3161: LAST_UPDATED_BY,
3162: CREATION_DATE,
3163: CREATED_BY)
3164: VALUES
3165: ( MSC_DESIGNATORS_S.NEXTVAL,
3166: c_rec.DESIGNATOR,
3167: c_rec.ORGANIZATION_ID,
3168: c_rec.MPS_RELIEF,
3169: c_rec.INVENTORY_ATP_FLAG,